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 –...
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you
We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.
Thank you!
We are reviewing your question. We will publish it shortly.
Or do you prefer the center to contact you?
Reviews
Have you taken this course? Share your opinion
Subjects
Microsoft Office
Import
Ms Office
Design
Office IT
XML
XML training
Options
Presentation
Course programme
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
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
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
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
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
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
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
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
Introduction to Outlook
Reading e-mails and creating a new message
Editing messages
Address List
Working with folders
Categorizing, searching for message, defining view
