Most people didn’t even know this formula existed! =FILTER(array, include, [if_empty]) •array = the range to filter •include = the criteria to base the filter on •[if_empty] = value to return if all values in the array are empty #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