Skip to content

The Excel 101 Mastery Series: Self-Learn Combo (Basic – Intermediate)

Categories: Excel
Share
Share Course
Page Link
Share On Social Media

About Course

Master the world’s most widely used data tool from scratch. This bundle is designed for students, fresh graduates, and working professionals who need a flexible, “learn anytime” path to professional data literacy.

Course Syllabus

Level 1: Basic
• Ribbon, QAT & Interface
• Worksheet Management
• Shortcuts
• Data Entry Shortcuts
• Autofill & Flash Fill
• Formulas & Functions
• Data Cleaning
• Range, Table & Freeze Pane
• Paste Options

Level 2: Intermediate
• Sort & Filter
• Charts
• Conditional Formatting
• Data Validation
• Absolute Reference
• Relative Reference
• Vlookup
• Xlookup
• IF Function
• [IF(S)/SUMIF(S)/COUNTIF(S)/IF(AND)/IF(OR)]

Show More

What Will You Learn?

  • By the end of this course, you will be able to:
  • Confidently navigate the Excel interface, including Ribbon and Quick Access Toolbar
  • Manage worksheets efficiently for better file organization
  • Use essential keyboard shortcuts to work faster and smarter
  • Apply data entry shortcuts, Autofill, and Flash Fill to save time
  • Create and use basic formulas and functions accurately
  • Clean and organize raw data for analysis
  • Work with ranges and tables effectively
  • Use Freeze Pane and paste options for better data viewing and control

Course Content

Level 1: Basic

  • Ribbon, QAT and Interface
    00:00
  • Worksheet Management
    00:00
  • Shortcuts
    00:00
  • Data Entry Shortcuts
    00:00
  • Autofill & Flash Fill
    00:00
  • Formulas & Functions
    00:00
  • Data Cleaning
    00:00
  • Range, Table & Freeze Pane
    00:00
  • Paste Options
    00:00

Level 2: Intermediate