Excel Training Classes

Microsoft Excel for Office 365 (Desktop or Online): Part 1

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is intended for students who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 gigahertz (GHz) 64-bit (x64) processor.
• 2 gigabytes (GB) of Random Access Memory (RAM).
• 32 GB available storage space.
• Monitor capable of a screen resolution of at least 1,024 × 768 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
• Bootable DVD-ROM or USB drive.
• IP addresses that do not conflict with other portions of your network.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 365™ license.

Course Objectives:

• Get started with Microsoft Excel.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Microsoft Excel for Office 365 (Desktop or Online): Part 2 

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 gigahertz (GHz) 64-bit (x64) processor.
• 2 gigabytes (GB) of Random Access Memory (RAM).
• 32 GB available storage space.
• Monitor capable of a screen resolution of at least 1,024 × 768 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
• Bootable DVD-ROM or USB drive.
• IP addresses that do not conflict with other portions of your network.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 365™ license.

Course Objectives:

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

Microsoft Excel for Office 365 (Desktop or Online): Part 3

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 gigahertz (GHz) 64-bit (x64) processor.
• 2 gigabytes (GB) of Random Access Memory (RAM).
• 32 GB available storage space.
• Monitor capable of a screen resolution of at least 1,024 × 768 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
• Bootable DVD-ROM or USB drive.
• IP addresses that do not conflict with other portions of your network.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 365™ license.

Course Objectives:

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

Microsoft Excel for Office 365/2021: Data Analysis with PivotTables

*Both instructor-led and self-paced online learning options are available.

Target Student:

Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.

Course Length: .5 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 gigahertz (GHz) 64-bit (x64) processor.
• 2 gigabytes (GB) of Random Access Memory (RAM).
• 32 GB available storage space.
• Monitor capable of a screen resolution of at least 1,024 × 768 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
• Bootable DVD-ROM or USB drive.
• Fast Ethernet (100 Mb/s) adapter or faster and cabling to connect to the classroom network.
• IP addresses that do not conflict with other portions of your network.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 365™ for Business license.

Course Objectives:

• Prepare data for PivotTable reporting and create PivotTables from various data sources.
• Analyze data by using PivotTables.
• Work with PivotCharts.

Microsoft Excel for Office 365/2021: Data Analysis with PowerPivot

*Both instructor-led and self-paced online learning options are available.

Target Student:

Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.

Course Length: .5 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 gigahertz (GHz) 64-bit (x64) processor.
• 2 gigabytes (GB) of Random Access Memory (RAM).
• 32 GB available storage space.
• Monitor capable of a screen resolution of at least 1,024 × 768 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
• Bootable DVD-ROM or USB drive.
• IP addresses that do not conflict with other portions of your network.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 365™ for Business license.

Course Objectives:

• Get started with Power Pivot.
• Visualize Power Pivot data.
• Work with advanced functionality in Power Pivot.

Microsoft Excel for Office 365 or Office 2019: Dashboards

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of the data analysis functionality with Excel using functions, charts, and PivotTables, and using visualizations in charts and dashboards in Excel.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 gigahertz (GHz) 64-bit (x64) processor.
• 4 gigabytes (GB) of Random Access Memory (RAM).
• 32 GB available storage space.
• Monitor capable of a screen resolution of at least 1,024 × 768 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
• Fast Ethernet (100 Mb/s) adapter or faster and cabling to connect to the classroom network.
• IP addresses that do not conflict with other portions of your network.
• Microsoft® Windows® 10 Professional or Enterprise.
• Any current version of Office.

Course Objectives:

• Perform data analysis fundamentals.
• Visualize data with Excel.
• Analyze data with formulas and functions.
• Analyze data with PivotTables.
• Present visual insights with dashboards in Excel.

Data Analysis and Visualization with Microsoft Excel

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Excel using PivotTables, use tools such as Power Pivot and the Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

Course Length: 2 Days

Schedule your Excel training.

Course-specific Requirements:

• 1 gigahertz (GHz) 64-bit (x64) processor.
• 4 gigabytes (GB) of Random Access Memory (RAM).
• 32 GB available storage space.
• Monitor capable of a screen resolution of at least 1,024 × 768 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
• Fast Ethernet (100 Mb/s) adapter or faster and cabling to connect to the classroom network.
• IP addresses that do not conflict with other portions of your network.
• Microsoft® Windows® 10 Professional or Enterprise.
• Any current version of Office.

Course Objectives:

• Perform data analysis fundamentals.
• Visualize data with Excel.
• Analyze data with formulas and functions.
• Analyze data with PivotTables.
• Present visual insights with dashboards in Excel.
• Create geospatial visualizations with Excel.
• Perform statistical analysis.
• Get and transform data.
• Model and analyze data with Power Pivot.
• Present insights with reports.

Programming and Data Wrangling with VBA and Excel

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.

Course Length: 3 Days

Schedule your Excel training.

Course-specific Requirements:

• 1.1 GHz or faster 64-bit processor, at least 2-core.
• At least 4 GB RAM.
• 50 GB available disk space.
• DirectX 9 or later graphics card and a 1,280 x 1,024 or higher resolution monitor.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® 365.

Course Objectives:

• Identify general components of VBA and their appropriate use in solving business solutions.
• Record VBA macros to automate repetitive tasks.
• Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.
• Write VBA code to create a custom worksheet function.
• Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
• Control how and when macros run.
• Develop UserForm objects to create custom dialog boxes and windows.
• Use VBA to read and write data from local files and cloud services.
• Use VBA to clean and transform data.
• Run programs and commands outside of Excel and share VBA projects with other users.

VBA with Microsoft Excel

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1.1 GHz or faster 64-bit processor, at least 2-co.
• At least 4 GB RAM.
• 50 GB available disk space.
• DirectX 9 or later graphics card and a 1,280 x 1,024 or higher resolution monitor.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® 365.

Course Objectives:

• Identify general components of VBA and their appropriate use in solving business solutions.
• Record VBA macros to automate repetitive tasks.
• Write VBA code to create VBA subroutines and functions.
• Use various programming elements to solve problems through code, including variables, objects, conditional statements, and loops.
• Eliminate, avoid, or handle errors in VBA code, and optimize its performance.

Microsoft Office Excel 2021: Part 1

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2021 that is necessary to create and work with electronic spreadsheets.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 GHz 32-bit or 64-bit processor.
• 1 GB RAM (32-bit) or 2 GB RAM (64-bit).
• 25 GB available disk space.
• DirectX 10 graphics card and a 1,024 × 576 or higher resolution monitor (1,024 × 768 resolution or higher monitor recommended).
• Printer (optional) or an installed printer driver.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 2021.

Course Objectives:

• Get started with Microsoft Office Excel 2021.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Microsoft Office Excel 2021: Part 2

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel 2021 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 GHz 32-bit or 64-bit processor.
• 1 GB RAM (32-bit) or 2 GB RAM (64-bit).
• 25 GB available disk space.
• DirectX 10 graphics card and a 1,024 × 576 or higher resolution monitor (1,024 × 768 resolution or higher monitor recommended).
• Printer (optional) or an installed printer driver.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 2021.

Course Objectives:

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

Microsoft Office Excel 2021: Part 3

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is intended for students who are experienced Excel 2021 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 GHz 32-bit or 64-bit processor.
• 1 GB RAM (32-bit) or 2 GB RAM (64-bit).
• 25 GB available disk space.
• DirectX 10 graphics card and a 1,024 × 576 or higher resolution monitor (1,024 × 768 resolution or higher monitor recommended).
• Printer (optional) or an installed printer driver.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 2021.

Course Objectives:

• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions, dynamic arrays, and formula auditing.
• Forecast data.
• Create sparklines and map data.

Microsoft Office Excel 2019: Part 1

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2019 that is necessary to create and work with electronic spreadsheets.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 GHz 32-bit or 64-bit processor.
• 1 GB RAM (32-bit) or 2 GB RAM (64-bit).
• 25 GB available disk space.
• DirectX 10 graphics card and a 1,024 × 576 or higher resolution monitor (1,024 × 768 resolution or higher monitor recommended).
• Printer (optional) or an installed printer driver.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 2019.

Course Objectives:

• Get started with Microsoft Office Excel 2019.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Microsoft Office Excel 2019: Part 2

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel 2019 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 GHz 32-bit or 64-bit processor.
• 1 GB RAM (32-bit) or 2 GB RAM (64-bit).
• 25 GB available disk space.
• DirectX 10 graphics card and a 1,024 × 576 or higher resolution monitor (1,024 × 768 resolution or higher monitor recommended).
• Printer (optional) or an installed printer driver.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 2019.

Course Objectives:

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

Microsoft Office Excel 2019: Part 3

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is intended for students who are experienced Excel 2019 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 GHz 32-bit or 64-bit processor.
• 1 GB RAM (32-bit) or 2 GB RAM (64-bit).
• 25 GB available disk space.
• DirectX 10 graphics card and a 1,024 × 576 or higher resolution monitor (1,024 × 768 resolution or higher monitor recommended).
• Printer (optional) or an installed printer driver.
• Microsoft® Windows® 10 Professional or Enterprise.
• Microsoft® Office 2019.

Course Objectives:

• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing.
• Forecast data.
• Create sparklines and map data.

Microsoft Office Excel 2016: Part 1

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 GHz 32-bit or 64-bit processor.
• 1 GB RAM (32-bit) or 2 GB RAM (64-bit).
• 25 GB available disk space.
• DirectX 10 graphics card and a 1,024 × 576 or higher resolution monitor (1,024 × 768 resolution or higher monitor recommended).
• Printer (optional) or an installed printer driver.
• Microsoft® Office Professional Plus 2016.
• Microsoft® Windows® 10 Professional or Enterprise.

Course Objectives:

• Get started with Microsoft Office Excel 2016.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Microsoft Office Excel 2016: Part 2

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 GHz 32-bit or 64-bit processor.
• 1 GB RAM (32-bit) or 2 GB RAM (64-bit).
• 25 GB available disk space.
• DirectX 10 graphics card and a 1,024 × 576 or higher resolution monitor (1,024 × 768 resolution or higher monitor recommended).
• Printer (optional) or an installed printer driver.
• Microsoft® Office Professional Plus 2016.
• Microsoft® Windows® 10 Professional or Enterprise.

Course Objectives:

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

Microsoft Office Excel 2016: Part 2

*Both instructor-led and self-paced online learning options are available.

Target Student:

This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets.

Course Length: 1 Day

Schedule your Excel training.

Course-specific Requirements:

• 1 GHz 32-bit or 64-bit processor.
• 1 GB RAM (32-bit) or 2 GB RAM (64-bit).
• 25 GB available disk space.
• DirectX 10 graphics card and a 1,024 × 576 or higher resolution monitor (1,024 × 768 resolution or higher monitor recommended).
• Printer (optional) or an installed printer driver.
• Microsoft® Office Professional Plus 2016.
• Microsoft® Windows® 10 Professional or Enterprise.

Course Objectives:

• Get started with Microsoft Office Excel 2016.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.