INDIRECT function - Microsoft Support
Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself. INDIRECT (ref_text, [a1]) The INDIRECT function syntax has the following …
Calculate values in a PivotTable - Microsoft Support
Use different ways to calculate values in calculated fields in a PivotTable report in Excel.
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Format an Excel table - Microsoft Support
Format an Excel table by applying different table styles or colors.
Issue: An _xlfn. prefix is displayed in front of a formula
When the formula is calculated, it displays the #NAME? error value. The Excel workbook contains a function that is not supported in the version of Excel that you are currently running. Remove …
Use the Format Painter - Microsoft Support
Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. With format painter, you can copy all of the …
CONVERT function - Microsoft Support
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. CONVERT …
Profile data to view statistics (Power Query) - Microsoft Support
Profile data to view statistics (Power Query) The data profiling tools provide intuitive ways to clean, transform, and understand query data, such as key statistics and distributions. In …
FISHERINV function - Microsoft Support
This article describes the formula syntax and usage of the FISHERINV function in Microsoft Excel. Returns the inverse of the Fisher transformation. Use this transformation when analyzing …
VLOOKUP function - Microsoft Support
Use the VLOOKUP function to look up a value in a table. There are four pieces of information that you will need in order to build the VLOOKUP syntax: The value you want to look up, also …
Create a Map chart in Excel - Microsoft Support
You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, …