October webinars-Excel L2 (10/2), Excel L3 (10/15), Word (10/23)

(618) 806-2455

Office Productivity Training, LLC
Office Productivity Training, LLC
  • Home
  • Microsoft 365 Training
  • Excel & Power BI Training
  • Upcoming Events
  • Business Skills Training
  • 90-minute Training
  • Our Blog
  • Teams-Outlook-OneNote
  • Copilot-OneDrive-Word
  • PowerPoint
  • Microsoft 365 Apps
  • About Us
  • Contact Us
  • Access & Project Training
  • More
    • Home
    • Microsoft 365 Training
    • Excel & Power BI Training
    • Upcoming Events
    • Business Skills Training
    • 90-minute Training
    • Our Blog
    • Teams-Outlook-OneNote
    • Copilot-OneDrive-Word
    • PowerPoint
    • Microsoft 365 Apps
    • About Us
    • Contact Us
    • Access & Project Training
  • Home
  • Microsoft 365 Training
  • Excel & Power BI Training
  • Upcoming Events
  • Business Skills Training
  • 90-minute Training
  • Our Blog
  • Teams-Outlook-OneNote
  • Copilot-OneDrive-Word
  • PowerPoint
  • Microsoft 365 Apps
  • About Us
  • Contact Us
  • Access & Project Training

Master Excel and Power BI: Take Your Data Skills to the Next Level

 With 80% of the workforce using Excel, staying ahead means more than knowing the basics. Our Excel and Power BI training helps you analyze, visualize, and share insights with confidence—turning data into decisions and putting your skills at the top of the pack.  

Below is a list of our most popular Excel and Power BI courses. All courses are fully customizable—we can combine advanced Excel topics with basic or intermediate skills to create a class tailored to your team’s needs. Our goal is to deliver top-tier training in a flexible, efficient format that maximizes learning and productivity.

Contact Us for a free skills assessment and pricing

Excel Courses

Excel Basics

Excel L1- Fundamentals

4 hours

New to Excel or need a refresher? This workshop offers a concise, hands-on introduction to Excel, perfect for beginners. Learn essential skills to confidently navigate and use Excel in your workplace. 

Topics Include:

  • Spreadsheet basics
  • Formatting features and tricks
  • Developing formulas to perform calculations
  • Utilizing functions to simplify tasks
  • Managing multiple worksheets
  • Customizing page layout options for printing
  • Implementing shortcuts and time-saving tricks


Intermediate and Advanced Courses

Intermediate Excel

4 hours

Enhance your Excel skills with essential functions and formulas that help increase your efficiency and accuracy. This four-hour course is designed for those familiar with Excel basics and ready to improve their Excel skills. 

 Topics include:

  • Using absolute and relative cell references in formulas
  • Named Ranges
  • Date functions 
  • Logical IF functions
  •  AND and OR functions
  • Lookup Functions
  • Financial Functions
  • Using Goal Seek for Scenario Analysis
  • Data Validation 
  • Workbook protection options

Advanced Excel

4 hours

 The Advanced Excel course enhances your skills in using Table and Pivot Table tools to convert raw data, create dynamic reports, and generate professional, data-driven reports. Topics include:

  • Conditional formatting
  • Quick Analysis
  • Creating Charts
  • Filtering, sorting, and subtotal options
  • Tables
  • Pivot Tables and Pivot Charts

Excel Expert

4 hours

The Excel Expert course covers newer Excel functions, helping you understand and use them efficiently for improved effectiveness in Excel. Topics include:

  • Advanced Logical Functions
  • UNIQUE and SORT functions
  • SUMIFS, AVERAGEIFS, and COUNTIFS functions
  •  IFERROR Function
  •  FILTER and SORTBY Functions
  •  XLOOKUP  function
  • Using INDEX and MATCH functions together
  • The Place Picture in Cell feature
  • The INDIRECT function

Excel Dashboards with Power Query Basics and the Data Model

4 hours

 In this training, you'll create dynamic PivotTables, Pivot Charts, and multi-table PivotTables by leveraging Power Pivot's data model.

Key Topics Covered:

  • Designing Simple Dashboards with PivotTables & Pivot Charts
  • Utilizing the Camera Tool for Enhanced Visuals
  • Building Dashboards with Power Query Load Options
  • Understanding and Leveraging the Data Model
  • Importing and Managing Data within the Data Model
  • Establishing Relationships Between Tables
  • Creating Multi-Table PivotTables for Complex Data Analysis

Advanced Power Query

4 hours

This training will teach you how to utilize Excel's Power Query editor to clean and transform your data efficiently.

Key Topics Covered:

  • Importing Data into the Power Query Editor
  • Understanding and Managing Applied Steps
  • Using Transform Tools for Data Cleaning
  • Loading Cleaned Data into Excel
  • Editing Existing Queries
  • Creating and Using Append Queries
  • Merging & Splitting Data 
  • Pivoting and Unpivoting Data
  • Adding Custom Columns
  • Transposing Data
  • Appending Data from a Folder

Data Analysis and Visualization with Microsoft Excel

14 hours

Use the Excel tools that allow you to connect to outside data sources, perform robust data analysis, and create data-backed visualizations and reports to show insights and data trends.

  • Perform data analysis fundamentals
  • Visualize data with Excel
  •  Analyze data with formulas and functions
  • Analyze data with PivotTables
  • Present visual insights with dashboards
  • Create geospatial visualization 
  • Perform statistical analysis
  • Get and transform data
  • Model and analyze data with PowerPivot
  • Present insights with Report

Helping you be more productive with the software you use every day.

Power Query

Using Power Query in Microsoft Excel

6 hours

 

In this training, participants will learn how to extract data from a source, clean and transform the data, and then load the new data into a worksheet.  

  • Connecting Data to Power Query
  • Basic Transform Features 
  • Append Queries
  •  Adding Tables to the Data Model
  • Creating Table Relationships
  • Creating a Multiple Table PivotTable
  • Advanced Transform Features
  • Column Tools
  • Appending Folder Data

Helping you be more productive with the software you use every day.

Power BI

Power BI Training

Creating data-backed visualizations allows data scientists or professionals to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. 

Microsoft Power BI: Data Analysis Practitioner

 At the end of this program, learners will be able to: 

  • Analyze data with self-service BI
  • Connect to data sources 
  • Perform advanced data modeling and shaping
  • Visualize data with Power BI
  • Enhance data analysis 
  • Model data with calculations
  • Create interactive visualizations


Recommendations: To ensure your success, you should have experience managing data with a spreadsheet program such as Microsoft Excel or Google Sheets. Optionally, having experience with other data analytics tools, such as Google Analytics™ or Customer Relationship Management (CRM) tools, as well as an understanding of database design concepts and basic programming constructs such as looping and branching, will help you get even more out of this course. 


Training Length: 14 hours

New: Power BI for End Users: Advanced Skills

  

This course is designed for users with a basic understanding of Power BI and are ready to advance their skills to the next level. Content covers topics like calculated columns, advanced DAX functions, advanced visualizations, and Power Automate, all within a manageable 4-hour timeframe.


At the end of this program, learners will be able to:

  • Create and manage calculated columns for advanced data modeling.
  •  Apply advanced DAX functions for data analysis.
  • Design and implement advanced visualizations using custom visuals and themes.
  • Use Power Automate within Power BI to create automated workflows that enhance data analysis and reporting.


Prerequisite: This course is designed for users who have prior experience with data modeling and transforming data in the Power Query Editor. Participants should be comfortable with foundational Power BI concepts and have hands-on experience creating and managing data models.

  

Course Length: 4 hours

Tips and Tricks

Download one of our Tips & Tricks Infographics or instructions.

Excel Fundamental Tips & Tricks (pdf)

Download

Quickly Combine Column Data with Flashfill (pdf)

Download

Removing Duplicates from an Excel List (pdf)

Download

How to Create Pivot Table Report Pages (pdf)

Download

How to use the GETPIVOT function (pdf)

Download

Contact Us for a Free Consultation and Pricing

Drop us a line!

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Office Productivity Training, LLC

2212 Haverford Dr. Shiloh, IL 62221

(618) 806-2455

Social

Copyright © 2025 Office Productivity Training, LLC - All Rights Reserved.

Powered by

  • Microsoft 365 Training
  • Excel & Power BI Training
  • 90-minute Training
  • Teams-Outlook-OneNote
  • Copilot-OneDrive-Word
  • PowerPoint
  • Privacy Policy

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept