Microsoft Excel Master Class – 2021
Excel Formulas & Functions, Advance Excel Analytics, Case Studies, BI Dashboards, Charts, Macros & Practice Exercises
What you’ll learn
-
A Solid understanding of Excel
-
Basics of Excel from Scratch.
-
All Important 33+ Formulas in Excel which are very useful in day to day life.
-
Making your data look good & re presentable by using Formatting & Advance Formatting.
-
Explore all the things that can be done using Excel .e.g: Speaking Cells in Excel [ 21 Things that you can do in Excel are included in this section ]
-
Visualization of the data using Excel Charts and deriving Important Insights from them.
-
Harness the power of Pivot Charts by introducing Slicers and deriving Insights from them.
-
Advance Excel : Linear Regression, Goal Seeker & Solver by working on Real Life Consulting Projects.
-
Introduction to BUSINESS INTELLIGENCE DASHBOARDS & building them from Scratch.
-
Solve 2 Real life Case Studies one building DASH BOARD from scratch for a school and putting hands on a Real Life consulting project for a Fertilizer Company and recommending them with Insights.m
-
Macros: Learn to Automate things by recording a Macro and assigning a button to it.
-
30+ Excel shortcuts useful in daily Life.
Requirements
-
You will need a PC with any version of Excel installed in it.
Who this course is for:
- Working Professionals [DATA ANALYST, RESEARCH SPECIALIST & BUSINESS MANAGERS] beginning their Data journey, High school students ,Professors , Graduates & Post Graduates and people from all phase of life who have the curiosity of learning EXCEL
