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.

Duration:
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

   In the Media

   Testimonials

  Training

   Bespoke Online Webinars

   Expert Advisory Sessions

   Microsoft 365 Support

   Customised Training

   One-to-one Consultancy

   Bite-Size Learning

   Design

   Document Design

   Template Design

   Redesigning Documents

   Forms Creation (Word or Adobe PDF)

   Design Solutions

   Company Branding

   Logo Design

   Web

   E-commerce Websites

   Brochure Websites

   SEO

   Social Media Management

   Content Creation (Blog)

    Development

   App Development

   Excel Automation

   Excel Dashboards / Reports

   Bespoke Database Systems

    Microsoft Packages

   Invest365 Microsoft Webinars

   Invest365 Microsoft Support

   Expert Advisory Sessions

   Invest365 Microsoft Ultimate