Learn Excel and Power BI with my FREE Tutorials
Excel: Combine Multiple Rows into Separate Columns with Power Query
How to combine multiple related rows into a single row & the split into columns
Excel: Automatically Generate Sequential Numbers and Dates
Use the SEQUENCE function in Excel to generate sequential and non-sequential values
Copilot: Personalisation and Rules
Make Copilot work Your way!
Excel: Center Across Selection
Center Across Selection has been added to the Ribbon for easier access
Name a Table on Creation
The Create Table dialog box now contains a Table Name field
Using AI for Cleaning Data: Yes or No?
There are times to use AI to clean your data…and there are times not to!
Use Copilot to Restructure Excel Data
Turn a comma separated list into s set of easy to read checkboxes
Excel: What “Dynamic” Actually Means in Dynamic Arrays
An explanation of what the Dynamic part of Dynamic Arrays means
Excel: Have Dynamic Arrays Killed Absolute References?
Are Absolute Cell References still worth learning about?