If you found this tip on Data Analysis Excel helpful 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!

bite-size learning

Data Analysis Excel – The Essentials and More

Extend your knowledge of Excel from Tips and Tricks to Pivot Tables, Pivot Charts and Slicers, CountIFs, SumIFs and the Table Features.

The most used feature in excel for analysing data is the PivotTable. It’s the power and flexibility that comes with this tool that makes it the go-to feature in Excel. Excel’s PivotTable helps you to answer these questions effortlessly. PivotTable is a summary table that lets you count, average, sum, and perform other calculations. With the latest version they have added a whole array of new features. One of the most talked about new features is the Slicer.

Unfortunately, the pivot table does have its downside. One of these is when you change the source of a PivotTable, and the table doesn’t automatically refresh. This is where the new table feature combined with formulas steps in. One of the most underused features of Excel is the Table. Tables in Excel are dynamic, so when you use formulas with tables, your formulas become dynamic and react to any changes made without having to worry about refreshing.

2 hrs

Like this? Wanna see more bite-size learning?

We have lots of different bite-size learning sessions 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