It’s 2025 and Excel is still our favourite app? 🤷🏻‍♂️ I made this guide to help some of my colleagues who want to level up their excel skills. So I tried to come up with something based on my experience in consulting and tech. But there are already so many great tutorials on the internet, so i think what I will do today is a very quick walkthrough / demo of 7 things that I use day to day or consider essential. So that if you want learn more about any of them, you can find a more targeted tutorial on Youtube. 😊 #efficiency

Below are what’s included in the crash course and I tried to explain them with practical examples. Feel free to post any question or share your tips! 🙏🏻

1. Everything about pivot table
2. Data visualisation with conditional formatting
3. Xlookup
4. Sumifs and Countifs
5. Text formulas
6. Common shortcuts
7. Macro fundamental