It’s time to answer more of your burning Excel questions… A little while ago, I wrote an article answering some of the most common questions I get asked about Microsoft Excel and how to use it. I was so pleased to receive so much positive feedback from the Excel Ace community about the article, telling […]
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 […]
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 […]
Who is who? and what do they do? Meet Excel’s top Lookup functions. Excel is widely known for its efficiency when navigating datasets and is an ACE tool for helping you to identify and analyse information. Manual searches for data can be tedious and prone to errors so utilising Excel’s top lookup functions to help […]
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 […]
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 […]
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? […]
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 […]
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 […]
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 […]
EXCELACE ALL RIGHTS RESERVED.
WEBSITE BY FARM FACTORy
