Excel financial model formatting guide
Tl;dr: Building a huge Excel model is great, using it easily is awesome. The foundation is in your formatting and knowing the code of what...
Read moreHow to rebase a chart
Have you ever wondered what stock has performed better or worse over a period of a year? What do things look like a year later?...
Read moreExcel number format cheat sheet
Did you know that you can do all sorts of magic in Excel to format your cells and make magic happen without formulas? Maybe you...
Read more25. COUNTIF: Count what matters simply - Startup and investor excel model training
Intro to Excel model training This is part of a series on Excel model training focused on helping founders and investors to actually enjoy and...
Read more24. SUMIF: Startup and investor excel model training
Intro to Excel model training This is part of a series on Excel model training focused on helping founders and investors to actually enjoy and...
Read more23. SUMPRODUCT: Power and flexibility Startup and investor excel model training
Intro to Excel model training This is part of a series on Excel model training focused on helping founders and investors to actually enjoy and...
Read more22. Nested IF: Startup and investor excel model training
Intro to Excel model training- Nested IF This is part of a series on Excel model training focused on helping founders and investors to actually...
Read more21. MIN MAX: The biggest and smallest. Startup and investor excel model training
Intro to Excel model training- MIN MAX This is part of a series on Excel model training focused on helping founders and investors to actually...
Read more20. ISERROR: Keep formulas cleanStartup and investor excel model training
Intro to Excel model training- ISERROR This is part of a series on Excel model training focused on helping founders and investors to actually enjoy...
Read more19. ROUND: Make numbers... round! Startup and investor excel model training
Intro to Excel model training- ROUND This is part of a series on Excel model training focused on helping founders and investors to actually enjoy...
Read more18. ISNUMBER, ISTEXT and ISBLANK: Startup and investor excel model training
Intro to Excel model training- ISNUMBER ISTEXT ISBLANK This is part of a series on Excel model training focused on helping founders and investors to...
Read more17. AND OR NOT: Startup and investor excel model training
Intro to Excel model training – AND OR NOT This is part of a series on Excel model training focused on helping founders and investors...
Read more15. Operators: Bigger, smaller, equal? Startup and investor excel model training
Intro to Excel model training- OPERATORS This is part of a series of Excel model training focused on helping founders and investors to actually enjoy...
Read more13. Dollar signs: Make formulas connect in specific ways Startup and investor excel model training
Learn how to make absolute and relative formulas in a jiffy! You can't build a model to raise without this
Read more12. TEXT: Format text to be all pretty. Startup and investor excel model training
TEXT makes things look prettier. You can insert it to make sentances include dynamic numbers, but formatted right!
Read more11. Ampersand: Startup and investor excel model training
Learn how to stick things together in excel so your text is dynamic. Save a bunch of time
Read more10. CONCATENATE: Startup and investor excel model training
CONCATENATE is like Excel glue. It sticks stuff together. Get in on the founder and investor excel training.
Read more16. OFFSET: Startup and investor excel model training
OFFSET. It a pretty annoying formula, but sometimes it's the only way to do something. Find out how to use it in a real model now.
Read more
Comments (0)
There are no comments yet :(