Excel – Part 1 training course

Instructor‑Led: $280 | Duration: 1 Day

Ready to start building your Excel skills from the ground up? This beginner Excel training course provides the foundation you need to grow your knowledge and become an expert in data manipulation over time. You'll learn how to create and format worksheets, perform basic calculation operations, work with charts and tables, and organize data efficiently.

This course also covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201.

Master the basics-and open the door to more advanced skills in data analysis, reporting, data visualization, and spreadsheet management.

Reserve your seat in an upcoming class date or select a Learning Method below:

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
4/20/2026 4/20/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$280.00
4/23/2026 4/23/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$280.00
4/28/2026 4/28/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$280.00
5/1/2026 5/1/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$280.00
5/6/2026 5/6/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$280.00
5/11/2026 5/11/2026
11:00AM - 7:00PM
star GTR

Guaranteed-to-Run

$280.00
START DATE : 4/20/2026
END DATE : 4/20/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $280.00
START DATE : 4/23/2026
END DATE : 4/23/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $280.00
START DATE : 4/28/2026
END DATE : 4/28/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $280.00
START DATE : 5/1/2026
END DATE : 5/1/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $280.00
START DATE : 5/6/2026
END DATE : 5/6/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $280.00
START DATE : 5/11/2026
END DATE : 5/11/2026
CLASS TIMES (EST) : 11:00AM - 7:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $280.00

Course Highlights

LEVEL: 
  • Beginner
TOPICS & JOB ROLES: 
BRANDS/TECHNOLOGIES: 

Excel – Part 1 Course Outline

Ready to start building your Excel skills from the ground up? This beginner Excel training course provides the foundation you need to grow your knowledge and become an expert in data manipulation over time. You'll learn how to create and format worksheets, perform basic calculation operations, work with charts and tables, and organize data efficiently.

This course also covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201.

Master the basics-and open the door to more advanced skills in data analysis, reporting, data visualization, and spreadsheet management.

PREREQUISITES
  • Basic computer literacy
  • Basic PC operating system navigation skills
  • Basic Internet usage skills

1 — Getting Started with Excel

  • Navigate the Excel user interface and organize your workspace efficiently
  • Use Excel commands and features, and locate tools with shortcut keys
  • Create and save a basic workbook
  • Access and use Excel Online for cloud-based collaboration
  • Enter and edit data entry efficiently in worksheets
  • Find help and support through built-in tools and Microsoft Support resources

2 — Performing Calculations

  • Build Excel formulas to perform calculations quickly
  • Insert and manage Excel functions like SUM, AVERAGE, and logical operators
  • Reuse and copy formulas and functions using step-by-step techniques

3 — Modifying a Worksheet

  • Insert, delete, and adjust cells, columns, and rows
  • Search for and replace data, and use filter tools for data management
  • Use proofing and research tools to ensure accuracy

4 — Formatting a Worksheet

  • Apply text and number formatting, including borders and shading for visual emphasis
  • Align, arrange, and organize worksheet content
  • Apply colors, borders, and predefined styles for professional spreadsheets
  • Apply basic conditional formatting to highlight trends
  • Create and use templates to streamline repetitive tasks

5 — Printing Workbooks

  • Preview and print worksheets with correct page layout settings
  • Configure headers and footers to provide context in printed sheets
  • Customize your sheet layout for clean presentation

6 — Managing Workbooks

  • Manage multiple sheets and workbooks efficiently
  • Update workbook properties to maintain organized files
  • Manage workbook and worksheet views for better navigation

Related Job Roles

This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

Explore Related Training Courses with TechSherpas 365