Course curriculum

  • 2

    Let's Learn About the Excel Window

    • Learn About the Excel Window

    • The Excel Window

  • 3

    Simple Formulas and Functions

    • Introduction to Simple formulas and Functions

    • Simple Formulas and Functions

    • Answers to Exercise 1

  • 4

    More Advanced Tasks

    • Let us do more with the Excel worksheet

    • Absolute Reference - Naming Ranges -Calculating Percentages

    • Answers to Part2

    • Linking Sheets

    • Answer to linking sheets

  • 5

    Formatting Your Worksheets

    • Lets add some colour to your sheets

    • Formatting your Worksheet

    • Answers to Formatting Exercise

  • 6

    Conditional Formatting

    • Conditional Formatting

    • Answers to Conditional Formatting

  • 7

    Creating Charts and Graphs

    • Creating Charts and Graphs