In-depth analysis with Pivot Tables in Excel

In just one fast-paced and informative training session, you’ll learn how to use PivotTables better to sort your data more efficiently, create multiple customized reports in a few easy steps ,and gain a powerful new tool to help you make better business decisions. Led by an Excel expert, this training event concentrates solely on PivotTables, what they are and how they can make your life  much easier!

In this 60 Minute fast-paced learning session, you’ll learn:

  • Why PivotTables are the “hidden gems” inside Excel
  • How to create multiple PivotTables so you can analyse large data sets from different business perspective
  • How to easily group and view data in a spreadsheet
  • The secrets to converting PivotTables into easy-to-read charts instantly
  • Steps for creating a macro that keeps your PivotTable data automatically updated
  • How to group date-related data into months, quarters and years and perform ad hoc grouping in 2 quick steps
  • Creating calculations in a pivot table

60 Mins

If you found this webinar interesting, InvestinU offers a range of training supports for Microsoft 365 which can be found here.

You can check out our FacebookInstagram, or Linkedin pages for more updates and to get in touch today!

Like this? Wanna see more webinars?

We have lots of different webinars on offer. To read more about them, click the button below.

   About InvestinU

   Meet The Team

   In the Media



   Microsoft 365 Webinars

   Microsoft 365 Consultancy

   Customised Training

   Bite-Size Learning


   Document Design

   Template Design

   Redesigning Documents

   Forms Creation (Word or Adobe PDF)

   Design Solutions

   Company Branding

   Logo Design


   E-commerce Websites

   Brochure Websites


   Social Media Management

   Content Creation (Blog)


   App Development

   Excel Automation

   Excel Dashboards / Reports

   Bespoke Database Systems

    Microsoft Packages

   Microsoft 365 Webinars

  Microsoft 365 Consultancy

   In-person Consultancy

   Invest365 Microsoft Ultimate