» »

Microsoft Office 2010

Course

ID: 460 | Video: High | Audio: High | Animation: None

Equivalent to FETAC: Level 5 | Equivalent to QCF (UK): Level 3

Start Course

Learn the fundamentals of the Microsoft Office 2010 suite of programmes

By Publisher: Microsoft | Factsheet

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.

Modules in Microsoft Office 2010

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
Learning Outcome

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.

Start Course

Comments & Reviews

  • Shelley Sonnier - United States of America

    2013-01-13 15:01:16

    Course Module: Module 1: Making the switch to Word 2010
    Course Topic: Acquaint yourself with the ribbon
    Comment: Very easy to understand, very detailed on each use of microsoft office 2010.

  • Khairulaman Sabir M Usman - Saudi Arabia

    2012-12-09 12:12:54

    Course Module: Module 4: Explore Your Document using the Navigation Pane
    Course Topic: Explore your document using the Navigation Pane
    Comment: No voice or pointer of elaboration for the course. This course is different from the MS excel course which I took earlier.

  • Meha Shah - Australia

    2012-11-19 11:11:34

    Course Module: Module 1: Making the switch to Word 2010
    Course Topic: Making the switch to Word 2010
    Comment: fast access keys are very usefull

  • Muhammad Asad Khan - United Kingdom

    2012-11-11 20:11:50

    Course Module: Module 60: Microsoft Office 2010 Training - Final Assessment
    Course Topic: Microsoft Office 2010 Training - Final Assessment
    Comment: Some contents do not load in safari

  • Olpha Pomells - United Kingdom

    2012-11-07 22:11:32

    Course Module: Module 49: Microsoft Access 2010 Assessment
    Course Topic: Microsoft Access 2010 Assesssment
    Comment: I have completed my Microsoft access asessment and score 80%