Excel Tools and Resources
Free
Want to improve at Excel? Learn to format, make formulas and the tips and tricks? I’ve got some resources for you!
- Excel course
- Number format cheat sheet
- Rebasing charts
Course
Free Excel Course
I’ve made a pragmatic daily course, where you get a spreadsheet to learn in as well as a clear description. It’s only by doing that you learn.
You will get 36 weekly emails with a practice sheet to work on.
Join up now
Formatting
Excel number format cheat sheet
Learn to do excel number format so you can make your sheets prettier, professional and more informative. This cheat sheet is all that you need.
DATA
How to rebase a chart
This is how you make a chart so that everything starts at 100 and grows from there so you can see the relative growth.
Formatting
Complex Excel Chart Templates
It’s easy to make a pie chart but there are advanced charts used by consultants and bankers that are a total pain in the behind to make. If you had templates you could take all effort out and just get your work done. Better yet, if you’re not even aware of these charts, you suddenly have the ability to make better presentations without even knowing how to make them!
Reading
Looking for some recommended reading?
Here are some blogs you can check out related to this topic:
Excel financial model formatting guide
Building a huge Excel model is great, using it easily is awesome. The foundation is in your formatting and knowing the code of what colors to use. I’m going to teach you how to use font colors consistently and to use cell background colors.
ISNUMBER, ISTEXT and ISBLANK
How do you know what is in a cell? Is it a number, a string, or even an empty cell? Depending on the analysis you are doing, you need to know how to use these operators.
