🔑The FILTER function in Excel 365 allows you to easily filter data based on specific criteria.
🏷️Use Alt + Enter to split a formula into multiple lines and maintain control over word wrapping.
💰Quickly format cells as currency by selecting the range and pressing Ctrl + Shift + 4.
🔢Utilize the SUBTOTAL function in Excel to calculate totals for filtered data.
📊Create interactive totals in pivot tables by adding slicers and linking them to multiple pivot tables.
How can I quickly turn numbers into currency formatting?
—Select the range of cells and press Ctrl + Shift + 4 to apply the default currency formatting with two decimal points.
How do I calculate totals for filtered data in Excel?
—Instead of using the SUM function, use the SUBTOTAL function and specify the appropriate function number for the calculation you need (e.g., sum, average, max, min).
Can I link multiple pivot tables to a single slicer?
—Yes, right-click on the slicer, go to Report Connections, and select the pivot tables you want the slicer to control.
What is the FILTER function in Excel 365?
—The FILTER function allows you to filter data based on specific criteria and return the filtered results as a spill range.
How can I split a formula into multiple lines?
—Place the cursor where you want to split the formula and press Alt + Enter. This will add a new line and maintain word wrapping when enabled.
01:01The FILTER function in Excel 365 allows you to easily filter data based on specific criteria and return the filtered results as a spill range.
02:52Use Alt + Enter to split a formula into multiple lines and maintain control over word wrapping when enabled.
07:40Quickly format cells as currency by selecting the range and pressing Ctrl + Shift + 4 to apply the default currency formatting with two decimal points.
09:11Utilize the SUBTOTAL function in Excel to calculate totals for filtered data instead of using the SUM function.
09:59Create interactive totals in pivot tables by adding slicers and linking them to multiple pivot tables.
