Introduction
  • Introduction
  • What is Excel
  • How To Get Excel?
Excel Fundamentals
  • Opening Excel for the first time
  • Excel Ribbon, Tab, Rows, Columns, Zoom
  • Navigate to different cells in Excel
  • Workbooks & Worksheets
  • Quick Access Toolbar
Excel Shortcuts
  • Excel Exercise Book
  • Shortcuts to move to Different Sheets
  • Quickly Move Within a Worksheet
  • Move to Beginning or End of the Data
Worksheet Fundamentals
  • Insert & Rename a Sheet
  • Column Width Adjustments
  • Change Data Entry Direction
  • Text & Number Alignment
  • Accessing Help in Excel
Data Entry in Excel + Quick Tips
  • Using Right Click Menus
  • Using Flash Fill
  • Flash Fill for Months
  • Delete Multiple Cells
  • Row & Column Height
Formatting Dates in Excel
  • Format Dates & Times
  • Getting a Date and time Stamp in Excel
Editing Data in Excel
  • Ways to Edit a Cell
  • Cut, Copy and Paste within a Cell
  • Move single or multiple cells
  • Merge and Centre
  • Changing Fonts & Colors
Save Excel Files - Locally or in the Cloud
  • Save a Workbook
  • Benefits of Saving in the Cloud
Formatting Data in Excel & Worksheet Magic
  • Inserting & Deleting Cells
  • Changing Tab Color
  • Move or Copy Worksheets
  • Rename a Worksheet
  • Format & Alignment of Text
  • Number Formatting & Decimal Places
Formulas & Functions in Excel
  • Use Excel as a Calculator
  • Order of Precedence
  • Simple Formulas in Excel
  • Introduction to Excel Functions
  • Inbuilt Functions in Excel, like SUM
  • Average Function in Excel
  • Count Function in Excel
  • Absolute & Relative Referencing
  • Absolute References in-depth
  • VLOOKUP Function
  • VLookup Simplified
  • XLOOKUP Function
Creating & Using Tables in Excel
  • How to Create a Table in Excel
  • Sorting a Table
  • Filtering a Table
Creating Charts in Excel
  • Create Simple Charts
Pivot Tables in Excel
  • Creating a Pivot Table in Excel