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 […]
Powering Up Microsoft Excel’s Quick Access Toolbar Secrets!
You’ve probably seen this ACE tool every time you’ve used Excel, but you might not know what it does… Not many people know about the Quick Access toolbar. We all have one and it’s an ACE tool for saving you time and effort when it comes to using Excel, but for so many people it […]
Harnessing AI in Excel for Formulas, Macros, and Data Insights!
Should you trust artificial intelligence when it comes to your spreadsheets? AI in Excel is a subject that I’m being asked about more and more regularly. On the one hand, it’s a somewhat scary idea that artificial intelligence can create formulas, macros and more in the blink of an eye – yet I can’t help […]
Data cleaning in Excel: 10 Tips for a flawless dataset
Organising your data can feel like a chore – but that doesn’t have to be the case… If you know me, you know that I’m the type of person who loves things to be organised. I thrive off deadlines, I live by my to-do lists and most importantly, I like to keep my Excel spreadsheets […]
What IF? Microsoft Excel’s popular IF function explained
True or False? Excel does so much more than just storing data. Wouldn’t it be nice if there was a function in Excel that could help you test specific conditions within your data? Oh wait, there is! One of the biggest misconceptions people have about Excel is that spreadsheets are just a place for storing […]
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 […]
Get to the heart of your data faster with VLOOKUP in Excel
Sprint to the finish line with this essential data analysis function. When it comes to analysing data, I love a trick that will speed things up and get me to the heart of my data faster. As much as I love Excel, sitting at the computer for hours on end manually sifting through data is […]
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 […]