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

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

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

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

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

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

Remove Blanks in Excel! #excel #exceltips #googlesheets #spreadsheet #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

Clickable Files in 26 seconds 📁 #cheatsheets #excel #exceltips #spreadsheet #tutorials

How to VLOOKUP: Step 1. Type =VLOOKUP( Step 2. Select the lookup_value (the value to look up). Step 3. Select the range of data where the lookup_value is in the leftmost column. Step 4. Type the column number of the result. Step 5. Type FALSE for an exact match. How to HLOOKUP: Step 1. Type =HLOOKUP( Step 2. Select the lookup_value (the value to look up). Step 3. Select the range of data where the lookup_value is in the topmost row. Step 4. Type the row number of the result. Step 5. Type FALSE for an exact match. #cheatsheets #excel #exceltips #spreadsheet #tutorials

Filtering data with Slicers 🔪 Step 1. Format Data as Table (Ctrl + T) Step 2. Insert Slicer (Alt + J + I + E). Step 3. Select option to slice and press OK. Step 4. Change columns to 3, adjust size, and move slicers above data. Step 5. Click buttons to slice data. Hold down Ctrl to slice multiple criteria. Press the button in the upper right corner to clear all filters. #cheatsheets #excel #exceltips #spreadsheet #tutorials

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

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

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

SUMIF in 25 seconds‼️ #cheatsheets #excel #exceltips #spreadsheet #tutorials

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