Contents: — Microsoft Office Series 1

Ready for something different? This series of lessons lets you play several different roles (in any order you want to follow).

In the Internet Explorer and Outlook Express lesson you start by visiting the web site of Office Pools Pty Ltd, gathering information from the pages and sending an e-mail (to a real address which will send you a reply) requesting information about their pools.

Then you switch to being an employee at Office Pools Pty Ltd and go through the process of creating a spreadsheet to compare the costs of operating a pool. (You can easily adapt this exercise to comparing, say, detailed quotes from two builders to add an extension to your home.) You will turn the data into a graph so it is very easy to see the cost differences (this is also a good way to spot where one builder might have missed things in the quote). You plot a simple work schedule using the spreadsheet (you can use this technique to plan any straight-forward task that is too messy to keep on scraps of paper -- such as selling, buying and moving house).

Then you jump over to the Sales Department at Office Pools where you use Microsoft PowerPoint to create a presentation about installing the pool. (You could do the same thing to give a group of Scouts or Guides an overview of their next trek, or to show how the local park will appear for the next fete.)

Next you will invoke the Magic Happens Here process. You will use a wizard to create a standard letter and convert it to a template for Office Pools staff to use when answering requests for pool information — there is even an address where you can send the letter and one of us will try to reply. (You can use this same wizard to create invitations to a party at your house - the steps you use to draw the company logo are the same ones you can use to create 101 different drawings for the invitation - and you can send everyone the same kind of invitation. Great for fetes and other such occasions.)

And finally, because Office Pools looks like such a great place to work, you will use the Resume wizard to create a very attractive application for a job in their office. (By the way, this type of resume is easy to change and adapt for different types of jobs.)

Microsoft Word — 1

Word Workspace:

Introduction Lesson Project Overview
Starting MS Word Word Screen Views
Workspace - top toolbars Workspace - bottom bars (1)
Workspace - bottom bars (2) Workspace - scroll bars, rulers
Workspace - Tabs on the ruler Workspace - Split Window

Configuring Word:

Configuration - Tools > Options Configuration - View tab (1)
Configuration - View tab (2) Configuration - View tab (3)
Configuration - General tab Configuration - Edit tab
Configuration - Print tab Configuration - Save tab
Configuration - Spell, Track Changes, etc. Configuration - File Locations
Configuration - AutoFormatting Configuration - modifying toolbars
Configuration - helpful Clipit Clipit configuration

Working a Wizard:

Starting to write a letter Wizard - Recipient Info tab
Wizard - Other & Sender tabs Wizard - envelope (1)
Wizard - envelope (2) Think "template"
Customizing the appearance Page Setup
Save as Template Tools > Options > Save
Saving the Normal template  

Text to go!

Write letter - Open and Save Write letter - lists - bulleted
Write letter - lists - numbered Write letter - lists - alphabetical
Write letter - lists - subparagraph Create a table
Format text in a cell Format text in columns
Format table appearance Special text effects
Second page header & footer Line and page breaks

Drawing in Word:

This lesson takes you step by step through drawing the simple picture that was used in the letter, above. It is easy to draw, using only text and boxes. Everyone can follow these steps and adapt them to 101 different pictures!

The Resume Wizard:

This lesson walks you through the Resume Wizard, showing you how the resume is assembled and which resume is the easiest one to modify and maintain. It re-enforces everything you covered in the previous lessons.

Microsoft Excel — 1

Configuring Excel

Introduction Objectives
Starting Excel Configuring the screen
Options - View Options - Calculation
Options - Edit Options - General
Options - Transition Custom Lists, Chart and Color
Workspace - main menu Workspace - Toolbars
Workspace - Formula and Status bars, Headings, Cells
Office Assistant Clipit Options, Screen Tips

Entering and formatting data

IntroductionRename, headings, Series Fill, text entry
Clear Contents, number entry, $ Format, FormulaFormula entry and Copy
AutoSumFormatting (Bold font, Color Fill, Border)
Print Preview 

Creating a basic chart

Creating a good data tableSeries Fill, Fill Down
AutosumAverage
Cell formats ($, shading, text, borders)Using the Chart Wizard - the simplest pathway
Positioning the chartPage setup for printing

Applying Excel to a simple task

IntroductionAdd tasks to schedule
Dynamic seriesDates, Column, Resizing columns
Formatting and Print PreviewEntering and copying simple formulae

Microsoft PowerPoint — 1

PowerPoint Workspace

IntroductionPowerPoint Features
ToolbarsOffice Assistant
Closing PowerPointOpening PowerPoint

Preparing a Presentation

New PP session and AutoContent explainedDesign Template explained
Blank presentation explainedStart Auto Content Wizard
Auto Content WizardNormal and Outline Views
Cancel New Presentation Dialog BoxSlide View
Slide Sorter ViewSlide Show View
Notes PageBasic Formatting and Editing
Formatting continuedMore Formatting
Outline toolbarClosing Statement

Using a Design Template

Open Design TemplateFormatting
Using Master SlideWorking with a Blank Presentation
Apply a Design Template 

Modifying Existing Templates

Open an Existing PresentationModifying the Master Slide
Create Objects using AutoshapesResizing and Coloring Objects

Microsoft Internet Explorer & Outlook Express — 1

Internet Explorer

IntroductionInternet Explorer Screen
Access a website with a known URLNavigating a website - following links
Sending an e-mail from Internet ExplorerSetting the default e-mail application in Internet Explorer
Checking the Internet account setup in Internet Explorer 

Outlook Express

IntroductionStarting Outlook Express
Changing Outlook Express Screen LayoutAdd a Sender to your Address Book
Create a Return E-Mail to a SenderExplanation of Send/Receive
Create an E-mail using the Address BookCreating an E-Mail without the Address Book
Checking if an E-Mail Account exists in OE 


Lasotell Home Page
Copyright 2002 Lasotell Pty Ltd. All rights reserved.
Please e-mail us your comments, criticisms or to report of any problems with this page. Thank you.
This page can be found at www.lasotell.com.au and was updated 2/5/2002.