
Microsoft based courses for new and frequent pc users. Our range of 78 Microsoft courses includes numerous related applications from beginner to expert level that even frequent pc users will require at least some training to grasp many of the more advanced features available.
Courses:
To view more information on courses click on the course to expand / collapse

This workshop is designed to teach you a basic understanding of Access 2007 in a practical way. The participants will learn how to use the features of Access to help them better manage a database. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
This workshop is meant to provide a safe learning environment where they can practice and learn Access 2007 Essentials functions without worrying about making mistakes. Making mistakes is a part of learning and is expected in this workshop. Taking the time to learn about the features of Access 2007 will increase their knowledge on how databases work and make creating and managing an Access 2007 database easier for everyone.
Workshop Objectives:
- Open and close Access
- Create a blank database from a template
- Open, close, and save a database
- Work with database Objects
- Sort and Filter the View
- Use Lookup columns in a table
- Add information to a table
- Edit, delete and search records
- Create a form with the Wizard and in Layout View
- Perform common formatting tasks on forms
- Add or move controls on a form
- Create reports using the Report Wizard
- Add a Logo to a report
- Create Queries using the Wizard
- Execute a Query
- Back up the database
- Email the database


This workshop is designed to teach you a deeper understanding of Access 2007 in a practical way. The participants will learn how to use the advance features of Access to help them better manage a database. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.
This workshop is meant to provide a safe learning environment where they can practice and learn Access 2007 Advanced functions without worrying about making mistakes. Making mistakes is a part of learning and is expected in this workshop. Taking the time to learn the advanced features of Access 2007 will increase their knowledge on how databases work and make creating and managing an Access 2007 database easier for everyone.
Workshop Objectives:
- Use advanced table tasks
- Use advanced form tasks
- Use advanced reporting tasks
- Understand relationships
- Use advanced query tasks
- Work with SQL
- Link data
- Import data
- Export data
- Use advance database tools
Download advertorial

Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability. The participants will learn how to use the basic features of Access 2010. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
Access is the world’s premier database software. You can use Access 2010 to create and edit databases -- just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access.
Workshop Objectives:
- Understand common database terms
- Open and close Access
- Create a blank database or a database from a template
- Understand the interface and the Ribbon tools
- Understand the Backstage View
- Use the Navigation Pane
- Work with database objects
- Sort and filter the view
- Create a blank table from a template, in Datasheet view, and Design View
- Use Lookup columns in a table
- Add information to a table
- Edit, delete and search records
- Perform common formatting tasks on forms
- Create reports using the Report Wizard
- Create Queries using the Wizard
- Understand Access file formats and save a database as another file format
- Email the database


The paticipants will learn how to use the advanced features of Access 2010. This workshop is designed to teach you a basic understanding of Access 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with SQL, and publish a Web database—among other things. By the time the paticipants finish this course, they will be able to navigate Access 2010 and create reports like a pro. Sit back, relax, and have fun. You are in for a thrilling ride!
Workshop Objectives:
- Use the Quick Start group, Property Sheet, table macros, report sections, conditional formatting, Expression Builder and logical functions.
- Add, move, remove and format both regular and calculated controls
- Set the Primary Key
- Create a sub-form, Web form, split form, modal dialog, PivotChart, PivotTable and mailing labels
- Group and sort data
- Understand, view and edit relationships
- Understand and establish referential integrity
- Sort and filter a query
- Add calculated fields
- Link to, import and export an Excel spreadsheet, Access database, SharePoint list, text or XML file and other types of links, imports and exports



Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. The participants will learn how to use the basic features of Excel. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
With Excel 2007, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!
Workshop Objectives:
- Open and close Excel
- Differentiate between worksheets, workbooks, rows, columns, and cells
- Enter labels and values
- Set up your page
- Copy formulas
- Use absolute referencing appropriately
- Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
- Use Selection Statistics
- Format text and numbers
- Change the workbook theme


Knowing how to use the advanced features of Microsoft Excel 2007 opens a completely new experience in using this spreadsheet program. The novice user tends to use Excel 2007 as holding place for report data. They may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2007 offers.
This workshop will teach the participants the most common advanced features of Microsoft Excel 2007. The goal of this course is to get them familiar with these functions in a safe learning environment. Once it is completed, their familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for everyone at work or at home.
Workshop Objectives:
- Use SmartArt
- Insert Objects
- Create Charts
- Create Pivot Tables
- Work with Pivot Tables
- Create Pivot Charts
- Solve Formula Errors
- Use What-If Analysis
- Manage Your Data
- Group and Outline Data


Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. The participants will learn how to use the basic features of Excel 2010. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!
Workshop Objectives:
- Open and close Excel
- Understand the new Interface and the new Backstage View
- Switch between Excel views and create custom views
- Set up, Preview and print your workbook
- Use absolute referencing appropriately
- Understand the new Function Names
- Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
- Use AutoFill and AutoComplete
- Sort and filter data
- Use alignment options
- Apply borders
- Use conditional formatting
- Change the workbook theme


The paticipants will learn how to use the advanced features of Excel 2010. This workshop is designed to teach you a basic understanding of Excel 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!
Workshop Objectives:
- Add text to a diagram
- Reset a diagram
- Understand the contextual tabs
- Trace dependents of a cell
- Display formulas within the sheet
- Work with comments
- Insert a chart
- Resize and move a chart
- Insert a Pivot Table
- Use the Pivot Table Tools tab
- Choose fields and group data in a Pivot Table
- Change Pivot Table data and refresh the view
- Create a Pivot Chart from a Pivot Table
- Understand formula errors
- Use the Scenario Manager
- Transposing Data from rows to columns
- Group Data
- Add Subtotals



Welcome to the Office 365 Excel Essentials workshop. With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved.
The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.
Workshop Objectives:
- Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
- Understand the Excel 365 browser interface
- Upload a spreadsheet to the Shared Documents library
- Download and reload workbooks
- Understand saving and collaborating
- Build, copy and edit formulas
- Understand the difference between Formulas and Functions
- Sort and filter data
- Collaborate with others on a spreadsheet
- Use alignment options
- Apply borders and fill color
- Insert and work with Tables and Charts
- Insert links


Welcome to the Microsoft Groove 2007 Essentials workshop. In this course, the participants will learn how to communicate and collaborate with team members all over the world, whether they are in your organization or not. Taking the time to learn about the basic features of Groove 2007 will increase their collaboration and communication skills.
Groove 2007 allows people to create workspaces, share files, and start and participate in team discussions. The participants will also learn how to use Groove tools like the Calendar and SketchPad. The paticipants will learn how to use the basic features of Groove 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
Workshop Objectives:
- Understand how Groove works
- Open and Close Groove
- Understand Workspace Types
- Add Workspace Members
- Set user roles
- Use the Calendar
- Use Forms and InfoPath forms
- View Message History
- View Item Properties
- Manage identities
- Modify general options
- Set synchronization options


The participants will learn how to use the basic features of InfoPath 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the features of InfoPath 2007 will increase their knowledge of information management.
We will take a close look at InfoPath 2007 to give the participants all the tools they need to create, manage, and fill out forms. They will be amazed at how InfoPath can help the organization streamline its information flow!
Workshop Objectives:
- Open and close InfoPath
- Use InfoPath’s Getting Started window and the interface
- Explain XML at a high level
- Work with InfoPath tables
- Create field labels
- Add and modify basic controls, including picture and file attachments
- Understand what advanced control types can be used for
- Format controls
- Add data validation and conditional formatting rules to controls
- Use the Logic Inspector and Design Checker
- View and modify data sources, fields, and groups
- Check spelling
- Preview and test a form
- Publish or print a form


The participants will learn how to use the advanced features of InfoPath 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the advanced features of InfoPath 2007 will increase their knowledge of information management.
This course will take a close look at InfoPath 2007 to give the paticipants all the tools they will need to create, manage, and fill out forms. They will be amazed at how InfoPath 2007 can help an organization streamline its information flow!
Workshop Objectives:
- Insert controls on a form template
- Use file and picture controls
- Understand Advanced and custom controls
- Remove a control from a form template
- Apply conditional formatting
- Calculate fields
- Validate form data
- Import designs from Word or Excel
- Understand how InfoPath uses XML Technologies
- View and manage Add-ins
- Understand form security
- Publish to a SharePoint Site as a Content Type
- Publish Browser capable forms
- Publish Installable Form Template


The participants will learn how to use the basic features of InfoPath 2010. This workshop is designed to teach you a basic understanding of InfoPath 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
In this workshop, the paticipants will learn how to create, manage, and fill out interactive forms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?
Workshop Objectives:
- Open and close InfoPath
- Add rules to customized forms
- Explain XML at a high level
- Use InfoPath Filler 2010 to fill out forms
- Work with InfoPath tables
- Create field labels
- Use the Logic Inspector and Design Checker
- Change the color scheme of a form
- Check spelling
- Preview and test a form
- Protect a form
- Publish or print a form


The paticipants will learn how to use the advanced features of InfoPath 2010. This workshop is designed to teach you a basic understanding of InfoPath 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
InfoPath is a powerful solution for collecting data from users on a variety of platforms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?
Workshop Objectives:
- Understand various types of controls
- Validate form data
- Import designs from Word or Excel
- Create cascading drop down lists
- Work with forms that can be merged
- Add resource files to your form template
- Understand InfoPath Form Events
- Manage data connections
- Publish in various types of forms


Lync Online is Microsoft's premiere online communications software with instant messaging, audio and video calls, and online meetings that include sharing your desktop. The paticipants will be well versed in this great tool that will provide a great benefit in their Office 365 usage.
Office 365 Lync Essentials will get the paticipants started on their path to using Lync for all your communications. We'll first look at how to sign into Lync Online. Then the paticipants will learn how to set up Lync to start automatically and configuring their Lync profiles.
Workshop Objectives:
- Sign in and out of Lync
- Set Lync to start up automatically
- Build your contacts list
- Tag or Pin a contact
- Check status, location, and calendar for contacts
- Change your status
- Hide your activity feed
- Enable privacy mode
- Send an IM to a contact or a group
- End a conversation
- Understand organizer and presenter best practices
- Share your desktop or a program
- Open a whiteboard
- Make a Lync Online Call


The participants will learn how to use the basic features of OneNote 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the features of OneNote 2007 will increase their skills in recording and noting data.
Have you ever wished that you could track appointments, take meeting notes, record research, and keep to-do items all in one place? Well, you can do all that and more with OneNote 2007! In this course, the participants will learn that and much more.
Workshop Objectives:
- Open, close, and use OneNote
- Use and modify the OneNote taskbar icon
- Create a notebook with text, drawings, pictures, lists, tables, screenshots, and recordings
- Use basic editing tools, including cut, copy, paste, undo, and redo
- Format and manage OneNote information
- Use OneNote to perform research and basic calculations
- Use OneNote to manage information from other applications, including Outlook
- Create and modify notebooks, section groups, sections, pages, and sub-pages
- Use organizational tools such as tags, the Page List pane, Find, and the Unfiled Notes section
- Use Full Page view
- Save, print, e-mail, and back up OneNote information


The participants will learn how to use the basic features of OneNote 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the features of OneNote 2007 will increase their skills in recording and noting data.
Have you ever wished that you could track appointments, take meeting notes, record research, and keep to-do items all in one place? Well, you can do all that and more with OneNote 2007 Advanced. In this course, the participants will learn how, plus we’ll explore OneNote’s new ribbon-based interface.
Workshop Objectives:
- Sort and view pages
- Use tables
- Understand the use of the drawing and pen tools
- Create a custom pen to use when drawing or handwriting
- Understand the calculator capabilities
- Use the task pane for formatting text and lists
- Select a page template for a new page
- Insert Files as Printouts
- Print to OneNote from Other Applications
- Send to Word
- Use the Side Note Window
- Send Web Pages to OneNote
- Use the Research task pane
- Use OneNote with multiple computers
- Understand how to use OneNote Mobile with OneNote 2007
- Assign a password to a section.
- Search for audio


The participants will learn how to use the basic features of OneNote 2010. This workshop is designed to teach you a basic understanding of OneNote 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
OneNote is a program that helps you collect notes about anything. You can store all of your notes – in a variety of formats – in one place. Then you can organize and share your notes. OneNote 2010 provides all of these features and can make your everyday business a lot easier.
Workshop Objectives:
- Open and close OneNote
- Dock OneNote to Desktop Mode
- Understand the OneNote 2010 interface and the OneNote icon
- Use the backstage view to create a new notebook
- Use cut, copy, and paste
- Format text and use styles
- Add extra writing space
- Undo and redo tasks
- Check spelling
- Insert lists, tables, pictures, and screen clippings
- Search your notes
- Use OneNote to perform calculations
- Link to Outlook Meetings and Tasks
- Draw, format, and rotate shapes
- Add, move, rename, or delete sections or section groups
- Use time stamps
- Understand different views
- Use Password protection
- Backup, e-mail, or print your notes


The paticipants will learn how to use the advanced features of OneNote 2010. This workshop is designed to teach you a basic understanding of OneNote 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
Have you ever wished that you could track appointments, take meeting notes, record research, and keep to-do items all in one place? Well, you can do all that and more with OneNote 2010. In this course, the participants will learn how, plus we’ll explore OneNote’s new ribbon-based interface.
Workshop Objectives:
- Understand the file and organization changes when upgrading from OneNote 2007
- Sort and view pages
- Use tables
- Understand the calculator capabilities
- Work with Equations
- Format text using the Mini Tool bar
- a Tablet PC
- Create a custom pen to use when drawing or handwriting
- Specify a pen as drawing or handwriting
- Convert ink to text
- Attach files to notes pages
- Insert Files as Printouts
- Use scanned pages
- Disable and Re-enable linked notes
- Understand Universal Access to Notebooks
- Share notebooks with other computers and other authors
- Use the search tools.


Through this workshop the paticipants will be introduced to the way OneNote is integrated into the 365 Web Apps by discussing the Home Page, the Team Site, and the Shared Documents list. We'll also explain how to upload one of your existing OneNote notebooks to the site.
With Office 365 OneNote, you can access your OneNote notebooks from the same website where they are stored, and make some basic changes without using a computer where your desktop Office applications are installed.
Workshop Objectives:
- Open and close notebooks in reading or editing view
- Understand the Office 365 web interface
- Upload a document to the Shared Documents library
- Understand notebooks
- Add sections, pages and sub-pages and move or delete them
- Name pages
- Format fonts and paragraphs with a variety of features
- Use Styles and Tags
- Insert tables and links
- Insert and work with Pictures and Clip Art
- Use the Pop Out
- Open Notebooks in the OneNote 2010 desktop application
- Show authors
- Work with Page versions


The participants will learn how to use the basic features of Outlook 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the features of Outlook 2007 will increase their organization skills.
Outlook is a powerful e-mail application. However, it does much more than that to help you stay organized. With contacts, calendars, and tasks, Outlook 2007 can help you manage every aspect of your life.
Workshop Objectives:
- Open and close Outlook
- Set up an e-mail account
- Send and Receive messages
- View or Print messages
- Reply to or forward messages
- Delete e-mail
- Create and send a new message
- Address a new message
- Use Categories
- Flag items for follow-up
- Search for items
- Understand appointments and the calendar
- Understand tasks and the To-Do List
- Create and organize contacts


Outlook is the most common email program at work. Outlook 2007 is actually more than an email program. This program manages tasks, events, contacts and more. Learning how to use all the advanced features of Outlook 2007 will increase the participant’s efficiency by managing their schedules better and improve communication.
This workshop will teach participants the commonly used advanced features of Outlook 2007. At the end of this course, you will have increased familiarity with Outlook 2007, giving you more confidence in using this program for all your communication needs at work.
Workshop Objectives:
- Customize Outlook
- Add Microsoft Word element to emails
- Customize your profile
- Use advanced email tasks
- Use advanced calendar tasks
- Do more with tasks
- Use notes
- View RSS feeds
- Manage Outlook data


The paticipants will learn how to use the basic features of Outlook 2010. This workshop is designed to teach you a basic understanding of Outlook 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
Outlook 2010 is a powerful e-mail application. However, it does much more than that to help you stay organized. With contacts, calendars, and tasks, Outlook can help the paticipants manage every aspect of their life.
Workshop Objectives:
- Set up an e-mail account
- View the Inbox
- Send and Receive messages
- Delete e-mail
- Ignore e-mail
- Create and send a new message
- Address a new message
- Create the body of an e-mail message
- Attach files to messages
- Mark an item as Read or Unread
- Print messages
- Create folders and use them to organize messages
- Create Rules for handling messages
- Use Categories
- Create and organize contacts


The paticipants will learn how to use the advanced features of Outlook 2010. This workshop is designed to teach you a basic understanding of Outlook 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
In this workshop, we’ll cover some of the more advanced tasks in Outlook 2010, like customizing the Outlook interface and profile. You're participants will learn how to use Word elements in your E-mails. This course explains some of the advanced e-mail, calendar, and task commands, as well as the Notes feature. They will also learn about RSS feeds and how to manage and protect your Outlook data.
Workshop Objectives:
- Customize Outlook, including the Navigation Pane, the Reading Pane, and the To Do Bar
- Understand the Outlook View Tab
- Split a Document
- Change Font options
- Change Stationary options
- Enable or disable automatic spell check
- Add a follow-up flag
- Create a recurring appointment
- Create and track a meeting request
- Color code appointments
- Create a recurring task
- Assign a task
- Use the Details tab
- Set task options
- Work with feed items
- Clean up folders
- Understand data configurations
- Archive and backup data
- Add, open or close a new PST file


Welcome to the Office 365 Outlook Essentials workshop. With Office 365, you can access your inbox anywhere from any computer that has an internet connection and a web browser. In the Office 365 Outlook web app, you can collaborate and keep up to date with built in tools that Outlook is known for.
The Office 365 experience is designed to render your documents and emails to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.
Workshop Objectives:
- Understand the Outlook 365 browser interface
- Open and close the Outlook 365 web app
- Understand IM settings
- Filter messages
- Check messages
- Create, rename, move, and delete folders
- Understand Junk Mail options
- Use the address book
- Attach a file or insert a picture in a message
- View message details
- Flag or categorize an item
- Create rules
- Use automatic replies
- Create a group
- Create appointments and meeting requests
- Share the calendar
- Work with contacts and groups
- Use the task list
- Use dates and reminders


PowerPoint is the world’s premier presentation software. You can use PowerPoint to create and edit slides, and then to run the slide show while you deliver your presentation. Slides can have a variety of information on them, and you can add interest to your slides using formatting and animation.
Microsoft’s PowerPoint 2007 uses the new ribbon interface, and offers significant improvement to its graphical capability. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the features of PowerPoint 2007 will increase their presentation skills.
Workshop Objectives:
- Open and close PowerPoint
- Create a presentation, either blank or from a template
- Open, close, and save presentations
- Use the Slide and Outline tab
- Add slides to a presentation and choose the layout
- Add text to slides
- Check spelling
- Change the font, size and color of text
- Enhance text using character spacing, bold, italic and underline
- Use the Font dialog
- Modify bullets and numbering
- Change the alignment and spacing
- Use tabs and indents
- Move and copy text
- Use Undo and Redo
- Change the Slide background
- Change the presentation theme and color scheme
- Add animation
- Add transitions
- Record narrations and time your slide show
- Run a slide show


PowerPoint is the world’s premier presentation software. You can use PowerPoint to create and edit slides, and then to run the slide show while you deliver your presentation. Slides can have a variety of information on them, and you can add interest to your slides using formatting and animation.
If you develop presentations or visuals for any reason, the skills included in this course will help the paticipants maximize their use of many robust PowerPoint 2007 features to create effective, visually attractive, and useful presentations. Taking the time to learn about the features of PowerPoint 2007 will increase their presentation skills.
Workshop Objectives:
- Insert a picture and a ClipArt image, work with the Picture Tools Tab to change the effects of an image, and move, size and delete and image.
- Insert a Text Box and add text to it, use the Text Box Tools tab to change the appearance of a Text Box, change text attributes within a Text Box, and resize, move and delete a Text Box.
- Insert and modify SmartArt using the Text Box Tools tab, and then format and move, resize and delete the SmartArt object.
- Add a movie and a sound clip to a presentation, and create WordArt and shapes, modifying their attributes using the Drawing Tools tab.
- Use PowerPoint’s research tools to check spelling, perform research in the Research Task Pane, look up word translations, and setting the language.
- Add notes to slides, create a notes master, create a handout master, and print notes and handouts.
- Insert slides from other presentations, create a custom show, package a presentation for use on a CD, and understand the use of the PowerPoint Viewer.


The paticipants will learn how to use the basic features of PowerPoint 2010. This workshop is designed to teach you a basic understanding of PowerPoint 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.
PowerPoint 2010 is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.
Workshop Objectives:
- Open and close PowerPoint
- Understand the PowerPoint 2010 interface
- Use the backstage view to create a new blank presentation or a presentation from a template
- Use the backstage view to open files and use the recent list
- Save presentations
- Add text to a slide and use content placeholders
- Add slides
- Use cut, copy, and paste, as well as the Office Clipboard Task pane
- Undo and redo tasks
- Find and replace text
- Format fonts and paragraphs with a variety of features
- Use bullets and numbering
- Use themes
- Change the slide design, layout, or background design
- Add headers and footers
- Create standard or custom animations
- Use slide transitions and other advance options
- Prepare a slide show, including narration and timing
- Start a presentation
- Navigate through a presentation
- Change a presentation pointer
- Switch to a blank screen in a presentation


The paticipants will learn how to use the advanced features of PowerPoint 2010. This workshop is designed to teach you a basic understanding of PowerPoint 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
PowerPoint 2010 is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.
Workshop Objectives:
- Insert a picture
- Insert screen shots
- Insert clip art
- Insert SmartArt
- Insert a text box and add text
- Insert a Table and add text
- Resize, move, and delete a picture, text box, or SmartArt
- Remove a picture’s background
- Modify table rows and columns
- Format a table
- Add a movie
- Draw shapes
- Align and distribute objects
- Order objects
- Set the Language
- Add Notes to Slides
- Create a Notes Master
- Use the Slide Master tab
- Create a Slide Master
- Record a presentation as a video
- Package your presentation for CD
- Understand the PowerPoint Viewer



While the Office 365 Web Apps are available to anyone who has either a Windows Skydrive account or a SharePoint site, in this course, we will assume that your organization is using the SharePoint site. In this module, we'll introduce the web apps by discussing the Home Page, the Team Site, and the Shared Documents list. We'll also explain how to upload one of your existing PowerPoint presentations to the site.
With Office 365 PowerPoint, you (or any of your viewers) can access your presentations anywhere. You can even make a few basic changes right on the same website where you presentation is located.
Workshop Objectives:
- Open and close PowerPoint
- Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
- Upload a presentation to the Shared Documents library
- Understand the PowerPoint 365 browser interface
- Open a presentation in Reading View or Editing View
- Page through presentations
- Review Slide Notes
- Open the pop out
- View the Outline View
- Open a selected presentation in the PowerPoint 2010 desktop application
- Understand about saving presentations
- Understand the PowerPoint web app interface
- Use content placeholders
- Insert and work with pictures
- Understand Broadcasting presentations over the web
- Prepare your presentations for broadcast
- Broadcast your presentation
- View a broadcast presentation


Project is the world’s premier spreadsheet software. You can use Project to analyze numbers, keep track of data, and graphically represent information. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the features of Project 2007 will increase their project management skills.
With Project 2007, participants can manage more data than ever, with increased worksheet and project sizes. Project also makes their job easier by providing an easy to use interface, and an array of powerful tools to help them turn their data into usable information – and better information leads to better decision making!
Workshop Objectives:
- Open and close Project
- Create a blank Project
- Create a project from a template
- Open, close and save files
- Display all phases of the Project Guide
- Set the start date for your project
- Modify the project calendar
- Define the units of time for the project
- Add Tasks
- Change the order of tasks
- Split a task
- Link and unlink tasks
- Define lags and leads
- Level resources
- Switch views
- Format the Gantt Chart
- Preview and print a project
- E-mail a project


The participants will learn how to use the advanced features of Project 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the advanced features of Project 2007 will increase their organization and management skills.
Project 2007 is a sophisticated project management software that can help project managers with planning, assigning resources, tracking progress, managing budgets, and analyzing workloads for projects. Project also makes their job easier by providing an easy to use interface, and an array of powerful tools to help them turn their data into usable information.
Workshop Objectives:
- Split the view
- Sort, group, and filter tasks
- Use zoom
- Overlap, delay, or split tasks
- Set task deadlines and constraints
- Understand task types
- Assign a task calendar
- Understand task indicators
- Delay resource start times
- Apply predefined resource contours
- Specify Resource availability
- Group resources
- Assign a Resource calendar
- View project statistics, costs, and critical path
- Check duration variance, work variance, and cost variance
- Identify slipped tasks
- Define report contents
- Create a visual report
- Create links between multiple projects
- Consolidate multiple projects
- View multiple project critical paths
- View consolidated project statistics
- Create a resource pool


The paticipants will learn how to use the basic features of Project 2010. This workshop is designed to teach you a basic understanding of Project 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.
Project 2010 is a sophisticated project management software that can help project managers with planning, assigning resources, tracking progress, managing budgets, and analyzing workloads for projects.
Workshop Objectives:
- Open and close Project
- Understand the Interface
- Create a blank project
- Create a project from a template
- Open and close project files
- Add tasks to a project
- Link and unlink tasks
- Create summary and sub tasks
- Create recurring tasks
- Create a baseline
- Update tasks and update the project
- Understand the Project Status date
- View the critical path
- Use change highlighting
- Create basic and visual reports
- Compare projects
- Check spelling
- Use the Page Setup Dialog
- Print a project
- Email a project
- Create a PDF of the project


The paticipants will learn how to use the advanced features of Project 2010. This workshop is designed to teach you a basic understanding of Project 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
Project 2010 has been completely redesigned, and we must say, we’re pretty excited! Whether you’ve been using Project for years, or haven’t opened it yet, you’ll appreciate this course’s information on using the new interface. Of course, we’ll also work through the basics, including how to create projects, add tasks and resources, and customize your view.
Workshop Objectives:
- Split the view
- Sort, group, and filter tasks
- Understand task indicators
- Assign a resource calendar
- Customize a resource calendar
- Apply predefined resource contours
- Specify resource availability
- Group resources
- Enter resource ratesand overtime rates
- Specify pay rates for different dates
- Apply a different pay rate to an assignment
- and actual costs
- View project statistics and costs
- Check duration variance, work variance, and cost variance
- Identify slipped tasks
- Save an interim plan
- Customize a basic or visual report
- Consolidate multiple projects
- View multiple project critical paths
- View consolidated project statistics
- Create a resource pool



In this course, the participants will learn the basic functionality and editing essentials that will allow them to produce high quality publications for both personal and business use. Microsoft Publisher 2007 is a flexible and powerful authoring tool. This course will teach them how to begin, edit, format and produce a publication in Microsoft Publisher 2007.
Once the participants gain a basic understanding of Microsoft Publisher 2007, they will be able to produce a wide variety of documents for publication. This course is a hands-on class that will have them producing documents today.
Workshop Objectives:
- Open and close Publisher
- Work with publications
- Create a publication
- Perform basic editing tasks
- Use the Format Publication task pane
- Perform basic formatting tasks
- Format paragraphs
- Format the page
- Add finishing touches


Publisher is one of the Office suite’s hidden gems, offering you the ability to easily create any kind of publication – newsletters, business cards, menus, invitations, and much more! The participants will learn how to use the advanced features of Publisher 2007. Taking the time to learn about the advanced features of Publisher 2007 will increase their publication and document creation skills.
This course will take the paticipants through the basics of using Microsoft Publisher 2007. Highlights include setting up business information, working with color and font schemes, using the new Getting Started Window, and using page masters. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
Workshop Objectives:
- Use the Format Publication pane to personalize publications
- Work with images
- Use the Graphics Manager Task Pane
- Use the Design Gallery
- Work with file properties
- Work with the default working folder
- Work with page and paper sizes
- Understand the scratch area
- Add or remove headers and footers
- Add an object for multiple pages
- Wrap text around pictures
- Use sound and motion clips with keywords
- Use animated gifs
- Crop pictures
- Use media files
- Convert pictures to watermarks
- Work with tab stops
- Insert the date and time
- Create a data source, and address list and a mail merge
- Add postal bar codes to labels or envelopes


The paticipants will learn how to use the basic features of Publisher 2010. This workshop is designed to teach you a basic understanding of Publisher 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.
Publisher is a desktop publishing tool and flexible and powerful authoring software. It goes well beyond what you can produce with word processing software like Word. Publisher 2010 will help the paticipants learn to produce high-quality publications for both personal and business use.
Workshop Objectives:
- Open and close Publisher
- Understand the Publisher 2010 interface
- Use the backstage view to create a new blank publication or a publication from a template
- Use the backstage view to open files and use the recent list
- Save publications
- Setup business information to use in publications
- Add text and other building blocks
- Work with pages and the Pages pane
- Use the Template group
- Format fonts and paragraphs with a variety of features, including styles
- Use bullets and numbering
- Insert and work with pictures, shapes, and other objects
- Link text boxes to create stories that continue on different areas of the page or different pages
- Create columns
- Add Page Numbers
- Understand Master pages
- Add headers and footers
- Check spelling
- Preview, print, or email a publication


The paticipants will learn how to use the advanced features of Publisher 2010. This workshop is designed to teach you a basic understanding of Publisher 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
Publisher is one of the Office suite’s hidden gems, offering you the ability to easily create any kind of publication – newsletters, business cards, menus, invitations, and much more! This course will take the paticipants through the basics of using Microsoft Publisher 2010. Highlights include using the new ribbon interface, setting up your business information, working with color and font schemes, using the new Getting Started Window, and using page masters.
Workshop Objectives:
- Import text from another file
- Work with Text Box Overflow
- Use special characters
- Work with tab stops
- Insert the date and time
- Convert pictures to watermarks
- Make pictures transparent
- Use the Graphics Manager Task Pane
- Move, group, ungroup, align, distribute and order objects
- Add an object for multiple pages
- Use sound and motion clips with keywords
- Use animated gifs
- Create a data source, and address list and a mail merge
- Track the effectiveness of marketing materials
- Add postal bar codes to labels or envelopes
- Create a catalog
- Use the Design Checker to check for publication errors
- Set Commercial Print Information
- Send files via email
- Save files as different formats, including XPS
- Use the Pack and Go Wizard to prepare a publication for commercial printing



SharePoint Designer is a reincarnation of the previous Microsoft FrontPage product. In this workshop, the participants will learn how to create dynamic websites with custom development. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
With SharePoint Designer 2007 you are able to edit HTML, create, and modify webpages that run SharePoint Foundation and SharePoint Server. SharePoint Designer a great tool and this Essentials course will provide the paticipants with a solid foundation to start building their SharePoint skill set.
Workshop Objectives:
- Open and close SharePoint Designer
- Understand the SharePoint Designer interface
- Create a new web page from scratch or from a template
- Create a new web site
- Save, open, and close web pages
- Understand design view and code view
- Set page properties
- Create and format tables
- Use images
- Use basic formatting tools, including styles, borders, and shading
- Use hyperlinks, bookmark links, hotspots and interactive buttons
- Understand navigation view
- Create and edit a link bar
- Remove an element
- Understand the toolbox
- Preview the page or the site
- Publish the site
- Backup the site


Welcome to the SharePoint Designer 2010 Essentials workshop. You can use SharePoint Designer 2010 to design, build, and customize Web sites running on SharePoint Foundation 2010 and Microsoft SharePoint Server 2010.
With SharePoint Designer 2010 the participants will learn how to create data-rich Web pages, build powerful workflow-enabled solutions, and design the look and feel of your site. SharePoint Designer a great tool and this Essentials course will provide the paticipants with a solid foundation to start building their SharePoint skill set.
Workshop Objectives:
- Open and Close SharePoint Designer 2010
- Understand the interface
- Save sites
- Close a site
- Edit or delete a site
- Work with lists and libraries
- Create a new list or library
- Use content types
- Use Master Pages and content placeholders
- Work with content types
- Create a data view
- Add or remove columns from a data view
- Create a data form
- Edit a list form
- Customize data views and forms
- Understand workflows
- Copy and modify a workflow
- Work with data sources
- Activate a site template in the Solution Gallery


In this workshop the paticipants will learn how to sign on to the Microsoft Office 365 portal, and see where their SharePoint content will be stored. They will learn about the home page of the portal, where to sign into the Team Site and the Office 365 web apps, including Outlook.
Through SharePoint Essentials the paticipants will take a look at the Team Site and how to navigate around and view the SharePoint site. SharePoint Online is the Office 365 answer to collaboration. SharePoint Online will let the paticipants manage documents and information in one place that customers and colleagues can access from virtually anywhere.
Workshop Objectives:
- Sign on to Office 365
- Understand the Home page
- Understand the Team Site
- Update your profile
- Share Information
- Understand content types
- Share and track items
- Track versions
- Understand the Library tools
- Create a site
- Understand Types of Lists
- Manage events
- Connect to Outlook
- Create a New calendar
- Understand Web Parts
- Creating a Site
- Modifying a view
- Understand workflows
- Update a task status


The participants will learn how to use the basic features of Visio 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the basic features of Visio 2007 will increase their creative skills.
This course will help the paticipants get up and running with Visio 2007. We’ll show them how to create drawings, add shapes, customize their screen for maximum productivity, and format their drawing.
Workshop Objectives:
- Open and close Visio
- Use the Getting Started window
- Manage Visio files
- Create a basic drawing (including adding and connecting shapes)
- Customize the drawing area
- Edit and format shapes
- Add, edit, and format text
- Print or e-mail a Visio drawing


The participants will learn how to use the advanced features of Visio 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the advanced features of Visio 2007 will increase their creative skills.
You may already be creating some basic drawing in Visio 2007. Now it’s time to unleash the full potential of this powerful application for creating diagrams and drawings. We’ll show them how to create drawings, add shapes, customize their screen for maximum productivity, and format their drawing.
Workshop Objectives:
- Understand advanced Visio definitions
- Create new drawings using a variety of templates
- Create and save a custom stencil
- Add shapes to stencils
- Control shape placement on a drawing
- Create new shapes
- Revise existing shapes
- Lock and protect shapes
- Understand the Layer Properties dialog box
- Hide or show a layer
- Activate a layer
- Add pages to a drawing
- Arrange pages
- Work with Background pages
- Hyperlink between pages
- Use the Shape and Position window to make precise changes
- View area measurements
- Set the drawing scale
- Work with a Building Plan layout
- Understand how to use data with your drawings


The paticipants will learn how to use the basic features of Visio 2010. This workshop is designed to teach you a basic understanding of Visio 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.
Visio 2007 is a drawing application that uses different shapes and stencils to help you draw different types of diagrams. You can use Visio to create simple flowcharts, complicated engineering plans, or even floor plans.
Workshop Objectives:
- Open and close Visio
- Understand the Visio 2010 interface
- Use the backstage view to create a new blank drawing or a drawing from a template
- Use the backstage view to open files and use the recent list
- Save files
- Switch between files
- Setup screen elements, guides, and ruler and grid settings
- Find and place shapes on a drawing
- Add text to a shape
- Resize, move, delete, and duplicate shapes
- Use the Tools group
- Use cut, copy, and paste
- Format fonts and paragraphs with a variety of features, including using preset styles
- Use bullets
- Rotate text blocks
- Use themes
- Validate the drawing
- Add a legend
- Share the drawing by printing, e-mailing, or saving it as a picture


The paticipants will learn how to use the advanced features of Visio 2010. This workshop is designed to teach you a basic understanding of Visio 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
This course will get the paticipants up and running with Visio 2010. We’ll show them how to use the new interface, create drawings, add shapes, customize your screen for maximum productivity, and format their drawing.
Workshop Objectives:
- Understand advanced Visio definitions
- Create new drawings using a variety of templates
- Create and save a custom stencil
- Control shape placement on a drawing
- Use Quick Shapes
- Lock and protect shapes
- Understand the Layer Properties dialog box
- Activate a layer
- Assign color to a layer
- Add pages to a drawing
- Hyperlink between pages
- View area measurements
- Work with a Building Plan layout
- Understand how to use data with your drawings
- Modify ShapeSheet data
- Use a formula in the ShapeSheet


Welcome to the Windows 7 Essentials workshop. This workshop will help you unlock the power of the tools available in Windows 7. By the end of this workshop, your new desktop will have you rocketing through your tasks like a pro!
Windows 7 Essentials will show the paticipants the great new features of Windows 7 and provide them with a great base to further their Windows 7 experiences. With Windows 7 you are able to better manage your time by providing new and more efficient tools and applications.
Workshop Objectives:
- Upgrade from Vista or XP
- Log in and out of Windows
- Use the Search Box
- Pin an application to the Start Menu or the Taskbar
- Customize the Start Menu
- Use the Notification Area and Action Center
- Navigate the Control Panel and make changes to Control Panel items
- Use Gadgets, Themes, Sticky Notes, and the Snipping Tool
- Backup Files
- Understand Libraries
- Use Windows Key Shortcuts
- Share Files
- Use Location Aware Printing
- Troubleshoot Program Compatibility
- Understand System Restore
- Understand Startup Repair


The participants will learn how to use the basic features of Word 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the basic features of Word 2007 will increase their document creation skills.
Microsoft Word is one of the most widely used applications in the world today, so it’s important to have a firm grasp on the basics. To begin, you’re participants will learn basic word processing tasks, such as how to type, delete, and edit text. Then, we’ll look at some of Word 2007 Essential features, including formatting tools, bullets and numbering, themes, and headers and footers.
Workshop Objectives:
- Open and close Word
- Use Word’s new interface
- Create a new document and add and edit text
- Open, close, and save files
- Use Word’s templates
- Perform basic word processing functions, such as selecting text; using drag and drop; and using cut, copy, and paste
- Check spelling in a document
- Format your document at a character, paragraph, page, and document level
- Use the basic features of styles
- Use Word’s new Themes feature
- Print or e-mail a document


The participants will learn how to use the advanced features of Word 2007. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer. Taking the time to learn about the advanced features of Word 2007 will increase their document creation skills.
Whether you are a business writer, a marketer, or someone who uses the software for general document creation and handling, the skills included in this course will help the paticipants maximize their use of many powerful Word 2007 features to create effective, visually attractive, and useful documents.
Workshop Objectives:
- Use the features of the Word Window: zoom, views, how to arrange windows, splitting a document, and using the document map
- Add ClipArt images and pictures from a file, use the Picture Tools tab, and move or delete added images
- Work with SmartArt by inserting SmartArt shapes, adding, moving or deleting SmartArt images, and making use of the SmartArt Tools tab
- Quickly add tables, text, and styles by using the Table Tools tab features
- Work with synonyms, use the research task pane, translate screen tips into other languages, and set your default language
- Review a document electronically; add and review comments, track and review changes, and compare two documents
- Customize your personal operating environment in Word by minimizing the ribbon, using the Quick Access toolbar, and tweaking the Word color scheme.


The paticipants will learn how to use the basic features of Word 2010. This workshop is designed to teach you a basic understanding of Word 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.
Word 2010 is a powerful word processing application. However, it does much more than create simple documents. It includes several desktop publishing features to make your documents look great.
Workshop Objectives:
- Open and close Word
- Understand the Word 2010 interface
- Use the backstage view to create a new blank document or a document from a template
- Use the backstage view to open files and use the recent list
- Save documents
- Type, select, and edit text
- Find and replace text
- Use the Selection pane to select pictures or objects
- Format fonts and paragraphs with a variety of features
- Use bullets and numbering
- Use borders and shading
- Understand, create and use styles
- Use the page setup dialog
- Check spelling
- Preview, print, or email a document


The paticipants will learn how to use the advanced features of Word 2010. This workshop is designed to teach you a basic understanding of Word 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
In this workshop, we’ll cover some of the more advanced tasks in Word 2010, like working with pictures and other objects, using generated tables of contents and indexes, and other research and review tasks.
Workshop Objectives:
- Use Zoom
- Understand Word Views
- Split a Document
- Use the Navigation Pane
- Insert ClipArt, Pictures from Files, and Screen Shots
- Move or Delete a Picture
- Use the Picture Tools Tab
- Use SmartArt
- Work with Tables
- Use the Table Tools Tab
- Apply a Style to a Table
- Add a Cover Page
- Add Word Art
- Draw Shapes
- Use Translation ScreenTips
- Set Your Language
- Use Comments
- Track and Review Changes
- Compare Documents
- Minimize the Ribbon
- Customize the Quick Access Toolbar
- Access Word Options



Welcome to the Office 365 Word Web App Essentials workshop. With Office 365, you can access your documents anywhere, and make some basic changes without using a computer where your desktop Office applications are installed.
With Office 365 Word the paticipants will learn how to edit, share, and publish Word files using the Office 365 interface. The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.
Workshop Objectives:
- Open and close documents in reading or editing view
- Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
- Understand the Word 365 browser interface
- Upload a document to the Shared Documents library
- Open a document in Reading View or Editing View
- Page through documents
- Zoom to a different view
- Open the pop out
- Open in Editing View
- Type, select, and edit text
- Understand the Word web app interface
- Use cut, copy, and paste
- Undo and redo tasks
- Format fonts and paragraphs with a variety of features
- Use bullets and numbering
- Insert and work with tables
- Insert links
- Insert and work with pictures
- Insert clip art
