Excel PivotTable Course – Quick Start

Master PivotTables in No Time – Even If You're a Beginner!

A quick-start guide to professional data analysis.

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 with tutorials broken into short videos with English subtitles and searchable transcripts.
	And when you're finished we'll send you a Certificate of Completion to add to your résumé.

Sample - Introduction to Pivot Tables and Data Layout

Excel PivotTable 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 PivotTable Course?

That would be me, I'm Mynda Treacy, Co-founder of My Online Training Hub, and 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.

Course Prerequisites

• Requires Excel 2016 or later. The course was filmed in Excel 365.

Choose Your Membership Level

Notes

• Money Back Guarantee - You can watch up t0 30% of the course and if it's not for you, simply request a refund.
• Video Downloads - Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
• Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
• Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.