Excel 2002 Training Materials

Part of the Office XP Computer Training Materials Library featuring high quality, fully customizable, print-on-demand training courseware titles for Microsoft Office XP.

This course provides everything you need to professionally deliver Microsoft Office Excel 2002 training including editable training manual, hands-on exercises, exercise files,  detailed instructor guide,  unlimited online learning licensing, classroom-ready PowerPoint slides, and quick reference tutorial sheets.

This course comes with:   Training Manual Hands-on Exercises Exercise Files Instructor Guide PowerPoint Slides Quick Reference Tutorial Online Learning

You also receive:   Unlimited reprinting rights Unlimited number of users Unlimited rights to customize all course contents to suit your needs Questions? Would you like more information on this or any of our training courses? Call us toll free 1-800-730-7115.

All Velsoft computer training courseware titles are completely customizable so you can easily edit each course to better suit your needs or the needs of your clients. Likewise, courses can be personalized to any organization in seconds giving you the ability to brand the material as your own. All courses come in Microsoft Word and PowerPoint formats for quick and easy editing. Print the materials as you need them, as many times as you like.

 

Excel 2002 Training Course    order now $ 995 course outline  •  download sample

Office XP Training Library    order now $ 2495 complete bundle   •  best value     The complete Office XP Computer Training Materials Library includes:   Access XP (2002)   Excel XP (2002)   Outlook XP (2002)   PowerPoint XP (2002)   Project XP (2002)   Publisher XP (2002)   Word XP (2002)

Using our computer training materials is easy and cost effective.
It works like this... each course (whether you purchase the course individually or as part of a library of related titles) comes with printable training manuals, stand alone exercise workbook, exercise files, instructor guide, classroom-ready PowerPoint slides, quick reference tutorials, and convenient lesson plans. Each of the components can be opened into Microsoft Word (or Corel WordPerfect) for editing and you are allowed to make any changes you want to the content to better suit your needs.

Why write Excel 2002 training materials when we've done it for you? We've saved you thousands of hours.  We do the prep work... you do the training.

By offering such flexible training solution, you will enjoy how easy it is to customize the training materials to meet your needs. You are allowed to make any changes to the content - including replacing our name with yours. Want to replace our examples and references to those of your own in order to enhance the training and your students' experience? No problem. Prewritten courseware saves you time any money and helps you better prepare for classroom training with well-researched and proven course materials.

Excel 2002 Course Outline

 

Getting The Most Form Your Data Outlining And Grouping Your Data Using Automatic Outlining Displaying And Collapsing Levels Grouping Data Manually Creating Subtotals Pivot Tables What Is A Pivot Table? Creating A Pivot Table Frame Specifying Data In A Pivot Table Rearranging Pivot Table Data More On Pivot Tables Modifying Pivot Table Calculations Formatting A Pivot Table Refreshing A Pivot Table Charting A Pivot Table Creating A Pivot Table Based On Data From An External Database Exploring Scenarios What Is A Scenario? Creating A Scenario Creating A Scenario Summary Report Saving Multiple Scenarios What If Analysis Using A One And Two Input Data Table Using Goal Seek Using Solver   Excel And The Internet Excel And Hyperlinks Hyperlinks And The Internet Inserting Hyperlinks Modifying Hyperlinks Using The Web Toolbar Browsing Hyperlinks In Excel  Excel Workbooks As Web Pages Interactive And Non-Interactive Web Pages Saving A Workbook As A Web Page Saving A Worksheet As A Web Page Saving A Chart As A Web Page Saving A Range As A Web Page  Getting Data From The Internet Importing From An External Data Source Creating A Web Query Saving A Web Query Refreshing A Web Query Advanced Excel Tasks Creating And Using Shared Workbooks Sharing A Workbook Requesting Reviews Reviewing A Workbook Tracking Changes Merging And Revising A Shared Workbook Visual Basic And Macros Adding Code To Your Macro Adding Comments To VBA Code Declaring Variables Prompting For User Input Iteration Over A Range Using If Then Else Statements Advanced File Management Identifying File Properties Searching For Files Protecting Personal Information Creating Back Up Files Changing Auto-Recovery Settings Excel Security Digital Signatures Macro Security Protecting Your Workbook With A Password Custom And Advanced Features In Excel Customizing Excel By Changing Options Using Custom Auto-Fill Lists What Is Text To Speech? Using Detect And Repair