Excel Bites 010: The Data Model

https://theexceltrainerdotcodotuk.s3.amazonaws.com/excel-bites/Excel%20Bites%20010%20-%20The%20Data%20Model.mp3 If you’ve ever needed to build a Pivot Table from multiple tables at once without resorting to a tangle of VLOOKUPs to merge everything first, Power...

Excel Bites 009: Automation

https://theexceltrainerdotcodotuk.s3.amazonaws.com/excel-bites/Excel%20Bites%20009%20-%20Automation.mp3 Automation in Excel sounds technical but at its core, it’s simply about getting Excel to handle your repetitive tasks so you don’t have to. In this...

Excel Bites 008: Power Query

https://theexceltrainerdotcodotuk.s3.amazonaws.com/excel-bites/Excel%20Bites%20008%20-%20Power%20Query.mp3 Power Query is one of Excel’s most useful features and one of its most overlooked. If you regularly work with data that needs importing, cleaning, or...

Excel Bites 007: Pivot Tables

https://theexceltrainerdotcodotuk.s3.amazonaws.com/excel-bites/Excel%20Bites%20007%20-%20Pivot%20Tables.mp3 If you’ve ever been handed a spreadsheet with thousands of rows and asked to produce a summary report, you’ll know the sinking feeling that comes...

Excel Bites 006: Lists & Tables

https://theexceltrainerdotcodotuk.s3.amazonaws.com/excel-bites/Excel%20Bites%20006%20-%20Working%20with%20Lists%20and%20Tables.mp3 Excel is uniquely flexible when it comes to storing data – no setup, no field definitions, just headings and data. But...

Excel Bites 005: Formatting

https://theexceltrainerdotcodotuk.s3.amazonaws.com/excel-bites/Excel%20Bites%20005%20-%20Formatting.mp3 Formatting isn’t just about making spreadsheets look nice. It’s about communication. It’s what transforms a sea of raw data into something people...