You may think you know how to format cells, but until you master this goldmine of a shortcut, you’ll forever be limited. In this video I will teach you the best (and most comprehensive) way to format cells. Download FREE Hands-On Exercises Full Video Transcript: Some people are extremely particular about the way their spreadsheets …
One major advantage that Excel has over paper & pen is that you can literally shift EVERYTHING over and make space for more information without disturbing your existing work. You can also clean things up by removing unused information (no more erasing feverishly!). In this video, I will teach you how to insert and delete …
Have you ever needed to clear PART of a cell, but not all of it? If so, this video is for you! It will save you minutes, hours, or days, depending on how complex your spreadsheet is :). Download FREE Hands-On Exercises Full Video Transcript: I don’t know if you know this, but Excel can …
The whole point of headers is to accurately describe the data underneath them. But what good are headers if they disappear every time you scroll down?!?! Don’t worry, in this video I will teach you exactly how to freeze your headers at the top of the screen, so you always know which data you are …
Fact: When it comes to spreadsheets, size matters. If the text is too small, make it easier to read by zooming in. On the flip side, if you can’t see everything you need to without scrolling, try zooming out. Either way, make it easier for your boss, colleagues, and yourself by learning how to zoom …
