CheatSheets

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

Bet you didn’t know this, did you? #cheatsheets #excel #exceltips

Noobs struggle, pros Excel 😉 #cheatsheets #excel #exceltips

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

His face turned bright red 😳 #cheatsheets #excel #exceltips

Oh oh oh it’s magic! 🧙‍♂️ #cheatsheets #excel #exceltips

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

Custom Search Bar in Excel‼️ #cheatsheets #excel #exceltips

Just what I needed 😊 #cheatsheets #excel #exceltips

Automating the way you Get Data in Excel‼️ #cheatsheets #excel #exceltips

Are you part of the 1%? #cheatsheets #excel #exceltips

The intern needs to start watching our videos! #cheatsheets #excel #exceltips

Trim Spaces in Excel ✂️ #cheatsheets #excel #exceltips

Let’s DGET it started in here! 🕺 #cheatsheets #excel #exceltips

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

Wrap it up #cheatsheets #excel #exceltips