User Guides for Word and Excel

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

Popularity: 1% [?]

Related Posts:

Microsoft Word, Excel, and PowerPoint Workshop Tutorials and User Guides

Software Learning Guides for Word, Excel, and PowerPoint

Sofware Help Guides for Word, Excel, and PowerPoint

Microsoft Office Reference Guide

Microsoft Office Articles and Training Tutorials for all Applications

Tags for this post>> Excel | Word