Keeping leading zeros and large numbers - Microsoft Support
Keeping leading zeros and large numbers
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
SUMPRODUCT function - Microsoft Support
The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.The default operation is multiplication, but addition, subtraction, and division are also possible. In this example, we'll use SUMPRODUCT to return the total sales for a given item and size:
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
SUBTOTAL function - Microsoft Support
SUBTOTAL function
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Description of Microsoft System Information (Msinfo32.exe) Tool
Description of Microsoft System Information (Msinfo32.exe) ...
Introduction to lists - Microsoft Support
Introduction to lists
Applies To:
SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint in Microsoft 365, Microsoft Lists
Overview of PivotTables and PivotCharts - Microsoft Support
Overview of PivotTables and PivotCharts
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Surface Pro 6 specs and features - Microsoft Support
Surface Pro 6 specs and features
PMT function - Microsoft Support
PMT function - Microsoft Support ... PMT function
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Split text into different columns with the Convert Text to Columns ...
Learn how to take the text in one or more cells, and split it out across multiple cells by using Excel functions. This is called parsing, and is the opposite of concatenate. Watch more in this video.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
LINEST function - Microsoft Support
LINEST function - Microsoft Support ... LINEST function
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016