Excel

Curriculum

8 chapters, each with a tutorial, a live example, a quiz, an exercise, a challenge, and class practice.

1. 1

   Introduction to Excel

   Formulas, cell references, and how a spreadsheet actually works.

   preview
2. 2

   Formulas & Functions

   SUM, AVERAGE, IF, and nested functions.

3. 3

   Conditional Formatting

   Highlighting data based on rules.

4. 4

   PivotTables

   Summarizing large datasets interactively.

5. 5

   Charts

   Choosing the right chart for the question.

6. 6

   VLOOKUP & XLOOKUP

   Looking up values across tables.

7. 7

   Data Validation

   Restricting what can be entered into a cell.

8. 8

   Macros Intro

   Recording and running simple automations.