Mastering Ms Excel 2002

Business Coverage for Business Users,The latest release of Excel is more about business productivity than ever before-and so is Mastering Microsoft Excel 2002, which has been designed specifically to help you tap into the unparalleled feature set Excel 2002 offers serious business users. Inside, two Excel experts give you not only the how but also the why-clear, concise explanations of the value you and the rest of your team will derive from a wide range of intermediate and advanced techniques. Coverage includes:1)Creating worksheets,2)Creating simple and complex formulas,3)Using Excel's logic to handle decisions and worksheet errors,4)Rearranging and manipulating data with text and date functions,5)Constructing, editing, and formatting charts,6)Sorting, filtering, and subtotaling databases,7)Applying conditional formatting and data validation,8)Summarizing data with pivot tables and pivot charts,9)Importing data from the Web, SQL Server, Access, OLAP servers, and other sources,10)Integrating Excel with Access, Word, PowerPoint, Outlook, and MapPoint 2002,11)Collaborating with other users: workbook routing, file sharing, and SharePoint Team Services,12)Modeling business data with the what-if tools: data tables, Goal Seek, Solver,and scenarios,13)Using templates and reports to create workbooks for other users,14)Recording and editing macros,15)Building applications using Excel 2002 and VBA,16)Creating simple smart tags