by anita.lund@trainers-direct.com.au | Sep 3, 2026 | Excel, Microsoft Training
Learn Excel Fast: Can You Really Build Job-Ready Skills in Half a Day? Summary Looking to improve your Excel skills but don’t have time for a full-day course? In this article, we explore whether you can realistically learn Excel in just half a day and why...
by anita.lund@trainers-direct.com.au | Apr 21, 2026 | Excel, Microsoft Training
Do Executive Assistants use Excel? Excel is a critical skill for today’s Executive Assistants. From managing reports and budgets to organising data for senior leaders, EAs are expected to work confidently, accurately, and efficiently in Excel. This article breaks...
by anita.lund@trainers-direct.com.au | Apr 14, 2026 | Excel, Microsoft Training
This post explains how to clean data in Excel faster using TEXTJOIN, Find & Replace and Flash Fill, with step‑by‑step examples you can use immediately. Stop Wrestling With Dirty Data: 3 Excel Tools That Will Save You Hours If you work with data in Excel, chances...
by anita.lund@trainers-direct.com.au | Mar 4, 2026 | Excel, Microsoft Training
How to Lock Images in Excel So They Don’t Move When You Sort or Filter Summary Images in Excel (such as logos, product photos, or screenshots) are inserted as floating objects by default. This means they can shift, overlap, or “pile up” when you sort or filter data....
by anita.lund@trainers-direct.com.au | Nov 19, 2025 | Excel, Microsoft Training
XLOOKUP vs VLOOKUP: What’s the Difference and Which Should You Use in 2026? For years, VLOOKUP has been the go-to function for finding data in Excel. It works, but it has limitations that can cause frustration. Microsoft introduced XLOOKUP to solve these issues...
by anita.lund@trainers-direct.com.au | Dec 1, 2018 | Excel, Microsoft Training
Conditional Format Dates in Excel If you want to create a system in your spreadsheet to flag dates automatically when they become due you can do this by using conditional formatting. There is a built in option to do this which can be found under Home, Conditional...