Microsoft Office 2010 - Interactive Training Programme (Basic, Intermediate & Advanced)

Microsoft Office 2010 - Interactive Training Programme (Basic, Intermediate & Advanced)
£400
Enquire Now

Become a Microsoft Office 2010 power user with this course. Combining five courses into one cost-effective bundle, the Microsoft Office 2010 Online Training course shows students how to master five of the most popular productivity tools in use today – Word 2010, Excel 2010, Outlook 2010, PowerPoint 2010 and Access 2010.

Upon completion of this course, students will have mastered advanced topics around document creation, spreadsheets and calculations, email and scheduling, presentations and desktop databases. Starting with basic concepts before moving on to look at advanced techniques, this course is best suited to:

  • Professionals who need to learn how to be more productive with all five applications that make up Office 2010.
  • Employees who want to deepen their knowledge of the Microsoft Office 2010 suite of applications.
  • Workers and individuals who want to work towards earning the world-famous Microsoft Office Specialist qualification.
  • Employees who need to earn an industry-recognised qualification in using Microsoft Office.
  • Individuals who would like to build up their skills for work or home.

Using a seamless mix of instructor-led videos, hands-on exercises and interactive quizzes the Microsoft Office 2010 Online Training course is delivered online using the learning platform. Using a self-study approach, students can work at their own pace, as and when best suits them. The course materials also provide a handy reference for when they try to apply their new found knowledge at work.

Learners can also repeat modules or practical exercises as many times as they like until confident that they have fully understood each application included in Office 2010. The social networking platform is an excellent resource for seeking help or sharing ideas with other learners.

key learning points

The Microsoft Office 2010 Online Training course is a comprehensive introduction to each of the applications included in the package. Students will learn both introductory and advanced techniques for Word, Excel, Outlook, PowerPoint and Access, giving them an all-round education in office productivity.

The Word 2010 section of the course will teach students all the basics of document creation and editing before moving on to:

  • Building and using templates and the Styles function to streamline document creation.
  • Creating, modifying and sorting tables and columns.
  • Using page headers and footers.
  • Inserting graphics, symbols and charts.
  • Using the Track Changes tools to audit changes made during editing.
  • Using Mail Merge tools to create a set of individualised documents (such as addressed letters) in a single file, and repeating the process to print labels and envelopes.
  • Utilising academic tools to implement referencing, footnotes and indexes.
  • Protecting documents from unauthorised access with encryption and passwords.
  • Working with multiple document formats, including PDF files.
  • Organising long documents using outline view and inbuilt heading tools.
  • Creating forms to collect data.
  • Programming advanced functions with macros and XML.

The Excel 2010 course walks students through the process of creating simple spreadsheets and manipulating figures before looking at a range of advanced techniques including:

  • Create and using a Sparkline to analyse data trends.
  • Filtering data to focus only on the information that matters.
  • Autosizing columns to fit data and improve visibility.
  • Editing and auditing formulae to ensure they continue to generate the required calculations correctly.
  • Freezing panes to help better navigate large spreadsheets.
  • Using Excel spreadsheet data to create charts.
  • Moving and copying cells between sheets.
  • Using the VLOOKUP function to locate key data quickly.
  • Using Paste Special (Transpose Values) to automate data copying.
  • Working with XML Data for use in other applications.
  • Mark the Workbook as Final and Read Only to prevent further editing.
  • Deleting duplicate records to maintain data integrity.

Moving on to Outlook 2010, students will learn:

  • How to read, write, edit and send emails.
  • How to use address lists to choose message recipients, and mail folders to file emails.
  • How to personalise messages with a signature, adding attachments and printing mail.
  • Creating, using, sorting and categorising contacts in the Outlook address book.
  • Working with rules and junk mail folders to streamline and simplify message management.
  • Sending automatic replies, like out of office notices, or requesting read receipts to further simplify messaging.
  • Working with the calendar to plan and arrange appointments, and use the address book to inform invitees and confirm attendance.
  • Using Notes and Tasks to stay on top of other non-mail related jobs.
  • Using the Outlook Journal to track activities and workload.
  • Using data import and export functions to back up important information or transfer data between computers.
  • How to use personal and public files to share messages and information with other Outlook users.

The PowerPoint section of the Microsoft Office 2010 Online Training course also begins with a number of basic concepts before launching into more advanced topics including:

  • Working with text boxes, and formatting text to improve slide appearance.
  • Using shapes, object snapping and WordArt Styles to add visual variety.
  • Moving and copying slides, or creating slide templates to speed up the creation process.
  • Using tables to display data – including tables from other applications like Excel.
  • Adding formatted charts to display data visually.
  • Using video clips and animated pictures to create additional visual interest.
  • Proofing and autocorrection tools to prevent spelling mistakes being left in the final presentation.
  • Using themes, format editing and sections to create a consistent “look” for a presentation.
  • Applying slide transitions, animation effects and object actions to further improve appearance of the slideshow as a whole.
  • Building a slide show and editing the timing to fit with a script and time constraints of the presentation.
  • Adding speaker's notes and comments to the presentation to assist with delivery.

Finally, students will learn about Microsoft Access 2010, the desktop database component of Office 2010:

  • Understanding table creation and design.
  • Finding, editing, sorting and filtering data to highlight key information.
  • Building table relationships and enforcing referential integrity to keep data “clean”.
  • A basic introduction to functions and using the formula creator.
  • Using aggregate functions and totals to simplify calculations.
  • Building forms using the forms wizard to simplify data collection and display.
  • Using form controls to create a true application interface for the database.
  • Building reports, and using calculations and graphics to improve the appearance of data.
  • Building macros and assigning actions to form buttons, increasing the functionality of database applications.
  • Importing and exporting data.
  • Using the SQL language to manipulate data in the database directly.

advantages of this course

The Microsoft Office 2010 Online Training course is designed to help users of any ability get to grips with Office 2010 and master the most advanced techniques to become more productive. By completing this course, learners will not only be more proficient with Word, Excel, Outlook, PowerPoint and Access, but they will also be ready to sit the Microsoft Office Specialist exam.

Among the benefits of the Microsoft Office 2010 Online Training course are:

  • Gaining the skills and experience required to be more efficient when using Office 2010 to create documents, capture numerical data, manage communications, build presentations and analyse datasets.
  • A marked boost in productivity, allowing Office 2010 users to spend more time on other, more profitable tasks.
  • An in-demand skill set that will help learners perform better at work.
  • An in-depth understanding of Office 2010 that can be shared with colleagues to help them be more productive too.

Upon completion of the Microsoft Office 2010 Online Training course, students will have an advanced knowledge of using the Office 2010 productivity suite and will be fully prepared for the Microsoft Office Specialist qualification exam.

Microsoft Access 2010 Online Training
Introduction
In this course, you will become familiar with the basics of using the Microsoft Access program. You will learn how to use and design tables and create various types of queries over them for purposes of an effective information retrieval.

List of Lessons:
  • Introduction to databases
  • The Microsoft Access environment
  • Table creation in datasheet view
  • Table design view
  • Special field types
  • Work within extensive tables
  • Looking up and editing data
  • Data sorting and filtering
  • Designing databases
  • Field selection and data sorting via queries
  • Work with criteria for select queries
  • Calculated items
  • Analysis of table relations
  • Relationships and referential integrity
  • Linked tables in queries
  • Relation features
  • Lookup column
  • Queries with parameters
  • Functions and formula creator
Intermediate
In this course, you will learn advanced techniques of designing tables and queries. You will acquaint yourself in depth with the creation and use of forms.

List of Lessons:
  • Field indexing and data validation
  • Totals
  • Aggregate functions
  • Crosstab query
  • Action queries
  • Data normalization
  • Make Table query
  • Form creation using wizard
  • Working with form
  • Creating forms in design view
  • Working with form controls
  • Calculated form fields
  • Combo Box in forms
  • Option buttons in forms
  • Organising Form fields
  • Creating a Form with a subform
  • Subform insertion in design view
  • Form as a user interface
Advanced
This course focuses on the creation of reports, data access pages and macros. It will also familiarize you with the options for database management, data import and export, as well as with the SQL language.

List of Lessons:
  • Field indexing and data validation
  • Report creation
  • Reports with calculations
  • Graphical editing of Reports
  • Additional report options
  • Pivot table and chart
  • Object dependencies and properties inheritance
  • Macro basics
  • Assigning a macro to a button
  • Data validation using macros
  • Data evaluation via macros
  • Database print and documentation
  • Importing Access Objects and splitting a database
  • Data exporting
  • Program import and export
  • XML format
  • Navigation in a database
  • Security and privacy in databases
  • SQL language
MS Excel 2010 Online Training
Introduction
In this course, you will learn to create tables in the Microsoft Excel program, to enter data in them, to format the data and edit the table format. You will provide calculations through simple functions and formulas and will familiarize yourself with the basics of chart creation and formatting.

List of Lessons:
  • Introduction to Excel
  • Data entry and editing
  • Worksheet navigation and basic settings
  • Cell range selection
  • Manipulation with cell ranges
  • Cell inserting and deleting
  • Text and cell formatting
  • Number, Date and Time format
  • Formatting via style gallery
  • Working with files and windows
  • Printing smaller tables
  • The AutoSum button and formula copying
  • Custom formula creation
  • Work with functions
  • Chart creation
  • Chart formatting
  • Proofing
  • Basic Excel settings
  • Getting help
Intermediate
In this course, you will learn advanced techniques for data processing in Excel (formatting, locking, using templates, advanced copying etc.). You will be creating complex formulas and using functions belonging to the date & time and text categories, as well as the logical, financial and database functions. You will learn how to filter lists on a sheet and create pivot tables. You will also practice advanced chart editing.

List of Lessons:
  • Lock
  • Advanced cell formatting
  • Conditional and custom formatting
  • Templates
  • Workbook properties and work with sheets
  • Sharing workbooks and tracking changes
  • Comments and workbooks comparing
  • Copying options, orders and lists
  • Formula creation and absolute links
  • Errors and formulas dependencies
  • Connected sheets
  • The IF, MIN, and COUNT functions
  • Functions and formulas used for Date and Time data
  • Functions for working with text
  • Rounding off
  • Financial functions
  • Techniques of work with relation tables
  • Data validation and sorting
  • Go To, Find and Replace orders
  • Printing larger tables
  • AutoFilter
  • Criteria table and advanced filter
  • Database functions
  • Outlines and totals
  • Splitting text into columns
  • Pivot table
  • Editing pivot tables and charts
  • Advanced chart editing
Advanced
In this course, you will learn to work with the advanced Microsoft Excel functions for data manipulation and analysis. You will familiarize yourself with macro creation, with the XML format and its use in MS Excel, with protecting and managing permissions for accessing workbooks.

List of Lessons:
  • Work with range names
  • Form creation in a sheet
  • Protection options within workbooks
  • Conditional calculations
  • Conditional calculations using SUMIF and COUNTIF
  • Working with an array
  • Calculation criteria in database functions
  • Using functions for searching in tables
  • Data import
  • Work with Microsoft Query
  • Complicated queries in Microsoft Query
  • Data merging
  • Sheet scenarios
  • Resolver
  • What-if analysis and goal seek
  • Statistical methods and functions
  • Macros recording and usage
  • The VBA code view and editing
  • Webpages, links and e-mail sending
  • File security
  • Permission control
  • Introduction to XML
  • Working with data in the XML format
MS PowerPoint 2010 Online Training
Introduction
This course will teach you how to create presentations containing text, images, charts, tables, organization charts and other elements. You will be using already-prepared slide layouts. You will discover an easy method for how to display a presentation.

List of Lessons:
  • Basic orientation in PowerPoint window
  • Getting help
  • Create a new presentation, work with text boxes
  • Text formatting
  • Text with bullets
  • Shapes
  • Objects snapping and WordArt Styles
  • Clip Art editing
  • Moving and copying slides
  • Slide with a table
  • Tables from other applications
  • SmartArt graphics
  • Other SmartArt types
  • Slide with chart
  • Chart formatting
  • Symbols and equations
  • Video clips and animated pictures
Microsoft PowerPoint 2010 Online Training - Advanced
In this course, you will learn advanced methods for formatting and showing presentations. You will be creating and using templates, color schemes and masters. You will be setting-up the properties for presentations, including transitions, animations, timing and notes. You will learn to review, print, export and import presentations.

List of Lessons:
  • Slide footer
  • Proofing and Autocorrection
  • Themes, format editing and sections
  • Slide background
  • Slide master
  • Slide transitions
  • Animation effects
  • Adding actions to objects
  • Slide show setup and editing timing
  • Slide show options
  • Custom template and theme creation
  • Speaker's notes and comments
  • Print
  • Various save formats and other Backstage options
  • Import
MS Word 2010 Online Training
Introduction
In this course, you will learn how to create and format simple text documents. You will learn how to use correction tools and help. After completing the course, you will know how to set page numbering, how to insert simple headers and footers, and how to print a document.

List of Lessons:
  • Introduction to Word
  • Navigation through the document
  • Text entry
  • Work with a document and multiple document windows
  • Use of automatic corrections and proofing tools
  • Proofing
  • Text selection techniques
  • Text moving and copying
  • Page setup
  • Paragraph formatting
  • Character formatting
  • Document printing
  • Borders and Shading
  • Bulleted and numbered lists
  • Data sorting, Converting text to a table
  • Multi-page document editing
  • Headers and Footers
  • Getting help
Intermediate
In this course, you will learn advanced techniques for data processing in Excel (formatting, locking, using templates, advanced copying etc.). You will be creating complex formulas and using functions belonging to the date & time and text categories, as well as the logical, financial and database functions. You will learn how to filter lists on a sheet and create pivot tables. You will also practice advanced chart editing.

List of Lessons:
  • Lock
  • Basic Word settings
  • Work with document windows
  • Styles
  • Templates
  • Quick Access Toolbar and keyboard shortcuts
  • Table creation
  • Table formatting
  • Table data sorting and calculations
  • Table design
  • Chart creation
  • AutoText
  • Text flow management
  • Searching in a document
  • Tracking changes
  • Document sections
  • Splitting text into columns
  • Graphics in documents
  • Work with symbols
  • Advanced techniques for paragraph numbering
  • Saving a file in various formats
Advanced
In this course, you will familiarize yourself with advanced methods for working with large documents. You will learn to create a table of contents, indexes and tables of figures. You will also be creating envelopes, labels and a catalog making use of mail merge. You will learn how to work with graphics and organization charts. You will understand the basics of creating forms and learn how to use fields in your documents. You will familiarize yourself with creating macros, with the XML format and its usage in MS Word, with security and management of permissions for accessing documents.

List of Lessons:
  • Document headers and sections
  • Showing outline and dividing long documents
  • Master document with subdocuments
  • Table of contents creation
  • Index generating
  • Table of figures
  • Envelopes and labels
  • Form letters in mail merge
  • Work with a data source in mail merge
  • Envelopes and labels in mail merge
  • Catalog
  • Linking and inserting objects
  • Organization chart
  • Cycle diagram and decorative text
  • Drawing and work with graphics
  • Work with fields
  • Footnotes and endnotes
  • Bookmarks
  • Cross-references
  • Hyperlinks
  • Text translation
  • Web presentation
  • Form fields
  • Form protection
  • Macros
  • Protected view and document protection
  • Permission control
  • Office Web Apps
  • Getting to know XML
MS Outlook 2010 Online Training
Introduction
Microsoft Outlook is a program for managing information that will help you to coordinate e-mail messages, calendars, contacts and tasks. This course will provide you with an opportunity to learn how to send, receive and organize messages. You will familiarize yourself with the Outlook folders.

List of Lessons:
  • Introduction to Outlook
  • Reading e-mails and creating new ones
  • E-mail content editing
  • Work with address list
  • Working with Mail folders
  • Searching and categorizing, View settings
  • Conversation View
  • Quick Steps
  • Signature creation, Delivery confirmation
  • Automatic replies
  • Working with rules, Junk E-Mail
  • Creating and using Contacts
  • Sorting and Categorizing Contacts
  • Working with Attachments, Printing
  • Getting help, Junk E-mail filtering
  • Other E-mail options
Microsoft Outlook 2010 Online Training - Intermediate-Advanced
In this course, you will learn how to use the Calendar, Tasks, Journal and Notes folders. Other topics include Outlook settings, import and export options, creation of forms and other advanced skills.

List of Lessons:
  • Working with Calendar
  • Appointment editing
  • Calendar organising and printing
  • Appointment planning
  • Appointment editing and Calendar setting options
  • Editing planned appointments
  • Info sharing with other users
  • Working with Notes
  • Tasks creation
  • Tasks management
  • Working with the Journal
  • Offline Folders
  • Data import and export
  • Personal and public files
  • E-mail account settings
  • Personal forms
Course Code
EC111837
Type
Online Course
Course Access
1 Year
Exams Included
No
Associated Examination
Microsoft Office Specialist Exam
Processor
1 gigahertz (GHz)
RAM
1 GB
Operating Systems
Windows 7
Windows 8
Windows 10
Browsers
Internet Explorer 8 or above
Google Chrome
Safari 6 or above
Mozilla Firefox
Flash Player
Latest version
Windows, Mac