with CEU Certificate*
This all-in-one training course provides comprehensive instruction on four popular MS Office programs: MS Word 2010, MS Excel 2010, MS PowerPoint 2010 and MS Outlook 2010.
MS Word 2010
Microsoft Word 2010 is the newest update to their popular word processing software. Looking a lot like their 2007 version, Word 2010 continues utilizing the ribbon to make accessing features and toolbars a lot quicker and easier than before. When you factor in all the writing, formatting, editing, and even publishing tools that this newest version offers, Microsoft 2010 becomes one of the best versions yet.
Even if you've never used Microsoft Word before, learning to use Word 2010 will be a breeze. This section takes its time in introducing you to the layout, providing you step-by-step instructions on how to benefit from the most commonly used features. If you're already familiar with previous versions of Word, this course will give you a tour of 2010 and go into some advanced aspects to improve your skill level and make you an expert with this program.
You'll learn how to:
Edit, proofread, and track changes in a document using easy, built-in tools
Create and use templates to put together newsletters, brochures, etc.
Design tables, charts, and graphs
Create 3D effects for pictures and graphics
Use MS Word's security features to protect your documents
Share documents over the web
Navigate through long documents in a matter of seconds using the new Navigation Pane
Take screenshots of your work with MS Word 2010
And much, much more
MS Excel 2010
Most computer-savvy people out there today know that MS Excel 2010 is a spreadsheet program that you can use to record data, create charts, and utilize mathematical equations. However, most people who are familiar with Excel aren't fully aware of all that MS Excel can do. Maybe that's you. You'd be surprised about the things that you can do using Excel that you're currently doing by hand or using other inappropriate software (such as the familiar sibling to Excel, MS Word). But that's okay. That's why we designed this course.
But first, let's dispel the myths that MS Excel 2010 is complicated to use, or to use its mathematical functions and capabilities that you must be good at math, or worse yet, that you must know some complicated programing in order to make it work for you. The truth is, most people like you that use MS Excel use it for a single defined reason. Because there are so many options and features available within the software, most people feel overwhelmed and don't take the time to explore just how many other things they can actually use it for.
With Excel 2010, you can:
Organize, sort, and record data.
Enter in text and mathematical equations.
Keep, track, chart, graph, and compare statistics.
Create mathematical equations and functions to accurately keep records and statistics whenever data changes.
You can even use Excel to balance your checkbook, calculate the dollar amount you're spending on interest rates for credit cards and mortgages, as well as track your corporate spending accounts! You can also turn around and use Excel for something as simple as listing who is bringing what to the next family reunion. MS Excel can be used for the most complex or simplest of tasks…and all these tasks can be done quite easily when you know how to use Excel 2010.
MS PowerPoint 2010
PowerPoint 2010 adds easy-to-use interactive features that make the usual slides of boring bulleted text and charts a relic of the past. Making up for a tedious PowerPoint presentation by being an exceptional speaker is no longer required.
PowerPoint is one of Microsoft's best programs, and improving upon previous versions, PowerPoint 2010 is now a lot more fun to use. You will be amazed at how easy it will be to familiarize yourself with the various aspects of this program.
With this course, you will learn:
- How to Use Themes and Layouts
- How to Insert Text and Using WordArt
- How to Insert Graphics (Tables, Charts, Shapes, Clip-Art)
- How to Work with Videos, Movie-Clips, Animations, and Transitions
- How to Work with Sounds
- How to create Photo Albums
- Reviewing and Adding Comments to the Presentation
- Editing, Saving, Printing and Publishing Tools
- and much more
MS Outlook 2010
Outlook 2010 is a personal information software program that's available with the Microsoft Office Suite. Although it's mostly used as an email client, it can also be used for managing tasks, keeping your calendar, managing contacts, taking notes, journaling, and even connecting with friends and colleagues via social networks. Unlike other email programs out there that you can install on your computer, Outlook 2010 can be your email program and planner all in one.
This section is designed to teach all users, regardless of experience, how to use Outlook 2010 for business or personal use. You'll learn all aspects of this program that you need to know in order to use it like a seasoned pro. In this course, you'll learn:
How to send and receive emails
How to use the calendar
How to set appointments, meetings, and events, then share them with others
How to take notes
How to connect to social networks using Outlook 2010
How to create a To-Do list
How to have Outlook answer your emails for you when you're away
How to assign tasks and schedule meetings – all from Outlook
And much, much more
MS Outlook 2010 is a comprehensive program that can be hard to use if you don't know all of its features and shortcuts. This course is designed to make it simple. Even if you've never used Outlook or any of the programs before, you'll come away from this course with enough experience to start using MS Office programs like a pro.
* Instantly download, print, and share your CEU Certificate at course completion (additional shipping/handling charges apply for hard copy delivery). UniversalClass™ offers many wonderful learning tools including an online portfolio service that manages all your course completions and CEUs.
Request More InformationHave a question? Contact us for more information.
Word 1.1: Beginning to Use Microsoft Word 2010By the time you're finished with this course, you will know the basic functions of MS Word, how to use them, and also know how to implement the advanced tools that will make any task you set out to accomplish even easier.
Word 1.2: Basic EditingThe first step in editing text that you've already entered is to learn how to select it for editing. This lesson will focus on how to use the editing tools.
Word 1.3: FormattingThis lesson will cover the subject of formatting an MS Word document using MS Word 2010, making it an easy task for you to accomplish.
Word 1.4: TemplatesThis lesson will focus on how to use templates in MS Word 2010.
Word 1.5: Working With Graphics and PicturesWord 2010 has a wealth of tools to add interesting graphics that will help your readers easily grasp all of the important information.
Word 1.6: TablesThis lesson will demonstrate how to use tables in this program to do complex page layout operations that almost rival expensive professional publishing programs like Adobe InDesign.
Word 1.7: Desktop PublishingThis lesson will focus on the many simple embellishments provided to enhance your word document for a professional looking presentation.
Word 1.8: Long DocumentsThis lesson will focus on the tools used to correctly record and present a longer word document.
Word 1.9: Technical DocumentsThis lesson will focus on how to make word documents in a specific format to meet specific requirements (such as a term paper)
Word 1.10: Mail MergeTo create mailing lists, envelopes, labels, and merge mail lists, you will go to the Mailings tab on the Ribbon.
Word 1.11: Proofing, Printing, and PublishingThis lesson will focus on the proofreading tools available in MS Word 2010
Word 1.12: Comparing, Merging, and Protecting DocumentsThis lesson will focus on how to use the Document Inspector to safely compare, merge and protect Word documents. The tool Macros will also be explained.
Word 1.13: Customizing and Expanding WordThe ribbon in Microsoft Word 2010 looks the same as in 2007, except in 2010 you can customize it. This lesson will show you how to do this.
Excel 2.1: Introduction to MS Excel 2010MS Excel is a spreadsheet program that you can use to record data, mathematical charts, and equations. This first lesson will go over the new features and how to navigate of this program
Excel 2.2: Worksheets and WorkbooksThe basic structure and tools to efficiently use workbooks and worksheets will be discussed.
Excel 2.3: Entering Information into MS Excel 2010More basic information will be covered as this lesson will discuss how to enter, format and manipulate data.
Excel 2.4: Entering Information Part 2Entering data more efficiently with Excels auto fill, how to search data, how to split and freeze panes, how to use to proofreading tools will be discussed in this lesson.
Excel 2.5: Formatting a WorksheetBy using a few simple formatting features in you MS Excel 2010, you can make the information in it easy to grasp and attractive. This lesson will show you how to use the features and more.
Excel 2.6: Adding Elements to a WorkbookNow we're going to show you how to add elements such as images, art and diagrams.
Excel 2.7: ChartsCharts and diagrams are tools you can use to visually represent the data in a worksheet. You can use them to show trends, averages, high points, low points, and more.
Excel 2.8: Formulas and CalculationsMS Excel has many features and capabilities, but the ability to use formulas and perform calculations is the bread and butter of MS Excel. In this lesson we will begin learning how to perform some basic calculationa.
Excel 2.9: Excel FormsA form is simply a dialog box that lets you display or enter information one record (or row) at a time. It can also make the information more visually appealing and easier to understand. This quick lesson will show you how to use this powerful feature.
Excel 2.10: TablesA Table in MS Excel consists of orderly rows and columns of data, such as names, addresses, or even sales totals. This lesson will show you how to put a table together as well as how to utilize other tools to better analyze your data.
Excel 2.11: Developing a WorkbookIn an earlier lesson we showed you how to create a workbook. In this lesson, we're going to show you how to develop it further to fit your needs.
Excel 2.12: Sharing Worksheets and WorkbooksIn this lesson, we're going to cover the ways that you can share your MS Excel 2010 workbooks.
Excel 2.13: Advanced SkillsThis final lesson will introduce many of the advance features that Excel can use- such as XML,a type of code that tells the computer how to display the content correctly across a wide variety of computers.
PowerPoint 3.1: Activating PowerPoint and Getting StartedIn this first lesson students will know the process of how to activate PowerPoint and how to get started creating a PowerPoint presentation.
PowerPoint 3.2: Using Themes and LayoutsLearning to use themes and layouts can be an exciting way to incorporate a variety of different themes to your PowerPoint presentation.
PowerPoint 3.3: Inserting Text and Using WordArtInserting Text and using Word Art will allow you to add text to your presentation in such a way that it will make your project come to life.
PowerPoint 3.4: Inserting Graphics (Tables, Charts, Shapes, Clip-Art)Adding Graphics will help make your presentation more presentable for viewing by making it more interesting.
More Class Lessons...
- Document Your Lifelong Learning Achievements
- Earn an Official Certificate Documenting Course Hours and CEUs
- Verify Your Certificate with a Unique Serial Number Online
- View and Share Your Certificate Online or Download/Print as PDF
- Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Learning OutcomesBy successfully completing this course, students will be able to:
- Demonstrate how to navigate, edit, format text in Microsoft Word 2010
- Demonstrate template and picture usage in MS Word 2010.
- Demonstrate table usage in MS Word.
- Summarize desktop publishing with Microsoft word 2010
- Demonstrate mail merging with Word 2010.
- Demonstrate comparing, merging, and protecting documents.
- Demonstrate creating worksheets, workbooks, and entering information into Excel 2010.
- Demonstrating formatting and adding elements to an Excel spreadsheet.
- Demonstrate charge usage in Excel 2010.
- Demonstrate formula and calculation usage in Excel 2010.
- Demonstrate using Excel forms and table in Excel 2010
- Demonstrate sharing worksheets and workbooks.
- Demonstrate basic PowerPoint usage, navigation, themes, layouts, and inserting text.
- Demonstrate inserting graphics (tables, charts, shapes, clip-art) in PowerPoint 2010.
- Demonstrate working with videos, movie-clips, animations, sounds, and transitions in PowerPoint 2010
- Demonstrate creating photo albums, reviewing and adding comments to the PowerPoint presentation.
- Demonstrate editing, saving, printing and publishing tools in PowerPoint 2010.
- Demonstrate navigation and basic email usage with Outlook 2010.
- Demonstrate using address books in Outlook 2010.
- Demonstrate working with messages, formatting message, and organizing mail in Outlook 2010.
- Demonstrate usage of the calendar, reminders, tasks, notes, and sharing with Outlook 2010, and
- Demonstrate mastery of lesson content at levels of 70% or higher.
|Word 1.1 Assignment||Assignment||5|
|Word 1.1 Exam||Exam||7|
|Word 1.2 Assignment||Assignment||20|
|Word 1.2 Exam||Exam||9|
|Word 1.3 Assignment||Assignment||20|
|Word 1.3 Exam||Exam||9|
|Word 1.4 Exam||Exam||8|
|Word 1.5 Assignment||Assignment||20|
|Word 1.5 Exam||Exam||9|
|Word 1.6 Assignment||Assignment||20|
|Word 1.6 Exam||Exam||6|
|Word 1.7 Assignment||Assignment||20|
|Word 1.7 Exam||Exam||9|
|Word 1.8 Assignment||Assignment||5|
|Word 1.8 Exam||Exam||8|
|Word 1.9 Assignment||Assignment||20|
|Word 1.9 Exam||Exam||9|
|Word 1.10 Exam||Exam||5|
|Word 1.11 Exam||Exam||9|
|Word 1.12 Exam||Exam||8|
|Word 1.13 Exam||Exam||10|
|Review of Word||Exam||55|
|Excel 2.1 Assignment||Assignment||5|
|Excel 2.1 Exam||Exam||7|
|Excel 2.2 Assignment||Assignment||20|
|Excel 2.2 Exam||Exam||10|
|Excel 2.3 Assignment||Assignment||20|
|Excel 2.3 Exam||Exam||9|
|Excel 2.4 Assignment||Assignment||20|
|Excel 2.4 Exam||Exam||8|
|Excel 2.5 Assignment||Assignment||20|
|Excel 2.5 Exam||Exam||10|
|Excel 2.6 Assignment||Assignment||20|
|Excel 2.6 Exam||Exam||9|
|Excel 2.7 Assignment||Assignment||20|
|Excel 2.7 Exam||Exam||7|
|Excel 2.8 Assignment||Assignment||20|
|Excel 2.8 Exam||Exam||8|
|Excel 2.9 Assignment||Assignment||20|
|Excel 2.9 Exam||Exam||3|
|Excel 2.10 Assignment||Assignment||20|
|Excel 2.10 Bonus Assignment||Assignment||0|
|Excel 2.10 Exam||Exam||9|
|Excel 2.11 Assignment||Assignment||20|
|Excel 2.11 Exam||Exam||10|
|Excel 2.12 Assignment||Assignment||20|
|Excel 2.12 Exam||Exam||10|
|Excel 2.13 Exam||Exam||9|
|Review of Excel||Exam||49|
|PowerPoint 3.1 Assignment||Assignment||20|
|PowerPoint 3.1 Exam||Exam||7|
|PowerPoint 3.2 Assignment||Assignment||20|
|PowerPoint 3.2 Exam||Exam||10|
|PowerPoint 3.3 Assignment A||Assignment||10|
|PowerPoint 3.3 Assignment B||Assignment||10|
|PowerPoint 3.3 Exam||Exam||8|
|PowerPoint 3.4 Assignment A||Assignment||10|
|PowerPoint 3.4 Assignment B||Assignment||10|
|PowerPoint 3.4 Exam||Exam||9|
|PowerPoint 3.5 Assignment A||Assignment||10|
|PowerPoint 3.5 Assignment B||Assignment||10|
|PowerPoint 3.5 Exam||Exam||18|
|PowerPoint 3.6 Assignment A||Assignment||10|
|PowerPoint 3.6 Assignment B||Assignment||10|
|PowerPoint 3.6 Exam||Exam||9|
|PowerPoint 3.7: Assignment A||Assignment||10|
|PowerPoint 3.7: Assignment B||Assignment||10|
|PowerPoint 3.7 Exam||Exam||17|
|PowerPoint 3.8 Assignment A||Assignment||10|
|PowerPoint 3.8 Assignment B||Assignment||10|
|PowerPoint 3.9: Final Assignment||Assignment||50|
|PowerPoint 3.9 Exam||Exam||8|
|Outlook 4.1 Exam||Exam||10|
|Outlook 4.2 Exam||Exam||9|
|Outlook 4.3 Exam||Exam||10|
|Outlook 4.4 Exam||Exam||8|
|Outlook 4.5 Exam||Exam||10|
|Outlook 4.6 Exam||Exam||9|
|Outlook 4.7 Exam||Exam||9|
|Outlook 4.8 Exam||Exam||8|
|Outlook 4.9 Exam||Exam||8|
|Outlook 4.10 Exam||Exam||10|
|Outlook 4.11 Exam||Exam||9|
|Outlook 4.12 Exam||Exam||9|
|Outlook 4.13 Exam||Exam||9|
|Review of Outlook||Exam||58|
- Word 2010$65.001.0 CEUs
- PowerPoint 2013$65.001.0 CEUs
- OneNote 2013$45.000.5 CEUs
- Office 2013: Word, Excel, PowerPoint and Outlook$110.003.5 CEUs
- Microsoft Access 2013$75.001.0 CEUs
- Advanced Excel 2013$75.001.7 CEUs
- QuickBooks 101$80.001.0 CEUs
- Google Analytics 101$70.001.0 CEUs
- Excel 2013$65.001.5 CEUs
- Windows 8$60.000.7 CEUs
- MS Word 2013$60.001.0 CEUs
- Google+ for Business$45.000.5 CEUs
- Microsoft Outlook 2013$45.001.0 CEUs
- Microsoft Publisher 2013$65.001.0 CEUs
- Excel 2010$65.001.0 CEUs
- Typing and Keyboarding 101$60.002.0 CEUs