For all you visual people out there, this one takes a little getting used to, but once you learn it you can save a bunch of time AND feel like a badass. Nerdy is the new cool, right? š In this video, I will teach you how to insert a blank sheet, and how to …
If your spreadsheet is a 3 ring binder, then each worksheet is a page. In this video, I will teach you how to insert a blank sheet, and how to delete an existing sheet, using Excel shortcuts for both PC and Mac. Download FREE Hands-On Exercises Full Video Transcript: I don’t know about you, but …
Download FREE, PrintableĀ Step-by-Step Guides Step-by-Step Guide: Customize Mac Keyboard Shortcuts Go to System Preferences. Shir Tip: Use Spotlight Search to open System Preferences. Press COMMAND + SPACE to open “Spotlight Search.” Type “sys” and it will most likely autofillĀ “System Preferences”. Press RETURN. Click on the “Keyboard” icon. Click on the “Shortcuts” tab on the top …
If you’re like most people, you are starting your day off with this inefficient step. It doesn’t have to be this way! In this video, I will show you how to open and close spreadsheets using Excel shortcuts for both PC and Mac. Save time every single day, so you can get back to your …
Practicing the most important Excel function: VLOOKUP! “Hold your horses Shir! I don’t know how to do a VLOOKUP!” No problem, check out this post:Ā The Most Important Excel Function You Will Ever Learn Alright sparky here’s the deal… You’ve got month numbers and you want to show them as month names. Simple enough right? Sure …
