CheatSheets | Excel & GSheets

How to create a Progress Tracker in 30 seconds ☑️ Step 1. Select the range and insert checkboxes (Alt + N + C + B). Check the boxes as necessary. Step 2. Type the formula =REPT(“▓”, COUNTIF(C3:G3,TRUE)). To type in ▓ use the alt code Alt + 178. Step 3. Copy the formula down (double-click the lower right corner of the cell to autofill down). It's almost time... Miss Excel is throwing a FREE Excel extravaganza THIS WEEK to help you save hours in your day by leveraging the power of Excel Dashboards to save you hours each week. Don't miss your chance to register! (link in bio!). #cheatsheets #excel #exceltips #spreadsheet #tutorials

How to Wrap Text in 17 seconds 🎁 Step 1. Press Ctrl + A Step 2. Press Alt + H + W #cheatsheets #excel #exceltips #spreadsheet #tutorials

Removing Blanks in Excel #cheatsheets #excel #exceltips #spreadsheet #tutorials

How to Quick Compare two lists in 15 seconds 💨 Step 1. Select both lists. Step 2. Press Ctrl + \ Step 3. Change the cell background of the selected cells to yellow. If you're not using Excel Dashboards to save you hours each week - you're missing out! In Miss Excel's FREE Class, she will show you her top tips for optimizing your spreadsheets. Register using the link in our bio! #cheatsheets #excel #exceltips #spreadsheet #tutorials

I can’t believe 99% of people didn’t know this already! #excel #exceltips #exceltutorial

My co-worker has a problem 🥴 But I’m here to help them! 😬 #excel #exceltips #exceltricks

VLOOKUP w/ IFERROR in 30 seconds #error #cheatsheets #excel #exceltips #spreadsheet #tutorial

Tidy Rows & Columns 🧹 Step 1. Select All (Ctrl + A) Step 2. AutoFit Columns (Alt + H + O + I) Step 3. AutoFit Rows (Alt + H + O + A) Don't waste time spending countless hours on manual, repetitive tasks in Excel 🚫 Join Miss Excel's FREE Masterclass to learn all of her favorite tips & tricks. In this fun power-packed 1 hour session, you'll learn her secret hacks for optimizing your data visualization skills to save you hours each week! Limited spots available! Register at our link in bio 🎉 #cheatsheets #excel #exceltips #spreadsheet #tutorials

Checkboxes in Excel! #excel #exceltips #googlesheets #spreadsheet #tutorials

Millions of users had no idea this shortcut existed! #excel #exceltips #exceltutorial

Creating a Simple PivotTable 📊 Step 1. Click anywhere in the data Step 2. Go to the ‘Insert’ tab Step 3. Click ‘PivotTable’ Step 4. Choose ‘New Worksheet’ and press ‘OK’. Step 5. Drag the desired fields to the desired areas. Step 6. (Optional) Right-click the values to sort. Don't waste time spending countless hours on manual, repetitive tasks in Excel 🚫 Join Miss Excel's FREE Masterclass to learn all of her favorite tips & tricks. In this fun power-packed 1 hour session, you'll learn her secret hacks for optimizing your data visualization skills to save you hours each week! Limited spots available! Register at our link in bio 🎉 #cheatsheets #excel #exceltips #spreadsheet #tutorials

Faster than ever‼️ #excel #exceltips #exceltutorial

Remove Blanks in Excel! #excel #exceltips #googlesheets #spreadsheet #tutorials

Drop-downs in Excel! #excel #exceltips #googlesheets #spreadsheet #tutorials

Filter in Excel #cheatsheets #excel #exceltips #spreadsheet #tutorials

Colon Number Format in Excel! #excel #exceltips #spreadsheet #cheatsheets #tutorials

How to Replace Blanks in Excel 🙌 Step 1. Select All (Ctrl + A) Step 2. Find and Replace (Ctrl + H), add a single space in the ‘Find what’ box, leave the ‘Replace with’ box empty, click Replace All. #cheatsheets #excel #exceltips #spreadsheet #tutorials

AutoFormat in Excel! #excel #exceltips #spreadsheet #cheatsheets #tutorials

Rept Charts in Excel! #excel #exceltips #spreadsheet #cheatsheets #tutorials

Group By in Excel! #excel #exceltips #spreadsheet #cheatsheets #tutorials