Microsoft Excel Masterclass: Complete and Concise
The most comprehensive Excel course, covering important topics such as Pivots, Data visualization, Macros & AnalyticsDetails
Lecture: 28Time 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 itWhat you will learn
Solid understanding of Microsoft ExcelKnowledge 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 journeyAnyone curious to master excel from beginner to Advance in short span of time
Students about to join their first corporate job
Social