Microsoft Office 2007 Package

Access 2007 Training - Course Outline

Lesson 1 - Welcome to Train Signal!

Meet your instructor, Heather Ackmann, as she introduces you to the features of this course as well as the course design.

• Instructor’s Introduction
• Course Introduction
• Exam Objectives

Lesson 2 - Microsoft Access: The Back Story

If you’re reluctant to use Access because you’ve heard that Access is not a very good program, then this is the video for you as I attempt to explain how Access has acquired a "bad reputation" among some IT professionals and explain how learning the basics of the program will save you time in the future.

• Introduction to Relational Databases
• Relational vs. flat-file
• Most Important thing to remember: Access is NOT Excel!
• The General Order for Building Databases
• The Scenario for the course
• Building a database for Picaroon Publishing Unlimited, a small literary press, to keep   track of employees, customers, orders, authors, and more.

Lesson 3 - Welcome to Microsoft Access 2007

This is a video for newbies and experienced users alike as I take students on a tour of the new Access 2007 interface. Just like moving to a new town, taking the time initially to learn where the grocery store or the hospital is will save you valuable time ""driving around"" in the future.

• Getting Acquainted with the Getting Started Screen
• Using Microsoft Access Database Templates
• Creating a New Blank Database in Access
• Opening an Existing Access Database
• Enabling “Certain Content” Using the Message Bar
• The New Interface
• The Microsoft Office Button
• The New 2007 MS Ribbon
• The Quick Access Toolbar
• Dialog Box Launchers
• The Navigation Pane

Lesson 4 - Introduction to Microsoft Access Objects

Designed for complete beginners to building a database, I walk the student through each of the basic MS objects that make-up a database. Becoming familiar with these objects is essential to the overall design process. This video is the ""birds-eye"" view of everything we will be designing and building in Access. So, if you are like me and must know where you are going before you go there, you’re going to appreciate this video.

• Types of Basic ObjectsTables
• Queries
• Forms
• Reports
• Getting Familiar with Basic Views in Access
• Datasheet View
• Design View
• Form View/Report View
• Pivot Table View
• Pivot Chart View
• SQL View
• Layout View
• Print View
• Relationships View

Lesson 5 - Designing a Database

An essential video for anyone new to constructing databases, I walk students through the whole design process from conducting a ""Needs Analysis"" and gathering data to building a table structure and deciding how far you will need to normalize your data.

• How NOT to Design a Database
• How to Design a Database
• Normalization (Basic Overview)
• Our Scenario
• Our Plan

Lesson 6 - Building Tables

This is an essential video for anyone who hasn’t yet built a table. Using the plan we created in the ""Designing a Database"" video, I walk students through table basics and demonstrate all the different ways you can create a table in Access 2007.

• Scenario: Build Tables to store company data for Picaroon Publishing Unlimited
• Building a Table from Datasheet View
• An Brief Introduction to Naming Conventions
• Overview of different Data Types
• How to Add Records
• How to Navigate in a Datasheet using both the mouse and Keyboard Shortcuts
• How to Build a Table in Design View
• Overview of different Data Types
• How to add Descriptions
• Using Advanced Properties
• How to Navigate in Table Design View (using both the mouse and Keyboard Shortcuts)
• Using the Microsoft Table Templates
• Advantages and Disadvantages Templates

Lesson 7 - Modifying Tables

There are a lot more to tables than just building them. Here I show students the more advanced features of constructing tables and controlling data entry.

• How to Control Data Entry
• Creating Input Masks
• Using Validation to restrict data entry
• Creating Lookup Fields
• Using the Access Find and Replace Dialog Box
• Sorting Data in Access
• Filtering Data in Access

Lesson 8 - Building and Modifying Tables: Extra Practice

If you are like the vast majority of the population and need to be shown how to do something more than once, then this is the video for you. Since tables can be a confusing topic for beginners, I walk students through the creation of ALL the tables we will be using throughout this course. No magic here, just building from the ground up.

Lesson 9 - Creating Relationships

Once tables are built, they are going to need a way to ""talk"" to each other. Here, students will learn about the various types of relationships as well as the various ways of connecting data inside Access.

• Creating a One-To-One Relationship
• Creating a One-To-Many Relationship
• Enforcing Referential Integrity
• Turning on the Cascade Update Feature
• Turning on the Cascade Delete Feature
• Creating a Subdatasheet
• Entering Information
• Viewing information

Lesson 10 - Advanced Relationships

Here I discuss some of the data limitations that can occur when builders rely on only the basic relationship types (one-to-one and the one-to-many). Then we go through how to build two slightly more advanced relationships in Access, the many-to-many and pass-through relationships.

• Building a many-to-many relationship
• Creating Multiple Keys
• Building a Pass-through relationship

Lesson 11 - Query Basics

Once you put data into Access, you’ll occasionally want to visit that data - you’ll need a query for that. Here, I’ll show you the basics of building a select query.

• The purpose of queries
• Types of queries
• Creating a Select Query
• Using the Query Wizard in Design View

Lesson 12 - Finding Specific Data Using Queries

As your database grows, you’ll find it rare to want to see ALL of your data all at once. To limit your query results, you’ll need to use a little something called ""criteria."" Here I’ll show you everything you could possible want to know about criteria and operators.

• Introduction to Criteria
• An Introduction to using Operators
• Mathematical
• Relational/Comparison
• Logical
• String
• Other
• Using Wildcards

Lesson 13 - Creating Flexible Queries

Flexibility is a quality I admire about people and MS Access. With parameter queries, you can design one query that will output or retrieve multiple data results based around user input. With parameter queries, you can save your end-users time and give them the choice of what data they want to see when.

• Benefits of a using flexible query
• Creating a flexible query
• Using Wildcards with a flexible query

Lesson 14 - Creating Calculations Inside Queries

Creating calculations is essential for many aspects of data analysis, manipulation, etc.; however, you can also use built-in functions to override table formatting options, data normalization, and output. Here I introduce students to creating their own custom calculations and show them how to use popular built-in functions.

• Introduction to Calculations
• Creating a Calculated Detail Field
• Calculating a Group of Records
• Introduction to Built-in Functions
• The DateDiff Function
• Format Functions

Lesson 15 - Introduction to Query Joins

Most times users to Access use queries to see data that exists in their database. Sometimes, though, users want to see data that doesn’t exist in their database. You’ll need to know how to change the join type for that.

• Introduction to Query Joins
• Creating an Inner Join
• Creating an Outer Join
• Creating a Self Join

Lesson 16 - Intro to Action Queries

Rather than just having your query show you something, you might want to have your query do something, like build a new table or add records to an already existing table. In this video, I show students how to make queries work for them by demonstrating how to build various action queries.

• Creating an Append Query
• Creating a Delete Query
• Creating a Make-Table Query
• Creating an Update Query

Lesson 17 - Using Special Query Wizards

In addition to building queries yourself, Access provides you with several wizards that are designed to perform very specific tasks. In this video, I’ll show students how to use some special query wizards, such as the crosstab query wizard.

• The Crosstab Query Wizard
• The Find Unmatched Query Wizard
• The Find Duplicates Query Wizard

Lesson 18 - Creating PivotTables and PivotCharts

If you are one of those crazy number crunchers, you’ll need to know how to use a PivotTable and PivotChart. In this video, I’ll introduce you to the basics of creating and modifying these elusive pivoting structures.

• Creating a PivotTable
• Modifying a PivotTable
• Formatting a PivotTable
• Creating a PivotChart
• Modifying a PivotChart
• Formatting a PivotChart

Lesson 19 - Creating Basic Forms

If your database will have multiple hands inside your Access cookie jar, so to speak, you’ll need to find a way to make your database more accessible to end-users. Forms are the way to go! In this video, I show students the basics of creating user-friendly forms.

• An overview of Form Views
• Creating Forms
• Using the wizard
• In design view
• Modifying Forms
• In layout view
• In design view
• Adding Special Tools
• Adding Images to forms
• Creating an Option Group Control
• Creating a Calendar Control
• Creating Command Buttons

Lesson 20 - Designing Macros

Rather than performing a lot of simple actions over and over, why not have Access just perform the series of actions with the click of one button? By learning to write macros, students can find ways to automate a lot of commonly repeated tasks.

• Creating a Macro
• Adding a macro to form control
• Embedded Macros
• Controlling Data through Macro Conditions
• Building a macro to run automatically

Lesson 21 - Creating Basic Reports

You won’t want your data to simply exist on a computer. At some point, you’ll need to print the data in order to hand it over to someone else. In this video, I’ll show you several methods for creating reports that will impress.

• Creating Reports
• Formatting Reports
• Adding Calculated Fields
• Sorting and Grouping Data
• Exploring Printing Options
• Adding a Chart to a Report

Lesson 22 - Creating a Switchboard

When your database is close to being complete, you’ll need to build a switchboard to help end-users locate the reports they use the most. That way, end-users won’t go exploring and break something they shouldn’t be able to see in the first place.

• Creating a Switchboard
• Editing a Switchboard

Access 2007 Training - Bonus Lessons

Lesson 23 - Introduction to When DBs Attack!: Tools for Maintaining Your Access 2007 Database

Lesson 24 - Importing and Exporting Data within MS Office

Lesson 25 - Collecting Data Through E-mail

Lesson 26 - Access Management Tools for Beginners

Excel 2007 Training - Course Outline

Lesson 1 - Introduction to Excel 2007

Meet your instructor, Bill Kulterman, and become familiar with the features of this course and the scenario that will guide you through your learning experience.

Lesson 2 - Welcome to Excel

A thorough explanation of the new interface of Excel 2007, focusing especially on The Ribbon, and navigation.

• The Ribbon
• Navigation, getting around in Excel

Lesson 3 - Entering and Editing Data

Learn tricks to enter data lists quicker and easier.

• How to enter data
• Working With Ranges of Data
• Auto Fill, or Fill Series

Lesson 4 - Calculations

Learn about basic arithmetic operations, and the syntax for writing Excel formulas. Discover many ways to perform the same function and learn about the new file formats of Excel.

• Understanding the Order of Operations
• Using Basic Formulas,
• Understanding Functions
• What is Absolute Reference?
• Save and Save As

Lesson 5 - Multiple Worksheets

Understand the difference between a workbook and a worksheet. Learn to add, move, and copy worksheets in an existing workbook or a new one. Learn to calculate data from several worksheets.

• What is a Worksheet?
• Add a new Worksheet
• Using 3D Reference to calculate across several worksheets
• Working With Worksheets

Lesson 6 - Basic Formatting

Learn about fonts, text size, color, cell options, fill, merge and center, borders, and alignment.

• Format Numbers
• Working with Text
• Cell options

Lesson 7 - Organization

Freeze Panes to make it easier to work with lots of data. Sort data into groups for better organization. Learn to filter out unwanted data.

• Freeze Panes
• Sorting your data
• Filtering out unwanted data
• Format Data as a Table

Lesson 8 - Advanced Formatting

Learn about the new Styles options and Smart Art in Excel 2007, as well as mastering the drawing tools to create shapes and text boxes. All of this is meant to help give a nice finished appearance to your Excel workbooks.

• Using Excel Table Styles
• Adding Shapes to your Excel workbooks
• Graphics in Excel
• Using the new Smart Art tools

Lesson 9 - Advanced Formulas

Get exposed to some of the most commonly used functions and formulas in Excel. Gain a basic understanding of the types of things you can do with Excel by exposing the user to the different functions available.

• Naming Ranges of data
• Lookup and Reference functions
• Logical Test functions
• Financial functions
• Using Database Functions
• Text functions

Lesson 10 - Auditing

Help people find errors in their worksheets, make sure the right type of data is being used, and keep an eye on changes as they happen.

• Identifying Errors
• Using Validation
• Watch Your Data

Lesson 11 - Charts

Learn to present data visually in easily understood charts and graphs.

• What Is a Chart?
• Create Charts with Excel
• Format Charts with Excel

Lesson 12 - Multiple Workbooks

Expose people to the concept of linking multiple workbooks together with formulas and summarizing information from a group of workbooks.

• Linking Workbooks
• Consolidation workbook data

Lesson 13 - Templates

Streamline the process of creating the same worksheet repeatedly.

• What is a template?
• Creating our own templates

Lesson 14 - PivotTables

The goal here is to simply learn the best way to analyze large amounts of data in Excel.

• What are Pivot Tables?
• Creating a Pivot Table
• What else can I do with Pivot Tables?
• Formatting a Pivot Table
• Create a Pivot Chart

Lesson 15 - Collaboration

Learn ways to track several people on the same worksheet and merge them together into a finished document; again, another time saver.

• Protect and share a workbook
• Tracking Changes in Excel
• Merging Documents
• Insert Comments and Hyperlinks in Excel

Lesson 16 - Macros

Record a series of commands performed frequently to speed up the process, or make it easier for less skilled users to perform complex actions.

• Using Macros
• Creating Macros in Excel 2007
• Create a Macro Button
• Take a look at the Macro Editor, VBA
• Saving a workbook with a Macro

Lesson 17 - Printing

Control the way your documents print.

• Viewing your documents
• Page layout options
• Insert Headers and footers
• Prepare your document to print

Visio 2007 Training - Course Outline

Lesson 1 - Introduction

Meet your instructor, Bill Kulterman, and become familiar with the features of this course and the scenario that will guide you through your learning experience.

• About Your Instructor
• Who Should Take this Course?
• What do I Need to Know before I Start?
• Course Outline
• The Scenario
• Visio Rocks!

Lesson 2 - Welcome to Visio

This introduction will give you a thorough understanding of the interface and how to use the essential features of Visio.

• Introduction
• What is Visio?
• Explore the Visio Interface
• The Getting Started Window
• A Look at Some Visio Drawings
• Navigating Around Visio

Lesson 3 - Create New Drawings

Learn the basics of creating a drawing using Visio shapes, templates, and themes.

• Working with Stencils and Shapes
• Visio Themes

Lesson 4 - Working with Shapes

Discover more about shapes, their properties, and how to work with them.

• Size and Position a Shape
• Select and Group Multiple Shapes
• Copying Shapes
• Using Add-ons
• Align and Distribute Multiple Shapes
• Formatting Shapes

Lesson 5 - Working with Text

This lesson will teach you how to use the Visio text tools, create text boxes, add text to shapes and format text.

• The Text Tools in Visio
• Control Your Text on the Page
• Changing the Look of the Text

Lesson 6 - Creating Flowcharts

This video will give you a better understanding of flowchart theory and how to create more effective flowcharts depending on how you want to illustrate the process.

• Flowchart Theory
• Process Mapping
• Flowchart Symbols Explained
• Types of Connections
• Connecting Shapes in Visio
• Flow Chart Exercises

Lesson 7 - More Formatting with Visio

Add style, color, and panache to your Visio drawings. Remember, it is a visual tool after all.

• Borders and Titles
• Backgrounds
• Themes
• Put it All Together

Lesson 8 - Create an Organization Chart

Learn the ins and outs of using Visio to create an organizational flowchart, and get a taste of the data linking functions of Visio with the Org. Chart Wizard.

• The Basic Organization Chart
• Org. Chart Layouts
• Using the Org. Chart Wizard
• The Shape Data Window
• More Options from the Org. Chart Menu and Adding Hyperlinks

Lesson 9 - Directional Maps

Not good at giving directions? Use Visio to create a simple directional map.

• Examining Road and Map Shapes
• 3-D Maps

Lesson 10 - Creating Shapes

Learn to create your own custom shapes using Visio's drawing tools.

• Shape Masters
• 1-D and 2-D Shapes
• Basic Drawing Tools
• Drawing Complex Shapes
• More Drawing Tools

Lesson 11 - Creating Master Shapes

Assign behaviors to a shape, and add connection points. Learn to protect shapes, create and modify Shape Masters and convert an image into a Shape Master.

• Create Master Shapes and Modify Stencils
• Modify a Master Shape
• Controlling Shape Behaviors
• Protecting Your Master Shapes
• Creating Masters From Images
• Adding Connection Points

Lesson 12 - Charts and Graphs

Think Excel is the only way to make charts and graphs? Exercise more control over your charts and graphs with Visio and discover how to create exciting marketing templates.

• Building a Bar Chart
• 3-D Bar Graphs
• Pie Charts
• Line Graphs
• Marketing Diagrams and Shapes

Lesson 13 - Connecting to a Data Source

Introducing the new Pivot Diagrams in Visio, a visually exciting way of presenting data. Customize data in your diagrams using Data Graphics.

• Linking Data to Our Org. Chart
• Pivot Diagrams
• Using Visio to Create a Pivot Diagram
• Updating the Data in a Pivot Diagram
• Adding Data Graphics

Lesson 14 - Building Floor Plans

In this lesson you'll create a floor plan, find out about adding scale to your drawings, and how to adjust print settings. You'll also discover the use of layers in Visio.

• Defining the Space
• Divide the Space
• Let’s Grow a Cube Farm
• Working with Layers

Lesson 15 - Reviewing and Tracking Markup in Your Drawing

Send a Visio drawing for others to review, learn to markup a drawing, as well as track and apply changes. We will also download, install, and use the Save as PDF or XPS add-in from Microsoft.

• The Reviewing and Ink Toolbars
• Reviewing and Tracking Markup

Lesson 16 - Creating Network Diagrams

We'll explore the Network diagramming tools Visio has to offer and add hyperlinks to a drawing.

• Active Directory Logical Network Diagrams
• Physical Network Diagrams
• Rack Diagrams
• Adding Hyperlinks to a Visio Drawing

Visio 2007 Training - Bonus Lessons

Lesson 1 - Space Planning with Visio, Part 1

• Create Master Shapes from a Database
• Space Planning
• Designating Space
• The Import Data Add-On

Lesson 2 - Space Planning with Visio, Part 2

• Adding Resources and Categories to a Shape
• Importing Updated Data
• Color Code the Drawing
• Run and Modify Reports

Lesson 3 - Planning and Mapping Websites

• Web Site Mapping
• The List Window
• The Filter Window
• Site Map Settings and Layout
• Sub Pages
• Page Centric View
• Run Reports
• Conceptual Web Site Planning

Lesson 4 - Bill's Guide to Visio Help, and Other Online Resources

• Bill’s Guide to Visio Help, and Other Online Resources
• Templates, Shapes, and More

PowerPoint 2007 Training - Course Outline

Lesson 1 - Course Introduction

This Video will acquaint you with the instructor, explain the overall design and segments of the course, and introduce basic computer/instructional terms.

• About the Instructor
• Course Design
• Course Topics
• Basic Terms and Commands
• Topics Recap

Lesson 2 - An Introduction to Rhetoric

Knowing how to build slides in PowerPoint will not necessarily give you all the tools necessary for building an effective presentation. The most effective presentation is one that is “rhetorically focused.” With that in mind, this Video introduces some basic rhetorical strategies that can be useful when constructing your overall presentation or speech, let alone individual PowerPoint slides.

• PowerPoint Lesson Number 1: PowerPoint is Not a Crutch
• Definition of Rhetoric
• A History and Evolution of Rhetoric
• Ethos
• Logos
• Pathos
• PowerPoint Lesson Number 2: The Audience Comes First
• PowerPoint and Rhetoric
• Conclusion
• Topics Recap
• Vocabulary You Should Know
• References

Lesson 3 - An Introduction to Design

If your goal is to create a visually stunning and captivating PowerPoint presentation, knowing how to use every feature in PowerPoint alone is not going to get you there; you have to know a little bit about design. In this Video, we’ll cover the differences between ‘fashion’ and ‘design’, (two terms that are often confused), the inherent linear structure of the oral presentation, and basic design fundamentals as outlined in Alex White’s book, The Elements of Graphic Design and relate those graphic design principles to building effective PowerPoint visuals.

• Fashion vs. Design
• PowerPoint Presentation Design
• PowerPoint Slide Design
• 7 Basic Graphic Design Principles and PowerPoint
• Conclusion
• Topics Recap
• References

Lesson 4 - Types of Learners

The goal of most presentations is either to inform or to convince someone of something. In either case, whether informing or convincing, knowing how an individual learns or processes information is a key fundamental in creating an effective presentation. In this Video, we’ll cover the various ways an individual might process information and how to incorporate various learning strategies into the design of a PowerPoint presentation.

• Kinds of Learning Styles
• Presenting to Different Kinds of Learners Using PowerPoint
• Mix and Match Methods
• Topics Recap
• Vocabulary You Should Know

Lesson 5 - Understanding Various Kinds of Presentations

People use PowerPoint for a variety of purposes and situations. With that in mind, creating an effective presentation also means understanding the role that the immediate environment plays on any given presentation. In this Video, we outline the various kinds of presentations you can create with PowerPoint 2007 and discuss how the environment of the presentation will affect the look and structure of your PowerPoint slides as well as the overall design of your presentation.

• Speaker-Led Presentations
• Interactive Presentations
• Self-Running Presentations
• Other Uses for PowerPoint
• Topics Recap

Lesson 6 - Navigating PowerPoint 2007

Designed for both new and seasoned users of PowerPoint, this Video will guide users through some of the new PowerPoint 2007 features, as well as offer a guided tour of the New PowerPoint 2007 interface. In other words, we show you where everything is, and what everything does.

• What’s New in PowerPoint 2007
• The New PowerPoint 2007 Interface
• The 2007 Ribbon
• Quick Access Toolbar
• The New Presentation Window
• The Office Button
• Setting PowerPoint Options
• Using Various PowerPoint Views

Lesson 7 - Starting from a Template vs. Starting from Scratch

PowerPoint 2007 comes loaded with predesigned templates and themes. In this Video, we’ll discuss the benefits of using prebuilt templates and how to customize and save PowerPoint templates.

• Pros and Cons
• Building a Presentation from a Predesigned Template
• The Difference Between a Template and a Theme
• Predisigned Templates and Themes
• Edit, Create, and Rename Masters
• Prebuilt Templates
• Templates on Microsoft Office Online
• Designing Your Own Template
• Saving a Presentation as a Template
• Topics Recap
• Vocabulary You Should Know

Lesson 8 - Introduction to our Scenario

The primary purpose of this Video is to acquaint you with the real-world scenario we will be using throughout the remainder of the course to build our templates and presentations.

• Introduction to Our Scenario
• Our Audience
• Our Goals
• Our Presentation
• Other Things to Consider
• PowerPoint Lesson Number Three: Choosing the Right Time for Your Presentation
• Our Equipment
• Topics Recap

Lesson 9 - Building a Template from Scratch

Building off of the previous two Videos, students will create a custom template for Globomantics, our scenario’s company. You will learn how to customize the Slide Master by formatting backgrounds, PowerPoint AutoShapes, pictures, text boxes, bullet points, slide layouts, and more! Afterwards, we will save the changes as a template that any Globomantics employee can reuse.

• Changing the Background
• Adding graphics
• Customizing Graphics
• Adding and Formatting AutoShapes
• Layering and Ordering Objects
• Customizing Bullet Points
• Master Layout Customization
• Manipulating AutoShapes
• Using WordArt
• Topics Recap

Lesson 10 - Making Our Speaker-Led Presentation, Part One

Following the scenario outlined in Video 8, you will begin creating a presentation designed for the Globomantics Operations department. Starting from a custom template, you will learn an abundance of PowerPoint skills from adding slides, pictures, and AutoShapes, to building the opening slide sequence that will act as our audience attention-getter.

• Test Your Presentation with the Actual Hardware and Environment
• Creating a Presentation from a Custom Template
• Inserting New Slides: 4 Ways
• Other Methods for Inserting Slides
• Adding Content
• Inserting Text into a Placeholder
• Differences between a Text Box and a Placeholder
• Inserting and Editing Pictures
• Creating Graphics with AutoShapes
• Graying Out and Highlighting Parts of the Slide
• Combining a Picture with Words
• Bulleted Lists
• Topics Recap

Lesson 11 - Making Our Speaker-Led Presentation, Part Two

Continuing with our presentation for the Globomantics Operations department, you will work on building slides for the body of our presentation by adding and formatting Charts and SmartArt.

• Types of SmartArt
• 3 Ways for Inserting SmartArt
• Editing SmartArt Text
• Inserting and Deleting Shapes
• Promoting and Demoting Shapes
• Changing the Subordinate Layout
• Applying SmartArt Styles
• Manually Formatting Graphics
• PowerPoint Charts
• Kinds of Charts
• Parts of a Chart
• Different Methods for Adding a Chart
• Changing the Charted Data Range
• Editing a Chart
• Swapping Rows and Columns
• Select Data
• Labels
• Refresh Data
• Changing the Chart Layout, Titles, Legends, Numbers, and More
• Adding a Trend Line
• Topics Recap

Lesson 12 - Making Our Speaker-Led Presentation, Part Three

Continuing with our presentation for the Globomantics Operations department, you will create and format a PowerPoint Table, and learn how to insert other objects (like a pdf) into a PowerPoint presentation.

• Inserting an Object from File
• Object Linking and Embedding (OLE)
• Embedding a File
• Breaking Links
• Changing an Embedded File to an Image to Cut Down on File Size
• Inserting and Formatting a Table
• Table Terminology
• Ways to Insert a Table
• Merging Cells
• Text Alignment
• Resizing Rows and Columns
• Additional Formatting Options
• Topics Recap

Lesson 13 - Preparing Materials for Your Presentation

In this Video, you will learn how to prepare Speaker Notes, Handouts and electronic PDF or XPS files using a variety of PowerPoint’s print and save options.

• Speaker Notes
• Handouts
• Printing Options
• Exporting Materials to MS Word
• Topics Recap
• Vocabulary You Should Know

Lesson 14 - Preparing Yourself for Your Presentation

In this Video, you will learn how to use PowerPoint’s Preparation and Show Tools, such as the Rehearse Timings and Custom Show feature as well as other show settings, presentation keyboard shortcuts, pen tools, and more.

• Slide Transitions
• Rehearsing Timings
• Creating a Custom Show
• Setting Up Your Show
• Keyboard Shortcuts and Tools
• Troubleshooting Technological Problems

Lesson 15 - Introduction to Animations

You will learn the basics of creating custom animations, using a variety of entrance, emphasis, exit, and motion path effects and learn to customize Effect start times, speed, and other Effect options, inlcuding setting triggers.

• Our Scenario
• Animation 101
• Creating Custom Animations
• Modifying Animation Effects
• Topics Recap
• Vocabulary You Should Know

Lesson 16 - Creating Hyperlinks

In this Video, you will learn the basics of user-interactivity by creating a variety of hyperlinks.

• What is a Hyperlink?
• What can be Hyperlinked?
• To what can I Hyperlink?
• Creating PowerPoint Hyperlinks
• Removing Hyperlinks
• Copying in Excel Data without OLE
• Creating Hyperlinks with Action Settings
• Setting the Presentation to Automatically Loop
• Applying Actions on Mouse Over
• Topics Recap
• Vocabulary You Should Know

Lesson 17 - Creating Action Buttons

Continuing with what we built in the hyperlinks Video, you will learn other ways to hyperlink to objects, slides, or even other presentations by using PowerPoint action buttons.

• Types of Action Buttons
• Inserting Action Buttons
• Action Buttons on the Master Slide
• Formatting Buttons
• Custom Action Buttons
• Altering Action Settings
• Topics Recap
• Vocabulary You Should Know

Lesson 18 - Inserting Audio into a Presentation

This Video shows you all the various ways to add sound to a presentation, including sound effects, music, and voice-over narration. You will also learn the differences between embedding versus linking sound files to your presentation.

• Our Scenario
• Introduction to Audio Tools
• Inserting and Playing Music
• Embedding vs. Linking Sound Files
• Recording Your Own Audio
• Topics Recap

Lesson 19 - Inserting Video into a Presentation

Here you will learn about the various Video file types that can be linked to a PowerPoint presentation and learn three different ways to play Video during a PowerPoint show, including linking to a YouTube Video.

• Introduction to Video Formats
• Inserting Video Files
• Creating a Mock Media Player with PowerPoint Objects
• Inserting a Windows Media Player
• Inserting a Shockwave Flash Object
• Topics Recap

Lesson 20 - Planning to Distribute a Presentation

In addition to learning several methods for distributing a presentation, you will also learn about how to prepare your PowerPoint file for distribution, including adjusting the file properties, password protection, embedding fonts, checking for prior version compatibility and more.

• Changing File Properties
• Embedding Fonts
• Checking for Prior Version Compatibility
• MS Office 2007 Compatibility Pack
• Inspect Document
• Mark as Final
• Encrypting a File with Password
• Package for CD
• Save As PowerPoint Show
• Saving the Presentation as a Webpage
• Topics Recap

PowerPoint 2007 Training - Bonus Lessons

Lesson 1 - Expert Animations - Creating a “Flash-Style” Presentation Using PowerPoint

In this Video, we will expand upon skills learned in earlier Videos by exploring more advanced techniques for animating drawn objects and syncing those animations to music, creating a PowerPoint presentation unlike any other.

• Flash vs. PowerPoint
• Creating Advanced Animations
• Building our Flash-Style Presentation
• Using Many Slides to Simulate Animation
• Topics Recap

Lesson 2 - Add-Ins for PowerPoint

Add-ins extend the functionality of PowerPoint 2007 by adding custom commands and features that can increase productivity. In this Video, students will learn how to install three popular (and free) add-ins for PowerPoint 2007: Microsoft’s “Get Started Tab,” PowerPoint MVP Shyam Pillai’s “LiveWeb,” and Microsoft Office Lab’s “pptPlex.”

• About Add-ins
• Free Add-ins
• Installing and Using Add-ins
• The Get Started Tab
• LiveWeb
• Uninstalling Add-ins
• pptPlex
• Save as XPS Add-in
• Create a pptPlex Presentation
• Adding Section Dividers
• Customizing the Background
• Running and Navigating a Show
• Format Section Divider Labels
• Topics Recap

Word 2007 Training - Course Outline

Lesson 1 - Introduction

Lesson 2 - Welcome to Microsoft Word 2007

A thorough explanation of the new interface of Word 2007, focusing especially on The Ribbon.

• The Office Button
• Understanding the Ribbon

Lesson 3 - Create a Document in Word

Learn how to enter and select text and navigate documents. Also, learn about the new file formats and how to save documents in the different formats.

• Navigation in MS Word
• Saving Word 2007 Document in Multiple Formats

Lesson 4 - Editing Documents in Word

Learn about cut, copy, paste, and effective use of the clipboard. Also unlock the secrets of find and replace.

• How to Cut, Copy, and Paste in Word 2007
• Learn How to Use the Clipboard
• Basic Editing
• Making Changes Using Find and Replace

Lesson 5 - Character Formatting

Learn to change font, font size, color, alignment, and get an introduction to quick styles.

• Changing Text Formatting
• Introducing Live Preview and the Mini Toolbar
• Where to Get More Fonts and How to Use Them?
• Aligning Text
• What the Heck are Smart Tags?
• Symbols and Characters
• Styles
• Copy that Formatting Using the Format Painter
• Formatting with Quick Styles

Lesson 6 - Paragraph Options

Understand what a paragraph is in Word. Learn about setting tabs and margins and about paragraph control.

• What is a Paragraph?
• Paragraph Control

Lesson 7 - Creating and Using Tables in Word 2007

Learn to use a table to display data. Master table styles, sort data in a table, and use formulas in a table like Excel. Also, discover the easy way to turn table data into a chart.

• Creating Tables in Word 2007
• Different Table Styles, Designs, and Layouts
• Sorting Data in a Table
• Using Formulas in a Word Table
Creating Charts From a Table Data

Lesson 8 - Working with Graphics in Microsoft Word 2007

Learn how to insert pictures, clip-art, page backgrounds, text boxes and use drawing tools. We also introduce the new SmartArt feature.

• Working with Pictures in Clipart
• Page Backgrounds Create Custom Graphics in Word 2007
• Introducing SmartArt in Word 1007

Lesson 9 - Proofing your Microsoft Word 2007 Documents

Learn all about spell check, the research and translation tools, and the new grammar checker. We also learn to use AutoCorrect to our advantage, and delve further into using styles to provide a consistent look to your documents. We cover using built-in headers and footers, create custom ones, and look at print preview options in Word.

• Auto Correct
• Apply a Consistent Look Using Styles
• Adding Headers and Footers
• Previewing and Printing Your Document

Lesson 10 - Controlling Text Flow in Word

Learn about outlining and document structure, styles, and types of breaks to effectively control page layout.

• Give Your Document Structure by Creating an Outline
• Breaks
• Page Orientation

Lesson 11 - Mailings in Word 2007

Learn everything you ever wanted know about mail merge but were afraid to ask, as well as printing labels, and envelopes.

• How to Use Mail Merge in Word

Lesson 12 - Automating Document Creation in Word

• Quick Parts
• Building Blocks
• Templates

Lesson 13 - Macros in Word 2007

This lesson is a very basic introduction about using and creating macros.

Lesson 14 - Collaborating with Word 2007

Track changes, comments, compare and merge documents. Learn how to efficiently collaborate with others on a document.

• Track Changes
• Combining Documents

Lesson 15 - Forms in Word 2007

Learn about the changes to form creation and Microsoft's push to transition form creation to InfoPath. Also, see which legacy form tools are still supported.

• Content Controls
Legacy Forms

Lesson 16 - Working with Long Documents in Word

This lesson is all about the references tab, bookmarks, endnotes, footnotes, captions, and cross references. We also create a table of contents easily, and learn the hard and the easy way to create an index. We also cover document security in this module.

• The References Tab
• Index
• Table of Contents
Secure a Document

Lesson 17 - Word with Other Microsoft Office Programs

Highlights how well the programs of the Microsoft Office Suite play together.

• Link to an Excel Workbook
• Send a Word Outline to PowerPoint
• Email a Document as an Attachment in an Outlook Message
• Open a Word Document in an Older Version of Word
• Create a Hyperlink to Another Document or Website

Outlook 2007 Training - Course Outline

Lesson 1 - Introduction

Lesson 2 - Hosted Email

• Hosted Solution E-mail Flow
• Registering a Domain Name
• Choosing a Hosting Company
• Hosting Companies
• Creating Email Accounts

Lesson 3.1 - Getting Started with Outlook - Part A

• Terminology
• How My Computer is Set UP
• Installing Outlook 2007
• Managing Outlook 2007 Profiles and E-mail Accounts
• Introduction to Outlook 2007 Interface
• Introduction to Outlook 2007 Features

Lesson 3.2 - Getting Started with Outlook - Part B

• Introduction to Outlook 2007 Features
• Personalizing Outlook 2007
• The View Menu
• Customizing a Calendar
• Customizing Contacts

Lesson 4 - Receiving and Viewing Mail

• Viewing E-mail Messages
• Read and Unread Messages
• Managing Message Attachments
• Configuring Send and Receive Options
• New Message Notification Options
• Managing Items in Mail Folders
• Create, Modify, and Remove Rules to Manage New E-mail Messages
• Bonus Topic: Deciphering E-mail Headers

Lesson 5 - Sending Mail

• Creating and Sending E-mail Messages
• Adding Items to Your Message
• Spell Checking Messages
• Redirecting Replies to a Message
• Creating Voting Buttons in an E-mail
• Selecting Sensitivity and Priority
• Receipts
• Attachments
• Managing Picture Attachments
• Replying to and Forwarding Messages
• Creating Out of Office Replies

Lesson 6 - Managing Calendars

• Viewing the Calendar
• Creating Calendar Items
• Other Ways to View the Calendar
• Editing Reoccurring Items
• Managing Calendar Settings
• Publishing Calendars
• Viewing Other People’s Calendars

Lesson 7 - Meeting Requests

• The Sender’s Side
• The Recipient’s Side
• Meeting Requests in Outlook 2007

Lesson 8 - Tasks

• Creating Tasks
• Creating Recurring Tasks
• Completing Tasks
• Customizing the Task Folder View

Lesson 9 - Contacts

• Managing Contacts and Personal Contact Information
• Editing and Using an Electronic Business Card
• Selecting Default Filing and View Options for All Contacts
• Distribution Lists
• Using Contact Information

Lesson 10 - Organizing Outlook Information

• Organize Mail Folders
• Mailbox Clean-Up Wizard
• The Organize Tool
• Rules
• Archiving folders
• Managing Spam and Junk Mail Folders
• Searching Outlook 2007 Items
• Using RSS in Outlook 2007

Lesson 11 - Outlook and Exchange

• General Functionality
• Using the Global Address List
• Allowing Others to Access Folders
• E-mail
• Calendaring/Scheduling
• Tasks
• Contacts

Lesson 12 - Third Party Add-Ins

• Send Personally Add-In
• Send Messages with the Send Personally Option

Lesson 13 - Introduction to Business Contact Manager 2007

• About Business Contact Manager (BCM)
• BCM Data
• Managing Accounts
• Managing Business Contacts
• Managing Opportunities
• Managing Business Projects
• BCM in Action