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

0010 Excel Shortcuts: How to Select Non-Adjacent Cells

Picture this: you have a lot of reformatting to do on your spreadsheet and there are pockets of different formatting sprinkled throughout. Finally there’s a shortcut to speed up that process! In this video, I will teach you how to select multiple cells that aren’t next to each other without touching the mouse. Download FREE …

Read more