Free Microsoft Office Training and Tutorial Resources

Blog Roll:
Free Microsoft Office Training & Tutorials
Free Adobe & Macromedia Training & Tutorials
Free Web Development Training & Tutorials
Intelligentedu.com Blogs
- Free Technical Computer Training
- Free Computer Books & Ebooks

Top Links:
Free Training By Email
Free Computer Training from EdComp
Free Computer and I.T. Training

November 23, 2005

101 Microsoft Office Tutorial Lessons

The Computer Information Systems Technology department of Southwest Mississippi Community College offers this course which provides 101 tutorial lessons teaching you some of the important features of Microsoft Word, Excel, Powerpoint, Access, and Outlook. You can also take their online Quizzes for free to see how well you have learned the material covered.

101 Microsoft Office Tutorial Lessons

How to begin Microsoft Word

	Making shortcuts to Microsoft Word
	Setting up the interface
	Saving the document
	Typing the body of the document
	Changing the font size
	Changing the font type
	Inserting Clip Art
	Printing the document

Creating a research paper in Word

	MLA Documentation
	Changing Margins and Line Spacing
	Applying Headers
	Typing the body of the research paper
	Creating a Works Cited Page

Creating a Personal Resume in Word

	Using the Resume Wizard
	Editing the Resume
	Printing the Resume
	Creating a personalized letterhead
	Creating a cover letter with a table

Using Word to create a resume Web page

	Creating a Resume Web Page in Word
	Using Web Page Wizard in Word
	Modifying the Resume Web Page
	Viewing the Web Page in your browser
.

How to begin Microsoft Excel

	Making shortcuts to Microsoft Excel
	Setting up the Worksheet Window
	Saving the workbook
	Entering text into the worksheet
	Using the AutoSum button
	Highlighting Vs. Copying Cells
	Formatting the Worksheet
	Inserting a 3-D Column Chart
	Printing the worksheet

Using formulas, functions, and basic formatting in Excel

	Using formulas
	AVERAGE, MAX, and MIN functions
	Formatting the worksheet
	Printing sections and the formulas version

Creating a what-if analysis in Excel

	Rotating Text and creating a series
	The Format Painter Button
	Absolute Versus Relative Referencing
	The IF Function
	Drawing Toolbar
	3-D Pie Chart

Static vs. Dynamic Web pages

	Creating a Static Excel Workbook as a Web Page
	Creating a Dynamic Excel Chart as a Web Page
.

How to begin Microsoft Access

	Making Shortcuts to Microsoft Access
	Starting Access
	Setting up the Database Window
	Creating and Saving a Table
	Adding Records to a Table
	Printing a Table
	Creating a Form
	Creating a Report with Report Wizard

How to create and use a query in Access

	Creating a Query
	Entering Criteria in a Query
	Using AND and OR in a Query
	Sorting Data in a Query
	Join Tables in a Query
	Using Calculations in a Query

How to use validation rules in Access

	Adding, Changing and Deleting Records
	Creating Validation Rules
	Using Referential Integrity
	Ordering Records

How to create a data access Web page in Access

	Creating a Data Access Page
	Viewing the Data Access Page
.

How to begin Microsoft PowerPoint

	Making Shortcuts to Microsoft PowerPoint
	Setting up the PowerPoint Window
	Saving the presentation
	Using a Design Template
	Creating the Title Slide
	Adding a New Slide
	Previewing the slide show
	Printing the Presentation

Inserting clip art and extras in PowerPoint

	Using the Outline Tab
	Adding Clip Art to a Slide
	Adding a Header and Footer
	Adding Animation Schemes
	Animating Clip Art

How to create PowerPoint Web pages

	Saving a presentation as a Web Page
	Viewing the Web Page in the browser
	Editing the page through the browser
.

How to begin Microsoft Outlook

	Making Shortcuts to Microsoft Outlook
	Customizing the Outlook Window
	Sending an E-mail Message
	The Calendar
	Entering Appointments
	Displaying the Calendar in various modes
	Printing the Calendar
	Creating Contacts