Ready to learn more?

Next Cohort: Aug 14-Sep 25

  • *Please select a subject

  • This field is for validation purposes and should be left unchanged.

By submitting your email address, you acknowledge and agree to CourseCompare.ca's Terms of Service and Privacy Policy.

Duration

6 weeks

Tuition

$190

 

Aug 14-Sep 25

Plus 1 other start dates

Sep 11 - Oct 23 2024

Commitment

Part-Time

Delivery

Online

Year Founded

1957

Scholarships

no

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!

Ready to get started?

Next Cohort: Aug 14-Sep 25

  • *Please select a subject

  • This field is for validation purposes and should be left unchanged.

By submitting your email address, you acknowledge and agree to CourseCompare.ca's Terms of Service and Privacy Policy.

Student Reviews (5)

Write a Review

University of Waterloo

The coop program offered in most programs further prepares students

Rendi Wu

February 26, 2024

Graduated From

not provided

Overall:

5 out of 5

Instructors:

5 stars

Curriculum:

5 stars

Job Assistance:

5 stars

I am a recent Mathematics grad from Waterloo. Waterloo offers a range of courses and career opportunities in multiple fields. The coop program offered in most programs further prepares students for full time career and ease of finding a job right out o...

I am a recent Mathematics grad from Waterloo. Waterloo offers a range of courses and career opportunities in multiple fields. The coop program offered in most programs further prepares students for full time career and ease of finding a job right out of graduation (almost 2 years work experience right out of graduation). While the school is academically focused and challenging at times, there are always events going on around the campus and people to hang out with. It is what you make it and I think if you are career focused and want to make meaningful connections, Waterloo is the place to be.

University of Waterloo

I(mmense opportunities on campus with respect to innovation

Tanisha Ghorpade

February 26, 2024

Graduated From

not provided

Overall:

5 out of 5

Instructors:

5 stars

Curriculum:

5 stars

Job Assistance:

5 stars

It's an amazing university. You can literally watch yourself getting smarter while you study here. The faculty is really good and there are immense opportunities on campus with respect to innovation. It's a tough university and you must study extremely...

It's an amazing university. You can literally watch yourself getting smarter while you study here. The faculty is really good and there are immense opportunities on campus with respect to innovation. It's a tough university and you must study extremely hard to stay here. All in all I'd say it's one of the best universities in the world.

Other courses in Excel