Introduction & Course Overview
  • Welcome To The New Beginning
  • Download Dataset
Quick Tour Of Excel
  • Tabs & Ribbons
  • Name Box
  • Formula Bar - FX
  • Rows & Columns
  • Sheets - How Does It Works?
  • Cells - Zoom In - Zoom Out
  • Scroll Bar
  • Data Entry
  • Save The File
Formatting Functions
  • Cell Border Outline
  • Font Bold / Italic / Underline
  • Cell Color Change/Update
  • Font Color Change
  • Merge Cells
  • Format Painter
  • Text Alignment In the Cells
  • Font Styling
  • Font Size - Increase & Decrease
Hyperlink / Find / Replace / Create, Hide, Unhide, Rename Sheets
  • Find Your Values / Text In Your Workbook
  • Replace Values
  • Hyperlink
  • Cut - Copy - Paste "Your Data"
  • Sheet Tab Color Change
  • Insert New Sheet
  • Delete Sheet
  • Rename Sheet Tab
  • Moving Sheet within Workbook
  • Hide / Unhide - Sheet Tabs
Filter & Data Sorting
  • Filter Your Data
  • Data Sorting
  • Hide and Unhide - Rows & Columns
  • Delete - Rows & Columns
  • Insert - Rows & Columns
Text To Column - How To Split Your Data
  • Text to Column - Data Split
Data Validation - Drop Down List
  • Create Your Own Drop Down List
  • How To Unrestricted Your Drop Down List
Data Cleaning
  • Data Formatting & Cleaning
Final Updates From Me
  • Closing Notes
What's New NOW
  • Boost Your Career Now