Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of Data Analytics with MS Excel and Advance Excel
Excel Foundation - Day 1
MS Excel Workshop – Prerequisites
Excel Interface
Formatting in MS Excel
Basic MS Excel Formulas
MS Excel Sorting Techniques
Day 1 Activity - Create Your Own Sales Tracker Sheet
Day 1 - Live Session Link
Belong. Engage. Grow. - Connect to community
Quiz
Data Cleaning and Preparation - Day 2
Text Functions in MS Excel
Data Types in MS Excel
MS Excel Cleaning Tools
Validation in MS Excel
Day 2 Activity - Clean Customer Dataset
Day 2 - Live Session Link
Collaboration Begins Here - Connect to community
Quiz
Analytical Functions and Formulas - Day 3
Logical Functions in MS Excel
Lookup in MS Excel
MS Excel Aggregation Functions
Nesting in MS Excel
Day 3 Activity - Analyze Sales by Region with Condition and Lookup
Day 3 - Live Session Link
Learn Together. Grow Together. - Connect to community
Quiz
Pivot Tables and Visual Analytics - Day 4
Pivot Tables in MS Excel
Pivot Charts in MS Excel
Slicers and Timelines in MS Excel
Charts and Graphs in MS Excel
Day 4 Activity - Create Pivot Report: Sales by Product
Day 4 - Live Session Link
Together, We Achieve More - Connect to community
Quiz
Dashboard Design Principles - Day 5
MS Excel Dashboard Layout
Form Control in MS Excel
Conditional Formatting in MS Excel
Day 5 Activity - Start Building Dynamic Dashboard
Day 5 - Live Session Link
Squad Up. Skill Up - Connect to community
Quiz
Final Dashboard Project - Day 6
Complete Dashboard in MS Excel
Exporting Dashboard Through MS Excel
Presentation of Dashboard
Day 6 Activity - Build and Present Full Dashboard
Day 6 - Live Session Link
Plug In. Geek Out. Grow Together. - Connect to community
Day 3 Activity - Analyze Sales by Region with Condition and Lookup
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock