Astm | search
Click here to view Astm news from 60+ newspapers.
Bookmark or Share- CONVERT function - Microsoft SupportConverts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. Syntax. CONVERT (number, from_unit, to_unit) Number is the value in from_units to convert. From_unit is the units for number. To_unit is the units for the result.
- ROUND function - Microsoft SupportTo always round up (away from zero), use the ROUNDUP function. To always round down (toward zero), use the ROUNDDOWN function. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function.
- Create custom functions in Excel - Microsoft SupportCertain kinds of statements, such as statements that select and format ranges, are excluded from custom functions. In this article, you’ll learn how to create and use custom functions. To create functions and macros, you work with the Visual Basic Editor (VBE), which opens in a new window separate from Excel.
- Add a pie chart - Microsoft SupportPie charts can convert one column or row of spreadsheet data into a pie chart. Each slice of pie (data point) shows the size or percentage of that slice relative to the whole pie. Pie charts work best when: You have only one data series. None of the data values are zero or less than zero.
- Accessibility best practices with Excel spreadsheetsThis topic gives you step-by-step instructions and best practices for making your Excel spreadsheets accessible and unlock your content to everyone, including people with disabilities. You learn, for example, how to work with the Accessibility Checker to tackle accessibility issues while you're creating your spreadsheet.
More
