Zar | search
Click here to view Zar news from 60+ newspapers.
Bookmark or Share- Get a currency exchange rate - Microsoft SupportWith the Currency data type you can easily get and compare exchange rates from around the world. In this article, you'll learn how to enter currency pairs, convert them into a data type, and extract more information for robust data.
- Use Microsoft Query to retrieve external dataThe external data is retrieved when a user opens the report template. After you create a query in either the Query Wizard or Microsoft Query, you can return the data to an Excel worksheet. The data then becomes an external data range or a PivotTable report that you can format and refresh.
- FV function - Microsoft SupportFV, one of the financial functions, calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment. Use the Excel Formula Coach to find the future value of a series of payments.
- WEBSERVICE function - Microsoft SupportThe WEBSERVICE function returns data from a web service on the Internet or Intranet. Note: The WEBSERVICE function may appear in the Excel for Mac function gallery, but it relies on Windows operating system features, so it will not return results on Mac.
- Format numbers as currency - Microsoft SupportIf you want to display numbers as monetary values, you must format those numbers as currency. To do this, you apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are available on the Home tab, in the Number group.
More
