Make the switch to Excel 2010
Do you already know how to use Microsoft Excel? Are you making the switch to Excel 2010 from Excel 2003 or earlier? If so, you’ve come to the right place to get familiar with the new version and to see how to do everyday tasks.
7/2010
Get to know Excel 2010: Create your first spreadsheet
Are you new to Excel? If so, learn how to create a spreadsheet, to do basic math in Excel, to add and delete columns and rows, to keep column titles in sight as you scroll, and to prepare a spreadsheet for printing.
7/2010
Get to know Excel 2010: Create formulas
Learn how to use formulas to do basic math in Excel, how to make formula results update automatically, and how to use predefined formulas called functions that do things like calculate the amount of monthly payments.
7/2010
Make the switch to Word 2010
If you are making the switch from Microsoft Office Word 2003 or earlier to Microsoft Word 2010, and you are comfortable in Word but want to learn your way around this newest version, this course is for you. We’ll help you get familiar with changes and see how to perform essential everyday tasks.
7/2010
Office 2010 Security: Protecting your files
In Microsoft Office 2010, when files open, Message Bars can alert you to useful information and potential problems with your files. Security Message Bars provide the opportunity to consider the potential security risks that may be in your file, and then the ability to open or read the file while reducing the risks that can occur.
7/2010
Use the Navigation Pane to search and move around in your document
In this course, find out how the Navigation Pane enables you to view all of your document’s headings and pages in a clear, top-to-bottom format; locate and restructure chunks of content just by dragging headings; and find all instances of specific words, phrases, or items such as figures and tables – without having to scroll through the search results.
7/2010
Create visually compelling documents in Word 2010
Effective documents convey important information in a well-designed way — and Word 2010 offers several options to assist you in designing your information so that it really stands out. In this course, we’ll show you how to be your own graphic designer and get your text and images noticed.
7/2010
Tame your Inbox: Organize messages by conversation
Ever wish you had a smarter, handier way to arrange your Outlook Inbox? Learn how Date (Conversations) can simplify and clarify your view — and how it can save you time and clicks by allowing you to take action on whole conversations at once, instead of having to handle each message individually.
7/2010
Make the switch to Outlook 2010
Make the transition from an earlier version of Outlook to Outlook 2010 with as little hassle as possible. Find the commands you’re likely to use every day on the ribbon and in the new Microsoft Office Backstage view.
7/2010
Make the switch to PowerPoint 2010
If you’re upgrading from an earlier version of PowerPoint, particularly from PowerPoint 2003 or before, this course is for you. Get familiar with changes to the interface in PowerPoint 2010, such as the design for menus and toolbars known as “the ribbon,” and do the things you’d typically do to create a presentation.
7/2010
Make the switch to Access 2010
If you're an experienced Access user, this course is for you. This course explains how to switch to Access 2010 from a previous version. You'll learn how to perform familiar tasks in Access 2010, such as using existing databases, creating new databases, building tables, and creating or editing forms and reports.
7/2010
Create reports for a new database
Learn how to create reports. Reports present information visually, help others understand your data, and answer critical business questions. This is the sixth and final course in a series that teaches beginners how to use Access 2010.
7/2010
Create queries for a new database
Learn how to create queries for an Access database. Queries are an essential part of any database. They’re how you answer extract meaningful information from your database and answer key business questions. This is the fourth course in a series that teaches beginners how to use Access 2010.
7/2010
Create forms for a new database
Learn how to create forms. Forms provide a window into your data, make your database look polished and professional, and help you enter data more accurately. This is the fifth course in a series that teaches beginners how to use Access 2010.
7/2010
Create relationships for a new database
Learn how to create table relationships for a new Access 2010 database. Relationships are essential because they bring the data in your tables together so you can extract meaningful information. This course explains the different types of relationships and shows you how to create them. This is the third course in a series that teaches beginners how to use Access 2010.
7/2010
Create tables for a new database
Learn how to build the tables for a new database. Tables are the essential component of any database. Without them, you don’t have a database. If you're feeling intimidated, relax. We assume you're a beginner, and we’ll show you how to create tables step by step. Just make sure you've taken the first course in this series, or that you're familiar with basic database concepts such as fields and primary keys.
7/2010
Design the tables for a new database
Learn how to use Access 2010 by designing and creating a database. You'll start by learning how to design the tables and relationships for a new database. A good design ensures your database captures all your data accurately. This is the first course in a series that teaches beginners how to use Access 2010.
7/2010
Build and publish web databases
This course explains how to create and publish an Access 2010 web database that runs on SharePoint 2010. You’ll also learn how to save a changed web database to SharePoint, and how to create a web database from scratch using a blank template.
7/2010
Make the switch to the new SharePoint 2010 user interface
You’re used to working with SharePoint team sites, but your organization has just upgraded to Microsoft SharePoint Foundation 2010 or Microsoft SharePoint Server 2010. This course shows you what to expect in terms of what’s changed from previous versions, and how to quickly get up to speed doing the tasks you’re used to doing.
7/2010
SharePoint lists IV: Create a custom list
Available
Soon
7/2010
SharePoint lists I: An introduction
Lists are a key, underlying feature of your SharePoint site. They enable teams to gather, track, and share information by using a Web browser. Take this course and learn the basics.
7/2010
Make Better Business Decisions
Learn how to use a PerformancePoint dashboard to analyze potential business concerns, such as profitability, and then share information and recommendations with others in order to improve business decision making.
7/2010
Quickly find the resources you need to get your job done
SharePoint Server 2010 search has been improved to help you quickly and easily find the documents you need to get your work done faster.
7/2010
Share information in a central place
This course shows you how you can use SharePoint sites as a central place to store and share information with team members.
7/2010
Introduction to Web Content Management
This course provides an introduction to designing and authoring structured content pages on a publishing site using an approval workflow.
7/2010
My Sites: Connecting to people and information
This course shows you how to be more productive by using your My Site, social tagging, and related features. The emphasis will be on helping you to be more productive and strategic by finding the resources you need.
7/2010
Collaborate on documents and projects more efficiently
Learn how to make the most out of SharePoint calendars, how to allow multiple people to author a document simultaneously, take your documents offline and then reconnect by using SharePoint Workspace, and how to manage a project in SharePoint and by using Project Task lists.
7/2010
Manage documents and content in Microsoft SharePoint Server 2010
This course provides an overview of the new and updated document management features in SharePoint Server 2010. If you are already familiar with basic document management tasks--such document check-in/check-out and working with document version history--but you want to gain a basic understanding of some of the more advanced document management capabilities in SharePoint Server 2010, then this course if for you. We’ll help you become familiar with the new document management features, and see how they might make your work easier.
7/2010
Introduction to Records Management and Compliance
This training course will introduce you to some of the new and improved records management and compliance features in Microsoft SharePoint Server 2010. In the examples throughout the course, we will look at how a fictitious, medium-sized company, Contoso, uses SharePoint Server 2010 to manage records.
7/2010
SharePoint pages I: An introduction
Get an introduction to the concept of pages on a SharePoint 2010 team site. Learn what types of pages are changeable, and, using the home page as an example, how to get started editing content.
7/2010
SharePoint lists II: Create and work with different lists
You know how to add, edit, and delete items in SharePoint lists. Now it’s time to create your own lists. Take this course to find out how. Plus, get cool tips like how to group list items and set e-mail alerts for a list.
7/2010
SharePoint lists III: Create a list based on a spreadsheet
How do you take a spreadsheet and make it into a SharePoint list? You import it. Take this short course to learn how.
7/2010
SharePoint lists IV: Create a custom list
In the last video, you learned how to create lists based on templates that come with your team site. But what if you need to create your own custom list, a list with special columns that you define? This course will show you the ropes.
7/2010
Getting started with Project 2010
Do you need to manage a project but aren’t sure how to get started with Project 2010? Learn how to start a new, blank project, create a few project tasks, and give structure to your project through outlining and linking one task to another.
7/2010
Make the switch to OneNote 2010
Already experienced with an earlier version of Microsoft Office OneNote, and just want to get up to speed with the changes in the 2010 version? Then this is the course for you.
7/2010
Excel - Getting Up To Speed
Learn the basics of navigating your way around the new and improved Excel. Figure out how to use everyday commands with ease and confidence. Take your first step toward conquering Excel.
10/2009
Excel - Create Your First Workbook
Inputting data is the essence of Excel, which is why you will thank yourself for learning basic tasks such as entering and editing text and deleting columns and rows.
4/2010
Excel - Enter Formulas
Make your life easier by learning how to add, divide, multiply, and subtract using formulas in Excel worksheets. Master this now and be rewarded indefinitely with saved time and reduced stress.
5/2010
Excel - Figure Out Dates Using Formulas
Have you ever been mystified by the task of having to manage your time? Eliminate the frustrations of manually calculating your schedule with Excel's use of dates. It makes it possible to perform date arithmetic, which frees up your time to focus on other, more important things - like saving the world.
6/2010
Excel - Create a Chart
Problem: You want to convey a lot of information in a short amount of time. Solution: Charts. Learn how to compress data into professional looking charts that are easy to understand. Your readers will thank you.
3/2010
Excel - Get Started with PivotTable Reports
How can you improve the presentation of data while saving time? The key to your increased productivity lies in this video. Learn how to efficiently create interactive tables that organize data in spectacular presentations that take no time at all.
4/2010
Word - Getting Up To Speed
Find out how to continue work as usual with the new version of Word, which now allows you to work at an accelerated pace. What's not to love?
10/2009
Word - Create Your First Document
Let's say you've never worked with Word. Fear not, it's never too late to start learning the basics of creating your first document. Find out how to type anywhere on a page, fix spelling errors, change spacing and page margins, and save your work. Let's get started.
10/2009
Word - Edit Text and Revise Your Documents
Learn how to move, select, and delete text and make other sundry changes to your document. Prepare to launch yourself as an editing professional.
4/2010
Word - Make Documents Look Great
Now that you are more familiar with Word, you may want to move on to tackling the minutiae of perfecting and fine-tuning your document. Watch this video and be prepared to be showered with compliments, on your document that is.
4/2010
Word - Bullets, Numbers and Lists
Do you have a million ideas to convey but you don't want to scare off your readers? Organize your information in lists, they make your documents look professionally chic and are always a crowd pleaser.
4/2010
Word - Revise Documents with Track Changes and Comments
Working on documents with one or more people need no longer be a daunting and uncoordinated task. Keep track of who made changes and why and before you know it, you will have a beautiful final document that everyone can be proud of.
4/2010
Word - Header and Footer Basics
Headers and Footers provide easy and straightforward navigation through a document. Learn the basics of adding headers and footers and experience more manageable documents.
4/2010
Word - Headers and Footers for Document Sections
Go the extra mile and make headers and footers for different sections to direct readers through changing topics and ideas.
Available
Soon
6/2010
Word - Table of Contents I: Create an Automatic TOC
Have you ever found yourself flustered and annoyed with a document that has no end in sight? Make it easy to find specific sections in your documents with a Table of Contents; your readers will thank you.
5/2010
Word - Table of Contents II: Customize Your TOC
Now that you have your Table of Contents firmly in place, it's time to get fancy. Learn how to change the color and formatting of your titles and headings.
5/2010
Word - Decorate Documents with Backgrounds, Borders, and Text Effects
Not everything in life is black and white and it shouldn't be in your document either. Customize your documents with visual effects that will impress any reader.
Available
Soon
Word - Save Time with Templates
Transport your documents to a whole new level in the blink of an eye with eye-catching templates.
Available
Soon
Word - Reuse Text and Other Document Parts: Introducing Building Blocks
As you work more frequently with documents, it will dawn on you that you are using many of the same features over and over again. Make it a built-in component with the speed dial of Word.
Available
Soon
Word - Mail Merge I: Use Mail Merge for Mass Mailing
Learn how to send uniform emails to many people, and save time when working with large events.
Available
Soon
Word - Mail Merge II: Use the Ribbon and Perform a Complex Mail Merge
Your messages just got more complicated and require personalization. Now you can mail merge emails that also contain unique elements. Don't underestimate the value of communicating your organization's message; make your first impression memorable.
Available
Soon
Outlook - Getting Up To Speed
If you tend to find application updates disorienting, watch this video to get reacquainted with the new Outlook. Find everyday commands and send and receive attachments as usual. Acclimate away!
6/2010
Outlook - Get Out of Your Inbox
Your inbox is a jungle, tame the wilderness by getting a handle on organizing your emails. Befriend helpful features just as flags, the to-do bar, colored categories, and the search feature.
Available
Soon
Outlook - See and Use Multiple Calendars
If you need to manage more than one calendar, you're in luck. This video will guide you through the steps of how to easily organize and maintain multiple schedules and important dates for different people.
4/2010
Outlook - Create Great-Looking Signatures for Your E-mail
Including signatures is a great way to lend a personal touch to your message. You can create multiple signatures to suit various occasions, whether for private communication or professional correspondence.
6/2010
Outlook - Create and Use Your Own Electronic Business Card
For those occasions when sending your business card via carrier pigeon isn't the most convenient method, you can turn to Outlook to quickly and easily create, customize, and share electronic business cards.
6/2010
Outlook - Manage Your Mailbox I: Find Its Size and Trim It Down
Are you afraid of your mailbox overflowing with millions of messages? If so, it's time to incorporate some simple processes that will prevent your inbox fears from being realized.
6/2010
Outlook - Manage Your Mailbox II: Understand Your Choices for Storing
If you need to store your email messages on your own computer rather than a server or another computer, you will be able to maneuver your way around these tasks after watching this video.
6/2010
Outlook - Manage Your Mailbox III: Move or Copy Messages To Personal Folders
Learn how to save your messages to a personal folder on your computer. This is a convenient way to maintain a record of your correspondence, whether it is with select individuals or specific organizations.
Available
Soon
Outlook - Manage Your Mailbox IV: Archive Old Messages
Do you ever find yourself trying to hunt down an email that stubbornly remains missing? With Outlook's automatic archiving function you will no longer find yourself searching through tons of old messages.
Available
Soon
Outlook - Manage Your Mailbox V: Retrieve, Back-Up, or Share Messages
Create personal folders on your computer that house Outlook items such as appointments and email messages. This is a convenient way to store backup files on your personal computer that can be easily accessed.
Available
Soon
PowerPoint - Create Your First Presentation
Send a clear and powerful message using the time honored art of pairing images with text. Learn how to apply themes, print handouts and notes, and give a presentation to remember.
7/2010
PowerPoint - Add Sound Effects to a Presentation
If you want to add that extra detail for emphasis, it might be time to add sound effects to your presentation. Whether it is a sound file or music from a CD, learn how to incorporate it into your presentation.
7/2010
PowerPoint - Personalize Your Slide Design
Add personal flair to your presentations, with the skills you will pick up in this video. Learn how to customize your own theme and save it as a template.
7/2010
PowerPoint - Discover the Power of Custom Layouts
Learn how to create your own layout for slides and save it as a template. This is perfect for those occasions when the built-in layouts do not suffice.
7/2010
PowerPoint - Get Visual with SmartArt Graphics
With the high stakes in the cutthroat world of PowerPoint presentations, you need the edge to impress your clients. Strategically incorporate some posh graphics to add style to your delivery.
7/2010
PowerPoint - Put Your Photos into PowerPoint
Sometimes graphics alone just won't cut it and you find yourself pressed to use an image plucked from reality. Learn how to crop, resize, frame, format pictures and insert them seamlessly into your slides.
7/2010