Excel Mastery: Introduction (Lecture 1)
Welcome to the foundational lecture of Excel Mastery. We cover the interface, ribbon, and basic navigation.
Practice Tasks (Lecture 1)
Open Excel and create a simple list of 5 items with prices.
Quiz (Lecture 1)
1. What is a cell? Answer: Intersection of row and column.
Excel Mastery: Formulas & Functions (Lecture 2)
Learn how to use SUM, AVERAGE, and cell references to automate your calculations.
Practice Tasks (Lecture 2)
Calculate the total and average of your sales data using formulas.
Quiz (Lecture 2)
1. How do you start a formula? Answer: With = symbol.
Excel Mastery: Data Sorting & Filtering (Lecture 3)
Managing Large Datasets
In Lecture 3, we focus on Data Management. Learn to use Sorting and Filtering to focus only on what matters.
Practice Tasks (Lecture 3)
Sort a product list by price and filter for specific categories.
Quiz (Lecture 3)
1. Which tool hides rows? Answer: Filter.
Excel Mastery: Data Visualization & Charts (Lecture 4)
The Art of Visual Communication
Transform raw numbers into compelling visual narratives. Learn to choose the right chart types and customize them for professional reports.
Practice Tasks (Lecture 4)
Create a Clustered Column Chart for monthly performance and add Sparklines for cell-level trends.
Quiz (Lecture 4)
1. Which chart shows trends over time? Answer: Line Chart.