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
MS Excel Workshop – Prerequisites
A
laptop or computer
Microsoft Excel (2013 or newer)
installed
Basic computer use
(like typing and opening files)
Internet connection
(if it’s online)
And Eager to explore and absorb knowledge
Complete and Continue