BLOGCATALOG
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.
Professional African-American woman training instructor smiling with overlay text.
Meet our PTR trainers, experts in engaging, impactful learning.
Accurate dart in center of a red and white target with bold text about hitting training goals.
Sharpen your team’s skills for high-impact, goal-precision results.

Microsoft Office Excel – Basic

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

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
COURSE CATALOG
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.