Main Pages

Trainingwarehouse > Courseware > IT Series > Excel > Excel 2003 > Excel 2003 Level 3

Excel 2003 Level 3 Ref: CMEX23E3 This Office 2003 courseware is presented through 2 series, Express and Standard. They both cover the same course content, differing only in the number of exercises at the end of each module and section. Full pricing details are at the bottom of this page. Course Objective The main objective of this courseware is to introduce you to the advanced features of Excel. The purpose of this book is to demonstrate features that can increase productivity in using many of the built-in features to format, analyze, calculate, or protect your worksheets. You will also look at how to set up worksheet data on web pages as well as how to use data from other programs within Excel. Basic Skills Checklist The following list summarizes skills that students should be comfortable with for this courseware. understand what functions are use the Insert Function feature to work with some advanced functions use the Format Painter hide and unhide rows, columns, or worksheets use comments create and use formatting styles draw shapes and AutoShapes move and resize shapes use WordArt add Clip Art to worksheets insert, modify, and delete hyperlinks to other Microsoft Office documents preview a worksheet in web page form publish a worksheet into a web page use the AutoFill tool find and replace data and cell formatting use the Go To Special tool use the Paste Special command use the AutoFilter export data for other programs to use use the research tool change Excel options settings create, use, and name lists and ranges of cells create and use databases in Excel create and use worksheet outlining and summarizing use advanced formatting tools on drawing objects and pictures customize charts System Requirements According to the Microsoft Office Users Guide, you must have the following in place prior to using the program: a personal computer with a Pentium III or higher processor a hard disk drive with at least 245 Mb of free space, and a CD-ROM drive a minimum of 64 Mb RAM (add 8 Mb RAM for each additional program you may open in addition to this one) a monitor compatible with Windows and a SVGA graphics display adapter card or higher resolution capable of displaying minimum 256 colors installed Microsoft Windows 2000 Service Pack 3 or higher, or Microsoft Windows XP (recommended) a mouse or other pointing device compatible with Windows Courseware Outline About This Courseware Courseware Conventions Courseware Objectives and Prerequisites A Quick Review of Basics Review Exercise Templates & Validating Data Using Built-In Templates User-Defined Templates Creating a Template Using User-Defined Templates Editing Templates Deleting Templates Alternate Location for Storing Templates Validating Data Using Pick Lists Circling Invalid Data Managing Your Workbooks Auditing a Worksheet Error Checking Tool Manual Checking and Displaying Formulas Correcting Worksheet Errors Tracing Formula Errors Tracing Circular References Using Cell Watch Evaluate Formulas Protecting Your Workbook Using Passwords Worksheet Protection Workbook Protection Protecting Files Using AutoRecover Using Analysis Tools What-If Analysis Using the Goal Seeking Tool Using the Solver Using a Data Table Single Variable Data Tables Two-variable Data Table Multiple Formulas in a Data Table Using Trendlines Creating a Trendline Looking at Trendline Options Using PivotTables Creating a PivotTable Creating a PivotChart Modifying Field Positions Modifying Data Field Options Analysis ToolPak Working with Scenarios Creating Scenarios Using Scenarios Creating Scenario Summaries Collaborating with Others Consolidating Data Looking at Workgroup Functions Creating a Shared Workbook Resolving Shared Workbook Conflicts Tracking Changes Showing History of Changes Removing Shared Use of Workbooks Merging Workbooks Linking Worksheets & Workbooks Creating Linked Workbooks Managing the Links Removing the Links Changing and Displaying Workbook Properties Importing and Exporting Data Save as Web Page Importing Data Importing Text Files Importing from Other Applications Importing Using a Web Query Importing from a Web Page Using XML Exporting Data as XML Spreadsheet Importing an XML Data File Managing Elements and Attributes Changing XML View Options Managing XML Maps Exporting Data Using an XML Maps Using Macros & Custom Forms Customizing Toolbars Adding and Deleting Toolbar Buttons Modifying Toolbar Buttons Creating a Custom Toolbar or Menu Using Macros in Excel Creating and Using a Macro Opening a Workbook Containing a Macro Editing a Macro Adding Macros to Toolbars Using Digital Certificates Creating a Digital Certificate Apply Digital Certificate to Macro Applying a Digital Certificate to a Workbook Removing a Digital Certificate Creating Forms with Controls Adding Controls to a Worksheet Using Spin Buttons or Scroll Bars Using Check Boxes or Option Buttons Using List Boxes or Combo Boxes Changing Excel Options Appendices Projects and Case Studies Productivity Tools Glossary of Terms Answers to Review Questions Index Microsoft Office Excel 2003 Specialist Exam Objectives The Express Series targets classes of 6-8 hours duration. There are hands-on, step-by step exercises that guide students through procedures and commands. These are presented immediately following a topic explanation and provide basic instructions on the most productive method of using a feature. At the end of each module there is an exercise which covers more than feature within a module. At the end of each section there is a hands-on, extended exercise requiring the student to work independently and apply their knowledge of the features learned in the section to accomplish a particular task. Each of these exercises is rated with a difficulty level, based on skill competence. Excel 2003 Express Level 3 Student Manual Price: (4 or fewer items) £9.95 (Excluding VAT at 20%) Price: (5 or more items) £8.96 (Excluding VAT at 20%)		Quantity:

Excel 2003 Express Level 3 - A5 format student manual Ref: C5EX23E3 These books are full student manuals scaled down to A5 format. They could be used as desktop companions or for students to take home after a training course as a reference guide. Price: (7 or fewer items) £7.95 (Excluding VAT at 20%) Price: (8 or more items) £7.16 (Excluding VAT at 20%)		Quantity:

Trainingwarehouse > Courseware > IT Series > Excel > Excel 2003 > Excel 2003 Level 3