Excel for Macintosh 2016
- Removes offline workbooks from your device the next time you quit and restart Excel. Workbooks on the server are not affected. ...
- Removes personal information that Excel typically displays in comments and on the Summary tab of the Properties dialog box, ...
- Removing connection(s) will separate this workbook from its data source(s), and data refresh operations in the workbook will ...
- Results of formulas may be out of date because Excel is not set to calculate automatically. Click here or press F9 to recalculate ...
- Revampted Tools for Building WorkbooksUse the brand new Formula Builder, Data Connections, and MSQuery to build workbooks ...
- row_num,column_num,abs_num,a1,sheet_text!Creates a cell reference as text, given specified row and column numbers!is the ...
- sample_s,number_sample,population_s,number_pop!This function is available for compatibility with Excel 2008 and earlier.Returns ...
- sample_s,number_sample,population_s,number_pop,cumulative!Returns the hypergeometric distribution!is the number of successes ...
- Save changes in '|'?Note: Though you already saved this workbook as an Add-In, Add-Ins cannot be viewed or edited. This workbook ...
- Saves a preview picture of the new file which is shown when you select the file in the Open dialog box (File menu) or in ...
- Saves copies of values contained in an external document linked to an Excel sheet. If a sheet with links to large ranges ...
- Saves the active workbook data in a format that is compatible with Lotus 1-2-3 version 3.0. Graphics, fonts, and other formatting ...
- Saves the active workbook in a format that is compatible with Lotus 1-2-3 version 2.0. Cell borders, shading, fonts, and ...
- Saves the active workbook in a format that is compatible with Lotus 1-2-3 version 2.0. Cell borders, shading, fonts, and ...
- Saves the active workbook in a format that is compatible with Lotus 1-2-3 version 3.0. Cell borders, shading, fonts, and ...
- Saves the active workbook in a format that is compatible with Lotus 1-2-3 version 4.0. Cell borders, shading, fonts, and ...
- Saves the active worksheet data in a format that is compatible with Lotus 1-2-3 version 1.0. Graphics, shading, fonts, and ...
- Saves the active worksheet data in a format that is compatible with Lotus 1-2-3 version 2.0. Graphics, fonts, and other formatting ...
- Saves the active worksheet in a format that is compatible with dBase version II. Cell borders, shading, fonts, and other ...
- Saves the active worksheet in a format that is compatible with dBase version III. Cell borders, shading, fonts, and other ...
- Saves the active worksheet in a format that is compatible with dBase version IV. Cell borders, shading, fonts, and other ...
- Saves the active worksheet only. Compatible with Excel version 2.2 for Macintosh. Some advanced features, such as list objects ...
- Saves the active worksheet only. Compatible with Excel version 3.0 for Macintosh. Some advanced features, such as list objects ...
- Saves the active worksheet only. Compatible with Excel version 4.0 for Macintosh. Some advanced features, such as list objects ...
- Saves the location, window size, and screen position for all open workbooks. Saving a workspace does not save changes to ...
- Saves the workbook for display on the Web by creating a single file that includes all page elements. Uses the MIME HTML Internet ...
- Saves the workbook for display on the Web. HTML is the default Web format and can be displayed by Macintosh and Windows browsers. ...
- Select the cell containing the text you want to center and the blank cells you want to center the text across. The blank ...
- Select the cells where you want the blank cells inserted. You can choose to have the existing cells moved down or to the ...
- Select the entire outline or a level in the outline that you want to apply styles to. If you select a level that includes ...
- serial_number!Returns the day of the month, a number from 1 to 31.!is a number in the date-time code used by Microsoft Excel! ...
- serial_number!Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).!is a number in the date-time code used ...
- serial_number!Returns the minute, a number from 0 to 59.!is a number in the date-time code used by Microsoft Excel or text ...
- serial_number!Returns the month, a number from 1 (January) to 12 (December).!is a number in the date-time code used by Microsoft ...
- serial_number!Returns the second, a number from 0 to 59.!is a number in the date-time code used by Microsoft Excel or text ...
- serial_number!Returns the year of a date, an integer in the range 1900 - 9999.!is a number in the date-time code used by ...
- serial_number,return_type!Returns a number from 1 to 7 identifying the day of the week of a date.!is a number that represents ...
- serial_number,return_type!Returns the week number in the year!is the date-time code used by Microsoft Excel for date and ...
- Sets options for how your Excel data will look when the data is viewed in a web browser. Affects: only the active workbook. ...
- Sets the Custom Lists available. Click a list that you want to edit, or click NEW LIST in the Custom Lists box to create ...
- Sets the default format for saved files and other compatibility options. This makes it easier to share Excel workbooks with ...
- Sets the maximum amount of change below which iteration stops for goal seeking or for resolving circular references based ...
- Sets the maximum number of iterations used for goal seeking or for resolving circular references based on the number you ...
- Sets the preferred file type Excel uses when you save workbooks. If your workbooks are used in different versions of Excel, ...
- settlement,maturity,coupon,yld,frequency,basis!Returns the annual duration of a security with periodic interest payments!is ...
- settlement,maturity,coupon,yld,frequency,basis!Returns the Macauley modified duration for a security with an assumed par ...
- settlement,maturity,discount!Returns the bond-equivalent yield for a treasury bill!is the Treasury bill's settlement date, ...
- settlement,maturity,discount!Returns the price per $100 face value for a treasury bill!is the Treasury bill's settlement ...
- settlement,maturity,discount,redemption,basis!Returns the price per $100 face value of a discounted security!is the security's ...
- settlement,maturity,frequency,basis!Returns the next coupon date after the settlement date!is the security's settlement date, ...
- settlement,maturity,frequency,basis!Returns the number of coupons payable between the settlement date and maturity date!is ...
- settlement,maturity,frequency,basis!Returns the number of days from the beginning of the coupon period to the settlement ...
- settlement,maturity,frequency,basis!Returns the number of days from the settlement date to the next coupon date!is the security's ...
- settlement,maturity,frequency,basis!Returns the number of days in the coupon period that contains the settlement date!is ...
- settlement,maturity,frequency,basis!Returns the previous coupon date before the settlement date!is the security's settlement ...
- settlement,maturity,investment,discount,basis!Returns the amount received at maturity for a fully invested security!is the ...
- settlement,maturity,investment,redemption,basis!Returns the interest rate for a fully invested security!is the security's ...
- settlement,maturity,issue,first_coupon,rate,pr,redemption,frequency,basis!Returns the yield of a security with an odd first ...
- settlement,maturity,issue,first_coupon,rate,yld,redemption,frequency,basis!Returns the price per $100 face value of a security ...
- settlement,maturity,issue,rate,pr,basis!Returns the annual yield of a security that pays interest at maturity!is the security's ...
- settlement,maturity,issue,rate,yld,basis!Returns the price per $100 face value of a security that pays interest at maturity!is ...
- settlement,maturity,last_interest,rate,pr,redemption,frequency,basis!Returns the yield of a security with an odd last period!is ...
- settlement,maturity,last_interest,rate,yld,redemption,frequency,basis!Returns the price per $100 face value of a security ...
- settlement,maturity,pr!Returns the yield for a treasury bill!is the Treasury bill's settlement date, expressed as a serial ...
- settlement,maturity,pr,redemption,basis!Returns the annual yield for a discounted security. For example, a treasury bill!is ...
- settlement,maturity,pr,redemption,basis!Returns the discount rate for a security!is the security's settlement date, expressed ...
- settlement,maturity,rate,pr,redemption,frequency,basis!Returns the yield on a security that pays periodic interest!is the ...
- settlement,maturity,rate,yld,redemption,frequency,basis!Returns the price per $100 face value of a security that pays periodic ...
- Shared workbooks cannot contain tables. You must either turn off sharing or disable the table functionality for this workbook. ...
- Shared Workbooks do not support the format of your data. Remove any Hyperlinks or Merged Cells to complete the operation. ...
- Shared workbooks from Microsoft Excel 95 must be opened read-only.To edit the workbook, click OK, then click Save As on the ...
- Shortcuts for switching windows: CONTROL+TAB to next open workbook window; CONTROL+SHIFT+TAB to previous open workbook window. ...
- Show the menu only after I've typed one or more letters Controls how many letters must be typed before the AutoComplete menu ...
- Show values as" calculations cannot be used with value fields for which values have been changed using PivotTable what-if ...
- Show values as" calculations cannot be used with value fields for which values have been changed using PivotTable what-if ...