Microsoft Excel for Business – Excel Formulas and Functions, Excel Charts, Excel Analytics, Shortcuts & Excel Macros
What you’ll learn
-
Solid understanding of Microsoft Excel
-
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
-
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
Who this course is for:
- Working Professionals beginning their Data journey
- Anyone curious to master excel from beginner to Advanced in short span of time
- Students about to join their first corporate job