Microsoft Office 2007

Microsoft Office 2007
£400
Enquire Now

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

Upon completion of this course, students will have mastered the advanced techniques involved in document creation, spreadsheets and calculations, email and scheduling, presentations and desktop databases. Starting with the basic concepts of each package, the bundled courses quickly move on to advanced principles, making this course best suited to:

  • Professionals who need to learn how to be more productive with all five applications that make up Office 2007.
  • Employees who want to learn more about using the Microsoft Office 2007 suite of applications.
  • Workers and individuals who want to develop the knowledge required to earn the world-famous Microsoft Office Specialist qualification.
  • Employees who need to prove their Microsoft Office expertise with an industry-recognised qualification.
  • Individuals who would like to improve their productivity skills for work or home.

Using a blend of instructional videos, hands-on exercises and interactive quizzes the Microsoft Office 2007 course is hosted on the learning platform, allowing students to work at their own pace, as and when best suits them. The online course materials also provide a handy reference for when students try to apply their new found knowledge in the workplace.

Learners can also repeat training modules and practical exercises to ensure that they have fully understood each application included in in the Office 2007 suite. The social networking platform is another excellent resource for seeking help or sharing tips and ideas with other learners.

key learning points

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

The Word 2007 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 2007 course takes students through the process of creating simple spreadsheets and manipulating numerical data 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.

The third course module concerns Outlook 2007, showing students:

  • 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 2007 course will help students build compelling, professional-grade presentaions:

  • 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 be introduced to Microsoft Access 2010, the desktop database component of Office 2007:

  • 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 2007 bundle is designed for complete beginners to get started with Office 2007, before moving on to master the most advanced techniques, helping them 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 2007 package are:

  • Gaining the skills and experience required to be more efficient when using Office 2007 to create documents, capture numerical data, manage communications, build presentations and analyse datasets.
  • A marked boost in productivity, allowing Office 2007 users to spend more time on other, more profitable tasks.
  • An in-demand skill set that will help learners perform better in their jobs.
  • An in-depth understanding of Office 2007 that can be used to provide ad-hoc training to colleagues.

Upon completion of the Microsoft Office 2007 courses, students will have an advanced knowledge of using the Office 2007 productivity suite and will be fully prepared for the Microsoft Office Specialist qualification exam. Completing the Office 2007 course is a pre-requisite for MOS certification.

Microsoft Word 2007 Online Training
Introduction
In this course you will learn how to create and format simple text documents. You will learn to use remedial tools and help. You will also learn how to set-up page numbering, design simple headers and footers and how to print documents.

List of Lessons:
  • Introduction to Word
  • Navigating Your Document
  • Text Entry
  • Working with documents and multiple windows
  • Use of automatic corrections and proofing tools
  • Spell Checking
  • Text Selection Techniques
  • Text moving and copying
  • Page Settings
  • Paragraph Formatting
  • Character Formatting
  • Document Print
  • Borders and Shading
  • Bulleted and Numbered Lists
  • Record sorting, converting text to table
  • Multi-page Document Editing
  • Headers and Footers
  • Using Help
Intermediate
In this course you will learn how to work with styles and templates. You will acquire the requisite knowledge for formatting large documents, for working with tables, including calculations, and working with charts. You will also insert graphics into your documents.

List of Lessons:
  • Basic Word settings
  • Working with document windows
  • Styles
  • Templates
  • Adjustment of Quick Access Toolbar and shortcuts
  • Creating tables
  • Table formatting
  • Sorting and calculations in tables
  • Table design
  • Chart creation
  • AutoText
  • Line and Page Break Management
  • Searching in a document
  • Track changes
  • Document sections
  • Column Sorting
  • Graphics in documents
  • Working with symbols
  • Advanced Techniques for Paragraph Numbering
  • Saving a File in Various FormatsBasic Word settings
  • Working with document windows
  • Styles
  • Templates
  • Adjustment of Quick Access Toolbar and shortcuts
  • Creating tables
  • Table formatting
  • Sorting and calculations in tables
  • Table design
  • Chart creation
  • AutoText
  • Line and Page Break Management
  • Searching in a document
  • Track changes
  • Document sections
  • Column Sorting
  • Graphics in documents
  • Working 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:
  • Headers and sections in documents
  • Showing outline and organizing long documents
  • Master document with collapsed documents
  • Creating a table of contents
  • Generating index
  • Table of figures and table lists and other lists
  • Envelopes and labels
  • Form letters in mail merge
  • Data source used in merge mail
  • Envelopes and labels in mail merge
  • Catalog
  • Linking and inserting objects
  • Organization chart
  • Cycle diagrams and decorative headings
  • Drawing and work with graphic objects
  • Working with fields
  • Footnotes and endnotes
  • Bookmarks
  • Cross-references
  • Hyperlinks
  • Web presentation
  • Fill-in and form fields
  • Lock and print form
  • Macros
  • Document security
  • Permission control
  • Getting to know XML
  • Working with data in XML format
Microsoft Excel 2007 Online Training
Introduction
In this course you will learn how to create Excel tables, to complete them with data, to format this data and to alter the graphic layout of tables. You will be performing calculations using simple formulas and you will familiarize yourself with the basics of chart creation and formatting.

List of Lessons:
  • Introduction to Excel
  • Data inserting and editing
  • Navigating the spreadsheet and basic settings
  • Area selection
  • Area Manipulations
  • Area inserting and deleting
  • Text and Cell Appearance Formatting
  • Number, Date and Time Format
  • Formatting Using Style Gallery
  • Files and Windows Handling
  • Printing Small Tables
  • Calculations using AutoSum and formula copying
  • Custom Formula Creation
  • Using Functions
  • Chart Creation
  • Chart Formatting
  • Spell Checking
  • Basic Excel Settings
  • Using the Help
Intermediate
In this course you will learn advanced techniques for data processing (formatting, locking, using templates, advanced copying etc.). You will be creating more complex formulas and using functions belonging to the date and time and text categories and also logical, financial and database functions. You will learn how to filter sheet records and how to create Pivot Tables. You will also practice advanced chart editing.

List of Lessons:
  • Lock
  • Advanced cell formatting
  • Conditional formatting and custom format
  • Templates
  • Workbook properties and work with sheets
  • Sharing and merging workbooks
  • Comments and comparing workbooks
  • Copying options, orders and lists
  • Creating Formulas and Absolute Links
  • Errors and Dependencies of Formulas
  • Connected Sheets
  • The IF, MIN and COUNT functions
  • Functions and formulas for working with date, time
  • Functions for working with text
  • Rounding off
  • Financial Functions
  • Relation table techniques
  • Validation and sorting
  • Go to, find and replace
  • Printing large tables
  • AutoFilter, lists
  • Criteria tables and advanced filter
  • Database functions
  • Outlines and totals
  • Splitting text into columns
  • Pivot Table Creation
  • Editing Pivot Tables and Pivot Chart
  • 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 creating macros, with the XML format and its use in MS Excel, with security and management of permissions for accessing workbooks.

List of Lessons:
  • Work with Area Names
  • Creating a Form in a Sheet
  • Protection Options and Embedded Objects
  • Conditional Calculations
  • Conditional Calculations - SUMIF and COUNTIF
  • Working with an Array
  • Calculation Criteria in Database Functions
  • Searching in Tables by Using Functions
  • Data Import
  • Working with Microsoft Query
  • Microsoft Query Program - Complicated Queries
  • Merging Data
  • Sheet Scenarios
  • Solver
  • What-if Analysis and Goal Seek
  • Statistical Methods and Functions
  • Use and Recording of Macros
  • View and Editing VBA Code
  • Web Pages, Links and E-mail Sending
  • File Security
  • Permission Control
  • Introduction to XML Format
  • Working with Data in XML Format
Microsoft Powerpoint 2007 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
  • Working with Help
  • Using AutoCorrect and AutoFormat Tools
  • Spell Check
  • Creating Presentation and Working with Text Boxes
  • Creating a New Presentation and Text Formatting
  • Text with Bullets
  • Automatic Shapes
  • Advanced Configuration of Graphic Objects
  • Pictures and working with multiple presentations
  • Movieclips and Animated Pictures
  • Slide with Table
  • Tables from Different Applications
  • Slide with a Chart
  • Chart Formatting
  • Organization Chart
  • Cycle Chart
  • Charts, Objects and Symbols
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:
  • Default Templates and Editing Formatting 
  • Changing Font Type and Format Copy 
  • Slide Background 
  • Slide Master 
  • Slide Footer and Slide Numbering 
  • Preparation of your own Template for Presentations 
  • Slide Transitions 
  • Animation Effects 
  • Presentation Set-up and Timing Adjustment 
  • Assignment of Action to Object 
  • Slide Show Options 
  • Publishing a Presentation as a Web Page 
  • Presentation Revision 
  • Print 
  • Import 
  • Saving Presentations in Various Formats 
Microsoft Outlook 2007 Online Training
Introduction
MS 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 a new message
  • Editing messages
  • Address List
  • Working with folders
  • Categorizing, searching for message, defining view
  • Creating signatures, request for confirmation
  • Out of Office Assistant
  • Working with rules, junk e-mail
  • Creation and use of Contacts
  • Sorting and organizing contacts
  • Working with attachments and print
  • Using Outlook Help, Junk E-mail Filter
  • Other e-mail options
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:
  • Event Planning
  • Event Editing
  • Calendar Organization and Printing
  • Meeting Arrangement
  • Times of Meetings, Options for Calendar Settings
  • Editing Arranged Meetings
  • Sharing Information with other Users
  • Notes
  • Creating and Managing the Tasks
  • Task Management
  • Working with Journal
  • Offline Folders
  • Data Import and Export
  • Personal and Public Folders
  • Setting for E-mail Accounts
  • User Forms
Microsoft Access 2007 Online Training
Introduction
This course will help you to understand the basics of using MS Access. You will learn to design and use tables and to create various types of queries over them for effective information retrieval.

List of Lessons:
  • Introduction to databases
  • Becoming familiar with Access
  • Designing databases
  • Creation of a table in the datasheet view
  • Table design view
  • Special field types
  • Working with a table
  • Looking up and editing records
  • Filtering and sorting records
  • Fields selection and records sorting with a query
  • Working with criteria for the select query
  • Creating calculated items
  • Linked tables in queries
  • Analysis of relationships between tables
  • Relationships and referential integrity
  • Lookup column
  • Overviews
  • Queries with parameters
  • Action queries
  • Crosstab query
Intermediate
In this course you will learn advanced methods for designing tables and queries. You will acquaint yourself in depth with the creation and use of forms.

List of Lessons:
  • Joins and their properties
  • Functions and Expression Builder
  • Aggregate functions
  • Data normalization
  • Create queries
  • Field indexing and data validation
  • Creating a form by using the wizard
  • Working with forms
  • Creating a form in design view
  • Working with form controls
  • Calculated items in the form
  • A combo box in the form
  • Buttons in the form
  • Organizing fields in the form
  • Creating a form with a subform by using wizard
  • Inserting subforms in the design view
  • A form as a user interface
Advanced
This course focuses on the creation of reports, data access pages and macros. You will also learn about the options for database management, for data import and export and also about SQL language.

List of Lessons:
  • Dependent objects and property inheritance
  • Creating reports
  • Reports with calculations
  • Graphic adjustments in reports
  • Pivot table and chart
  • How to work with macros
  • Matching macros and buttons
  • Verifying data by means of macros
  • Evaluating data by means of macros
  • Print and database documenter
  • Importing objects and splitting the database
  • Data export
  • Automatic import and export
  • XML Format
  • Navigation in databases
  • Database security and administration
  • SQL language
Course Code
EC111838
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