Online based
Downloadable exercise
Offline viewing
Fixed/flex schedule
Fixed time homework
Certificate of completion
Objectives
- Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts, Macros
- Knowledge of all the essential Excel formulas
- Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
- Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match
- Harness full potential of Excel by creating Pivot tables with slicers
Level expectations
- Make great presentations using the Conditional and Table formatting options
- Visually enchant viewers using Bar charts, Scatter Plots, Histograms etc.
- Increase your efficiency by learning how to create and use important Excel shortcuts
- Explore fun and exciting use cases of Excel
Content
- Mathematical Functions
- Textual Formulas
- Logical Formulas
- Date-time (Temporal) Formulas
- Lookup Formulas
- Formatting data and tables
- Excel Shortcuts