Microsoft Excel Bundle

Course Titles and Descriptions

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 in 30 Minutes (Basics Part 1): 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 in 30 Minutes (Basics Part 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 in 30 Minutes (Basics Part 2): Entering Data

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 create and save a new workbook and enter data.

 

Excel in 30 Minutes (Basics Part 3): 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 in 30 Minutes (Basics Part 4): 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 in 30 Minutes (Basics Part 5): 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 in 30 Minutes (Basics Part 6): 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 in 30 Minutes (Basics Part 7): 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 in 30 Minutes (Basics Part 8): 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 in 30 Minutes (Basics Part 9): 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 in 30 Minutes (Intermediate Part 1): 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 in 30 Minutes (Intermediate Part 10): 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 in 30 Minutes (Intermediate Part 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 in 30 Minutes (Intermediate Part 2): 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 in 30 Minutes (Intermediate Part 3): 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 in 30 Minutes (Intermediate Part 4): 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 in 30 Minutes (Intermediate Part 5): 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 in 30 Minutes (Intermediate Part 6): Querying and Subtotals with 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 use Database functions and find Subtotals.

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 in 30 Minutes (Intermediate Part 7): 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 in 30 Minutes (Intermediate Part 8): 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 in 30 Minutes (Intermediate Part 9): 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: 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: 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: Introduction to PowerPivot

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.

Mastering Excel 2016—Advanced

If you’ve mastered Microsoft Excel 2016, 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.