MBA's Guide to Microsoft Excel 2002 by Stephen L. Nelson

By Stephen L. Nelson

Designed in particular as a reference for enterprise execs, this concise consultant to Microsoft Excel 2002 starts off with fast primers that movement new clients to skillability in all Excel different types, together with worksheet fundamentals, operating with databases, and growing charts. It describes intimately these positive aspects of Excel which are vital to company clients: statistical capabilities, monetary services, facts sharing, PivotTables and PivotCharts, Solver, BackSolver, and Small company Finance supervisor. It additionally offers step by step plans for finishing universal Excel company tasks equivalent to construction a revenues forecast, making a marketing strategy, and appearing capital budgeting research. The accompanying CD-ROM offers examples of Excel workbooks created via those initiatives in addition to these mentioned through the e-book.

Show description

Read Online or Download MBA's Guide to Microsoft Excel 2002 PDF

Best software: office software books

Kathy Jacobs On PowerPoint

Discover ways to layout shows to slot any viewers, create stories and graphical essays, use PowerPoint with different Microsoft workplace items, and extra with this timesaving advisor.

Care for the Dying: A Pathway to Excellence

Marie Curie Centre Liverpool, united kingdom. textual content offers instructions for the care of the death in keeping with the Liverpool built-in Care Pathway for the loss of life sufferer (LCP). comprises evidence-based practices and describes the method of care and results. Discusses bedside documentation structures, rules and systems, criteria of perform, and caliber development courses.

CIO Survival Guide: The Roles and Responsibilities of the Chief Information Officer

CIO Survival advisor is a management handbook for the rising position of the executive details Officer. This ebook helps and publications CIOs in buying or improving their technical abilities and management abilities to be a whole and revered member of the administrative staff. It contains exposition and perform of the talents and talents required to be a winning CIO.

Additional info for MBA's Guide to Microsoft Excel 2002

Example text

Use the boxes and buttons for the category you chose to specify the exact formatting. In a budgeting worksheet, for example, you might need to select a different currency symbol from the Symbol drop-down list box. 4. Click OK. Changing Font and Font Size Excel offers a wide variety of choices for changing a selected font’s appearance, such as by adding boldfacing or underlining, for changing a font, and for specifying a different size. To add effects such as boldfacing, italics, and underlining, you can use the Bold, Italic, and Underline font buttons on Excel’s toolbar.

One point is 1/72 of an inch. So a point size of 18 means that the font is ¼ inch tall. Excel’s default point size is 10. You probably don’t want to use fonts smaller than 10 points for legibility. Adding Color to Cells and T ext Text Excel allows you to add color and shading to your data to help you organize, clarify, and emphasize the information on your worksheet—as well as to add interest. To change the color of text, select the range you want to color, click the down arrow beside the Font Color toolbar button, and then select a color for the text.

For example, to add the budgeted amounts on your budgeting worksheet using a formula with cell references, follow these steps: 1. Move the cell selector to C7. You can do this by clicking cell C8. Or you can use the arrow keys. 2. Type =C1+C2+C3+C4+C5. If you make a mistake entering this formula, you can edit it in the same way that you edit any label or value. 3. Press the Enter key, or click the Enter button. Excel enters your formula in the cell, calculates the formula, and then displays the formula result.

Download PDF sample

Rated 4.37 of 5 – based on 32 votes

Related posts