Sign-up today to join over 8 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 59,783 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 purchase 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.

Share This Course!






Manage a Group of Learners
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 599 votes
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

  • Augustine Obemu
    Augustine Obemu Uganda This is good leaning course, it make you play around with computer, wonderful course. Alison keep it up. I have enjoy the course so much. 2016-07-15 16:07:11
  • IRENE FRANKS
    IRENE FRANKS United Kingdom I am finding this course very difficult - the reason being that I am hearing impaired so rely on sub-titles to follow the videos unfortunately, they are not provided with this course, so I am having to keep going over and over the videos until I can understand what is being said. It is very demoralising when you are prevented from progression through the course because of one simple thing missing - it is with other courses, so not sure why it has not been considered with this course. It is such a shame because it is taking me so long to do each video that I am exhausted and therefore have taken a break to recover - hopefully, this extended break will enable me to work a bit quicker but I will still struggle with the videos until I get text. I have asked about this, but have not received a response, so perhaps the contact form went amiss. It is a shame that Microsoft don't provide a simulator with this course so that we can do the relevant tasks within the course and gives practice along the way. Not everyone can afford to keep buying new Office suites everytime they come out and some of us like the variation we have. I preferred Office 2003 but have progressed to Office 2007 and some of the features in Office 2010 are appealing but I don't want to start adding more software when the one I have works! I am doing this course in preparation for my new job, which may have this software installed. If it was not for the sub-title issue, I would definitely give the course a high rating but as it is for me, I would only give it mid-way score purely based on the difficulties I am experiencing and the time I am having to spend just to understand what is being said. However, the course provides excellent knowledge, skills (when you can practice on the actual package) and understanding of the Office suite and is a distinct advantage for the CV and I would recommend that you do the course. 2016-06-19 23:06:23
  • Sharon Preville
    Sharon Preville United States of America Test too diffcult. 2016-05-15 01:05:43
  • Somen Das
    Somen Das United States of America This is the best learning site I have ever used in my life. 2016-05-12 22:05:56
  • Joseph Kline
    Joseph Kline United States of America Great' except it was removed! 2016-04-29 15:04:11
  • KIMBERLY JOHNSON
    KIMBERLY JOHNSON United States of America Interesting 2016-04-20 19:04:14
  • Ayisha Northam
    Ayisha Northam United Kingdom This course was extremely helpful for me. I had some doubts because the course was free but that has long gone. I recommend this course for anyone who wants to learn more about Microsoft Office 2010. 2016-04-19 19:04:12
  • Tumelo John Tsoeu
    Tumelo John Tsoeu South Africa What an excellent, exciting and most convenient way to work through the computer. 2016-03-11 14:03:15
  • ROBERT EATON
    ROBERT EATON United States of America This was a very comprehensive course. It will enhance my ability to use MS Office. I'm very glad I took this course! 2016-02-07 01:02:42
  • Olutayo Ekundayo
    Olutayo Ekundayo Nigeria Good work 2016-02-06 17:02:48
More Comments and Reviews >>

Study for Free at Your Own Pace! Start This Course

Free, Online Microsoft Office 2010 Course.