Manual Grouping in an Excel PivotTable

Manual Grouping in an Excel PivotTable

Manually Grouping Text in a PivotTable Grouping data in a PivotTable can help you show a subset of data to analyze. In my example, I took GA, NC, and SC and grouped them and named them South. I took CA, WA, and OR and grouped them and named them West. Links: Microsoft...
Add a Map Chart in Microsoft Excel

Add a Map Chart in Microsoft Excel

Insert a Map Chart in Excel 2016 You can easily create a map chart in Excel 2016. The map chart uses Bing data for countries, regions, postal codes, and states. Simply select your data, click on the Insert tab, click Maps and a map will appear. You can change the...
Excel – Use Subtotal Function with Filters

Excel – Use Subtotal Function with Filters

Excel – Subtotal Function Use the Excel Subtotal Function when you filter data in Excel. When data is filtered only the visible rows appear. To calculate the average, max, lowest, and sum, use the Subtotal function. If you the Max function for example, it will...

Pin It on Pinterest