Microsoft Excel Masterclass: Complete and Concise

The most comprehensive Excel course, covering important topics such as Pivots, Data visualization, Macros & Analytics

Details

Lecture: 28
Time Required: 3 hour
Downloadable Resources: 40
Access: Life Time
Access on mobile and TV
Certificate of Completion

Requirements

You will need a PC with any version of Excel installed in it

What you will learn

Solid understanding of Microsoft Excel
Knowledge of all the essential Excel formulas
Become proficient in 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
Make great presentations using the Conditional and Table formatting options
Visually enchant viewers using Bar charts, Scatter Plots, Histograms, Waterfall charts etc.
Increase your efficiency by learning how to create and use important Excel shortcuts
Become competent in using advanced Analytics techniques in Excel such as Regression, Goal seek and Solver
Learn Automation techniques by using Macros
Explore fun and exciting use cases of Excel in our bonus videos

Targeted Audience

Working Professionals beginning their Data journey
Anyone curious to master excel from beginner to Advance in short span of time
Students about to join their first corporate job
Take This Course