Add or remove add-ins in Excel - Microsoft Support
WEBBy default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them. Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Some other add-ins are available from the Download Center, and must first be downloaded and installed.
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.
Change the scale of the vertical (value) axis in a chart
WEBBy default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs.
Overview of formulas in Excel - Microsoft Support
WEBTry using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor. Create a formula that refers to values in other cells. Select a cell. Type the equal sign =. Note: Formulas in Excel always begin with the equal sign.
Using IF with AND, OR, and NOT functions in Excel
WEBIn Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
Create a chart from start to finish - Microsoft Support
WEBNeed more help? Want more options? Learn how to create a chart in Excel and add a trendline. Visualize your data with a column, bar, pie, line, or scatter chart (or graph) in Office.
Add or remove series lines, drop lines, high-low lines, or up-down …
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.
Basic tasks in Excel - Microsoft Support
WEBFor example, pick a color scale in the Formatting gallery to differentiate high, medium, and low temperatures.
Create a Map chart in Excel - Microsoft Support
WEBMap charts can only plot high-level geographic details, so latitude/longitude, and street address mapping isn’t supported. Map charts also support one-dimensional display only, but if you need multi-dimensional detail you can use Excel’s 3D Map feature.
Change the format of data labels in a chart - Microsoft Support
WEBTo get there, after adding your data labels, select the data label to format, and then click Chart Elements > Data Labels > More Options. To go to the appropriate area, click one of the four icons (Fill & Line, Effects, Size & Properties (Layout & Properties in Outlook or Word), or Label Options) shown here.
Using structured references with Excel tables - Microsoft Support
WEBTo include structured references in your formula, click the table cells you want to reference instead of typing their cell reference in the formula. Let’s use the following example data to enter a formula that automatically uses structured references to calculate the amount of a sales commission.