Progression | search
Click here to view Progression news from 60+ newspapers.
Bookmark or Share- Apply data validation to cells - Microsoft SupportUse data validation to restrict the type of data or the values that users enter into a cell, like a dropdown list. Select the cell (s) you want to create a rule for. Select Data >Data Validation. Whole Number - to restrict the cell to accept only whole numbers. Decimal - to restrict the cell to accept only decimal numbers.
- Create a flow chart with SmartArt - Microsoft SupportThis article explains how to create a flow chart that contains pictures. You can use the methods described in this article to create or change almost any SmartArt graphic. Try different layouts to achieve the results you want. What do you want to do? On the Insert tab, in the Illustrations group, click SmartArt.
- Add alternative text to a shape, picture, chart, SmartArt graphic, or ...Use the procedures in this article to learn how to add alt text to a shape, picture, chart, SmartArt graphic, or other graphical objects. To learn how to write alt text, go to Everything you need to know to write effective alt text. Right-click the object and select Edit Alt Text.
- FORECAST and FORECAST.LINEAR functions - Microsoft SupportCalculate, or predict, a future value by using existing values. The future value is a y-value for a given x-value. The existing values are known x-values and y-values, and the future value is predicted by using linear regression. You can use these functions to predict future sales, inventory requirements, or consumer trends.
- Filter by using advanced criteria - Microsoft SupportMicrosoft Office Excel uses the separate criteria range in the Advanced Filter dialog box as the source for the advanced criteria. The following sample data is used for all procedures in this article. The data includes four blank rows above the list range that will be used as a criteria range (A1:C4) and a list range (A6:C10).
More
