Spending | search
Click here to view Spending news from 60+ newspapers.
Bookmark or Share- Tutorial: Import Data into Excel, and Create a Data ModelWe start this tutorial with a blank workbook. The goal in this section is to connect to an external data source, and import that data into Excel for further analysis. Let’s start by downloading some data from the Internet. The data describes Olympic Medals, and is a Microsoft Access database.
- Calculate a running balance - Microsoft SupportLet'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 add up as you enter new items and values over time. To calculate a running balance, use the following procedure.
- Use Goal Seek to find the result you want by adjusting an input value ...You can use Goal Seek to determine what interest rate you will need to secure in order to meet your loan goal. Windows macOS. If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For example, suppose that you need to borrow some money.
- View or change the properties for an Office file - Microsoft SupportDocument properties, also known as metadata, are details about a file that describe or identify it. They include details such as title, author name, subject, and keywords that identify the document's topic or contents. If you include the document properties for your files, you can easily organize and identify them later.
- Introduction to What-If Analysis - Microsoft SupportBy using what-if analysis tools in Microsoft Office Excel, you can use several different sets of values in one or more formulas to explore all the various results.
More
