BLOG
CATALOG
Menu
Businessman discussing budget report at the meeting with a computer and statements - Conquering the Grammar Game
a stack of orange and white books with text overlay of different training topics related to the professional workforce.
Browse hundreds of training topics to elevate team performance.
a laptop and phone with course training text on the screen.

Learn about PTR’s interactive course workbook for different learning styles.

Professional African-American woman training instructor smiling with overlay text.

PTR instructors are experts at delivering engaging, professional training.

Microsoft Office Excel Basic Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

The course covers the latest version of Microsoft Excel (2021–2024);
earlier versions are available upon request.

This course aims to provide you with a foundation for Excel knowledge and skills. You’ll learn to organize, calculate, analyze, revise, update, and present your data. It will also make these tasks much easier for you to accomplish in less time than if you used traditional pen-and-paper methods or non-specialized software. 

Recommended Follow-Up: Microsoft Excel Intermediate

Learning Objectives »

  • Getting started with Microsoft Office Excel.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Course Agenda

Getting Started with Microsoft Excel

  1. Navigate the Excel User Interface
  2. Use Excel Commands
  3. Create and Save a Basic Workbook
  4. Enter Cell Data
  5. Use Excel Help

Performing Calculations

  1. Create Worksheet Formulas
  2. Insert Functions
  3. Reuse Formulas and Functions

Modifying an Excel Worksheet

  1. Learn to insert, delete, and adjust cells, columns, and rows.
  2. Searching for and Replacing Data
  3. Use Proofing and Research Tools

Formatting an Excel Worksheet

  1. Apply Text Formats
  2. Apply Number Formats
  3. Align Cell Contents
  4. Apply Styles and Themes
  5. Apply Basic Conditional Formatting
  6. Create and Use Templates

Printing Workbooks

  1. Preview and Print a Workbook
  2. Set Up the Page Layout
  3. Configure Headers and Footers

Managing Workbooks

  1. Managing Worksheets
  2. Manage Workbooks
  3. Managing Worksheet Views
  4. Managing Workbook Properties
Businessman discussing budget report at the meeting with a computer and statements - Conquering the Grammar Game

Microsoft Office Excel Basic Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

The course covers the latest version of Microsoft Excel (2021–2024);
earlier versions are available upon request.

This course aims to provide you with a foundation for Excel knowledge and skills. You’ll learn to organize, calculate, analyze, revise, update, and present your data. It will also make these tasks much easier for you to accomplish in less time than if you used traditional pen-and-paper methods or non-specialized software. 

Recommended Follow-Up: Microsoft Excel Intermediate

Learning Objectives »

  • Getting started with Microsoft Office Excel.
  • Perform calculations.
  • Modify a worksheet.
  • Format a worksheet.
  • Print workbooks.
  • Manage workbooks.

Course Agenda

Getting Started with Microsoft Excel

  1. Navigate the Excel User Interface
  2. Use Excel Commands
  3. Create and Save a Basic Workbook
  4. Enter Cell Data
  5. Use Excel Help

Performing Calculations

  1. Create Worksheet Formulas
  2. Insert Functions
  3. Reuse Formulas and Functions

Modifying an Excel Worksheet

  1. Learn to insert, delete, and adjust cells, columns, and rows.
  2. Searching for and Replacing Data
  3. Use Proofing and Research Tools

Formatting an Excel Worksheet

  1. Apply Text Formats
  2. Apply Number Formats
  3. Align Cell Contents
  4. Apply Styles and Themes
  5. Apply Basic Conditional Formatting
  6. Create and Use Templates

Printing Workbooks

  1. Preview and Print a Workbook
  2. Set Up the Page Layout
  3. Configure Headers and Footers

Managing Workbooks

  1. Managing Worksheets
  2. Manage Workbooks
  3. Managing Worksheet Views
  4. Managing Workbook Properties
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.