Introduction and Welcome
  • Welcome
  • Navigating The Udemy Dashboard and Viewing Settings
  • Introduce Yourself
Introduction To Excel
  • Name and Save a Microsoft Excel Workbook
  • Add and Format Text in a Microsoft Excel Worksheet
  • Save time by Autofilling Data in a Microsoft Excel Spreadsheet
  • Add Simple Data and Formulas to a Microsoft Excel Worksheet
  • Choose and Change Cell Formats
  • Add More Basic Formula in a Microsoft Excel Spreadsheet
  • Add Total and Averages Formulas into a Microsoft Excel Worksheet
  • Use Absolute Referencing to Anchor a Cell or Cells in a Microsoft Worksheet
  • Add Borders to Define a Table in a Microsoft Excel Worksheet
  • Print a Microsoft Excel Worksheet
  • Insert Headers and Footers into a Microsoft Excel Worksheet
  • Sort Simple and Related Data in a Microsoft Excel Worksheet
  • Extract Data Through Filtering in a Microsoft Excel Spreadsheet
  • Summary and Next Steps
Supporting Documents
  • Timesheet Spreadsheet Version 1 - Showing Data
  • Timesheet Spreadsheet 1 - Showing Formula
Developing The Spreadsheet Further
  • Insert and Format a Table of Data in a Microsoft Excel Spreadsheet
  • Duplicate a Worksheet
  • Delete Data From a Table
Troubleshooting/ Answers to Questions From Students
  • Why Do Hashes Appear In Columns Instead of Data? Fix
  • Why Does Excel Auto-Complete (Auto-Populate) Cells? Explanation
  • Why is My AutoFill Not Working? (Fix)
  • Why Isn't AutoSum Selecting Range of Cells? Fix
  • How To Duplicate An Existing Worksheet (To keep formatting)
Quick Start Tips and Shortcuts
  • #1 Add Up a Range of Cells in Microsoft Excel Fast (Alt +-)
  • #2 Insert Current Date and Time Using Microsoft Excel Shortcut Keys
  • #3 Creating Multiple Worksheets, Changing Tab Name and Colour in Microsoft Excel
  • #4 Change the Colour of The Gridlines on a Microsoft Excel Worksheet
  • #5 Change Colour of Text and Cells In Microsoft Excel Worksheets (Tip #5)
  • Microsoft Excel Shortcut Keys
(Course Preview) Quick Start: Creating an Accountancy Spreadsheet
  • Creating a Business Spreadsheet
  • Business Yearly Set Up (Image)
  • (First Calendar Month)Inserting Formula - Setting Up A New Worksheet With Titles
  • Creating and Formatting an Excel Table With Monthly Accountancy Headings
  • How Do I Get This Course?
Extra Support, Tutorials and Tips
  • Join my Free Facebook Group Now!