Unlock the Power of Pivot Tables in Excel – 90 minute workshop

Unlock the Power of Pivot Tables in Excel with this 90 minute workshop

Date: 3rd April 2025 14:30 to 16:00 (Dublin/Edinburgh time). You can check your time zone here
Duration: 90 minutes
Price: $97

Bonuses

Follow-up homework - with feedback if required

30-minute Q&A session on 24th April

Lifetime access to the recorded session

Bonus lessons and material

You will receive all the details you need to attend the live workshop. Don't worry if you can't attend. It will be recorded and uploaded within 24-48 hours.

Excel is used by over a billion people worldwide and pivot tables are one of its key analysis tools. Pivot tables allow you to view your data from a number of different angles, making it easier to gain insights and make informed decisions.

What You'll Learn in This Workshop

How to use Excel's inbuilt AI to ask natural language questions of your data.
How to construct a pivot table and show the data in several different formats.
How to add charts, slicers, and timelines to easily drill down to specific situations.
How to create a pivot chart.
Clean data – what is it and why is it so important.
Use Conditional formatting to draw attention to unusual data.

Benefits of Pivot Tables

Efficient Data Analysis: Quickly summarize large datasets and extract meaningful insights.
Flexibility: Easily change the layout and format of your data to view it from different perspectives.
Time-Saving: Automate repetitive tasks and reduce manual data manipulation.
Enhanced Reporting: Create professional and interactive reports with charts and slicers.
Improved Decision-Making: Make data-driven decisions with accurate and up-to-date information.

Business Professionals: Enhance your data analysis skills to make more informed decisions.

Students: Gain a valuable skill that will set you apart in your studies and future career.

Data Analysts: Learn advanced techniques to streamline your workflow.

Anyone Interested in Excel: Whether you're a beginner or have some experience, this workshop will take your skills to the next level.

Why attend?

Interactive Learning: Comprehensive tutorial you can revisit again and again.

Expert Guidance: Learn from Anne Walsh, a seasoned Excel trainer with a friendly and inclusive style.

Lifetime Access: Revisit the session anytime with lifetime access to the recording.

Course Curriculum

Meet the Instructor
1 Lesson
- About Anne Walsh
  Start
Recording of Workshop (3rd April 2025 14:30 to 16:00 (Dublin/Edinburgh time))
3 Lessons
- You can check your time zone here
  Start
- Recording of Workshop (3rd April)
  Start
- Extra Pivot Table Resources
  Start
Your Challenge - Should you choose to accept it. AKA Homework
1 Lesson
- This is your homework file. Instructions are in the file. Happy to give feedback if you need it.
  Start
1. - Download your one page pivot table cheat sheet
1 Lesson
- Download your one page pivot table cheat sheet - Here
  Start
2. - Clean up your data - using Excel tricks
1 Lesson
- 2.3 - Remove merged cells, unwanted rows and columns, subtotals
  Start
3. - Clean up your data using Excel's inbuilt Power Query
1 Lesson
- 3.1 - Automate your data cleansing using Power Query
  Start
4. - Keeping up appearances
6 Lessons
- 4.1 - Formatting the pivot table - design options
  Start
- 4.2 - Adding and formatting a slicer
  Start
- 4.3 - Adding and removing subtotals and grand totals
  Start
- 4.4- Different report layouts
  Start
- 4.5 - Formatting the chart - adding and removing options
  Start
- 4.6- Colour code your pivot table - use conditional formatting
  Start
5. - Getting fancier - Coming soon!
5 Lessons
- 5.1 - Calculated fields
  Start
- 5.2 - GetPivotData() function
  Start
- 5.3 - One data source to rule them all - without a vlookup
  Start
- 5.4 - Meet PowerPivot
  Start
- 5.5 - Meet Calculate
  Start
Q&A - Zoom Link (24th April 2025 at 15:00 to 15:30 Irish time)
1 Lesson
- Opportunity to ask any questions/ get feedback on your homework
  Start

Anne Walsh is a freelance Excel and PowerBI trainer based in the west of Ireland. She is the author of the Amazon best-seller, Hate Excel. Learn to love the software that can transform your confidence and career. She has 25 years of referral-driven success as a trainer. She likes to “put the fun in functions”. If you would like to book an appointment with her – use the link here

Hear from some brand new Excel fans!

Anne has a wonderful, friendly and inclusive style of training. She puts you at your ease, whatever your ability, with her warmth, wit and fantastic people skills. My confidence has grown enormously since starting the course.
Christine Morrison

Anne is a fantastic facilitator and was really interested in our questions and how to solve our issues. Everyone was at the same level of knowledge, so no one was lost or bored, which was great.
Siobhan Rodgers

From printing to pivots, I have learned so much, and Anne’s style is friendly and helpful.
Emma Williams

Anne was very patient, had a great sense of humor, and made me feel at ease. No stupid questions! Time allowed to practice in the breakout rooms. Great that resources are available for one year after.
Mark Devlin

Overall, this is an excellent course, and Anne is a great tutor. Really enjoying the sessions on the Pivot Tables at present.
Catherine O'Donoghue

Don't Miss Out!

Join us for this transformative workshop and take your Excel skills to the next level. Secure your spot today and unlock the full potential of pivot tables!