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 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
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
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
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