BLOG
CATALOG
Menu
Portrait of young and cheerful male businessman in a wheelchair holding his smartphone and smiling while sitting at his workplace in modern office. Handicapped worker. Trading online. Stock market - leadership strategies for wellness
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 Advanced 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 advanced 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 and in much less time than if you used traditional pen-and-paper methods or non-specialized software.

Course Prerequisite: Microsoft Excel Intermediate

Learning Objectives »

  • Work with multiple worksheets and workbooks.
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Use lookup functions, dynamic arrays, and formula auditing.
  • Forecast data.
  • Create sparklines and map data.

Course Agenda

Multiple Worksheets and Workbooks

  1. Use Links and External References
  2. Use 3-D References
  3. Consolidate Data

Sharing and Protecting Workbooks

  1. Collaboration on a Workbook
  2. Protecting Excel Worksheets and Workbooks

Sharing and Protecting Workbooks

  1. Applying Data Validation
  2. Invalid Data and Formulas with Errors
  3. How to work with Macros

Lookup Functions, Dynamic Arrays, & Formula Auditing

  1. Using Lookup Functions
  2. Using Dynamic Arrays and Functions
  3. Trace Cells
  4. Watch and Evaluate Formulas

Forecasting Data

  1. Potential Outcomes Using Data Tables
  2. Potential Outcomes Using Scenarios
  3. Use the Goal Seek Feature
  4. Forecasting Data Trends

Creating Sparklines & Mapping Data

  1. Create Sparklines
  2. Map Data

Formats ⟩  Live Virtual: 4 hrs./day, 4 Days  |  In-Person: 6 hrs./day, 4 Days

Portrait of young and cheerful male businessman in a wheelchair holding his smartphone and smiling while sitting at his workplace in modern office. Handicapped worker. Trading online. Stock market - leadership strategies for wellness

Microsoft Office Excel Advanced 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 advanced 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 and in much less time than if you used traditional pen-and-paper methods or non-specialized software.

Course Prerequisite: Microsoft Excel Intermediate

Learning Objectives »

  • Work with multiple worksheets and workbooks.
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Use lookup functions, dynamic arrays, and formula auditing.
  • Forecast data.
  • Create sparklines and map data.

Course Agenda

Multiple Worksheets and Workbooks

  1. Use Links and External References
  2. Use 3-D References
  3. Consolidate Data

Sharing and Protecting Workbooks

  1. Collaboration on a Workbook
  2. Protecting Excel Worksheets and Workbooks

Sharing and Protecting Workbooks

  1. Applying Data Validation
  2. Invalid Data and Formulas with Errors
  3. How to work with Macros

Lookup Functions, Dynamic Arrays, & Formula Auditing

  1. Using Lookup Functions
  2. Using Dynamic Arrays and Functions
  3. Trace Cells
  4. Watch and Evaluate Formulas

Forecasting Data

  1. Potential Outcomes Using Data Tables
  2. Potential Outcomes Using Scenarios
  3. Use the Goal Seek Feature
  4. Forecasting Data Trends

Creating Sparklines & Mapping Data

  1. Create Sparklines
  2. Map Data

Formats ⟩  Live Virtual: 4 hrs./day, 4 Days  |  In-Person: 6 hrs./day, 4 Days

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.