Excel for non-beginners- Day 3 - Counting & Why Pivot Tables are overrated
- 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