Unlock MICROSOFT EXCEL: Excel Basics, Charts & Functions

Master Excel Charts, Pivot table, Maps. Learn Functions such as SUMIF, SUMIFS, IFS, SWITCH, TEXT, Date/Time functions

Created by: Pamch Tutor M.Ed
Educational Technologist | Bestselling Trainer | M.Ed

What Will I Learn?

• Understand the basics of Excel and how to manipulate the workbook tabs, ribbons and tools
• Creating and designing different types of charts - Histogram, Pareto, Funnel Chart, Combo Chart, Tree map, Box and Whisker Chart, Sunburst chart and more
• Get a good grip on how to work with Maths & Trig Functions - TRUNC, POWER, SUM, SUMIF, SUMIFS, QUOTIENT, SUMX2PY2, SUMX2MY2, ,LCM, SIN, COS, TAN, etc
• Master how to work with Logical Functions - IF, IFERROR, IFS, SWITCH, NOT, OR, AND, etc
• Enjoy how to work with Text Functions - LET, CONCAT, MID, REPT, TEXT, ARRAYTOTEXT, TRIM, LEN, LEFT, RIGHT, etc
• Understand how to work with Date & Time Functions - DAYS360, NOW, TODAY, DATE, TIME, etc
• Master the skill of tracing dependents and precedents of data
• Create 3D Map with Time Line

Requirements

• This course is for ABSOLUTE BEGINNERS in Microsoft Excel. You will be taught from beginner to advanced
• You can use Excel 2013, Excel 2016, Excel 2019, Excel 2021, Office Excel 365 software

Target audience

• This course is for ABSOLUTE BEGINNERS in Excel spreadsheet and Excel Functions.
• If you want to have an excellent grasp of Excel Charts, Pivot Table, Conditional Formatting, Tables, Slicer tools, then this Excel course is for you.
• If you want to have an excellent grasp of Excel Functions, Arrays and Data Manipulation, then this Excel course is for you.