Microsoft Excel Pivot Tables

Code: COMP1897

Course description

Wouldn't it be great to learn how to effectively use all the advanced Excel pivot table features? In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities. Most organizations rely heavily on Microsoft Excel pivot tables to analyze and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. You'll see how to work with the numerous pivot table options and system settings to become skilled in developing useful analysis models and reports within your company. Impress your coworkers by learning how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. You'll discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid reporting mistakes when data is added or deleted. Whether you're new to pivot tables, need a refresher, or want to become the pivot table guru within your organization, this course is for you!

Course details

Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None

Notice for ed2go courses

ed2go online courses are designed for working professionals and those seeking to gain personal advancement. If you are enrolled in a program, carefully review the requirements of your program before registering to ensure the course code and title match the requirements in your program.

 
Start Date
Day/Time
Delivery
Campus
Cost
Availability
Start Date: Feb. 13, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Apr. 15, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

Start Date: Mar. 13, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: May. 13, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

Start Date: Apr. 17, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Jun. 17, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

Start Date: May. 15, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Jul. 15, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

Start Date: Jun. 12, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Aug. 12, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

Start Date: Jul. 17, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Sep. 16, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

Start Date: Aug. 14, 2019
Day/Time:
Delivery: Online
Campus: Online
Cost: $193.32
 
End date: Oct. 14, 2019
Hours: 24
Credits: 2
Prerequisites: None
Corequisites: None
Equivalent to: None

Additional information: This course is offered through ed2go. Find out more about ed2go courses.

Not all courses are offered each term. Spring 2019 registration opens February 4, 2019. Fall 2019 registration opens July 8, 2019.