Create a PivotChart

Sometimes visualising the big picture can be difficult when your raw data hasn’t been collated. Your first action could be to create a PivotTable, but some people prefer other ways to decipher the meaning of numbers and their associated data. PivotCharts are an easy way to insert data visualisations to your data. Household expense data CorrespondingContinue reading “Create a PivotChart”

Filter data in a PivotTable

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac. Filter your data to hone in on a smaller segment of your PivotTable data for granular analysis. Initially, add one or multiple slicers for a fast and productive way toContinue reading “Filter data in a PivotTable”

Use the Field List to arrange fields in a PivotTable

Applies to: Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. After you produce a PivotTable, you’ll notice the Field List. You can modify the design of the PivotTable by inserting and organising its fields. If you want to sort or filter the columns of data displayed in the PivotTable, see Sort data inContinue reading “Use the Field List to arrange fields in a PivotTable”

Filter data in a range or table

Applies to: Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel Starter 2010. Use AutoFilter or automatic comparison operators including “greater than” and “top 10” in Excel to reveal your preferred data and conceal those left over. After you’ve filtered data in a range of cells or table, you can chooseContinue reading “Filter data in a range or table”