Analysing data in Excel using PowerPivot and DAX
Unlock the full potential of data literacy
Excel Hot Topics:
Dynamic Array Formulas
Excel Hot Topics:
More magic hotkeys with Simon
Excel Hot Topics:
VLOOKUP, INDEX/MATCH vs XLOOKUP
Excel Hot Topics:
Handling common errors
Introduction to Excel Power Pivot
Conditional Formatting - An all round guided tour
New Chart Types & Geo-mapping data
Building a Dashboard in Excel
Office 365: Building a modern intranet with Sharepoint communication sites
When should I use One Drive, Sharepoint or Teams?
Sharepoint Online Document Version Management
Microsoft Software for Projects - Choose the right tool
Using Planner & OneNote
Power BI Desktop: Introducing DAX measures
Power BI Desktop: Introducing DAX Syntax and Columns
Power BI Desktop: The Environment & Building Basic Reports
Power BI: Using Power Query to Clean & Tidy your data
Power BI Desktop: Introducing DAX Calculated Tables
Power BI Desktop: Introducing DAX Syntax and Columns
Word Hot Topics
Word Shortcuts, Hints & Tips
Google Sheets Fundamentals - How to get the most out of Google Sheets
Google Sheets - Use Pivot Tables like a Pro
Google Workspace: Mastering Automation with Macros in Google Sheets
Gmail Productivity Hacks