Finance & Accounting Online Course by Udemy, On Sale Here
Go from being a Google Sheets beginner to an advanced user with our complete and up-to-date training course!
An excellent training about Financial Modeling & Analysis
Google Sheets: Complete Beginner to Advanced Training Course
Do you want to learn everything there is to know about Google Sheets in one complete course?Do you want a course that will let you learn the basics of how spreadsheets work before building up to intermediate and advanced topics such as macros, arrays and complex functions?Do you want access to spreadsheets that you can use to practise the exercises as you go through each lesson?If so, then our Google Sheets – Complete Beginner to Advanced Training Course is for you-What will I learn from this course?Our Google Sheets – Complete Beginner to Advanced Training Course will teach you everything you need to know about building practical and elegant spreadsheets. Over more than eight hours, you will start at the beginner level where you will learn how to access Google Sheets and get your first spreadsheet started, before learning about: cells, rows, columns and tabs; formatting data; basic formulas and functions; and much more. You will then move onto the intermediate section of the course where you will learn about: sorting and filtering data, including filter views; data validation; charts; and dozens of intermediate level functions such as VLOOKUP, INDEX/MATCH, SUMIF, RANK, TRIM and CONCATENATE. Then, you will finish with the advanced section of the course where you will discover all about: arrays, named ranges; basic macros; and advanced level functions such as MMULT, SUMPRODUCT, NPV and QUERY-What is the course structure?This course is divided up into beginner, intermediate and advanced sections. Depending on your skill level, you can do the entire course or skip ahead to the lessons you want to learn. Its totally up to you! We cover everything there is to know in Google Sheets for you to be able to build amazing spreadsheets. Check out the full list of topics we cover on this course: BEGINNER LEVEL: How to use these beginner level functions: SUMCOUNTAVERAGEMAX and MINHow to work with data: Selecting and movingCopying and pastingCutting and pastingDeletingPaste specialAuto-FillHow to use the basic components of a spreadsheet: Cells, rows and columnsWorksheets (tabs)Freezing panesFormatting tips and tricks to create great looking spreadsheets: Font size and typeBold, italics and strikethroughText and background coloursVertical and horizontal AlignText wrap and rotationFormatting numbersBorders, gridlines and alternating coloursHow to insert content such as imagesHow to import dataHow to export data through: PrintingSharingEmailingDownloadingINTERMEDIATE LEVEL: How to use these powerful intermediate level functions: DATE, DAY, DAYS, EDATE, NOW, TODAYCELL, ISBLANK, ISERR, ISERRORIF, AND, OR, IFERROR, Nested IF functions, IFSVLOOKUP, HLOOKUP, INDEX/MATCHCOUNT, COUNTIF, COUNTIFS, COUNTBLANKROUND, ROUNDDOWN, ROUNDUPSUM, SUMIF, SUMIFSSUBTOTALAVERAGE, AVERAGEIF, AVERAGEIFS, AVERAGE. WEIGHTEDRANKLEFT, RIGHT, LENTRIM, SUBSTITUTE, REPLACECONCATENATE, CONCAT, AMPERSANDHow to use these amazing data tools: SortFilterFilter ViewsConditional FormattingData ValidationHow to create charts and graphs such as: Pie chartsLine chartsBar or column chartsCombination chartsHow to create and use pivot tables and pivot chartsHow to add protection to worksheets and ranges of cellsADVANCED LEVEL: How to use these powerful advanced level functions: Array functions: Curly BracketsARRAYFORMULAARRAY CONSTRAINMMULTTRANSPOSESUMPRODUCTFILTERSORTDatabase Functions: DSUMDAVERAGEDCOUNTDCOUNTAInterest Rate Functions: EFFECTNOMINALINTRATERATEValue Functions: FVNPVPVInvestment Functions: IRRNPERPMTYIELDGoogle Functions: GOOGLEFINANCEGOOGLETRANSLATEQUERY: with SELECT, AND, ORDER BY and LIMITSPARKLINEWeb Functions: IMPORTHTMLIMPORTRANGEHow to create and manage fixed and dynamic Named RangesHow to combine the functions you have learned and Named Ranges to extract and manipulate large amounts of data easilyHow to create and manage basic macros-So what are you waiting for? Sign up today and go from a complete beginner to an advanced user in Google Sheets. See you on the course!
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.