Excel for non-beginners- Day 3 - Counting & Why Pivot Tables are overrated

Counting Masterclass:

  • Two quick ways to find unique values in a list
  • Using unique values with Countif to summarise for reports
  • Summarising more conveniently than Pivot Tables!

Why Pivot Tables are overrated:

  • What Pivot tables are, how they are constructed and why you should consider alternatives in many cases
  • Why the alternatives are more reliable and much better for speeding up the production of report and dashboards