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
Daily Zoom Live Sessions Registration
Excel Interface
Formatting in MS Excel
Basic MS Excel Formulas
MS Excel Sorting Techniques
Day 1 Activity - Create Your Own Sales Tracker Sheet
Belong. Engage. Grow. - Connect to community
Quiz
Day 1 Assignment
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
Collaboration Begins Here - Connect to community
Quiz
Day 2 Assignment
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
Learn Together. Grow Together. - Connect to community
Quiz
Day 3 Assignment
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
Together, We Achieve More - Connect to community
Quiz
Day 4 Assignment
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
Squad Up. Skill Up - Connect to community
Quiz
Day - 5 Assignment
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 Assignment
Plug In. Geek Out. Grow Together. - Connect to community
Together, We Achieve More - Connect to community
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock