Free Microsoft Office Training and Tutorials Blog




    



Tutorials for Microsoft Word, Excel, Access, Powerpoint and more

Here is a virtual treasure trove of great learning and training tutorial materials for many software applications, including all Microsoft Office Word, Excel, Access, and Powerpoint applications. Baseline Access, Training and Support (BATS) is a California State University initiative to provide all students, faculty, and staff with "baseline" training in the uses of  hardware and software systems, and computer resources at San Diego State University. The BATS program offers a wide range of training and support, and thousands of faculty, staff and students have benefited from the training documents linked and described here.

Training is provided on the following software applications:

  • Operating systems (Windows XP)
  • Microsoft Office (Word, Excel, Access, PowerPoint)
  • Photoshop for computer graphics
  • Web page and web form creation
  • Flash for animated GIFs and movies
  • Dreamweaver for web creation and design
  • Web searching for research purposes
  • Acrobat Reader for PDF files
  • iMovie for digital video editing

There are 3 areas of training tutorials available: Student, Faculty, and Staff.


Student Tutorials


Workshop Title
Handouts

Computer Basics

Introduction to Computers Download PDF Handout

Introduction to the Windows XP Operating System

Prerequisite: Basic computer skills including the ability to use a mouse

Download PDF Handout

Microsoft Office

Microsoft Word: Introduction

Basic computer skills including the ability to use a mouse

Download PDF Handout

Microsoft Word: Intermediate

Prerequisite: 'Introduction to Word' or proficient in the basics of Word

Download PDF Handout

Master's Thesis Template Using MS Word

Prerequisite: 'Introduction to Word' and 'Word Intermediate'

Download PDF Handout

Microsoft Excel: Introduction

Basic computer skills including the ability to use a mouse

Download PDF Handout

Microsoft Excel: Intermediate

Prerequisite: 'Introduction to Excel'

Download PDF Handout

Microsoft PowerPoint: Introduction

Basic computer skills including the ability to use a mouse

Download PDF Handout

Microsoft PowerPoint: Intermediate

Prerequisite: 'Introduction to PowerPoint'

Download PDF Handout

Microsoft Drawing Tools

Prerequisite: Basic computer skills including the ability to use a mouse.

Download PDF Handout

Introduction to Microsoft Access I: Overview and Tables

Intermediate level computer skills including the ability to use a mouse

Download PDF Handout

Introduction to Microsoft Access II: Relationships and Queries

Prerequisite: 'Access I' or equivalent knowledge

Download PDF Handout

Introduction to Microsoft Access III: Forms

Prerequisite: 'Access II' or equivalent knowledge

Download PDF Handout

Introduction to Microsoft Access IV: Reports

Prerequisite: 'Access III' or equivalent knowledge

Download PDF Handout

Microsoft Access: Intermediate I

Prerequisite: Completion of 'Access I - IV' or equivalent knowledge

Download PDF Handout

Microsoft Access: Intermediate II

Prerequisite: Completion of 'Access Intermediate I' or equivalent knowledge

Download PDF Handout

Graphics / Page Layout

Adobe PhotoShop CS: Introduction
Note: Mac and PC PhotoShop versions are the same

Prerequisite: Intermediate level computer skills including the ability to use a mouse

Download PDF Handout

Adobe PhotoShop CS: Intermediate*
Note: Mac and PC PhotoShop versions are the same

Prerequisite: 'Photoshop Introduction'

Download PDF Handout

Adobe PhotoShop CS: Advanced*
Note: Mac and PC PhotoShop versions are the same

Prerequisite: 'PhotoShop Intermediate'

Download PDF Handout

Internet

WWW-Searching the Internet

Prerequisite: Basic computer skills including the ability to use a mouse plus experience surfing the web

Download PDF Handout

Creating a Web Page: Introduction

Prerequisite: Experience surfing the Web

Download PDF Handout

Creating a Web Site: Intermediate

Prerequisite: Proficient in the basics of 'Creating a Web Page'

Download PDF Handout

Creating a Simple Web Form: Introduction

This is an online lesson.

HTML File

Creating a Simple Web Form: Intermediate

This is an online lesson.

HTML File

Using Flash to Create Animated GIFs

Prerequisite: Introduction to 'Windows OS', or equivalent knowledge

Download PDF Handout

Flash: Intermediate I & II

Prerequisite: Using Flash to Create Animated GIFS

Download PDF Handout

Dreamweaver MX 2004: Introduction

Intermediate level computer skills including the to use a mouse

Download PDF Handout

Dreamweaver MX 2004: Intermediate I

Prerequisite: 'Introduction to Dreamweaver' or equivalent knowledge

Download PDF Handout

Dreamweaver MX 2004: Intermediate II

Prerequisite: 'Introduction to Dreamweaver' and 'Dreamweaver Intermediate I' or equivalent knowledge

Download PDF Handout

Dreamweaver: Cascading Style Sheets

Prerequisite: 'Introduction to Dreamweaver' and 'Dreamweaver Intermediate I' or equivalent knowledge

Download PDF Handout



Faculty Tutorials


Workshop Title Handouts

Computer Basics

Introduction to Computers Download PDF Handout 

Introduction to the Windows XP Operating System

Prerequisite: Basic computer skills including the ability to use a mouse

Download PDF Handout 

Microsoft Office 2003

Microsoft Word: Introduction

Prerequisite: Basic computer skills including the ability to use a mouse

Download PDF Handout 

Microsoft Word: Intermediate I

Prerequisite: 'Introduction to Word' or proficient in the basics of Word

Download PDF Handout 

Microsoft Word: Intermediate II

Prerequisite: 'Introduction to Word' or proficient in the basics of Word

Download PDF Handout 

Microsoft Word: MailMerge

Prerequisite: 'Introduction to Word' or proficient in the basics of Word

Download PDF Handout

Mailmerge for Word XP

Microsoft Word: Tables

Prerequisite: Introduction to MS-Word, or equivalent knowledge

Download PDF Handout 

Microsoft Word: Templates and Styles

Prerequisite: 'Introduction to Word' or proficient in the basics of Word

Download PDF Handout 

Microsoft Excel: Introduction

Basic computer skills including the ability to use a mouse

Download PDF Handout 

Microsoft Excel: Intermediate I

Prerequisite: 'Introduction to Excel' or proficient in the basics of Excel

Download PDF Handout 
Microsoft Excel: Intermediate II

Prerequisite: 'Introduction to Excel' or proficient in the basics of Excel

Download PDF Handout 

Microsoft Excel: Advanced I

Prerequisite: 'Excel Intermediate I' and 'Excel Intermediate II' or equivalent knowledge

Download PDF Handout 

Microsoft Excel: Advanced II

Prerequisite: 'Excel Intermediate I' and 'Excel Intermediate II' or equivalent knowledge

Download PDF Handout 

Microsoft PowerPoint: Introduction

Basic computer skills including the ability to use a mouse

Download PDF Handout

Microsoft PowerPoint: Intermediate

Prerequisite: 'Introduction to PowerPoint' or proficient in the basics of PowerPoint

Download PDF Handout 

Microsoft PowerPoint: Advanced

Prerequisite: 'MS-PowerPoint Intermediate' or equivalent knowledge

Download PDF Handout 

Introduction to Microsoft Access I: Overview and Tables

Intermediate level computer skills including the ability to use a mouse

Download PDF Handout 

Introduction to Microsoft Access II: Relationships and Queries

Prerequisite: 'Access I' or equivalent knowledge

Download PDF Handout 

Introduction to Microsoft Access III: Forms

Prerequisite: 'Access II' or equivalent knowledge

Download PDF Handout 

Introduction to Microsoft Access IV: Reports

Prerequisite: 'Access III' or equivalent knowledge

Download PDF Handout 

Microsoft Access: Intermediate I

Prerequisite: Completion of 'Access I - IV' or equivalent knowledge

Download PDF Handout 

Microsoft Access: Intermediate II

Prerequisite: Completion of 'Access Intermediate I' or equivalent knowledge

Download PDF Handout 

Graphics / Page Layout

Adobe PhotoShop CS: Introduction
Note: Mac and PC PhotoShop versions are the same

Prerequisite: Intermediate level computer skills including the ability to use a mouse

Download PDF Handout 

Adobe PhotoShop CS: Intermediate
Note: Mac and PC PhotoShop versions are the same

Prerequisite: 'Photoshop Introduction' or equivalent knowledge

Download PDF Handout 

Adobe PhotoShop CS: Advanced
Note: Mac and PC PhotoShop versions are the same

Prerequisite: 'PhotoShop Intermediate' or equivalent knowledge

Download PDF Handout 

Internet

WWW-Searching the Internet

Prerequisite: Basic computer skills including the ability to use a mouse plus experience surfing the web

Download PDF Handout 

Creating a Web Page: Introduction

Prerequisite: Experience surfing the Web

Download PDF Handout 

Creating a Web Site: Intermediate

Prerequisite: Proficient in the basics of 'Creating a Web Page'

Download PDF Handout 

Creating a Simple Web Form: Introduction'

This is an online lesson.

HTML File

Creating a Simple Web Form: Intermediate

This is an online lesson.

HTML File

Using Flash to Create Animated GIFs

Prerequisite: Introduction to 'Windows OS', or equivalent knowledge

Download PDF Handout 

Flash: Intermediate I & II

Prerequisite: Using Flash to Create Animated GIFS

Download PDF Handout 

Dreamweaver MX 2004: Introduction

Intermediate level computer skills including the ability to use a mouse

Download PDF Handout 

Dreamweaver MX 2004: Intermediate I

Prerequisite: 'Introduction to Dreamweaver' or equivalent knowledge

Download PDF Handout 

Dreamweaver: Intermediate II

Prerequisite: 'Introduction to Dreamweaver' and 'Dreamweaver Intermediate I' or equivalent knowledge

Download PDF Handout 

Dreamweaver: Cascading Style Sheets (CSS)

Prerequisite: 'Introduction to Dreamweaver' and 'Dreamweaver Intermediate I'

Download PDF Handout 

Making Your Web Site Accessible

Prerequisite: 'Introduction to Dreamweaver' and 'Dreamweaver Intermediate I' or equivalent knowledge

Download PDF Handout

Other Workshops

Setting up Poster Sessions for Large Format Printing

Note: For both Mac and PC users

Download PDF Handout 

Digital Video Editing with iMovie

Prerequisite: Introduction to Computers of equivalent

Download PDF Handout 



Staff Tutorials


Workshop Title Handouts

Computer Basics

Introduction to Computers Download PDF Handout

Introduction to the Windows XP Operating System

Prerequisite: Basic computer skills including the ability to use a mouse

Download PDF Handout

Microsoft Office 2003

Microsoft Word: Introduction

Basic computer skills including the ability to use a mouse

Download PDF Handout

Microsoft Word: Intermediate I

Prerequisite: 'Introduction to Word' or proficient in the basics of Word

Download PDF Handout

Microsoft Word: Intermediate II

Prerequisite: 'Introduction to Word' or proficient in the basics of Word

Download PDF Handout

Microsoft Word: MailMerge

Prerequisite: 'Introduction to Word' or proficient in the basics of Word

Download PDF Handout

Microsoft Word: Tables

Prerequisite: Introduction to MS-Word, or equivalent knowledge

Download PDF Handout

Microsoft Word: Templates and Styles

Prerequisite: 'Introduction to Word' or proficient in the basics of Word

Download PDF Handout

Microsoft Excel: Introduction

Basic computer skills including the ability to use a mouse

Download PDF Handout

Microsoft Excel: Intermediate I

Prerequisite: 'Introduction to Excel' or proficient in the basics of Excel

Download PDF Handout
Microsoft Excel: Intermediate II

Prerequisite: 'Introduction to Excel' or proficient in the basics of Excel

Download PDF Handout

Microsoft Excel: Advanced I

Prerequisite: 'Excel Intermediate I' and 'Excel Intermediate II' or equivalent knowledge

Download PDF Handout

Microsoft Excel: Advanced II

Prerequisite: 'Excel Intermediate I' and 'Excel Intermediate II' or equivalent knowledge

Download PDF Handout

Microsoft PowerPoint XP: Introduction

Basic computer skills including the ability to use a mouse

Download PDF Handout

Microsoft PowerPoint XP: Intermediate

Prerequisite: 'Introduction to PowerPoint' or proficient in the basics of PowerPoint

Download PDF Handout

Microsoft PowerPoint XP: Advanced

Prerequisite: 'MS-PowerPoint Intermediate' or equivalent knowledge

Download PDF Handout

Introduction to Microsoft Access I: Overview and Tables

Intermediate level computer skills including the ability to use a mouse

Download PDF Handout

Introduction to Microsoft Access II: Relationships and Queries

Prerequisite: 'Access I' or equivalent knowledge

Download PDF Handout

Introduction to Microsoft Access III: Forms

Prerequisite: 'Access II' or equivalent knowledge

Download PDF Handout

Introduction to Microsoft Access IV: Reports

Prerequisite: 'Access III' or equivalent knowledge

Download PDF Handout

Microsoft Access: Intermediate I

Prerequisite: Completion of 'Access I - IV' or equivalent knowledge

Download PDF Handout

Microsoft Access: Intermediate II

Prerequisite: Completion of 'Access Intermediate I' or equivalent knowledge

Download PDF Handout

Graphics / Page Layout

Adobe PhotoShop CS: Introduction
Note: Mac and PC PhotoShop versions are the same

Prerequisite: Intermediate level computer skills including the ability to use a mouse

Download PDF Handout

Adobe PhotoShop CS: Intermediate
Note: Mac and PC PhotoShop versions are the same

Prerequisite: 'Photoshop Introduction' or equivalent knowledge

Download PDF Handout

Adobe PhotoShop CS: Advanced
Note: Mac and PC PhotoShop versions are the same

Prerequisite: 'PhotoShop Intermediate' or equivalent knowledge

Download PDF Handout

Internet

WWW-Searching the Internet

Prerequisite: Basic computer skills including the ability to use a mouse plus experience surfing the web

Download PDF Handout

Creating a Web Page: Introduction

Prerequisite: Experience surfing the Web

Download PDF Handout

Creating a Web Site: Intermediate

Prerequisite: Proficient in the basics of 'Creating a Web Page'

Download PDF Handout

Creating a Simple Web Form: Introduction'

This is an online lesson.

HTML File

Creating a Simple Web Form: Intermediate

This is an online lesson.

HTML File

Using Flash to Create Animated GIFs

Prerequisite: Introduction to 'Windows OS', or equivalent knowledge

Download PDF Handout

Flash: Intermediate I & II

Prerequisite: Using Flash to Create Animated GIFS

Download PDF Handout

Dreamweaver MX 2004: Introduction

Intermediate level computer skills including the ability to use a mouse

Download PDF Handout

Dreamweaver MX 2004: Intermediate I

Prerequisite: 'Introduction to Dreamweaver' or equivalent knowledge

Download PDF Handout

Dreamweaver: Intermediate II

Prerequisite: 'Introduction to Dreamweaver' and 'Dreamweaver Intermediate I' or equivalent knowledge

Download PDF Handout

Dreamweaver: Cascading Style Sheets (CSS)

Prerequisite: 'Introduction to Dreamweaver' and 'Dreamweaver Intermediate I'

Download PDF Handout

Making Your Web Site Accessible

Prerequisite: 'Introduction to Dreamweaver' and 'Dreamweaver Intermediate I' or equivalent knowledge

Download PDF Handout

Other Workshops

Setting up Poster Sessions for Large Format Printing

Note: For both Mac and PC users

Download PDF Handout

Digital Video Editing with iMovie

Prerequisite: Introduction to Computers of equivalent

Download PDF Handout

Comments



 
Name

Email

URL


Remember me?

Comments


Verification code
Verification code