Building worksheets. Getting familiar with the Excel interface ; Entering the worksheet data ; Formatting the worksheet ; Printing worksheet reports ; Modifying the worksheet -- Using formulas and functions. Building formulas ; Copying and correcting formulas ; Creating date and time formulas ; Financial formulas and functions ; Using math functions ; Using common statistical functions ; Using lookup functions ; Using logical functions ; Text formulas and functions -- Working with graphics. Charting worksheet data ; Adding graphics to worksheets -- Managing and securing data. Building and maintaining tables ; Protecting workbooks and worksheet data -- Doing data analysis. Performing what-if analysis ; Generating PivotTables -- Macros and visual basic for applications. Using macros ; Using the visual basic editor -- The part of tens. Top ten features in Excel ; Top ten tips for using Excel like a pro --Index.
Summary
This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program.