Advertisements

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”

Advertisements

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”

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”