Module 1 - Your First Look at Excel
  • Introduction
  • Module 1 Introduction
  • Before you forget
  • Excels Help features
  • How do I open and save an Excel Workbook?
  • Opening and Saving Workbooks
  • What are the Ribbons
  • Excel Orientation
  • How do I enter data to excel
  • How do I add a formula?
  • Entering data and formuals to Excel
  • How do I navigate a workbook and select data?
  • How do I use and edit the quick access tool bar?
  • The quick access toolbar
  • Learn and Earn Activities
  • Module 1 basic excel quiz
  • Module 1 practice
  • Module 1 Conclusion
Module 2 - Working with Data in Excel
  • Module 2 Introduction
  • How do I use Autofill?
  • Autofill
  • How do I use Cut, Copy, Paste, Undo and Redo?
  • The Clipboard
  • How do I sort and filter in Excel?
  • Sort and Filter
  • How can I use Find/replace, Hide/unhide and how can I name and move worksheets?
  • Find and Replace
  • Formatting – How do I work with fonts and number formatting?
  • Formatting – How do I work with alignment and apply borders?
  • Formatting
  • Module 2 assignment 1
  • Module 2 assignment 2
  • Module 2 quiz
  • Module 2 Conclusoin
Module 3 Print and Preview Options in Excel
  • Module 3 Introduction
  • How do I preview and Print?
  • What page options are available when setting printing options?
  • How can I amend the page margins for printing an Excel workbook or worksheet?
  • Print Options in Excel
  • How do I add header and footers to an Excel workbook?
  • Headers and Footers
  • How to I change the view of my workbook?
  • Freeze panes
  • Module 3 quiz
  • Module 3 assignment
  • Module 3 Conclusion
Module 4
  • Module 4 Introduction
  • How do I insert a table?
  • How do I work with tables?
  • Tables
  • How do I insert a chart?
  • Charts
  • How do I add and amend chart elements?
  • Chart Elements
  • Slicers
  • How do I insert slicers and timelines?
  • Module 4 quiz
  • Module 4 assignment 1
  • Course Conclusion
  • BONUS TIME