Sign-up today to join over 5 million learners already on ALISON:

Microsoft Office 2010 Course


Microsoft Office 2010
Microsoft Office 2010

Learn Microsoft Office 2010 by getting trained in Word, Excel, PowerPoint, Outlook and Access.


Join 30,249 other students.

Course Description

This free online computer skills course is a highly demanded compilation of web-based training for five Microsoft Office 2010 software products including Word, Excel, PowerPoint, Access and Outlook.


This is a perfect course if you want to enhance your existing office skills using this software; as a new employee induction training program; or for companies wanting to up-skill their current staff.


People who use older versions of Microsoft Office, particularly 2003 and 2007 versions, will be amazed at the new feature sets of Microsoft Office 2010!


For those who have completed ABC IT, our comprehensive introductory computer course, the Microsoft Office 2010 course is the perfect next step as a means of getting your Microsoft Office skills up-to-date.

Certification

To qualify for your official ALISON Diploma, Certificate or PDF you must study and complete all modules and score 80% or more in each of the course assessments. A link to your Diploma certificate will then appear under the My Certificates heading of your My Account page.

Learning Outcomes

Learning outcomes: - Familiarity with the new layout and interfaces of Word 2010; - Knowledge of the new formatting features in Word 2010; - Ability to complete basic functions of Word 2010; - Use the Navigation Pane to manage headings and find objects and text; - Create visually effective content without using other software; - Manage Header and Footer content and update page numbers and dates; - Insert complete Table of Contents for large documents; - Create easily assessable documents for e-reader software; - Understand the shortcuts and useful features of Word 2010; - Comfortably use keyboard short cuts with Access Keys and Key Combos; - Understand how to navigate the menu; - Learn about the improvements and new features of the software; - Create, save, prepare for printing and apply templates to a worksheet; - Work with formulas and functions; use VLOOKUP to search through the data in the spreadsheet; - Determine patterns and trends with conditional formatting, Sparklines and charts; - Apply a table to the data; check conditions with the IF function; - Understand, save and run macros; figure out dates using formulas and work quicker with keyboard shortcuts; - Create, manage, and collaborate with other people; - Separate PowerPoint presentation files in different windows; - Enrich your presentations with video, picture, and animations; - Embed, edit, and play a video in your presentation; - Trim an audio or video clip; - Use bookmarks in your audio and video clips; - Use transitions with 3-D motion graphic effects; - Copy and paste animated effects from one object to another; - Deliver and share your presentations more effectively; - Broadcast your slide show; - Identify and resolve accessibility issues; - Use database templates; - Plan for good design; - Learn about keys and data types; - Create tables; Save add and navigate data; - Create relationships between tables; - Set referential integrity; - Create queries and lookup fields; - Learn about and create different types of forms in different ways; - Learn to work in layout view; - Create reports for your database; - Build and work with online databases; - Create and publish web databases; - Save a changed database to the web; - Learn keyboard shortcuts and access keys; - Learn to work with security protocols; - Create, manage, and organize email and contacts; - Save time with Outlook Calendar; - Organize your time more easily with meeting requests; - Organize messages and Automatic Replies; - Enrich your emails with electronic business cards and e-mail signatures; - Use conversation view to eliminate excess emails in your inbox; - Maximize your time with Quick Steps; - Stay connected with the new Outlook Social Connector; - Manage your information and create RSS web feeds; - Use Instant Search to quickly locate a file; - Speed up your email with efficient attachments; - Create Templates to use again and again.


Manage a Group of Learners

Share This Course!

 
Module Title
Module 1: Making the switch to Word 2010
Module 2: What's New in Word
Module 3: Creating Your First Word Document
Module 4: Explore Your Document using the Navigation Pane
Module 5: Create Visually Compelling Documents
Module 6: Get Control of Page Numbers, Headers, and Footers
Module 7: Create and Customize a Table of Contents
Module 8: Create Accessible Documents
Module 9: Word 2010 Tips and Techniques
Module 10: Keyboard Shortcuts
Module 11: Microsoft Office 2010 Security
Module 12: Microsoft Word 2010 Assessment
Module 14: Make the Switch to Excel 2010
Module 15: What's New in Excel 2010
Module 16: Basic Tasks in Excel 2010
Module 17: Get to Know Excel 2010 - Create Your First Spreadsheet
Module 18: Get to Know Excel 2010 - Create Formulas
Module 19: VLOOKUP - What It Is and When to Use It
Module 20: Understand Data at a Glance with Conditional Formatting
Module 21: Sparklines - Use Tiny Charts to Show Data Trends
Module 22: Use Excel Tables to Manage Information
Module 23: The IF Function - What It Is and How To Use It
Module 24: How to Create a Basic Chart in Excel 2010
Module 25: Save Time by Creating and Running Macros in Excel 2010
Module 26: Figure Out Dates by Using Formulas in Excel 2010
Module 27: Plan Payments and Savings in Excel 2010
Module 28: Keyboard Shortcuts in Excel 2010
Module 29: Microsoft Excel 2010 Assessment
Module 31: Making the Switch to PowerPoint 2010
Module 32: What's New in PowerPoint 2010
Module 33: Create Your First PowerPoint 2010 Presentation
Module 34: Add Photos to PowerPoint
Module 35: Insert Video into a Presentation
Module 36: Broadcast a Presentation
Module 37: Charts and SmartArt in PowerPoint
Module 38: Animations and Transitions
Module 39: Keyboard Shortcuts
Module 40: PowerPoint Tips and Techniques
Module 41: Microsoft PowerPoint 2010 Assessment
Module 43: Making the Switch to Microsoft Access 2010
Module 44: Design and Create New Tables for a Database
Module 45: Create Relationships and Queries for a New Database
Module 46: Create Forms and Reports for a New Database
Module 47: Build and Publish Web Databases
Module 48: Access 2010 Keyboard Shortcuts
Module 49: Microsoft Access 2010 Assessment
Module 51: Making the Switch to Outlook 2010
Module 52: What's new in Microsoft Outlook 2010
Module 53: Get Familiar with the Outlook Calendar
Module 54: Manage Your Information and Create RSS Web Feeds
Module 55: Organize Messages and Automatic Replies
Module 56: Electronic Business Cards, E-mail Signatures and Instant Search
Module 57: Organize with Templates and Views
Module 58: Microsoft Outlook 2010 Assessment
Module 60: Microsoft Office 2010 Training - Final Assessment

Study for Free at Your Own Pace! Start This Course

Course Rating (By Learners): 4 stars based on 390 reviews
Course Title: Microsoft Office 2010
Course #: 460
Course Publisher: Microsoft
Course Category: 1
Content Origin:
Course Description:

This free online computer skills course is a highly demanded compilation of web-based training for five Microsoft Office 2010 software products including Word, Excel, PowerPoint, Access and Outlook.


This is a perfect course if you want to enhance your existing office skills using this software; as a new employee induction training program; or for companies wanting to up-skill their current staff.


People who use older versions of Microsoft Office, particularly 2003 and 2007 versions, will be amazed at the new feature sets of Microsoft Office 2010!


For those who have completed ABC IT, our comprehensive introductory computer course, the Microsoft Office 2010 course is the perfect next step as a means of getting your Microsoft Office skills up-to-date.

License: Not for download or distribution.
Release Date: 18 April 2013
Content  
Course Duration (Avg Learner): 15-20 Hours
Video/Audio: High
Audio Only: High
Animation: None
Assessments: Yes
Education Level
Age appropriateness: 16+ Years
Minimum Grade/Class Level:
Validation: Level 5
ALISON Testing: Yes
Certification Availability
PDF Download: Yes
Parchment: No
Framed Certification: No

Study for Free at Your Own Pace! Start This Course

  • Imran Shehzad
    Imran Shehzad Pakistan This course is extremely amazing, I have got more experience 2015-08-14 21:08:31
  • Francisco Fernandes
    Francisco Fernandes Angola I've been looking for this oportunity. You're welcome now to allow me study now. It can help many people whole over the world. 2015-07-22 16:07:53
  • Didas Mzirai
    Didas Mzirai Kenya It was really a challenging as well as an exciting experience for me. You really have to pass with more than 80% to go to the next level. Combining it with work, I had to use more than 46 hours. But it is really worth it 2015-03-20 21:03:34
  • Amylyn Reynolds
    Amylyn Reynolds Thailand Great! Very comprehensive. 2015-03-07 14:03:05
  • Calvin Eliphas
    Calvin Eliphas Nigeria First I must appreciate this body (ALISON), this is the second course i have undertake and I most sincerely say is though but educative, am grateful for this opportunity... 2015-03-05 13:03:10
  • Benny John
    Benny John Ireland A great course! Presentations are wonderful. 2015-02-28 22:02:44
  • Eve O' Leary
    Eve O' Leary Canada Excellent course, Very in-depth and very knowledgable 2015-02-05 17:02:55
  • Martin Akinwale
    Martin Akinwale United Kingdom I really do enjoy this course not as easy as I thought it would but it is a good background knowledge for office 2013 2015-02-04 19:02:28
  • Joann Sparks
    Joann Sparks United States of America I thought that this was a very thorough course. I enjoyed the course. Thank you, Joann Sparks 2015-01-27 22:01:57
  • Martin Akinwale
    Martin Akinwale United Kingdom This course is very helpful in more ways than one so in depth and easy to follow 2015-01-24 00:01:08
More Comments and Reviews >>

Study for Free at Your Own Pace! Start This Course

Free, Online Microsoft Office 2010 Course.