File size limits for workbooks in SharePoint Online

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”

Comments and notes

Applies to: Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010. Office 365 Excel for Office 365 has updated how comments operate. Comments are now threaded, and enable you to have conversations with various people about the data. Notes are tailored for making notes or annotations regarding the data, and function similarly to comments like how they formerly worked inContinue reading “Comments and notes”

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”

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”

Combine text from two or more cells into one cell

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 Mobile. Data from numerous cells can be joined into a single cell using the Ampersand symbol (&) or the CONCAT function. Combine data with the Ampersand symbolContinue reading “Combine text from two or more cells into one cell”