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 →Excel & Power BI Resources
Learning resources organised by path: Excel, Power BI and data analytics.
Excel
Pivot Tables in Excel: A Practical Guide
Create, group and refresh pivot tables, and avoid the mistakes that produce wrong summaries.
Read guide →How to Build an Excel Dashboard (Step by Step)
A step-by-step approach to Excel dashboards using pivots, slicers and clear layout rules.
Read guide →Power Query in Excel: Clean and Combine Data Automatically
Import, clean, merge and refresh data with Power Query - the same engine used in Power BI.
Read guide →Power BI
What Is Power BI? A Plain-English Introduction
A plain-English explanation of Power BI, its components and who uses it.
Read guide →DAX in Power BI: Fundamentals and Essential Functions
Understand filter context, CALCULATE and time intelligence so your measures stay correct.
Read guide →Power BI Data Modeling: Star Schema and Relationships
Why a star schema works best in Power BI and how to set up relationships correctly.
Read guide →How to Create a Power BI Dashboard
Step-by-step process for building a clear, interactive Power BI dashboard.
Read guide →Power Query in Power BI: Prepare Data Before You Model
Prepare data in Power Query before modeling, so DAX and visuals stay simple.
Read guide →Data analytics
What Is Data Analytics? Types, Process and Tools
A clear explanation of data analytics: what it is, the main types and the typical process.
Read guide →The Data Analytics Process: Six Steps from Question to Decision
Six steps that most analytics projects follow, with an example for each.
Read guide →Excel for Data Analysis: A Practical Workflow
A five-step workflow for analysing data in Excel, with the tools to use at each step.
Read guide →How to Create a Power BI Dashboard
Step-by-step process for building a clear, interactive Power BI dashboard.
Read guide →Tool comparisons
Excel vs Power BI
Which one to learn and when.
Read more →Excel vs Tableau
Spreadsheet vs visualization platform.
Read more →Power BI vs Tableau
Two BI tools compared.
Read more →Excel vs Google Sheets
Features and use cases.
Read more →All articles: CharterPeak blog.
Talk to a CharterPeak counsellor
Tell us your background and goal, and we will suggest the right starting point - Excel, Power BI or the full Excel + Power BI program.