Maestro

Charting Your Course (2)

You can see the dialog box for step three has several tabs, but I’ll discuss only the Titles tab. You can add text for the following items: Chart title— A title displayed above the chart Category (X) axis— A label displayed below the horizontal axis Value (Y) axis— A label displayed next to the vertical axis...

Maestro

Charting Your Course

One of the features that has made Excel so popular is its charting ability. You can easily create a wide variety of charts based on data in the worksheet. When the data changes, the chart updates automatically. Excel charts are very sophisticated, but, by using the Chart Wizard, you can create many great-looking charts with a few mouse clicks....

Maestro

Formatting Money and Percentage Values

I mentioned earlier that you can use the Format Cells dialog box to specify the number formatting for cells. Formats for money and percent values are most important for the topics of later chapters, so let’s take a look....

Maestro

Excel and Money

Excel has a number of features designed specifically for working with financial data. These are, of course, particularly relevant to this book. This section reviews these features. Cash Flow Excel uses a cash flow model for dealing with financial data. This is a lot simpler than it sounds, and means simply that money values are treated as positive values if the money is...

Maestro

Excel Functions

Excel provides a library of functions for performing commonly needed calculations. A function can be thought of as a prewritten formula ready for you to drop into your own formula. Each function takes the following form:...