Microsoft Excel training

Basic Excel Training

Build a solid working knowledge of Microsoft Excel and confidently handle everyday data tasks—from worksheet navigation and essential formulas to charts and introductory analysis.

Join a Public Class Request Company Training

Beginner levelLittle to no formal Excel training

Instructor-ledGuided exercises and realistic worksheets

Flexible deliveryPublic class or exclusive company session

Course overview

Start with strong Excel foundations.

This program is designed for novice Excel users who want to work more confidently and efficiently. Participants learn core features, formulas, data organization, visualization, and introductory analysis.

The course also prepares learners for more advanced applications such as reporting, dashboards, and data analytics.

Understand Excel’s core features and essential functions for professional use.

Manage datasets using sorting, filtering, formatting, and validation tools.

Apply foundational formulas in practical business scenarios.

Create basic charts and PivotTables to summarize information.

Build confidence for advanced Excel and data-analysis training.

Who should attend

Designed for everyday Excel users.

Excel beginners

Participants with little to no formal Excel training.

Administrative teams

Administrative, HR, finance, and operations staff handling routine data.

Process improvers

Professionals moving from manual processes to spreadsheet-based work.

Productivity learners

Employees who want stronger workplace digital skills.

Interactive instruction

Instructor-led exercises, structured activities, recitation, and active participation.

Scenario-based practice

Realistic worksheets, guided problem solving, and feedback on formulas and workflows.

Course outline

What you will learn.

Open each section to review the topics covered. The final sequence may be adjusted to the class profile and available duration.

Basic Worksheet Operations

Merging cells and wrapping text
Freezing cells and panes
Cell formatting options
Filtering and sorting data
Row, column, and sheet operations
Formatting values
Protecting ranges

Essential Excel Functions

Arithmetic formulas including SUM and AVERAGE
Text functions including LEFT, RIGHT, and CONCATENATE
Conditional functions including SUMIFS, COUNTIF, and RANK
Handling dates
IF, nested IFs, and series IFs
VLOOKUP and named ranges
Combining functions in practical scenarios
Essential shortcut keys

Data Tab Tools

Text to Columns
Conditional formatting
Data bars, color scales, and icon sets
Subtotal tools
Data validation
Basic dropdown lists

Creating Basic Charts

Chart elements, axes, labels, legends, and data tables
Choosing an appropriate chart for the purpose

Introduction to PivotTables

Creating PivotTables for data analysis
Modifying value-field settings
Grouping data
Using slicers

Choose your path

How would you like to join?

Individuals and small groups

Check the live public schedule for available Basic Excel dates, rates, delivery modes, and enrollment options.

View Public Classes

Company teams

Request an exclusive program for your organization with your preferred schedule, venue, and participant requirements.

Request a Proposal

Continue learning