Skip to content

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

Categories: Excel
Share

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