JaxWorks
Small Business Spreadsheet Factory
Since 1996

 

     
 

Free Microsoft Office Training




JaxWorks is a Microsoft Partner


Sign up for occasional notifications of new free templates and special promotional offerings. We ask for only your name and email address.

 

                                                                  PLEASE NOTE
Contrary to popular belief, most of the business world is not using the current versions of Microsoft Excel.

Since all versions of Excel have over 90% of the same procedures, there is still a vast need for fundamental training in earlier versions.

In an effort to offer a level playing field for all MS Excel newcomers worldwide, we provide FREE training modules for versions XP through 2000.

After mastering these modules, the user should then embark on more ambitious training at this Microsoft Training Link.

Instructors: Feel free to update the courses below for your classroom use. We ask only that the copyright notice remain with the unaltered material.

You will need Adobe Acrobat Reader Version 9 or better for the modules. To download Adobe PDF Reader 9.0+ Click Here
  

 


Index

Word XP Level 1   Excel 2000 Level 5
Word XP Level 2   Upgrading From Excel 2000 to Excel XP
Word XP Level 3   Upgrading From Excel 97 to Excel XP
Word XP Level 4   Access XP Level 1
Word XP Level 5   Access XP Level 2
Excel XP Level 1 Access XP Level 3
Excel XP Level 2 Access XP Level 4
Excel XP Level 3 PowerPoint XP Level 1
Excel XP Level 4 PowerPoint XP Level 2
Excel XP Level 5 Windows XP Fundamentals
Excel 2000 Level 1 Introduction to PCs Using Windows XP
Excel 2000 Level 2 Project XP Level 1
Excel 2000 Level 3 Project XP Level 2
Excel 2000 Level 4  

(Sorry, There is No Support For Free Downloads)

   

Word XP Courseware
Levels 1 Through 5

 

  Microsoft Word XP Level 1

Learn the basics of word processing skills using Word XP. You will learn basic document skills; text editing; document views; character, paragraph and document formatting; and printing. Experience with Microsoft Windows is required.

Download or View Index


 

 

  Microsoft Word XP Level 2

Advance your knowledge of Word by learning about styles, tabs, numbers and bullets, section breaks, dates and symbols, auto format, auto correct, auto text, find and replace, and file management. Experience with Word XP Level I topics is required.

Download or View Index


 

 

  Microsoft Word XP Level 3

Take the next step, learn how to insert borders and shading; draw objects; and use newspaper columns, templates and wizards. Using outline view, Microsoft graph and macros become a snap. Experience with Word XP Level II topics is required.

Download or View Index


 

 

  Microsoft Word XP Level 4

Learn to create a form letter, merge it with a name/address listing, and generate mailing labels for group mail-outs. Topics include using Mail Merge, modifying the data source and main document, selecting and sorting records, and using an external data.

Download or View Index


 

 

  Microsoft Word XP Level 5

Term papers, research documents, legal briefs, books, and intricate contracts require specialized organization and referencing. Topics for reference documents include creating a master document, table of contents, index, bookmarks, table of authorities and footnotes and endnotes.

Also learn to manage shared documents by tracking revisions, creating multiple versions, highlighting text and using comments

Download or View Index


 

Access XP Courseware
Levels 1 Through 4

 

  Microsoft Access XP Level 1

Learn the basics of setting up and using database tables in Access XP. Create, edit and work with tables, set field properties and find data. Develop skills to use the query functions in Access. Experience with Windows 98/2000/XP/ME is necessary.

194  8 x 11 pages printed. Hundreds of graphic illustrations. 75 student practice files included.

Download or View Index


 

 

  Microsoft Access XP Level 2

Build your basic Access XP capabilities by learning how to create basic forms and reports and use advanced query techniques. Access XP Level I or experience working with Access tables and queries are necessary. Prior experience with Access XP is necessary.

144  8 x 11 pages printed. Hundreds of graphic illustrations. 75 student practice files included.

Download or View Index


 

 

  Microsoft Access XP Level 3

Access XP Level III focuses on advanced form and report design using design view. Topics include manipulating controls, using editing tools and creating charts. Access experience using forms, reports and queries is necessary.

161  8 x 11 pages printed. Hundreds of graphic illustrations. 75 student practice files included.

Download or View Index


 

 

  Microsoft Access XP Level 4

Access XP Level IV focuses on advanced features such as using sub forms, switchboards, creating macros and replicating database. Access experience using forms, reports and queries is necessary.

139  8 x 11 pages printed. Hundreds of graphic illustrations. 75 student practice files included.

Download or View Index


 

Excel XP Courseware
Levels 1 Through 5

 

  Microsoft Excel XP Level 1

Learn the following basic workbook skills: ranges, and simple formulas, working with columns and rows, page setup, formatting numbers, text and cells.  Experience with Microsoft windows is required.

250  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

 

  Microsoft Excel XP Level 2

Level II continues your experience with Excel.  You will learn automatic formatting and styles, working with data series, conditional and custom formats, using large worksheets, working with multiple spreadsheets, outlines, using paste special, working with labels in formulas, and using multiple workbooks.  Experience with Excel XP Level 1 topics is required.

175  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

 

  Microsoft Excel XP Level 3

Enhance the look of your worksheets by creating, editing and modifying charts, drawing objects, using additional effects and objects, using auto shapes, working with databases, data forms, auto filter, advanced filters, using HTML files, importing and exporting data.  Experience with Excel XP Level II topics is required.

225  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

 

  Microsoft Excel XP Level 4

This advanced course includes using other functions, using range names, using advanced functions, using data tables, using, recording, and editing macros, custom toolbars, and using worksheet protection. Prior experience with Excel XP is necessary.

176  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

 

  Microsoft Excel XP Level 5

Topics in this advanced course include setting view options, working with templates, working with pivot tables, working with comments, working with views, using Solver, using the Scenario Manager, auditing tools, and consolidation. This course is recommended for certification.

155
  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

Upgrading To Excel XP

 

  Upgrading From Excel 2000 to Excel XP

Topics in this course include using new file features, new worksheet features, new formatting features, new formulas and functions, new graphics features, new pivot table features, and more.

166
  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

 

  Upgrading From Excel 97 to Excel XP

Topics in this course include using new file features, new worksheet features, new formatting features, new formulas and functions, new graphics features, new pivot table features, and more.

206
  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

Excel 2000 Courseware
Levels 1 through 5

 

  Microsoft Excel 2000 Level 1

Learn the following basic workbook skills: ranges, and simple formulas, working with columns and rows, page setup, formatting numbers, text and cells.  Experience with Microsoft windows is required.

203  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

 

  Microsoft Excel 2000 Level 2

Level II continues your experience with Excel.  You will learn automatic formatting and styles, working with data series, conditional and custom formats, using large worksheets, working with multiple spreadsheets, outlines, using paste special, working with labels in formulas, and using multiple workbooks.  Experience with Excel 2000 Level 1 topics is required.

165  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

 

  Microsoft Excel 2000 Level 3

Enhance the look of your worksheets by creating, editing and modifying charts, drawing objects, using additional effects and objects, using auto shapes, working with databases, data forms, auto filter, advanced filters, using HTML files, importing and exporting data.  Experience with Excel 2000 Level II topics is required.

210  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

 

  Microsoft Excel 2000 Level 4

This advanced course includes using other functions, using range names, using advanced functions, using data tables, using, recording, and editing macros, custom toolbars, and using worksheet protection. Prior experience with Excel 2000 is necessary.

168  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

 

  Microsoft Excel 2000 Level 5

Topics in this advanced course include setting view options, working with templates, working with pivot tables, working with comments, working with views, using Solver, using the Scenario Manager, auditing tools, and consolidation. This course is recommended for certification.

168  8 x 11 pages printed. Hundreds of graphic illustrations. 150 student practice files included.

Download or View Index


 

PowerPoint XP Courseware
Levels 1 and 2

 

  Microsoft PowerPoint XP Level 1

Use PowerPoint to create professional electronic on-screen presentations, overhead transparencies, 35mm slides, speaker notes and more. Experience with Windows XP is necessary.

288  8 x 11 pages printed. Hundreds of graphic illustrations. 133 student practice files included.

Download or View Index


 

 

  Microsoft PowerPoint XP Level 2

Add impact to your presentations with PowerPoint XP Level II. You will learn how to use editing tools, customize color schemes, import data and draw objects. Also learn the basics of setting up a slide show, pulling data from other programs, and exporting your presentation slides. Experience working with PowerPoint is necessary.

203  8 x 11 pages printed. Hundreds of graphic illustrations. 133 student practice files included.

Download or View Index


 

Windows XP Fundamentals
Courseware

 

  Microsoft Windows XP Fundamentals

Most computers purchased since the summer of 2001 use the Windows XP operating system.  This Introduction to Windows XP course teaches you how to use menus, windows, programs, files, folders and shortcuts.  How to use Accessories.

239  8 x 11 pages printed. Hundreds of graphic illustrations.

Download or View Index


 

 

  Introduction to PCs Using Windows XP

Most computers purchased since the summer of 2001 use the Windows XP operating system.  This Introduction to Windows XP course teaches you how to use menus, windows, programs, files, folders and shortcuts.  How to use Accessories.

240  8 x 11 pages printed. Hundreds of graphic illustrations.

Download or View Index


 

Project XP Courseware
Levels 1 and 2

 

  Microsoft Project XP Level 1

Topics covered include project basics; working, adjusting and outlining tasks; working with views, resources and calendars; adjusting resources; assigning costs; working with critical path. Experience with Windows 2000/XP is necessary.

257  8 x 11 pages printed. Hundreds of graphic illustrations. 69 student practice files included.

Download or View Index


 

 

  Microsoft Project XP Level 2

Topics covered include customizing project information; filtering/sorting/grouping information; working with baselines; tracking progress; evaluating and distributing data; finalizing a project; working with multiple projects; working with resource pools; importing and exporting data; working with graphics and web pages. Prior experience with Project XP is necessary.

254  8 x 11 pages printed. Hundreds of graphic illustrations. 69 student practice files included.

Download or View Index