Pivot Tables in Excel: A Practical Guide
Create, group and refresh pivot tables, and avoid the mistakes that produce wrong summaries.
Read guide →Excel, Power BI & Data Analytics Blog
Practical tutorials and career guides from the CharterPeak training team - organised around the same learning paths we teach.
XLOOKUP in Excel: Syntax, Examples and Common Errors
How XLOOKUP works, how it differs from VLOOKUP, and how to fix the errors people hit most often.
Read guide →