Excel PivotTable Course – Quick Start

This short course will quickly have you building your own PivotTables with confidence. Start with the ideal data layout for creating Pivot Tables. Then move on to formatting, aggregation, pivot charts, filters, slicers and much more. 
M.Treacy ·September 22, 2020


Course Details

Course Overview 

Many people are afraid of PivotTables, but in this course I’ll quickly have you building your own PivotTables with confidence. Once you understand the key ingredients of a PivotTable, you’ll wonder what all the worry was about.

I know your time is valuable, which is why the complete course is just under 1.5 hours long with tutorials broken into short videos (on average 5 minutes long).
And when you’re finished we’ll send you a Certificate of Completion to add to your résumé.

Course Syllabus

  • Ideal Data Layout for PivotTables – get this wrong and you’ll have nothing but trouble
  • Creating PivotTables
  • Formatting, Grouping Data and Sorting
  • Aggregation Options and Show Values As
  • Pivot Charts
  • Filters, Slicers and Timelines
  • GETPIVOTDATA Function
  • Adding New Data and Refreshing
  • Troubleshooting – what causes problems and how to fix them
  • Conditional Formatting
  • Calculated Fields and Items
  • Introduction to the Data Model
  • PivotTable Options and Settings

Who Is Teaching The Course

M.Treacy, a Microsoft Excel MVP.

I have been working with Excel since 1995 and teaching since 2010 (not including teaching many colleagues over the years), and I’m excited to be able to share what I have learned with you.

Back when I started using Excel I was lucky, in that you weren’t expected to know how to use it! As you’d know, that’s not the case these days.

Once you’ve completed the course and practiced what you learn you’ll be able to build PivotTables with ease.

Prerequisite

  • Requires Excel 2007 or later. The course was filmed in Excel 2019/Office 365.

10% off

Be The First

to Know

For Your next purchase when sign up.

Great News ?

  • This Discount Offer is exclusively available only to clients coming from Pro-education Academy website.

100 % Guarantee

Notes

  1. Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  2. Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  3. Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  4. You can request a refund provided that no more than 30% of the course videos have been watched.

Choose Your Membership Level

Currency

cart images

PivotTables Quick Start

$39.00

12 Months Online


Online Only Access To Course


PivotTable Quick Start Course Videos 1hrs 27mins


One Payment for 12 Months Access


Unlimited 24/7 access


Pause, rewind, replay


Download Workbooks and Practice Data


30 Day Money Back Guarantee

Notes

  • Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.

 

 

 

cart images

PivotTables Quick StartOnline + Download

$79.00

12 Months Online + Download


Online Access + Download & Keep Course Videos


 PivotTable Quick Start Course Videos 1hrs 27mins


One Payment for 12 Months Access


Unlimited 24/7 access


Pause, rewind, replay


Download Workbooks and Practice Data


30 Day Money Back Guarantee

Notes

  • Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.

Our Business Excel Course Collection

                Why Not Discover, More Courses Below! 

Excel 
Charts
Formulas
PivotTables 
Online Training
Dashboard
 Shortcuts 
 VBA
01 / 05

PROFESSIONAL TRAINING

Course Delivery – Live online sessions
Course Duration – 8 Weeks (Three hours every weekend)
Why Learn with Us?
Interactive Learning: You’ll learn with a team of ambitious professionals.
Lifetime Access: It will allow you to revisit the course every time you need it.
Certification: Completion Certificate provided to back your learnings.
IIBA Certified Trainer: You’ll learn from certified industry experts.

So whatever job you are in, let us hold your hand and show you our innovative approach to success using one of our courses. You won’t find a more committed team.
Studying a Business Analyst Course, you can rely on our skillful team of Consultants to build your Business Analyst career even with no experience. Taking this course you’ll find only the most cutting-edge classes designed by Industry Experts. The instructors you’ll meet know SDLC, AGILE and HYBRID project methodologies inside out. Setting you for the highest level of success as a Business Analyst.
These courses are aligned to IIBA and designed to provide you with the core and job ready Business Analysis experience and certification so that you are set on the right growth track in Australia and globe.

02 / 05
Lara Madrigal
DESIGNER

Lara has over 10 years’ experience in the design industry. During this time, she has developed skills across many areas including branding, illustration, UI design, print and web design. She loves to be challenged and to enhance her skillset.

“Being a member of such a talented team is constantly inspiring. We each bring our passion to the studio to make our company a very special creative hive.”
03 / 05
Deborah Barbosa
BRAND STRATEGIST

Deborah describes brand strategy as her perfect blend of critical thinking and collaborative research, one that encourages her natural love of questions and genuine interest in people.

“We are fortunate enough to get to work with many internationally recognised brands, on interesting projects, which makes working at our company an exciting place to be.”
04 / 05
Martijn Dragonjer
PARTNER

Martijn joined the team in early 2015, after ten years working in the film industry. With a strong background for sales and marketing, Will was excited to bring a new perspective to the team.

“There is a constant buzz here, everyone is driven and focused on producing the best work possible for clients. It is a very rewarding place to work with fantastic clients .”
05 / 05
Dominik Doudny
DEVELOPER

Dominik has a passion for developing sites with clean, beautiful code. Dominik’s love for full-stack web development makes him a great asset that can take on back-end code and front-end UI needs if necessary.

“What makes a good company enjoyable? Working with enthusiastic members of well-structured teams of engaging characters.”
previous arrownext arrow
Slider

Still Not too Sure ?

No problem at all, you can book an appointment to speak to one of our subject experts, please, click in Get Support button below.

About Instructor

M.Treacy

4 Courses

+182 enrolled
Open Registration
Skip to content