February Webinars-OneDrive (Feb. 7), Excel L2- Formulas & Functions (Feb. 16)

(314) 596-2534

Office Productivity Training, LLC
Office Productivity Training, LLC
  • Home
  • Upcoming Events
  • 90-minute Training
  • Software Training
  • Business Skills Training
  • Online & Virtual Training
  • Our Blog
  • Excel Training
  • Access & Project Training
  • Outlook-OneNote Training
  • Word & Office Training
  • PowerPoint & Publisher
  • Other Training Topics
  • Instructional Design
  • Consulting Services
  • About Us
  • Contact Us
  • More
    • Home
    • Upcoming Events
    • 90-minute Training
    • Software Training
    • Business Skills Training
    • Online & Virtual Training
    • Our Blog
    • Excel Training
    • Access & Project Training
    • Outlook-OneNote Training
    • Word & Office Training
    • PowerPoint & Publisher
    • Other Training Topics
    • Instructional Design
    • Consulting Services
    • About Us
    • Contact Us
  • Home
  • Upcoming Events
  • 90-minute Training
  • Software Training
  • Business Skills Training
  • Online & Virtual Training
  • Our Blog
  • Excel Training
  • Access & Project Training
  • Outlook-OneNote Training
  • Word & Office Training
  • PowerPoint & Publisher
  • Other Training Topics
  • Instructional Design
  • Consulting Services
  • About Us
  • Contact Us

80% of the workforce uses Excel. Our Excel training will bring your skills to the top of the pack

Are you proficient in Excel? Being able to organize and analyze information quickly is an essential productivity skill. Excel training is the easiest way to gain these skills quickly.


Below is a list of our most common Excel training courses. Our courses are customizable. We can mix and match our advanced excel training topics with basic and intermediate skills and create a specialized class that meets your specific needs. Our goal is to provide the best excel training in the most efficient and flexible time format.

Contact Us for a free skills assessment and pricing

Excel Courses

Excel Basic Courses

The following course is designed for Excel beginners.

Excel L1 - Fundamentals

4 hours

  

Are you proficient in Excel? Maintaining and creating spreadsheets is a requirement for almost every office job. This short hands-on workshop teaches the most essential skills needed to maintain workbooks. Topics include:

  • Spreadsheet Basics
  • Creating worksheets from scratch
  • Formatting Features and Tricks
  • Creating Formulas 
  • Using Functions
  • Page Layout Options
  • Shortcuts and Tricks


Intermediate and Advanced Courses

Intermediate Excel

4 hours

  

The best shortcuts in Excel are the calculations available through formulas and functions. The Excel Intermediate four-hour course walks you through what you need to know to be well versed in Excel’s most common functions. Topics include:


  • Working with multiple worksheets and workbooks
  • Named Ranges
  • Date functions
  • Logical If functions
  • Common Financial functions
  • VLOOKUP & HLOOKUP
  • The Goal Seek

Advanced Excel

4 hours

  

The Excel Advanced course explores the reporting features of Excel. From creating visualizations through conditional formatting, charts, and graphs, filtering information through a table, and summarizing a data list with pivot tables, this course explains the endless possibilities of analyzing and reporting data with Excel. Topics include:

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

Excel Expert

4 hours

  

This course explains the Excel tools that help teams work together and share information. Trainees will also learn how to create intuitive spreadsheets using advanced functions that combine different logical and lookup functions. Topics include:

  • Logical Functions, IF, AND, and OR
  • The UNIQUE Function
  • Data Validation
  • Criteria Based Logical Functions. SUMIFS, AVERAGEIFS, COUNTIFS, and IFERROR
  • XLOOKUP
  • INDEX and MATCH
  • The Scenario Manager

Excel Productivity Tips for Advanced Users

4 hours

  

Visualization is the key when reporting numbers. Excel Productivity Tips for Advanced users presents advanced conditional formatting, charting, and pivot table tips to help experienced Excel users create reporting visualizations from their data. Topics include:

  • Customizing conditional formatting rules
  • Advanced charting tools
  • Slicers and timelines
  • PivotTable report filter pages
  • PivotTable calculated fields
  • GETPIVOTDATA function
  • Creating dashboard elements

Automating Excel

4 hours

The Automating Excel course provides the final step to customizing and sharing a workbook. This hands-on workshop teaches users how to import and query data from outside sources, create data user forms, and automate the workbook using macros. Users will also learn how to create dynamic PivotTables by relating more than one table. Topics include:

  

  • Importing data
  • Query Builder
  • Table relationships
  • Creating PivotTables based on different tables
  • Creating Forms
  • Creating Macros

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 BI and Tableau

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

Microsoft Power BI: Data Analysis Professional

 Learner Outcomes At the end of this course, you 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 
  • Perform advanced analysis 
  • Publish and share reports and dashboards 
  • Extend access to Power BI 


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), 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: 21 hours

Tableau

Tableau is another software program that is used to create data visualizations from a wide array of data sources.

Tableau: Part 1

 At the end of this course, the learner will be able to: 

  • Identify and configure basic functions of Tableau 
  • Connect to data sources, import data into Tableau, and save Tableau files 
  • Create views and customize data in visualizations 
  • Manage, sort and group data 
  • Save and share data sources and workbooks 
  • Filter data in views 
  • Customize visualizations with annotations, highlights, and advanced features 
  • Create maps, dashboards, and stories 


Prerequisites: To ensure your success in this course, you should have experience managing data with Microsoft Excel or Google Sheets. 

Training length: 12 hours  

Tableau: Part 2

 At the end of this course, the learner will be able to:  

  • Blend data to visualize relationships 
  • Join data 
  • Access data in PDFs 
  • Refine visualizations with sets and parameters 
  • Manipulate data with calculations 
  • Visualize data with advanced calculations 
  • Perform statistical analysis and forecasting 
  • Enrich visualizations, dashboards, and maps 


Prerequisites: Tableau Part 1 

Training length: 12 hours

Course Outlines

Download our Excel course outlines.

Outline - Excel Fundamentals (pdf)Download
Outline - Excel Intermediate (pdf)Download
Outline - Excel Advanced (pdf)Download
Outline - Excel Expert (pdf)Download
Outline - Excel Productivity Tips for Advanced Users (pdf)Download
Outline - Automating Excel (pdf)Download

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.

Call us today!

We love our customers, so feel free give us a call.

Office Productivity Training, LLC

PO Box 912 O'Fallon IL 62269

(314) 596-2534

Social

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

Powered by GoDaddy

  • 90-minute Training

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