Control Your Excel World: Unravelling the Magic of the ‘Ctrl’ key!

Check out these 12 Ctrl key shortcuts that will help you save time and make Excel more efficient. Let’s be honest, work isn’t always a walk in the park. There are often times when our to-do lists just keep growing and growing and no matter how hard we try to tick things off, something else […]
How to Master Your Data Retrieval with INDEX/MATCH

Retrieve data faster and more dynamically with this match made in Excel heaven. When dealing with large datasets, being able to retrieve the right information quickly and accurately is crucial. Searching manually for data is time-consuming (not to mention boring) and leaves so much room for error. So how do we avoid having to do […]
Become a Trend Spotter with Excel’s Conditional Formatting Feature

Identifying trends in your data doesn’t have to be like a game of Where’s Wally. Spotting trends in your data is such an important part of data analysis. Why? Because seeing the trends in your data helps you to make informed decisions, and the quicker you can make decisions and implement actions, the better, right? […]
Excel Spreadsheets: Common Excel Questions

Excel Ace is celebrating its 15th year in business, which is just ACE and makes me very happy and grateful. However, it’s also made me reflect on how Excel has changed and developed over the years, and also on some of the common Excel questions I get asked time and time again. In this article, I’m […]
Your quick guide to Excel’s CTRL shortcuts

On your marks, get set, go – these quick shortcuts will get your spreadsheets over the finish line faster! I’m constantly in awe of Excel’s capabilities to allow you to analyse data in a fast and efficient way. There are so many Excel shortcuts (including Excel’s CTRL shortcuts) available to help you streamline your activities […]
Excel Shortcuts That Will Change Your Life

Hold on to your keyboards, these Excel shortcuts are going to change your life and streamline your spreadsheet usage forever. I have absolutely no problem admitting that I can be a bit lazy, although I prefer to call it ‘being efficient’. It’s a fact; if I can make Excel do it, then NO WAY am […]