how to use excel

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

A graphic showing three keyboard keys: the ctrl key, the windows home key, and the alt key. Above the ctrl key are yellow stars, indicating it's magic potential.

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 […]

Streamlining Administrative Tasks with Excel Macros

A graphic of a pie chart in three pieces with a knife and fork on either side. It is a play on the word Macro, presenting Excel macros as nutrition macros.

Take a look at this comprehensive guide on how to leverage Excel macros to enhance your productivity. Every Executive Assistant knows that efficiency is the key to successful administration. With an ever-increasing workload, finding ways to streamline your tasks can be a game-changer. Enter Excel macros – an ACE tool within Microsoft Excel that is […]

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 […]

Uncover the magic of Pivot Tables in 5 simple steps

Are you ready to level up your Excel game and unlock the full power of data analysis? Imagine having the ability to effortlessly summarise and analyse vast amounts of data and gain valuable insights with ease.  It sounds like magic, right? Almost too good to be true? Well, I’ve got good news because that magic […]

Join the Excel Ace community!
Get FREE Excel tips, guides, and industry insights delivered straight to your inbox. Sign up for our newsletter today!
Name