0015 Excel Shortcuts: How to Insert and Delete Cells, Rows, and Columns

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 …

Read more

0014 Excel Shortcuts: How to Clear Cell Contents

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 …

Read more

0013 Excel Shortcuts: How to Freeze Headers

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 …

Read more

0012 Excel Shortcuts: How to Zoom In or Out

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 …

Read more

0011 Excel Shortcuts: How to Go To any Cell and Use Special Cells

My mother always told me “Everyone is special in their own way.” What she didn’t tell me, is that every cell in a spreadsheet is special too. In this video, I will teach you how to go to a specific cell or range of cells using their special traits. This is perfect for jumping to a …

Read more