Follow us on YouTube Facebook, LinkedIn, and Insta to hear about more upcoming webinars.

Get in touch to hear more about pivot tables, training, support, branding, web design, and more. At InvestinU we take the complicated and make it simple.

Webinars – Pivot Tables

An Alternative to Pivot Tables – Using Countifs, Sumifs and Averageifs

These functions can be a useful alternative to PivotTables. Both the PivotTable and stated functions have their pros and cons. In this session both will be discussed.

Sumifs and Countifs are advanced forms of Sumif and Countif functions respectively. They can work with single as well as multiple conditions.

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

  • Countifs/Sumifs vs PivotTables
  • Countifs
  • Sumifs
  • Averageifs
  • Maxifs and Minifs (Office 365)

60 Mins

Like this? Wanna see more webinars?

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

Get in Touch

Would you like to discuss your companies requirements with us?

If so, please get in touch and we can organise a face to face zoom meeting at a time that suits you.

Call Us

International: +353 85 133 5649
Ireland: (085) 133 5649

   About InvestinU

   In the Media



   Bespoke Online Webinars

   Expert Advisory Sessions

   Microsoft 365 Support

   Customised Training

   One-to-one Consultancy

   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

   Invest365 Microsoft Webinars

   Invest365 Microsoft Support

   Expert Advisory Sessions

   Invest365 Microsoft Ultimate