MS Excel Foundation – Zero to Confident User

Categories: MS Excel Beginner
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

What is this Course?

  • A beginner-friendly, step-by-step foundation program designed to build strong fundamentals in Microsoft Excel

  • Covers essential concepts from basic navigation to working with data and formulas

  • Structured into 3 practical modules:

    • Getting Comfortable with Excel

    • Working with Data

    • Basic Formula Foundation

  • Focused on hands-on learning with real examples

  • Designed to help learners confidently use Excel for daily professional and academic tasks

What Will You Learn?

  • Clear understanding of Excel interface (Tabs, Groups, Worksheets, etc.)
  • Ability to create, open, save, and organize Excel files efficiently
  • Confidence in editing and formatting data professionally
  • Mastery of tools like:
  • Flash Fill
  • Text to Columns
  • Custom Lists
  • Advanced Fill options
  • Strong foundation in:
  • Basic formulas
  • Relative & Absolute references
  • Logical operators
  • Concatenation
  • Ability to manage and structure data cleanly and accurately

Course Content

Module 1
Module 1: Getting Comfortable with Excel 1. Excel Basics 2. Open, Create, Save 3. Tabs & Groups 4. Viewing Worksheets 5. Adjusting Worksheets 6. Working with Worksheets 7. Hyperlinking of Sheets

  • Chapter 1 – Excel Basics & Screen Interface Details
    05:03
  • Chapter 2 – Customized Tabs, Customized Groups & Buttons
    10:25
  • Chapter 3 – Edit Text, Find & Replace, Undo & Redo, Edit a Cell, Formulas & Functions
    13:39
  • Chapter 4 – Text Formatting & Text Alignment
    09:42
  • Chapter 5 – Numbers & Decimals, Dates & Formats, Currency Symbols
    08:00

Module 2
Working with Data - Relative Reference, Absolute Referencence Speak Cells, Stop Speaking Cells Text to Columns, Tab Delimited, Fixed with Advance Fill & Advantanges Flashfill & Features

Module 3
Lessons Covered Logical Functions, Equal to, Greater than, Less than, Less than or equal to, Greater than or equal to Excel Formulas, Addition, Subtraction, Multiplication, Division, BODMAS If Function, Nested If Function AND Function

Student Ratings & Reviews

No Review Yet
No Review Yet