Welcome
  • Introduction
  • Welcome to Udemy
  • Introduction to Udemy
  • Curriculum
Level 1, Section 1 - An introduction to Excel
  • Creating new blank workbooks
  • Entering data
  • An introduction to fonts and highlighting
  • Saving and closing your workbook
  • Practice Activity Number 1
  • Practice Activity Number 1 - The Solution
Level 1, Section 2 - Create worksheets and workbooks
  • Creating new workbooks using templates
  • Menus and toolbars
  • Managing multiple workbooks
  • Importing files and Opening non-native files directly in Excel
  • Adding worksheets to existing workbooks
  • Copying and moving worksheets, and changing spreadsheet order
Level 1, Section 3: Configure worksheets and workbooks to save
  • Saving workbooks in alternate file formats
  • Saving files to remote locations
Level 1, Section 4: Basic formulas
  • Using basic operators
  • Order of operations
  • How to enter numbers and dates
  • Referencing cell ranges in formulas
  • Solution to the above exercise
  • Practice Activity Number 2
  • Practice Activity Number 2 - The Solution
Level 2, Section 1: Navigate through worksheets and workbooks
  • Searching for data within a workbook
  • Hyperlinks
  • Using Go To and Using Name Box
  • Hot Keys
Level 2, Section 2: Format worksheets and workbooks
  • Changing worksheet tab colour
  • Inserting and deleting columns and rows
  • Undo and Redo
  • Adjusting row height and column width
  • Hiding columns and rows
  • Selecting multiple ranges
  • Practice Activity Number 3
  • Practice Activity Number 3 - The Solution
Level 2, Section 3: Customise options and views for worksheets and workbooks
  • Hiding worksheets
  • Customising the Quick Access toolbar
  • Customising the Ribbon for purchased versions of Excel
  • Customising the Ribbon
  • Recording simple macros
  • Managing macro security
  • Changing workbook views
  • Using zoom
  • Adding values to workbook properties
  • Displaying formulas
  • Freezing panes
  • Splitting the window
  • Practice Activity Number 4
  • Practice Activity Number 4 - The Solution
Level 2, Section 4: Configure worksheets and workbooks to print
  • Printing individual worksheets
  • Printing an entire workbook and printing a selection
  • Setting a print area
  • Page setup, Part 1 (first two tabs)
  • Page setup, Part 2 (Repeating headers and footers)
  • Adding dynamic text to headers and footers
  • Page setup, Part 3 (Headings etc.)
  • Configuring workbooks to print
  • Practice Activity Number 5
  • Practice Activity Number 5 - The Solution
Level 2, Section 5: Utilise cell ranges and references in formulas and functions
  • Copying and pasting basics, and Utilising references (relative, mixed, absolute)
  • Practice Activity - multiplication table
  • Answer - multiplication table
Level 3, Section 1: Insert data in cells and ranges
  • Appending data to worksheets
  • Setting data validation
  • Finding and replacing data
  • Copying and pasting data, including Paste Special
  • Cutting and moving cell data
  • Using AutoFill tool, and Expanding data across columns
  • Practice Activity Number 6
  • Practice Activity Number 6 - The Solution
Level 3, Section 2: Format cells and ranges
  • Modifying cell alignment and indentation
  • Wrapping text within cells
  • Merging cells and Shrink to Fit
  • Changing font and font styles
  • Applying highlighting
  • Applying Number format
  • Applying borders
  • Applying cell styles
  • Using Format Painter
  • Changing text to WordArt
  • Practice Activity Number 7
  • Practice Activity Number 7 - The Solution
Level 3, Section 3: Highlight and filter cells and ranges
  • Applying conditional formatting - highlighting
  • Applying conditional formatting - Bars, Scales and Sets
  • Transposing columns and rows, and #####s