Mastering Microsoft Excel 2002

DescriptionExcel X is the upgrade to Microsoft's market-dominating spreadsheet program. In addition to new spreadsheet features, this version of Excel contains enhanced Internet capabilities. The book leads the user through Excel fundamentals, then covers intermediate material in depth. Advanced topics such as VBA macros and programming, Web publishing, and Office integration are covered at length. Users will also learn to use and distribute Excel applications on the Web and how to integrate Excel with other Office applications.   • Creating worksheets • Creating simple and complex formulas • Using Excel's logic to handle decisions and worksheet errors • Rearranging and manipulating data with text and date functions • Constructing, editing, and formatting charts • Sorting, filtering, and subtotaling databases • Applying conditional formatting and data validation • Summarizing data with pivot tables and pivot charts • Importing data from the Web, SQL Server, Access, OLAP servers, and other sources • Integrating Excel with Access, Word, PowerPoint, Outlook, and MapPoint 2002 • Collaborating with other users: workbook routing, file sharing, and SharePoint Team Services • Modeling business data with the what-if tools: data tables, Goal Seek, Solver, and scenarios • Using templates and reports to create workbooks for other users • Recording and editing macros • Building applications using Excel 2002 and VBA • Creating simple smart tags Contents Introduction Part 1: Putting Excel 2002 to work for you Part 2: Using Excel's Functions Part 3: Using Charts and Graphics Part 4: Managing Data with Excel 2002 Part 5: Out of the Box with Excel 2002 Part 6: Analysis and Collaboration with Excel 2002 Part 7: Automating Excel 2002 with Macros and VBA Part 8: Appendices Index