Microsoft Excel Bundle*

Course Titles and Descriptions

Excel – Data Analysis with Pivot Tables

Pivot Tables are the perfect tool to analyze large amounts of data in Excel. Being able to summarize, visualize, and tabulate your data makes PivotTables an important skill for anyone who uses Excel to store and report on data, and in this course Microsoft trainer Kathy Jones will show you how to effectively use the PivotTable tools in Excel 2013 and 2016.

Excel – Intro to Power Pivot

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.
In this course we’ll show you everything you need to know in order to install and start using Power Pivot in Excel.

Excel – Power Query

Have you spent a lot of time performing repetitive cleanup tasks on your data, using multiple VLOOKUP functions to merge data, or trying to combine multiple datasets? If so, then Excel’s Power Query tool will transform how you work. You’ll learn how to connect to multiple data sources, and set up queries to remove unneeded data, manipulate existing data, and even create new columns. And the best part is, once you’ve set up your query, you’ll just refresh it when you need to perform those tasks. Microsoft certified trainer Kathy Jones will show you how to use the Power Query Editor to perform all of these functions and streamline your workflow in the process.

Excel 2019 in 30 Minutes (Basics – 1 of 10): Getting Started

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to navigate the Excel interface and access Excel Help.

Excel 2019 in 30 Minutes (Basics – 10 of 10): Customizing Options

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to customize Excel to work with your preferences and to quickly access the commands you use most.

Excel 2019 in 30 Minutes (Basics – 2 of 10): Entering Data

Excel 2019 in 30 Minutes (Basics – 3 of 10): Calculations

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to use formulas and functions to perform basic calculations in Excel.

Excel 2019 in 30 Minutes (Basics – 4 of 10): Modifying Worksheets

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to insert and remove rows and columns; quickly find, replace, and select data; and use proofing and research tools.

Excel 2019 in 30 Minutes (Basics – 5 of 10): Text and Number Formats

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to format text and numbers including custom number formats.

Excel 2019 in 30 Minutes (Basics – 6 of 10): Formatting Cell Contents

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to improve the appearance of your worksheets with cell formatting like alignment and text wrapping, and also apply Styles and Themes for consistency.

Excel 2019 in 30 Minutes (Basics – 7 of 10): Conditional Formatting

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to use Conditional Formatting and Comparative Analysis Formatting to easily read and analyze data, as well as access and create templates for predefined formatting.

Excel 2019 in 30 Minutes (Basics – 8 of 10): Printing and Page Layout

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to prepare your worksheets for printing using features like Set Print Area, Page Breaks, and Headers & Footers.

Excel 2019 in 30 Minutes (Basics – 9 of 10): Worksheets and Workbooks

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to manage multiple worksheets and workbooks and easily view and compare data.

Excel 2019 in 30 Minutes (Intermediate – 1 of 11): Using Named Ranges

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to create and use named ranges.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 10 of 11): Creating PivotTables

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to create a PivotTable to group and summarize data.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 11 of 11): Advanced PivotTables and Slicers

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to apply advanced PivotTable features, create a PivotChart, and filter data using Slicers and Timelines.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 2 of 11): Working with Date Functions

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to insert Date and Time functions into spreadsheets.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 3 of 11): Working with Logical Functions

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to use Logical functions and nest functions in a cell.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 4 of 11): Working with Text and Math Functions

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to use Text and Math functions to manipulate text and numbers in cells.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 5 of 11): Sorting and Filtering Lists

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to sort and filter columns of data in Excel.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 6 of 11): Querying and Subtotals with Lists

This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 7 of 11): Analyzing Data with Tables and Formatting

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to create and modify tables, and apply advanced Conditional Formatting to a spreadsheet.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 8 of 11): Visualizing Data with Charts

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to create and modify charts.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel 2019 in 30 Minutes (Intermediate – 9 of 11): Advanced Charting, Trendlines, and Graphics

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. Our “Excel in 30 Minutes” series can help you get started. By the end of this course, you will be able to apply advanced charting tools and work with graphics.
This course is one of 11 30-minute courses. Take the full series and you will have completed our “Bigger Brains Mastering Excel 2019 – Intermediate” course.

Excel for Mac Basics

Excel can do almost anything – crunch numbers, create lists, store data, edit budgets, and more. In this basics course we’ll show you how to get started with Excel on a Mac, including using the most popular features. Whether you’re a first-time Excel user, or if you just want to re-learn the fundamentals, this course is for you!

Excel for Project Management

Learn to create the deliverables of a Project Management Plan in Excel with worksheets including Project Charter, Requirements, Issues, Work Breakdown Structure (WBS), Risks, and Stakeholder Communication. When all of the information about your project is inside one workbook, you can answer any question, and you’ll always know where to track a new piece of information.

A new requirement identified? Add it to your Requirements sheet. A new stakeholder? Add them to your Stakeholder Communication sheet. Without any additional project management tools, you can track all of the information you need and use Excel features such as linked fields and conditional formatting to create a professional and effective Project Management Plan.

Excel: Creating Dashboards

Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that.

Excel: Power Functions

Excel provides over 400 functions to perform a variety of calculations within your data. With this many functions, it’s guaranteed you’re missing out on some powerhouse formulas that can make your day easier. This course explores 10 functions the experts recommend to expedite your data analysis.

Mastering Excel 2013

If you’ve mastered Microsoft Excel 2013 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your path to first learning, then even mastering Excel.

Mastering Excel 2013 – Advanced

If you’ve mastered Microsoft Excel 2013 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course is for users who wish to gain skills in the more advanced features of Excel.

Mastering Excel 2013 – Basics

Mastering Excel 2013 – Intermediate

If you’ve mastered Microsoft Excel 2013 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course moves you beyond the basics and into being a real pro with Excel.

Mastering Excel 2016

Mastering Excel 2016 – Advanced

“If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business-critical questions like ROI, budget allocations, tracking expenditures, and more. This course builds on your existing knowledge of Excel and teaches you how to use links, lookup functions, macros, data tables, and more.
Note: When combined with the Basics and Intermediate versions of this course, these cover all the objectives required in the Microsoft Office Specialist exam 77-727″

Mastering Excel 2016 – Basics

“If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your first step towards getting started with Microsoft Excel.
Note: When combined with the Intermediate and Advanced versions of this course, these cover all the objectives required in the Microsoft Office Specialist exam 77-727″

Mastering Excel 2016 – Intermediate

If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course builds on your existing knowledge of Excel basics and teaches you how to manage data, charts, and tables, and how to use powerful tools such as PivotTables, Pivot Charts, Slicers, Timelines, and more.
Note: When combined with the Basics and Advanced versions of this course, these cover all the objectives required in the Microsoft Office Specialist exam 77-727

Mastering Excel 2019 – Advanced

“When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to use links, Lookup functions, Data Validation, Macros, data tables, and more.
By the end of this course, you will feel empowered to use Excel’s most advanced features to create professional, secure, and accurate workbooks in Excel 2019 or Excel 365″

Mastering Excel 2019 – Basics

When you master Excel, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel 2019.

Mastering Excel 2019 – Intermediate

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to manage data, charts, and tables, and how to use powerful tools such as PivotTables, PivotCharts, Slicers, Timelines, and more.

Mastering Excel 2021 – Basics

Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you’ll learn to make your spreadsheets easily readable and visually appealing, while including complex functions and summary reports. Excel expert Kathy Jones will also show you how to address function errors, customize your charts, and create and use tables and PivotTables to easily manipulate and summarize your data.

Mastering Excel 2021 – Beginner

When you master Excel, you have one of the most practical and valuable skillsets in modern business. You will learn to work wonders with your data—from organizing lists to creating charts and interactive reports. Excel will help you answer critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel.

Mastering Excel 2021 – Intermediate

Mastering Excel 365 – Advanced

When you master Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. Once you have completed this course, there are few things you won’t be able to do with Excel!

Mastering Excel 365 – Basics (2024)

Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you’ll learn to make your spreadsheets easily readable and visually appealing, while including complex functions and summary reports. This course will show you how to address function errors, customize your charts, and create and use tables and PivotTables to easily manipulate and summarize your data.

Mastering Excel 365 – Beginner (2024)

Mastering Excel 365 – Intermediate (2022)

When you master Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course builds on your existing Excel knowledge and teaches you how to manage data, charts, and tables, and how to use powerful tools such as Pivot Tables, Pivot Charts, Slicers, Timelines, and more.