Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
WEBUse the table_array argument in a VLOOKUP function. Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.
Create a parameter query (Power Query) - Microsoft Support
WEBCreate a parameter that stands for a value you might frequently change, such as a server, database, folder, file name, location or filter value.
Transpose (rotate) data from rows to columns or vice versa
WEBIf you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
Create and share a Dashboard with Excel and Microsoft Groups
WEBOnce your dashboard is created, we’ll show you how to share it with people by creating a Microsoft Group. We also have an interactive Excel workbook that you can download and follow these steps on your own. Download the Excel Dashboard tutorial workbook. Create a dashboard Share your dashboard. Get your data.
Add or remove series lines, drop lines, high-low lines, or up …
WEBYou can add predefined lines or bars to charts in several apps for Office. By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can help you analyze the data that is displayed. If you no longer want to display the lines or bars, you can remove them. New to formatting charts in Excel?
Guidelines and examples of array formulas - Microsoft Support
WEBSum every Nth value in a range of values. The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array functions, as well as existing array formulas entered as both dynamic and legacy arrays.
SCAN function - Microsoft Support
WEBScans an array by applying a LAMBDA function to each value and returns an array that has each intermediate value.
Download free, pre-built templates - Microsoft Support
WEBYou can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business cards, letters, cards, brochures, newsletters, resumes, cover letters, presentations, social media and much more.
Overview of diagnostic log files for Office - Microsoft Support
WEBA copy of the log files that are sent to Microsoft are usually found in the %temp%\Diagnostics\UploadCache folder. These files are text files, which can be viewed with most text editors. Log files on devices running Android. There are separate log files for each Office app, such as Word or Excel.
LINEST function - Microsoft Support
WEBThe LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line.
XLOOKUP function - Microsoft Support
WEBUse the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.