Microsoft Excel Weekender Crash Course

Microsoft Excel in just 5 hours - 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



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

Description
[April 2024 update]
Added a video on the "Analyze Data" option in MS Excel
Added a video on "How to integrate ChatGPT inside Excel using openAI API"
Added a video on "Advanced Filters" option which enables users to apply complex filtering conditions on the data
7 Reasons why you should choose this Excel course
Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment
Concise - you can complete this Microsoft Excel course within one weekend
Business related examples, data analysis and case studies solved using Advanced Excel.
You will learn various data analysis techniques using MS Excel
Ample practice exercises on data analysis, MS excel (basic & advanced), because Excel requires practice
Downloadable resources comprising important MS Excel techniques and functionalities
Your queries will be responded by the

More Info