Course curriculum

  • 1

    Welcome to the course!

  • 2

    Chapter #1

    • Learn About the Excel Window

    • The Excel Window

  • 3

    Chapter #2

    • Introduction to Simple formulas and Functions

    • Simple Formulas and Functions

    • Answers to Exercise 1

  • 4

    Chapter #3

    • Let us do more with the Excel worksheet

    • Absolute Reference - Naming Ranges -Calculating Percentages

    • Answers to Part2

    • Linking Sheets

    • Answer to linking sheets

  • 5

    Chapter #4

    • Lets add some colour to your sheets

    • Formatting your Worksheet

    • Answers to Formatting Exercise

    • Conditional Formatting

    • Answers to Conditional Formatting

    • Creating Charts and Graphs