Excel 2003 Interactive Training Pack

This book and CD-ROM together create the ultimate learning experience! The comprehensive CD-ROM follows each section of the book, starting by taking you through the basics of Excel and navigating around cells and workbooks. You then move on to entering and manipulating data and formulas, and finally onto more sophisticated analysis tools such as templates, functions and PivotTables. Your expert tutor talks you through every aspect of the course on the CD-ROM, providing a completely natural pace and feel. He uses case studies, graphics and animations to explain all concepts in full. The CD-ROM is fully interactive - practice as you learn using the hands-on labs, interactive examples and tests throughout the CD-ROM. Your test results, the time spent learning and your progress through the course are all recorded. It is simple and intuitive to use - simple navigation makes the CD-ROM course easy to follow. Return to the course where you left off, or jump to any section you choose. The course follows the syllabus of the Microsoft Office Specialist Excel 2003 Core and Expert exams, with testing throughout to enhance your learning.

Table of Contents:
Microsoft Excel 2003 Basic Skills Module 1: Getting Familiar with Excel Basic Features Title and Menu Bars Standard Toolbar Formatting Toolbar Cells, Rows, Columns and Worksheets The Name Box and Formula Bar Sheet Tabs and Scrollbars Using the Office Assistant. Opening and Creating a Workbook Opening an Existing Excel Workbook Opening a Custom Template Creating a New Workbook Saving a Custom Template Entering and Formatting Text Entering and Editing Text Resizing Rows and Columns Formatting Cell Properties Merging Cells Formatting the Worksheet Creating Hyperlinks Rotating Text and Changing Indents Using AutoFill Defining Styles Using AutoFormatting Applying Number Formats Formatting Cell Borders Applying Cell Shading Managing Cells, Rows, Columns and Worksheets Inserting Cells, Rows, Columns and Worksheets Deleting Cells, Rows, Columns and Worksheets Copying Cells, Rows, Columns and Worksheets Using Drag and Drop Clearing Cell, Row and Column Content Hiding and Un-Hiding Rows and Columns Module 2: Enhancing the Workbook Working with Formulas What is a Formula? What is an Operator? Entering a Formula Using AutoSum Editing Formulas Basic Functions and References What is a Function? Basic Functions Using the Formula Palette with the Function Wizard Using References Using Date Functions Using Financial Functions Using Logical Functions Linking Worksheets and Consolidating Data Using 3-D References Creating Charts What is a Chart? Types of Charts Parts of a Chart Creating a Chart Using the Chart Wizard Changing the Chart Type. Formatting the Chart Changing the Chart Data Adding Clip Art Inserting Clip Art Resizing Clip Art Moving and Deleting Clip Art Inserting and Formatting Objects The Drawing Toolbar Drawing Shapes Drawing AutoShapes Formatting Shapes Adding Text to AutoShapes Resizing Objects Creating Text Boxes Editing Text Moving Objects and Text Boxes Saving a Workbook Saving a Workbook Saving a Workbook as a Web page Sending a Workbook via E-mail Setting up a Workbook Previewing a Workbook Inserting, Removing and Viewing Page Breaks Changing Page Orientation and Scaling Setting Page Margins Headers and Footers Printing the Workbook Setting Print Titles and Options Printing Only a Section of the Worksheet Printing the Workbook Microsoft Excel 2003 Expert Skills Module 3: Customising Excel Working with Toolbars Hiding and Displaying Toolbars Customising a Toolbar Moving a Toolbar Using Templates Opening and Applying a Template Editing and Saving a Template Creating a Template Working with Named Ranges Adding a Named Range Using a Named Range in a Formula Using Lookup Functions Importing and Exporting Data Importing Data from Text Files Importing Data from Microsoft Word using Drag and Drop. Importing a Table from an HTML File Round Tripping Exporting Data to Other Applications Formatting Numbers Applying Number Formats Creating Custom Number Formats Using Conditional Formatting Collaborating with Workgroups Working with Comments Applying and Removing Worksheet and Workbook Protection Setting, Changing and Removing File Passwords Changing Workbook Properties Tracking Changes Creating a Shared Workbook Merging Workbooks Module 4: Advanced Excel Features Auditing a Worksheet The Formula Auditing Toolbar Identifying Error Codes Tracing Errors Tracing Precedents and Dependents Displaying and Formatting Data Performing Single and Multilayer Sorts Using Subtotaling Using Data Forms Using Grouping and Outlines Applying Data Filter