The Microsoft Office Suite is a must for almost everyone in an office setting. The online Microsoft Office 2010 certification bundle designed by IT University Online helps gain the skills and certification students need to enhance their resume and increase marketability.

The deal:

• $39 for an online Microsoft Office 2010 certification bundle ($437.55 value)

Beginners and advanced students take the course at their own pace by accessing its online content anytime they want for one year. They learn to master Word, Excel, PowerPoint, Access and Outlook 2010.

Functions of each of the five programs are addressed: layout, using worksheets, creating tables and charts, managing database, keyboard shortcuts, etc. Course reviews at the end of each chapter and module help students assimilate the course content. Designed by professionals in the IT industry who have a minimum of fifteen years of experience, the course content includes multimedia presentations based on real-world scenarios that focus on skill-set development, as well as exercises and exam simulators to prepare students for their exams and assess their progress.

Syllabus

Word 2010

• Introduction
• Basic file commands and operations
• Creating, managing and formatting content
• Tables
• Applying page layout and reusable content
• Including illustrations and graphics in a document
• Proofreading documents
• Applying references and hyperlinks
• Mail merge
• Customize the Word Interface
• Course review

Excel 2010

• Introduction
• Basic file commands and operations
• Creating, managing and navigating the worksheets
• Entering and managing worksheet data
• Formatting cells and worksheets
• Applying formulas and functions
• Analyzing and organizing data
• Naming and hyperlinks
• Displaying data visually using charts
• Preparing to print and printing
• Share worksheet data with other users
• Including illustrations and graphics in a workbook
• Customize the Excel interface
• Course review

PowerPoint 2010

• Introduction
• Beginning a presentation
• Beginning a new presentation
• Formatting text
• Preparing to deliver a presentation
• Working with table and charts
• Using multimedia in presentation
• Working with Autoshapes
• Managing PowerPoint Masters
• Special effects through animation
• Delivering a presentation
• Collaborating in PowerPoint
• Securing and distributing the presentation
• Course review

Access 2010

• Introduction
• Access basics
• Designing a database
• Building a database
• Managing table data
• Creating selection queries
• Creating and managing forms
• Creating and managing reports
• Controlling data entry
• Finding and joining data
• Creating flexible queries
• Enhancing forms
• Customizing reports
• Sharing access data
• Structuring existing data
• Writing table queries
• Using macros
• Making forms more effective
• Improving reports
• Creating a startup interface
• Database maintenance
• Distributing and securing a database
• Course overview

Outlook 2010

• Introduction
• Introducing the interface
• Working with mail items
• Common actions
• Working with calendar items
• Working with contact items
• Working with task items
• Organizing items
• Advanced message management
• Managing data files
• Security and privacy
• Course overview

Regular rates checked on August 11, 2014.