Course curriculum

    1. Course Welcome

    2. Course Overview

    3. Practice Task File

    1. Chapter Objectives

    2. Exploring the Excel Interface

    3. Creating and Saving Workbooks

    4. Navigating Worksheets

    5. Understanding Worksheets and Workbooks

    6. Chapter 1 Summary

    7. Chapter 1 Practice Task

    8. Chapter 1 Quiz

    1. Chapter Objectives

    2. Entering Data into Excel

    3. Adjusting Cell Sizes

    4. Formatting Cells

    5. Adding Borders and Colours

    6. Using AutoFill for Efficiency

    7. Chapter 2 Summary

    8. Chapter 2 Practice Task

    9. Chapter 2 Quiz

    1. Chapter Objectives

    2. Writing Basic Formulas

    3. Using Essential Functions

    4. Understanding Cell References

    5. Troubleshooting Formulas

    6. Sorting Data

    7. Filtering Data

    8. Find and Replace

    9. Freeze Panes and Splitting Windows

    10. Chapter 3 Summary

    11. Chapter 3 Practice Task

    12. Chapter 3 Quiz

    1. Chapter Objectives

    2. Introduction to Charts

    3. Customizing Charts

    4. Conditional Formatting

    5. Chapter 4 Summary

    6. Chapter 4 Practice Task

    7. Chapter 4 Quiz

    1. Chapter Objectives

    2. Saving Workbooks

    3. Sharing Workbooks

    4. Preparing for Printing

    5. Chapter 5 Summary

    6. Chapter 5 Practice Task

    7. Chapter 5 Quiz

About this course

  • 57 lessons