Sarah Bridge | search
Click here to view Sarah Bridge news from 60+ newspapers.
Bookmark or Share- Create a chart from start to finish - Microsoft SupportLearn 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.
- Create a waterfall chart - Microsoft SupportUse the waterfall chart to quickly see positive and negative values impacting a subtotal or total value. Waterfall charts are often used to visualize financial statements, and are sometimes called bridge charts.
- SUMIF function - Microsoft SupportYou use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5.
- Calculate multiple results by using a data tableA data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. A good example of a data table employs the PMT function with different loan amounts and interest rates to calculate the affordable amount on a home mortgage loan.
- Edit titles or data labels in a chart - Microsoft SupportIf your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.
More
