Loading Shopping Cart Items...
Catalog
Bundle
Added:
The following courses are included in the Microsoft Excel Course Bundle. Available dates for each course will appear once the bundle has been added to cart.
Microsoft Excel Simplified
10:00 a.m. - 3:30 p.m.
Virtual
Participants will learn how to setup an Excel worksheet, create formulas to perform calculations, and enhance the appearance of the worksheet using various formatting techniques. Students will also learn how to use some of Excel’s most common functions such as Average, Count, Counta, Max and Min, and Sum.
Microsoft Excel Pivot Tables
10:00 a.m. - 3:30 p.m.
Virtual
Participants will learn how to create Pivot Tables using a large data set, apply filters in a Pivot Table, use field and report filters on a Pivot Table, create calculated fields in a Pivot Table, create logical tests using basic IF functions, evaluate when to use the AND & OR functions with IF functions, and create nested IF statements.
Microsoft Excel Simplified II - Data Management, Data Visualization and Really Cool Function
10:00 a.m. - 3:30 p.m.
Virtual
This class covers worksheets, formulas, and formatting. Learn how to utilize charts, manage and summarize data, and utilize LOOKUP and IF functions. Compatible with the latest version of Excel (Office 2019/2021/365. There may be some functions that aren’t available in older versions (2016).
Microsoft Excel Simplified
10:00 a.m. - 3:30 p.m.
Virtual
Participants will learn how to setup an Excel worksheet, create formulas to perform calculations, and enhance the appearance of the worksheet using various formatting techniques. Students will also learn how to use some of Excel’s most common functions such as Average, Count, Counta, Max and Min, and Sum.
Microsoft Excel Pivot Tables
10:00 a.m. - 3:30 p.m.
Virtual
Participants will learn how to create Pivot Tables using a large data set, apply filters in a Pivot Table, use field and report filters on a Pivot Table, create calculated fields in a Pivot Table, create logical tests using basic IF functions, evaluate when to use the AND & OR functions with IF functions, and create nested IF statements.
Microsoft Excel Simplified II - Data Management, Data Visualization and Really Cool Function
10:00 a.m. - 3:30 p.m.
Virtual
This class covers worksheets, formulas, and formatting. Learn how to utilize charts, manage and summarize data, and utilize LOOKUP and IF functions. Compatible with the latest version of Excel (Office 2019/2021/365. There may be some functions that aren’t available in older versions (2016).
Credits awarded per Session. See individual Sessions for further details.
Credits awarded
Type
Name
Sub type
Value
bundle items 3
Instructor led
Virtual: Microsoft Excel Simplified
Instructor led
Virtual: Microsoft Excel Simplified II - Data Management, Data Visualization and Really Cool Functions
Instructor led
Virtual: Microsoft Excel Pivot Tables
$1068.00
Already successfully completed: re-enrollment available!
Secure Transaction
About this item
The following courses are included in the Microsoft Excel Course Bundle. Available dates for each course will appear once the bundle has been added to cart.
Microsoft Excel Simplified
10:00 a.m. - 3:30 p.m.
Virtual
Participants will learn how to setup an Excel worksheet, create formulas to perform calculations, and enhance the appearance of the worksheet using various formatting techniques. Students will also learn how to use some of Excel’s most common functions such as Average, Count, Counta, Max and Min, and Sum.
Microsoft Excel Pivot Tables
10:00 a.m. - 3:30 p.m.
Virtual
Participants will learn how to create Pivot Tables using a large data set, apply filters in a Pivot Table, use field and report filters on a Pivot Table, create calculated fields in a Pivot Table, create logical tests using basic IF functions, evaluate when to use the AND & OR functions with IF functions, and create nested IF statements.
Microsoft Excel Simplified II - Data Management, Data Visualization and Really Cool Function
10:00 a.m. - 3:30 p.m.
Virtual
This class covers worksheets, formulas, and formatting. Learn how to utilize charts, manage and summarize data, and utilize LOOKUP and IF functions. Compatible with the latest version of Excel (Office 2019/2021/365. There may be some functions that aren’t available in older versions (2016).
Ratings and reviews
Type:
Name:
Sub type:
Value: