
Manage business finances - Microsoft Support
It's key to keep track of the finances for your business. In Microsoft Excel, you can use one of the many templates to get started or build a workbook to track it all yourself. What will I learn? …
Format numbers as currency in Excel - Microsoft Support
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.
Financial functions (reference) - Microsoft Support
List Financial functions, such as the DURATION, RATE, and PMT functions.
Format numbers as currency in Excel for the web
To show numbers as currency, you can apply either the Currency format or the Accounting format. (You'll find a comparison of the two formats in the Currency or Accounting section, …
Manage your household budget in Excel - Microsoft Support
This Excel template can help you track your monthly budget by income and expenses. Input your costs and income, and any difference is calculated automatically so you can avoid shortfalls or …
Using Access or Excel to manage your data - Microsoft Support
Common scenarios for using Excel Accounting You can use the powerful calculation features of Excel in many financial accounting statements — for example, a cash flow statement, income …
TEXT function - Microsoft Support
Following are examples of standard number (thousands separator and decimals only), currency and accounting formats. Currency format allows you to insert the currency symbol of your …
Calculate a running balance - Microsoft Support
Let's say you may want to see a running balance of items that you purchase so that you don't exceed your spending limits. You can use a running balance to watch values of items in cells …
Excel functions (by category) - Microsoft Support
Lists all Excel functions by their category, such as Logical functions or Text functions.
Create estimates and invoices - Microsoft Support
You can create professional looking invoices with a template that you can customize for your business. Fill it out in Word or Excel and send it electronically as a PDF or print it. Find Word …
DOLLAR function - Microsoft Support
Generally, you should use the Format Cells dialog (Ctrl+1) or Home > Number > Accounting Number Format option to apply a currency formatting to a cell. This is because the DOLLAR …