Includes index

Introduction -- PART I: CREATING SPREADSHEETS: Getting familiar with the Excel 2007 interface -- Entering the spreadsheet data -- Formatting the spreadsheet -- Printing the spreadsheet -- Modifying the spreadsheet -- PART II: USING FORMULAS AND FUNCTIONS: Building formulas -- Copying and correcting formulas -- Creating data and time formulas -- Financial formulas and functions -- Using math functions -- Using common statistical functions -- Using lockup functions -- Using logical functions -- Text formulas and functions -- PART III: WORKING WITH GRAPHICS: Charting spreadsheet data -- Adding graphics to spreadsheets -- PART IV: MANAGING AND SECURING DATA: Building and maintaining data lists -- Protecting the spreadsheet -- PART V: DOING DATA ANALYSIS: Performing what-if analysis -- Generating pivot tables -- PART VI: MACROS AND VISUAL BASIC FOR APPLICATIONS: Using macros -- Using the visual basic editor -- PART VII: THE PART OF TENS: Top ten features in Excel 2007 -- Top ten tips for using Excel like a pro -- Appendix: About the CD

Showcases Excel's updated features and new user interface while explaining how to use Excel 2007 to build and format spreadsheets, sort and analyze data, and integrate spreadsheets with Web documents and other Office applications

plus-circle Add Review

comment

Reviews