Free Microsoft Office Training and Tutorials Blog




    



PowerPoint 2003 and PowerPoint XP Tutorials

Here are several PowerPoint 2003 and PowerPoint XP Tutorials  hosted by the University of Utah's Office Handouts and Tutorials site. These PowerPoint tutorials teach and demonstrate with screenshots and step-by-step instructions many basic and advanced PowerPoint features. 


PowerPoint 2003 Tutorials

PowerPoint 2003: Basics Tutorial
 - PowerPoint 2003; Basics slides

Powerpoint 2003: Advanced Techniques Tutorial
 - PowerPoint 2003; Advanced slides

Powerpoint 2003: Icons 

Tips for Creating Effective and Interesting PowerPoint Presentations

Powerpoint 2003: Posters 
 - PowerPoint Posters: Tips & Guidelines - Medical Graphics and Photography
 - PowerPoint Poster Template: 36" by 56" - Medical Graphics and Photography

Create Your Own Powerpoint Jeopardy Game


Powerpoint XP (2002) Tutorials


PowerPoint XP: Basics Tutorial

 - PowerPoint XP; Basics slides

PowerPoint XP: Advanced Techniques Tutorial
 - PowerPoint XP; Advanced slides

PowerPoint XP: Icons

Tips for Creating Effective and Interesting PowerPoint Presentations

PowerPoint XP: Poster Tutorial

 - Medical Graphics and Photography Helps
 - Medical Graphics and Photography Helps
 - Riding the Wave to Powerful Poster Presentations
 - Sample poster: Portable classroom
 - Sample poster: Walking for Fun and Fitness
 - Eccles Library leaf image
 - Joan tossing plastic image
 - Joan tossing plastic image
 - Recycle logo image

Beginning and Advanced Access Tutorials

Here are two Microsoft Access Tutorials and two Access Slide Presentations from The University of Utah. The two Access tutorials provide step-by-step instructions, along with screenshot graphics to demonstrate both beginning and advanced features of Access.


Access Basics Presentation  (11 Powerpoint slides 67kb)

  - Definitions
  - Data Integrity
  - Access vs. MS Excel
  - Examples
  - Access vs. MS Excel

2003 Access Basics Tutorial  (7 pages, pdf format, 594kb)

Contents of Microsoft Access Tutorial: The Basics:
Part 1: Starting MS Access and the Database Wizard
Part 2: Database Structure: Table Relationships, Fields, Primary Key,
Part 3: Viewing Your Data: Obljects, Tables, Queries, Forms, Reports, Assignment


Advanced Access Presentation  (21 Powerpoint slides, 121 kb)

  - Definitions
  - Basic Database Design Principles
  - Main Parts of Database Design
  - Sample Database Scenario
  - Database Mission Statement
  - Mission Statement >>Tables
  - Tables and Fields
  - Fields in the Table
  - Primary Key
  - Foreign Keys
  - What You Don’t Know Can Cause You Problems
  - Access and its Templates Can Help You

Advanced Access Tutorial  (9 pages, pdf format, 379kb)

Contents of Microsoft Access Tutorial: Advanced:
Part 1: Create Database
   A. Primary and Foreign Keys, Table Design
   B. Importing Data
Part 2: Implement Table Relationships
Part 3: Creating Forms and Modifying Queries and Reports
   A. Creating and Modifying Forms
        1. Creating Forms
        2. Modifying Forms
        3. Adding Records Using Forms
  B. Modifying Queries and Reports
       1. Modifying Queries
       2. Modifying Reports
  C. Setting Up Functions with Queries and Reports to Create a Count Query and Report
       1. Create the Function Column in a Query
       2. Run the Function in a Report
Part 4: Test Your Database
Part 5: Conclusion: Assignment - Design, create and modify MS Access forms, queries and reports and check to be sure that

The exercise files for this advanced Access tutorial are available:
  - Calls.xls
  - Contact.xls
  - Employees.xls


2 Excel Tutorials from the University of Utah

The University of Utah offers several Office Handouts and Tutorials that are nicely illustrated with screenshots. Here are their two Excel Tutorials taking you step-by-step through several beginning and advanced features of this spreadsheet application.


Excel Tutorial Part 1: The Basics of Creating a Spreadsheet  
(6 pages, 377kb, pdf format)

Tutorial Contents:
Introduction
  - How to Run Excel
Entering Data
  - How to Enter Information
  - Copying Series Content with AutoFill
  - Form Controls
  - Editing Cell Content
Formatting Worksheets
  - Cell Format
  - Row and Column Format
  - Conditional Format
  - Macros
Formulas and Functions
  - Calculating Data with Formulas
  - Entering Formulas
  - Relative and Absolute Cell References
  - Calculating Data with Functions
Saving and Printing Worksheets
  - Saving
  - Printing


Excel Tutorial Part 2: Displaying, Importing and Analyzing Data
(4 pages, 302kb, pdf format)

Tutorial Contents:
Displaying Data
  - Sort
  - Auto Filter and Advanced Filter
  - Form
  - Subtotal
  - Freeze and Split
Importing and Exporting Data
  - Import Text Files
  - Import From or Export To Other Microsoft Applications (Access)
  - Import HTML File
Charting and Analyzing Data
  - Charts and Graphs
  - Editing a Chart
  - Pivot Table and Pivot Chart


Access Tutorial - Create a Database Application

Here is a Access Tutorial that takes you through the the steps to create a database application using Microsoft Access 2000. It uses easy to following instructions along with screenshots to help you see how the tasks are performed. The tutorial introduces the features of Access and prepares you for learning and doing more with this database application. The database concepts taught here can be applied to any database managment system (DBMS) which you may use to create your application. This tutorial can also be used with Access XP and Access 2003. Click here to download the database created in this exercise (zip format, use 7-zip to uncompress it).

Requirements for this Access Tutorial
:

Imagine you have been called in by the special assistant to a Fortune-500 company CEO. She feels overwhelmed by the volume of correspondence coming in that has to be handled, and wants a way to keep track of it. As letters and email arrive, it is usually assigned to an assistant for handling, who may further assign the matter to a division or department. The special assistant wants an automated method to keep on top of this correspondence, so that none of it gets misplaced, mishandled, or improperly ignored.

Access Tutorial Contents:

   1. Introduction - Table Design and Starting Access
   2. Create the Table
   3. Create a Data-entry Form
   4. Create a Query
   5. Create a Report


66 PowerPoint Tutorials and Techniques

Here are 66 PowerPoint Tutorials and Techniques, hosted by onppt.com. These cover many areas and features of using PowerPoint to its fullest extent. Areas covered by these PowerPoint tutorials include: playing sound and music with your slides, running your presentation in a look, showing your slides on 2 projectors at once, creating attractive animations, keeping your files from getting corrupted, making a summary slide, using colors effectively, replacing fonts, using shapes and autoshapes, finding and using templates, and advice on public speaking.
 

PowerPoint Tricks

A Sound Solution: Playing Music on HTML Presentations

Shows how to play music across slides after they are converted to HTML

Creating Depth within a Slide Presentation
Discover some new tricks to add extra punch to your presentations

Creating & Running an Opening Loop
Learn how to add impact to your presentations by running an open loop.

Using PowerPoint in Dual Monitor/Projector
Discover how to display your presentations on multiple screens in two different views.


PowerPoint Features and Basics

Boom - Blowing things up in PowerPoint

Learn how to blow things up and apart using PowerPoint animations.

Black and White Printing Solution in PowerPoint
Learn how to pick choose which objects on a slide to print or not to print when using black and white or grayscale.

PowerPoint Animations: Starting Things Going
Find out the basics of animation timing in PPT 2002 and 2003 with this tutorial.

Quick PowerPoint Trigger Tips
This tutorial gives you great information on avoiding problems with triggers.

Making and Preserving a Second Master in PowerPoint
Read here for steps to create and keep the all the masters in your presentation.

Find fabulous fonts to dress up your PowerPoint deck
Learn how to set the tone of your presentations by using the right font at the right time.

Ten PowerPoint FAQ Entries You Don't Know You Need to Read
Check out this list for the top10 FAQs that everyone should know about  PowerPoint.

PowerPoint Presentations for Multiple Machines
Discover 7 great tips for building a presentation that will run on more than one machine.

PowerPoint 2003 - the Other Changes
This PowerPoint 2003 article teaches you about Smart Tags, inking, and font handling.

PowerPoint 2003: The Other Changes
Stay up-to-date on research tools and template changes made to PowerPoint 2003.

PowerPoint Custom Show Extras
This tutorial discusses how to customize your presentation by adding extras such as repeating slides, action settings and more.

Trigger Happy Animations in PowerPoint
This tutorial shows you how to use animation triggers with PowerPoint 2002 and 2003.

Great News for PowerPoint Users
Learn how to use the PowerPoint 2003 Viewer and Package for CD.

Preventing and Fixing PowerPoint File Corruption
Find out how to keep your PowerPoint files from getting corrupted and what to do if they do.

Four Quick PowerPoint Hints
How to: 1) Animate your masters, 2) Use outline toolbar, 3) Create a summary slide, and 4) Turn your slide into desktop wallpaper.

One Object - Two Animations: A Quick PowerPoint How-To
Discover how to automate an object more than once within the same slide in PowerPoint 2002 and 2003.

Some Quick PowerPoint Sound Reminders
Here are tips on getting sound to work on your PowerPoint presentations

OLE Links vs. Servers for PowerPoint
Learn the difference between OLE objects and OLE Servers, in relation to PowerPoint

Places to Get PowerPoint Help
Here are 10 places to find more help with your PowerPoint questions.

Creating a Complete PowerPoint Template - Part 1
This is the first part of a two part PowerPoint Template tutorial which takes you through the steps to create a fully enabled template from a blank presentation.

Creating a Complete PowerPoint Template - Part 2
This is the second part of a two part PowerPoint Template tutorial showing you how to create a new template from a blank presentation.

Wide-Screen Presentations in PowerPoint
Learn how to make your PowerPoint slide presentations fit the 16x9 widescreen format.

New Photo Album Feature in PowerPoint 2002 is a Huge Time Saver
Here is a short tip for using the Photo Album, which is one of PowerPoint 2002's great features.

Animating Text in Your PowerPoint Presentation
Add style and flash to your text entrances using animated text in your PowerPoint presentations.

Information Hiding with PowerPoint
Learn how to use PowerPoint's hidden slides feature to create FAQ slides for your presentations.

Need a PowerPoint Loop Show? Here's How!
This tutorial provides some great tips on creating a looping PowerPoint slide show.

Building the Content of Your PowerPoint Presentation
This tutorial helps you get started on creating a PowerPoint Presentation.

Font Fixing: Using Replace Fonts in PowerPoint
This will show you how to use the replace fonts feature in PowerPoint.

Color Scheming in PowerPoint
Learn how to use and coordinate colors in your PowerPoint presentations.

Back to Basics with PowerPoint: Starting From Scratch, Part 1
This is part 1 of 2 on how to the basics of PowerPoint presentations.

Back to Basics with PowerPoint: Starting From Scratch, Part 2
This is part 2 of 2 on how to the basics of PowerPoint presentations.

How to create Multiple PowerPoint Shows from One file
Learn how to create multiple PowerPoint slide shows using one presentation file.

10 Common PowerPoint Problems and Their Solutions
Here are quick answers to 10 common PowerPoint questions.

Shaping Up Your PowerPoint Presentations
Find out how to insert a fairly basic shape into a PowerPoint presentation.

PowerPoint Autoshapes From A to Z
Here are some great tips and techniques to use when working with PowerPoint's Autoshapes.


PowerPoint Issues and Opinions

Linda's Soapbox: People Who Think the World Owes Them Everything
Here are tips on how to ask for computer and PowerPoint help. By following the ideas presented here, you will more likely to get help for free.

PowerPoint 2002 Anti-Alias Problems? Where?
This is an article about anti-aliasing problems that some users are having with PowerPoint 2002 animated text on some backgrounds.

PowerPoint 2002 "Upgrade"
This will inform you on how to get PowerPoint 2002 on your "Small Business Edition" of Office 2002.

An Opinion: Why You Need PowerPoint XP/2002
This articles offers several reasons why you need and should buy PowerPoint XP/2002


PowerPoint Reviews

The Best PowerPoint Shows on the Web
This artilce links to the best free PowerPoint slide show samples.

Website Review: BrainyBetty.com

PowerPoint & Internet Explorer: A Shift In Thought?

Should I get PowerPoint 2002?  

How the Cavemen and Cavewomen Developed PowerPoint
This will give you some history on how PowerPoint was developed.


PowerPoint Templates

Help - I need to find a PowerPoint Template
Here is where to look for finding the best PowerPoint templates.

PowerFinish: Templates and Backgrounds for Every Use
This is a review of an excellent PowerPoint template source: PowerFinish

Awesome - Powerpoint Backgrounds
Here is an updated article that gives you information about TAJ Simmon's free PowerPoint templates.


Missing PowerPoint Features


What you think PowerPoint is Missing
Here are your choices for the Missing PowerPoint Features.

Top Ten Missing PowerPoint Features
This article describes ten features that PowerPoint needs to have for more powerful and ease of use.

A PowerPoint Sound Solution: Playing Music on HTML Presentations
This tutorials will help you get sound to play after converting your slides to an HTML presentation.


Sharing PowerPoint Presentations

7 PowerPoint Tips to Cleanly Creating Presentations to Share
Here are seven tips that explain how to make your PowerPoint presentations easy and ready to share with others.

Sharing PowerPoint Presentations
This PowerPoint tutorials shows you how to create a presentation to share.


Tips on Public Speaking

PowerPoint Presentation Disasters: Conference Style
How to avoid presentation disasters when using PowerPoint for large audiences

How to Merge Presentations From Multiple PowerPoint Versions
This tutorial provides steps on how to not get trapped by mistakes when merging multiple PowerPoint presentations.

How Attention Works for Audiences when doing a PowerPoint Presentation
Here are some great hints for getting and keeping an audience's attention when doing a Powerpoint presentation.

The "Big Show" - On-Site Checklist for your PowerPoint Presentation
This is a checklist of things and items you need to remember to do and get ready for a large PowerPoint presentation.

Writers Block with PowerPoint Presentations
Learn new ways to write content for your PowerPoint presentations.


Page :  1 2