Building a basic Excel Report

A demo on how to use the features below in Excel to produce better reporting & basic analysis natively. Whilst these aren't the flashiest of skills, they do help lay the foundation for taking on more advanced analysis tools, not only in Excel but are also transferrable to PowerBI.

We cover using:
- Tables in Excel;
- PowerQuery; and
- PowerPivots & Pivot Charts

#exceltips #excel #datawizardconsulting #datawizard #datamodelling #datamodel #dataanalysis #powerpivot #powerquery #data