This is a practical guide to getting the most out of the Microsoft (R) Office Excel 2003 spreadsheet application. You will become quickly familiar with all the features of the application: the Excel 2003 environment and how to configure it; workbook and worksheet management; entering and editing data (numbers, dates, calculation formulas, data series); all the tools for formatting data (fonts, colours, borders, AutoFormats, style and templates); creating and working in outlines; using worksheet auditing; improving your worksheets with charts, drawing and multimedia objects and printing your work. Create and filter Excel lists and analyse complex data with pivot tables and pivot charts. Learn how to share Excel data safely, creating multiple-user workbooks and applying worksheet protections and digital signatures. Effectively import and export data with Excel; automate your work with macros and create HTML and XML files from Excel.a Tick the Add- Ins that you wish to activate: adds tools and functions for financial, statistical, and technical analysis. enables developers to publish financial, statistical, and technical analysis tools and functions using Analysis ToolPak syntax.
|Author||:||ENI Publishing, ENI Publishing Ltd. Staff|
|Publisher||:||Editions ENI - 2004-03-01|