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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |