advanced excel functions

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

Level Up Your Excel Mastery With Parameters In Power Query

Level Up Your Excel Mastery With Parameters In Power Query

Take the next step on your Excel journey by adding Parameters in Power Query. In my previous article (where I showed you the incredible power that Power Query in Excel holds), I mentioned a few ways to really maximise your usage of this fantastic tool. If you haven’t read the article yet, you can find […]

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

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!
Please enable JavaScript in your browser to complete this form.
Name