Welcome to Excel for Beginners
  • Course Structure and Delivery Methodology
  • My Latest Course! Free for a Limited Time Only
Getting Started with Excel for New Users
  • Introduction
  • Opening Excel for the First Time
  • Saving, Closing and Opening your File
  • Screen Elements Explained
  • Typing and Deleting Data
  • Scrolling and Zooming
Text and Cell Formatting
  • Introduction
  • Workbook Download
  • Font Selection and Font Sizing
  • Bold, Italic and Underline
  • Cell and Text Colouring
  • Border Creation
  • Horizontal and Vertical Justification
  • Wrap Text and Merging
  • Row and Column Adjustment
  • Format Clearing
Number Formatting – Currency, Decimal Places, Dates and More
  • Introduction
  • Workbook Download
  • Number Generator
  • Number Types
  • Decimal Places
  • Currency and Accounting
  • Dealing with Dates
  • Creating Time and Dates
  • Format Painter
AutoSum and Count Functions
  • Introduction
  • Workbook Download
  • Applying the AutoSum
  • Average, Minimum, Maximum and Count
  • Readjusting the Connections
  • Applying to Large Tables
Formulas - Arithmetic Functions
  • Introduction
  • Workbook Download
  • Formula Construction - Addition
  • Other Arithmetic Functions
  • Linking Cells into your Formulas
  • Using BODMAS
  • Copying Formulas
  • Fill Handle
Inserting Equations, Symbols, WordArt and Hyperlinks
  • Introduction
  • Workbook Download
  • Equation Editor (Part I)
  • Equation Editor (Part II)
  • Symbols
  • WordArt
  • Hyperlinks
Increase your Organisation using Sheets
  • Introduction
  • Workbook Download
  • How you shouldn't use Sheets
  • Renaming, Reordering and Tab Colouring
  • Moving and Copying sheets between Workbooks
  • New Window Function
Importing Images, Control and Formatting
  • Introduction
  • Workbook Download
  • Importing Images
  • Moving, Resizing and Rotating
  • Picture Styling and Artistic Effects
  • Bring to Front and Back
  • Cropping
Shapes – Text Boxes, Arrows, Squares, Flowcharts, Banners and More
  • Introduction
  • Workbook Download
  • Textboxes and Formatting
  • Arrows and Arrow Locking
  • Shape Proportion Adjustments
  • Object Rotation
  • Quick Duplications
SmartArt
  • Introduction
  • Workbook Download
  • Inserting SmartArt
  • Indenting
  • Colours, Accents and Styles
  • Layout Changes
  • Graphic Restting
Data Sorting and Filtering
  • Introduction
  • Workbook Download
  • Sorting A to Z, Z to A
  • Custom Sort Based on Field
  • Primary Key
  • Sorting by Cell Colour
  • Multi-Level Sorting
Inserting a Basic Line Chart
  • Introduction
  • Workbook Download
  • Weight Loss Number Generator
  • Preparing your Data for a Line Chart
  • Inserting your Line Chart