Tips and Tricks

All those nitty gritty little things that make your life with MS Excel a lot easier will go into this section of the blog. Most of the times these are things like keyboards shortcuts or approaches to make your work a lot easier. Usually this is not worth a big tutorial but it helps improve your workflow with your spreadsheets and calcualtions.

Todays post is all about dollars! Well, to be honest, it's more about the $-sign (I think it's usually known pronounced as "string"), but hey, I wanted to make you curious. We will talk about referencing which can help you a lot when entering greater amounts of formulas or copying them.

In yesterdays post I showed you an effective approach to enter formulas in cells all at once by selecting the range, entering the formula and pressing CTRL+Enter instead of only Enter. Todays post will enhance this technique a little bit more.

Today I want to focus on a little technique, that makes it easy to enter a big amount of formulas in a very short time.

 

Today I want to share a quick tip with you which I learned recently. I think you know the problem: Sometimes it is hard to give a nicely created chart an exact position. You can of course CTRL-klick your chart to treat it like a graphic and nudge it with your arrow keys (see this post) but there is an even easier way.

Todays Quick-Tip is really a very very short one. It's about formatting a value towards invisibility. Sometimes you need values in cells only for calculation purposes and don't want your users to see them.