6. Add a ‘ at the start: Startup and investor excel model training

Looks like you need some model training. Do you want to show a formula but it keeps turning in a formula result. Want to add text with a zero at the start like 007 and it looks like 7? Super annoying right? This is a super quick learning for you today!

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 get proficient in excel. It’s such an important skill to have, and there’s no excuse to not be able to do all the ‘advanced’ stuff, let alone the basics.

This is a pragmatic course where you will only learn the most useful things; those that I actually use regularly. We’ll go through the obvious applications, but also include some hacks I’ve developed over the years.

To get the excel example for this and all the other instalments, subscribe with the pretty box on the right and you’ll get the excel tip of the day sent directly to your inbox. Within a month and ten minutes practice, you’ll be a boss in no time.

You can join up to the training here.

What’s the point of adding a ‘?

Adding a ‘ (apostrophe) is your way of telling Excel to take the weekend off and leave the cell alone. It’s just that simple. If you type in ‘007 you will see 007, not 7. This means it doesn’t work as a formula, but it’s useful for footnotes and general presentation.

How do you use the ‘?

Take a wild guess here… just type ‘ in front of something!

Example

The excel example sheet will help you to learn this with some examples.

To get the training model, subscribe to the series below.