You are here: / / / Microsoft Excel Training – Beginner

MSEX101

Microsoft Excel Beginner Training

Duration:22.5 Hours (Over 5 ~ 6 days)
Language:English
Platform:Windows
Format:Option 1:  Online Live Instructor-led
Option 2:  In-Class with Instructor
Class Size:1 ~ 5 Participants
Who should attend:Students, job seekers, office workers, small business owners, and anyone new to Excel who wants to build practical spreadsheet skills.
Pre-requisite:Basic computer knowledge and familiarity with using a mouse and keyboard—no prior Excel experience required.
Key Outcomes & Highlights:Gain practical Excel skills to organize data, use formulas, create charts, and confidently manage spreadsheets for personal or professional use.

Dates coming soon…

No start dates available at the moment.

SKU: MSEX101 Category: Tags: , , , , , , , , , , , , , ,

Course Curriculum

  • Introduction to Microsoft Excel
    • Purpose and real-world use cases of Excel
    • Exploring the Excel interface: Ribbon, workbook, worksheet, cells
  • Creating and Saving Workbooks
    • Opening, creating, saving, and closing workbooks
    • Understanding file types (.xlsx, .csv, .xls)
  • Basic Cell Operations
    • Entering and editing data
    • Copy, cut, paste, undo, and redo
    • Autofill and Flash Fill basics
  • Formatting Cells
    • Formatting text and numbers
    • Applying borders, shading, and alignment
    • Using Format Painter
  • Managing Rows and Columns
    • Inserting, deleting, resizing, and hiding/unhiding
    • Freezing panes and using split view
  • Sorting and Filtering Data
    • Sorting by text, numbers, and dates
    • Using AutoFilter and custom filters
  • Basic Formulas and Functions
    • Understanding formulas and cell references
    • Introduction to functions: SUM, AVERAGE, MIN, MAX, COUNT
  • Working with Dates and Text
    • Using basic date functions (TODAY, NOW)
    • Text functions: CONCATENATE, LEFT, RIGHT, LEN
  • Working with Multiple Sheets
    • Adding, renaming, moving, and copying sheets
    • Using formulas across worksheets
  • Creating Charts
    • Types of charts: Column, Line, Pie, Bar
    • Inserting and customizing charts
    • Chart elements and design
  • Conditional Formatting
    • Highlighting duplicate values
    • Color scales, data bars, and icon sets
  • Data Validation
    • Creating drop-down lists
    • Restricting data entry
  • Working with Tables
    • Converting data into Excel tables
    • Table styles and structured references
  • Printing and Page Layout
    • Page setup and print area
    • Adjusting margins, headers, footers, and scaling
  • Keyboard Shortcuts and Tips
    • Useful navigation and editing shortcuts
    • Time-saving tricks for data entry
  • Intro to Named Ranges
    • Defining and using named ranges
    • Managing names for readability and formula clarity
  • Building a Small Project
    • Creating a simple invoice, budget tracker, or timesheet
    • Using formulas, formatting, and charts
  • Reviewing Key Concepts
    • Recap of essential skills and features covered
  • Common Mistakes and Troubleshooting
    • Fixing common formula and formatting errors
  • Course Q&A and Practice
    • Hands-on revision
    • Final Q&A and support
read more

What is Microsoft Excel Beginner Training?

Microsoft Excel Beginner Training is a structured course designed to teach you how to use Excel from the ground up. It covers all the essential skills including data entry, formatting, formulas, charts, and organizing information efficiently. You’ll learn how to navigate Excel confidently and perform common tasks with accuracy and speed.

Who is this course for?

This course is perfect for:

  • Students and job seekers looking to build foundational computer skills
  • Office workers who want to handle spreadsheets more efficiently
  • Small business owners managing data, invoices, or budgets
  • Anyone who wants to organize, analyze, or present data professionally

Why is learning Microsoft Excel important?

Excel is one of the most powerful tools for data management, widely used across all industries. From budgeting and tracking sales to organizing projects and creating reports, Excel helps you work smarter with data. Knowing how to use Excel is often a requirement for administrative, finance, HR, marketing, and management roles.

How can this course help your career?

By completing this course, you’ll gain job-ready Excel skills that can boost your resume, improve workplace productivity, and increase your confidence in handling data. It opens doors to a variety of career paths and makes you more efficient in both professional and personal data tasks.

Contact Us