Applies to: Excel for the web, SharePoint Online. SharePoint Online has some file size limits for workbooks. Once you upload an Excel for the web workbook to a SharePoint document library that’s too huge, it will either not open in a browser window, or let you edit or refresh data in the browser. To avoid occupyingContinue reading “File size limits for workbooks in SharePoint Online”
Tag Archives: Answers community
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”
Group or ungroup data in a PivotTable
Grouping data in a PivotTable can assist you with displaying a subset of data to analyse. For instance, you might want to group a monumental list of dates or times (date and time fields in the PivotTable) into quarters and months, similar to this image. Note: The time grouping feature is new in Excel 2016. WithContinue reading “Group or ungroup 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”
Total the data in an Excel table
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, Excel for Mac 2011. Windows You can easily total data in an Excel table by activating the Total Row option, and then apply one of many functions that are given in a drop-downContinue reading “Total the data in an Excel table”
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”
COUNTIF function
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, Excel for Mac 2011, Excel Starter 2010. With COUNTIF, one of the statistical functions, you can count the amount of cells which qualify a criterion; for instance, to count how often a specificContinue reading “COUNTIF function”
Create and format tables
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, Excel for Mac 2011. You can create and format a table, to visually group and analyse data. Note: Excel tables shouldn’t be confused with the data tables that are part of a suite ofContinue reading “Create and format tables”