30 Excel Tips

Excel can do incredible things to save you time and make you look good (even to yourself)! 📊 By popular request we’ve put together the most common Excel functions in this Top 30 cheat sheet.  

My favourite Formulas?

➕ Using Index/Match instead of Vlookup. It’s a lot more flexible and easier to work out the issue if you get an error

➕ Using Sumifs to add up numbers with multiple criteria

My main tip?

Anything that has to be done more than once a day / week needs to be automated. A few quick automationsand formulas in a spreadsheet can save you so much time in a week (and time is money, right?) 

Looking to get some efficiencies using excel? Our experts regularly train corporate teams and individuals in excel to boost employee skills,productivity, and collaboration, resulting in long-term benefits for your organisation. 

‍

Click here to download a copy of this sheet to print and hang on your wall.