Comprehensive Video Tutorials

MS Office 2007 (MCAS) Beginner to Advanced Online Training Bundle

CareerVision Training
Online

£150 - ($124.101)
+ IVA

Información importante

  • Curso
  • Online
  • Duración:
    Flexible
  • Cuándo:
    A definir
  • Campus online
Descripción

Microsoft Office 2007: MCAS Microsoft Certified Application Specialist Training Bundle:



Word 2007



The Basic Document

Editing a Document

Formatting Text

Formatting Paragraphs

Adding Tables

Controlling Page Appearance

Proofing a Document

Format Document Text

Format a Paragraph

Create a New Style

Insert or Create a Table

Change the Page Appearance

Managing Lists



Customizing Tables and Charts

Customized Formatting

Automating Data Entry

Controlling Text Flow

Drawing

Performing Mail Merges

Automating Common Tasks

Sort and Format a List

Customize a Table

Create Themes and Templates

Create and Use Building Blocks

Change the Document Layout

Use the Mail Merge Wizard

Word and Other Programs



Collaborating on Documents

Versioning

Reference Marks and Notes

Working in Long Documents

Securing a Document

Creating Forms

Using XML in Word

Creating Web Pages

Link or Embed Content

Compare and Merge Documents

Reference Marks and Notes

Create a Table of Contents

Secure a Word Document

Course Summary

Información importante
Instalaciones

¿Dónde se da y en qué fecha?

comienzo Ubicación
A definir
Online

¿Qué aprendes en este curso?

IT
Office IT
Ms Office

Temario

PACKAGE INCLUDES: • Instructor Led Video Training - 12 Months Online On-Demand Access
• Demos and Lab Learning
• Multimedia Presentations and Self-Paced Navigation
• Practice Quizzes

COURSE DESCRIPTION The Microsoft Office 2007 (MCAS) Online Training Package includes expert instructor-led training modules with customized presentations, practice quizzes simulators and learning supplements for an all-inclusive training program that provides all the benefits of classroom training at your own pace.

Our MS Office (MCAS) 2007 Online Training Package includes the following courses:

  • Microsoft Word 2007
  • Microsoft Excel 2007
  • Microsoft Access 2007
  • Microsoft PowerPoint 2007
  • Microsoft Outlook 2007

The Microsoft Certified Application Specialist (MCAS) credential, part of the Microsoft Business Certification program, identifies specific skills covering the most in-demand 2007 Microsoft Office system products—Microsoft Office Word 2007, Excel 2007, PowerPoint 2007, Access 2007, and Outlook 2007—as well as the Windows Vista operating system. The MCAS certification is replacing the Microsoft Office Specialist or MOS certification for the Office 2007 Suite.

Our Office 2007 MCAS Certification training courses prepare students for the MCAS exams by teaching greater skill mastery in each of the individual Microsoft Office 2007 programs. Candidates must pass one or more certification exams in order to earn the MCAS credential. The MCAS exams provide a valid and reliable measure of technical proficiency and expertise in Microsoft Office 2007 or Windows Vista by evaluating the ability to use the advanced features in the products to solve real-world business problems.

We offer individual MCAS certification training courses for Access 2007, Excel 2007, Outlook 2007, PowerPoint 2007 and Word 2007. As a Microsoft Certified Partner, you can be certain that our comprehensive MCAS training program will provide you with all the tools necessary to successfully prepare for your MCAS certification exam(s).

COURSE OUTLINE

Microsoft Office 2007: MCAS Microsoft Certified Application Specialist Training Bundle:

Word 2007

The Basic Document
Editing a Document
Formatting Text
Formatting Paragraphs
Adding Tables
Controlling Page Appearance
Proofing a Document
Format Document Text
Format a Paragraph
Create a New Style
Insert or Create a Table
Change the Page Appearance
Managing Lists
Customizing Tables and Charts
Customized Formatting
Automating Data Entry
Controlling Text Flow
Drawing
Performing Mail Merges
Automating Common Tasks
Sort and Format a List
Customize a Table
Create Themes and Templates
Create and Use Building Blocks
Change the Document Layout
Use the Mail Merge Wizard
Word and Other Programs
Collaborating on Documents
Versioning
Reference Marks and Notes
Working in Long Documents
Securing a Document
Creating Forms
Using XML in Word
Creating Web Pages
Link or Embed Content
Compare and Merge Documents
Reference Marks and Notes
Create a Table of Contents
Secure a Word Document
Course Summary

Excel 2007
New Features
Starting in Excel
Basic Navigation
Working with Data
Formulas and Functions
Formatting Data
Working with Worksheets
Printing
Level Summary
Use AutoSum and AutoFill
Use the Vlookup Function
Use Themes, Styles and Formats
Use Table Styles
Insert Cells, Rows and Columns
Cut, Copy and Paste Cells
Manage Worksheets
Adjust Page Layout

Templates
Sorting and Filtering
Navigating in Excel
Working with Comments
Using Name Box
Controlling and Validating Data Entry
Controlling What You See
Using Drawing Tools
Charting
Level Summary
Create a Hyperlink
Use AutoFilter
Sort Data in a Range or Table
Use the Subtotal Command
Use Advanced Filter
Create a Custom List
Use the Name Box and Go To
Add, Edit, and Delete Comments

Advanced Data Tools
Advanced Formula and Function Tools
Protecting and Reviewing Your Work
Merging and Consolidating
Working with External Data
Macros
XML
Trusting and Privacy in 2007
Excel Options
Level Summary
Use Scenarios
Audit a Formula
Use a PivotTable Report
Consolidate Data
Track and Review Changes
Use Goal Seek
Validate Data
Use Conditional Formatting
Summary


PowerPoint 2007

Starting in PowerPoint
Beginning a Presentation
Formatting Text
Formatting Paragraphs
Preparing to Deliver
Format Slide Text
Create a Presentation
Change a Placeholder
Create and Print Handouts

Adding Tables
Charting in PowerPoint
Inserting Multimedia Objects
Working with AutoShapes
Add and Customize a Table
Insert Graphics in Slides

Powerpoint Masters
Special Effects
Delivering a Presentation
Collaborating in PowerPoint
Securing and Distributing
Create and Modify Masters
Apply Animation Effects
Deliver a Custom Slide Show
Use Comments and Markup


Outlook 2007
Using Outlook
Application Window
Messages
Appointments
Contacts
Tasks
Moving, Copying, and Deleting Items
Printing and Finding Items
Customize the Navigation Pane
Use the To-Do Bar
Create an Email Message
Use the Reading Pane
Attach a File to a Message
Open and Preview Attachments
Create a New Contact
Add a Contact from a Message

Advanced Management
Message Settings
Task Management
Item Organization
Assign Categories to Contacts
Apply a Flag to Mail Items
Customize a Message View
Find a Message using Search
Save a Message as Text
Send a Calendar via Email
Save a Calendar as a Web Page
Use a Distribution List

Options and Customization
Managing Views
Sharing Calendars
Managing Outlook
Security and Privacy
Create a Default Signature
Schedule an Appointment
Create a Recurring Appointment
Schedule a Meeting
Respond to a Meeting Request
Create and Assign a Task
Respond to a Task Request
Create, Delete, and View Notes

Course Summary


Access 2007
Access Basics
Designing a Database
Building a Database
Non-Numerical Data Types
Managing Table Data
Filters and Queries
Using Forms
Producing Reports
Create a Database
Create a New Table
Edit a Relationship
Set Field Data Type
Manage Table Data
Filter a Datasheet
Design a Query
Create a Form
Design a Report

Controlling Data Entry
Finding and Joining Data
Creating Flexible Queries
Enhancing Forms
Customizing Reports
Sharing Access Data
Create a Validation Rule
Join Tables in a Query
Create a Parameter Query
Add Controls to a Form
Create a Grouped Report
Get External Data

Structuring Existing Data
Writing Advanced Queries
Creating and Using Macros
Making Forms More Effective
Improving Reports
Setting Startup Options
Database Maintenance
Distributing and Securing the Database