add_action( 'after_setup_theme', function() { remove_action( 'generate_archive_title', 'generate_archive_title' ); } );
BLOGCATALOG
Menu
An individual analyzing data from an ipad while working on the laptop
COURSE CATALOG

Microsoft Excel Intermediate

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

You know how to use Microsoft Excel to perform simple calculations and modify your workbooks and worksheets to make them easier to read, interpret, and present to others. However, Microsoft Excel is capable of doing so much more. With this course, you can extract actionable organizational intelligence from your raw data to crunch the numbers when needed.

Learning Objectives »

  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Use PivotTables and Pivot Charts.

Course Agenda

Working with Microsoft Excel Functions

  1. Work with Ranges 
  2. Use Specialized Functions
  3. Work with Logical Functions 
  4. Work with Date & Time Functions 
  5. Work with Text Functions 

Working with Microsoft Excel Lists

  1. Sort Data 
  2. Filter Data 
  3. Query Data with Database Functions 
  4. Outline and Subtotal Data

Analyzing Data

  1. Create and Modify Tables 
  2. Intermediate Conditional Formatting 
  3. Apply Advanced Conditional Formatting 

Visualizing Data with Charts

  1. Create Charts
  2. Modify and Format Charts
  3. Used Advanced Chart Features

Pivot Tables and Pivot Charts

  1. Create a PivotTable
  2. Analyze PivotTable Data
  3. Present Data with PivotCharts
  4. Filter Data Using Timelines and Slicers
An individual analyzing data from an ipad while working on the laptop

Microsoft Excel Intermediate

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

You know how to use Microsoft Excel to perform simple calculations and modify your workbooks and worksheets to make them easier to read, interpret, and present to others. However, Microsoft Excel is capable of doing so much more. With this course, you can extract actionable organizational intelligence from your raw data to crunch the numbers when needed.

Learning Objectives »

  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Use PivotTables and Pivot Charts.

Course Agenda

Working with Microsoft Excel Functions

  1. Work with Ranges 
  2. Use Specialized Functions
  3. Work with Logical Functions 
  4. Work with Date & Time Functions 
  5. Work with Text Functions 

Working with Microsoft Excel Lists

  1. Sort Data 
  2. Filter Data 
  3. Query Data with Database Functions 
  4. Outline and Subtotal Data

Analyzing Data

  1. Create and Modify Tables 
  2. Intermediate Conditional Formatting 
  3. Apply Advanced Conditional Formatting 

Visualizing Data with Charts

  1. Create Charts
  2. Modify and Format Charts
  3. Used Advanced Chart Features

Pivot Tables and Pivot Charts

  1. Create a PivotTable
  2. Analyze PivotTable Data
  3. Present Data with PivotCharts
  4. Filter Data Using Timelines and Slicers
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.