Excel 2003 Training Materials

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

This course provides everything you need to professionally deliver Microsoft Office Excel 2003 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 2003 Training Course    order now $ 995 course outline  •  download sample

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

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 2003 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 2003 Course Outline

 

Working With Functions And Formulas Using Formulas In Excel Understanding Relative And Absolute Cell References The Basic Mathematical Operators Using Formulas With Multiple Cell References The Formula Auditing Bar Fixing Formula Errors Displaying And Printing Formulas Practice Exercise Exploring Excel Functions What Are Functions? Finding The Right Function Some Useful And Simple Functions Practice Exercise Using Functions In Excel Inserting Functions Using Functions And Autofill To Perform Difficult Calculations Using The If Function Working With Nested Functions Practice Exercise Working With Names And Ranges What Are Range Names? Defining And Using Range Names Selecting Nonadjacent Ranges What Is Auto Calculate? Practice Exercise Working With Array Formulas What Are Array Formulas Using Basic Array Formulas Using Functions With Array Formulas Using The If Function In Array Formulas Practice Exercise Review Questions Managing Lists Working With Lists What Is A List? Creating Lists Modifying Lists What Is The Total Row? Practice Exercise Working With Records And Fields What Are Records And Fields? Adding Fields By Inserting Columns Adding Records By Inserting Rows Adding Records With A Data Form Finding And Deleting Records Practice Exercise Working With Lists And Filters Sorting A List What Is An Autofilter Custom Autofilters Using An Advanced Filter Copying Filtered Records Practice Exercise Using Excel As A Database Filtering With Wild Card Characters Validating Your Data What Are Database Functions? What Are Lookup Functions? Practice Exercise Review Questions Working With Macros And Controls Creating Macros In Excel What Is A Macro? Creating A Macro Playing A Macro Assigning A Shortcut Key To Macro Macros, Buttons, And Toolbars Practice Exercise Excel Form Controls What Is A Form Control? The Form Toolbar Adding A Control To A Worksheet Assigning A Macro To A Control Using Form Controls Practice Exercise Review Questions Using Excel With Other Programs Using Excel In Word Inserting Excel Data In Word Modifying Excel Data After Insertion Linking Excel Data In Word Linking An Excel Chart In Word Practice Exercise Using Excel With Other Programs And Files Using Outlook To Send Excel Data Opening An Excel File In A Different Format Importing Data From A Text File Importing Data From A Database Practice Exercise Review Questions