Excel

Hey you! I’m working on making navigation more of a pleasure for you. These pages are going to look a little ghetto; I’m focused on helping you get the content for now.

  1. Step 1 is just spreading out all my blogs by categories for you. I can also more easily see where I need to add more content to fill in the gaps for you.
  2. Then I’ll add in filler and fancy shite to make it all look pretty.

If you’re an expert on any topics and want to teach others from your hard-won experience, message me as I’d love the help to make more quality blogs.

Excel

Excel is king when it comes to numbers.

I’m really fricking good at Excel. Like I got stuck once on a problem and called 4 Excel consultants and they said “tbh, you’re the expert here”.

I started making content on Excel but tbh there are a lot of people doing the usual content so I couldn’t see an angle for me to do it.

I might make a course on hard stuff like how to financial model in Excel. I need your feedback to know if that’s worth my while.

Blogs to read

There are a couple of things worth checking out. If you are specifically interested in financial models, I have another section for that. This is just about Excel formulas.

Tips

I occasionally write blogs on slightly complicated things.

Excel financial model formatting guide

Excel number format cheat sheet

How to rebase a chart

Course

I made a little free course because I couldn’t help myself. I stopped as frankly I didn’t think I would make money from it. It’s good content though.

  1. Create a list and hide excel gridlines: Startup and investor excel model training
  2. Excel hide columns and row: Startup and investor excel model training
  3. Paste links and excel transpose data: Startup and investor excel model training
  4. Insert rows and columns: Startup and investor excel model training
  5. Save multiple versions: Startup and investor excel model training
  6. Add a ‘ at the start: Startup and investor excel model training
  7. Colouring tabs and name changes: Startup and investor excel model training
  8. VLOOKUP: Startup and investor excel model training
  9. INDEX MATCH: Startup and investor excel model training
  10. CONCATENATE: Startup and investor excel model training
  11. Ampersand: Startup and investor excel model training
  12. TEXT: Format text to be all pretty. Startup and investor excel model training
  13. Dollar signs: Make formulas connect in specific ways Startup and investor excel model training
  14. IF: Startup and investor excel model training
  15. Operators: Bigger, smaller, equal? Startup and investor excel model training
  16. OFFSET: Startup and investor excel model training
  17. AND OR NOT: Startup and investor excel model training
  18. ISNUMBER, ISTEXT and ISBLANK: Startup and investor excel model training
  19. ROUND: Make numbers… round! Startup and investor excel model training
  20. ISERROR: Keep formulas cleanStartup and investor excel model training
  21. MIN MAX: The biggest and smallest. Startup and investor excel model training
  22. Nested IF: Startup and investor excel model training
  23. SUMPRODUCT: Power and flexibility Startup and investor excel model training
  24. SUMIF: Startup and investor excel model training
  25. COUNTIF: Count what matters simply – Startup and investor excel model training