Introduction
  • Introduction to the Course
  • Important notice about the Practice Files
Worksheet Hacks & Shortcuts
  • Section Introduction and Practice Files
  • How to Create a Hyperlink to Other Worksheets
  • Copying and Moving Worksheets in Various Ways
  • Entering Data to Multiple Worksheets at a Time
  • Preventing a sheet from Unhiding - Very Hidden Property
  • Hiding Scrollbars in a Worksheet
  • Creating and Managing Custom Views
  • Changing the Default number of Worksheets
  • Hiding and Unhiding Sheets
Basics of Shortcuts
  • Understanding the Types of Shortcuts
  • How to identify a shortcut for a feature
  • Moving between Ribbons - Inwards and Outwards
  • Shortcuts within Features - Inwards and Outwards
Data Protection Shortcuts and Hacks
  • Section Introduction and Practice File
  • Protecting a Sheet, yet allowing only a few actions to happen
  • Enabling a part of the Sheet to be editable
  • How to Create Backup of your file automatically
  • Excel Password Encryption to Open and Modify
  • Data Protection Quiz
Navigation Shortcuts & Hacks
  • Section Introduction & Practice File Download
  • Navigating within a Sheet - Empty Sheet
  • Navigating within a Sheet - With data
  • Navigating Between Sheets
  • Navigation Quiz
Formatting Hacks and Shortcuts
  • Section Introduction and Practice Files
  • How Excel Stores Info
  • Changing Default Values
  • Shrink Cell Tools to Have the Size of the Cells
  • How to Add Text to a Number
  • Solving the Problem with Leading Zero
  • Blocking a User from Interacting Outside a Specific Range
  • Understanding the Custom Format Options
  • How to Hide & Unhide the Status Bar
  • Calculating Values without Formulas
  • Highlight Cells that contains Formulas
  • Coloring Alternate Rows or Columns
  • Formatting Numbers – Rapid Fire Shortcuts
  • Duplicate Records and How to Get Rid of These
  • Creating Bulleted List
  • Format Painter Tips
  • How to Insert a Watermark
  • Formatting Dates - Custom Date formats
  • Filling a cell with Color - Shortcut
  • Increasing the Font Size and Decreasing it using Shortcut
  • Hiding and Unhiding Rows and Columns
  • Summary