|
Excel 2003 On Your Side
This is a practical guide to getting the most out of the Microsoft 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.
Overview
Help
Moving around
Display
Selecting
Managing documents
Entering & modifying data
Calculations
Presentation of data
Printing
Charts & objects
Lists of data
Group work
Miscellaneous features
|
