6 Courses in 1! Beginner to advanced Excel training from the Excel experts – Simon Sez IT
What you’ll learn
How to get started using Microsoft Excel as a complete beginner
How create, save, and open a workbook.
How to use Mathematic Functions (SUM, AVERAGE, MIN, MAX)
Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
The basics of entering and editing data in a workbook.
Discover how to format dates and numbers.
How to use Logical Functions (IF, COUNTIF, SUMIF)
Effectively use autofill and flashfill so you are more productive.
Discover the essentials of using fomulas and functions.
How to use Lookup Functions (VLOOKUP, XLOOKUP, HLOOKUP, INDEX MATCH)
How to rename, insert, move, and reference an Excel worksheet.
Discover how to create charts and graphs
Learn practical methods to sort and filter your data
How to protect and secure your Excel data
How to Clean and Prepare your Data in Excel
How to create Pivot Tables
Using the Fields pane and adding Fields and Calculated Fields
How to create Pivot Charts and add sparklines and slicers
Selecting the right Chart to present your data
Adding Slicers and Timelines and how to apply on multiple tables
How to combine data from multiple worksheets for a PivotTable
All about GETPIVOTDATA
How to use 3D Maps from a PivotTable
Adding new Data to the original source dataset
How to update your data in a PivotTable and Pivot Chart
All about Conditional Formatting in a PivotTable
Learn to unlock advanced Excel formulas
Create multi-dependent dynamic drop-down lists in Excel
Perform a 2-way lookup in Excel
Automate repetitive tasks in Excel using Macros
How to edit Macros in the VBA Editor
How to write your own macro from scratch
