Ready to learn more?

Next Cohort: Jun 14-Jul 21

  • *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

 

Jun 14-Jul 21

Plus 2 other start dates

Jul 12 - Aug 16 2023

Aug 16 - Sep 20 2023

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: Jun 14-Jul 21

  • *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 (2)

University of Waterloo

Best Computer Science Co-op in Canada

Chris Ward

December 15, 2022

Graduated From

Introduction to Java Programming

Overall:

5 out of 5

Instructors:

5 stars

Curriculum:

5 stars

Job Assistance:

5 stars

Waterloo's co-op programs for CS (Computer Science) students is the best in Canada and one of the best in the world. The students are very smart and motivated. Work is part of the learning experience, with rotating semesters in class vs. on the job. I'...

Waterloo's co-op programs for CS (Computer Science) students is the best in Canada and one of the best in the world. The students are very smart and motivated. Work is part of the learning experience, with rotating semesters in class vs. on the job. I'm in my third year but can already see people in my year and the year ahead of me getting job offers from Microsoft, Google, Meta, etc. -- the big names -- in Canada and in the U.S. I can't speak for other co-ops, but you can't find better than the CS opportunities here IMO.

University of Waterloo

Not your typical MBA

Kamil

August 21, 2019

Graduated From

Master of Business, Entrepreneurship and Technology (MBET)

Overall:

5 out of 5

Instructors:

5 stars

Curriculum:

5 stars

Job Assistance:

4 stars

I'm a recent grad and the network and community at Waterloo just blew me away. This isn't your typical MBA, it's very entrepreneurial with a strong focus on technology and the startup world. I truly loved my experience. My only caution is to people who...

I'm a recent grad and the network and community at Waterloo just blew me away. This isn't your typical MBA, it's very entrepreneurial with a strong focus on technology and the startup world. I truly loved my experience. My only caution is to people who pursue the MBA to "figure out what to do" after graduation. You need to understand how you want to make the MBET work for you, then network and choose electives and extracurriculars accordingly. Unlike a traditional MBA, where you might be streamlined into finance or management positions at big firms after graduation, the MBET will challenge you to create new things and work with people from different academic backgrounds--from the arts to tech to research types and many, many more. A+.

Other courses in Excel