Here are 2 well written and informative Microsoft Office user guides, one each for Word and Excel. The Word booklet is aimed for the type of user who is familiar with Word and would like to learn and use some of its more advanced features. It is aimed
particularly at those who compile large documents, books, reports, etc.
The Excel booklet helps you learn some basics, along with charting,
pivot tables, Gantt charts, and using Excel as a database. Two video
viewlet tutorials are also linked to in the Excel section below.
Using Word - 25 page guide in pdf format
|
Fonts,
Text
|
|
| Tables | |
| ShortCut Keys | |
| Section Breaks | |
| Headers & Footers | |
| Equations | |
| Proofreading / Managing revisions | |
| -
Track Changes - Merging revisions - Resolving Proposed Changes - Comments |
|
| Templates | |
| Styles | |
| -
Using Styles - Creating Styles 1. Create by example 2. Automatic style changes 3. Format styles via style dialog box - Changing Styles - Identifying TOC (table of contents) styles |
|
| Master Documents | |
| - Creating a master document and subdocuments | |
| Creating a Contents Page | |
| Creating a Contents page for a Master document | |
| Updating a contents | |
| Creating an Index | |
| Creating Forms | |
| Tips on incorporating images | |
Using Excel - 21 page guide in pdf format
|
The
Excel Screen
|
|
| Functions exclusive to Excel | |
| Worksheet Navigation | |
| Formatting Entries | |
| Using Formulas, Functions (including Statistics Functions) | |
| Copying / Moving | |
| Controlling the worksheet View | |
| -
Windows Arranged - Freezing columns and rows - Splitting the screen |
|
| Printing | |
| Spreadsheet Charts | |
| Preparing a scatter graph | |
| (watch
a viewlet)Error bars (watch a viewlet) Inserting a Trendline |
|
| -
Example: Bradford's - Example: Error bar data |
|
| The Excel Database | |
| -
Database Table Rules - Searching a Database |
|
| Pivot Tables | |
| Creating Gantt charts | |
| - Creating a Dynamic Gantt Chart | |