Use the INTERCEPT function when you want to determine the value of the dependent variable when the independent variable is 0 (zero). For example, you can use the INTERCEPT function to predict a metal's electrical resistance at 0°C when your data points were taken at room temperature and higher.
Analyze and format in Excel. Automatically fill a column with Flash Fill. For example, automatically fill a First Name column from a Full Name column. In the cell under First Name, type Molly and press Enter. In the next cell, type the first few letters of Garret.
There is no automatic way to find all workbook links in a workbook. You need to look differently in formulas, defined names, objects (like text boxes or shapes), chart titles, and chart data series.
Use the Quick Analysis tool to pick the right chart for your data. Select the data you want to show in a chart. Select the Quick Analysis button to the bottom-right of the selected cells. Select Charts, hover over the options, and pick the chart you want. Try it!