In this one-day instructor-led course you will use Microsoft Office Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas, through group and individual instruction, hands-on practical exercises, visual aids, and comprehensive training manuals and materials.
Upon successful completion of this course, students will be able to apply visual elements and advanced formulas to a worksheet to display data in various formats.
Customising the Toolbar • Customising Toolbars • Displaying Toolbars • Creating Toolbars • Changing a Button’s Appearance • Removing Buttons from the Toolbar • Deleting a Toolbar • Personalised Menus and Toolbar Options
Working with Range Names • Creating and Defining a Range Name • Defining a Range Name • Editing a Range Name • Deleting a Range Name • Moving Quickly to a Named Range • Using Ranges in a Formula • Applying Range Names to Existing Formulae • Using Labels
Outlining • What is an Outline? • Creating an Outline Automatically • Copying Outline Data • Creating an Outline Toolbar • Removing an Outline
Working with Lists • List Management • Creating a New List • Editing Records Using the Data Form • Finding Records • Additional Criteria • Deleting Records Using the Data Form
Sorting and Filtering Data • Sorting • Performing a Secondary Sort • Creating Subtotals • Using the Summary Outline • Removing Subtotals • Applying Autofilter
Working with Functions • What is a Function? • Date and Time Functions • Date Functions • Pmt Function • Using Insert Function • The Vlookup Function
Working with Multiple Worksheets • Moving Around Multiple Worksheets • Renaming Worksheets • Inserting a Worksheet • Deleting a Worksheet • Copying Data between Worksheets • Copying and Moving Worksheets • Copying and Moving Worksheets Using the Mouse
Consolidating Data Across Multiple Worksheets • Grouping Multiple Worksheets • Filling a Group of Worksheets • Editing a Group of Worksheets • Colour Coding Worksheet Tabs
Data Validation • Indicating Data Type and Acceptable Values • Creating a List of Acceptable Values • Using a Formula to Validate Input • Specifying an Input Message • Choosing an Error Alert Style
Inserting Clipart and Diagrams • Inserting Clip Art Pictures • Inserting Diagrams in Excel 2002 and 2003 • The Diagram Toolbar in Excel 2002 and 2003 • Inserting and Deleting Diagram Shapes in Excel 2002 and 2003 • Resizing a Diagram in Excel 2002 and 2003 • Changing the Style of the Diagram in Excel 2002 and 2003
Auditing Tools • Displaying the Formula Auditing Toolbar • Precedents and Dependents • Tracing Cell Dependents • Tracing Cell Precedents • Tracing Cell Errors • Using the Error Checking Options in Excel 2002 and 2003 • Using the Trace Error Smart Tag in Excel 2002 and 2003 • Circular References
The target audience for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
Before attending this course it is recommended participants have completed the Excel 2003 Level 1 course or have equivalent working experience.
