PRODUCT INFO
 
Shipping Information
Product Guarantee
Testimonials
 
MAIN LINKS
 
Training Categories
New Titles
In Development
Free Online Demos
Multi User Training CDs
Contact Us
 


This Week's Special Offer

NEW TITLE DISCOUNT!
Adobe Photoshop CS5 Tutorial


Quicktime is required for the movies,
click here to download if needed.

Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.


- See right for full details on this Microsoft Certified Application Specialist Tutorial

- See far right to purchase this Microsoft Certified Applications Specialist Training CD (MCAS Tutorial)

Microsoft Certified Application Specialist Tutorial
 Professionally created, self-study video training.

About this Tutorialshow details
This easy-to-follow, self study MCAS tutorial is the ideal learning resource for this taking any of the Microsoft Certified Application Specialist exams. Presented by Microsoft Office expert Lauri Matson, he uses step-by-step video training movies to guide users through the key skills and "real world" uses of Microsoft Word 2007, Access 2007, Excel 2007, PowerPoint 2007, Outlook 2007, and MS Windows Vista. This training course will prepare you for the MCAS exams 77-600 through 77-605 and demonstrate the know-how required in each of the Microsoft Office 2007 programs to achieve the maximum level of performance and efficiency. You can start learning right now, click any of the blue linked lessons below for FREE MCAS video training movies...
Learn this Software - See below for FREE TUTORIALS

Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on all Orders


Microsoft Certified Application Specialist (Exam 77-600 to 77-605) Tutorial Info

CLICK HERE TO BUY THIS CD
Tutor: Lauri Matson
Duration: 9.5 hrs / 127 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 33988
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Don't take our word for it, see our Customer Testimonials


Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers guide you using simplistic terms and minimal jargon.
  Personal Tutoring - Step-by-step video training from your own desktop. Delivered via DVD/CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses, seminars & classes.
  Jump to and from lessons - learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals.
Customer Testimonials
Associated Training CDs:
Microsoft Visio 2010 | Complete Range of Microsoft Access Tutorials | Complete Range of Microsoft Excel Tutorials | Complete Range of Microsoft Word Tutorials | Complete Range of Microsoft PowerPoint Tutorials | Complete range of Microsoft Outlook Tutorials | MCTS Certification Exam 70-642
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Introduction
MCAS Certification
Getting Started
Understanding IRM
Using the Work Files

MCAS Vista Exam (77-600)
Manage Windows Firewall
Internet Explorer Security
Securing User Accounts

Remote Computing
Network Terminology
Network Connections
Collaboration with Meeting Space
Managing Remote Access

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below, please purchase the CD.
CLICK HERE TO BUY THIS CD

Customizing Devices
Devices & Drivers
Personalize Display Settings/Appearance
Personalize Other Settings
Start Menu/Taskbar/Notification Area
Sidebar

Files & Folders
Windows Explorer
Manage & Secure Folders
Advanced Searching
Sharing Files
77-600 Exam Review Questions

MCAS Word 2007 Exam (77-601)
Create & Customize Documents
Page Layout: Personalization
Page Layout: Columns/Arrange/Headers/Footers
Pagination/Options/Settings

Visual Content
Illustrations: Pictures & Shapes
Illustrations: SmartArt Diagrams
Format Text Graphically
Insert & Modify Text Boxes

Organizing Content
Structure Content by Using Quick Parts
Tables & Lists
Margins & Tabs
References & Captions

Reviewing Documents
Navigating Your Documents
Tracking Changes & Comments
Compare & Combine Documents

Sharing & Collaboration
Prepare Documents for Sharing
Access & Security
Permissions/Information Rights Manager
77-601 Review Questions

MCAS Excel 2007 Exam (77-602)
Manipulating Data - Lesson 1
Manipulating Data - Lesson 2
Data Validation & Integrity
Using Auto-fill
Themes & Styles

Formulas & Functions
Reference Data in Formulas
Working with Formulas
Summarize Data with Functions
Conditional Logic (IF Statements)

Presenting Data Visually
Conditional Formatting
Create & Format Charts
Charting Continued
Sort & Filter
Outlining & Subtotals

Collaborating & Securing Data
Track Changes
Preparing for Distribution
Print Options

Advanced Features
External Data
Saving & File Formats
77-602 Review Questions

MCAS PowerPoint 2007 Exam (77-603)
PowerPoint Views
New Presentations
Using Masters
Elements & Arrangements

Slide Content
Insert & Format Text Boxes
Manipulate Text
Linking Content

Working with Visual Content
SmartArt Diagrams
Picture Styles
Formatting Pictures
Shapes & Other Techniques
Charts & Tables

Collaborating & Delivering Presentations
Review Presentations
Secure & Share Presentations
Printing Presentations
Timing & Rehearsal

Animation
Applying Animation to Text
Applying Animation to SmartArt
Working with Transitions
77-603 Review Questions

MCAS Outlook 2007 Exam (77-604)
Navigation
Outlook Today & Mail
Attachments
Signatures
Security & Digital Signatures

Scheduling
Appointments & Events
Meetings & Recurring Items
Calendar Settings
Sharing Calendar

Tasks
Task Terminology
Create/Modify/Complete Tasks
Assign/Update/Respond to Tasks

Contact Information
Terminology: Books/Lists/Folders
Create & Modify Contacts
Working with Business Cards
Creating a Distribution List

Organizing Information
Customizing Views
Using Instant Search
Folders & Junk Mail
Rules to Organize Messages
77-604 Review Questions

MCAS Access 2007 Exam (77-605)
Database Design: Data Needs & Types
Primary Keys
Table Relationships
Split Databases

Database Elements
Getting Started
Security Settings
Tables & Fields
Creating Forms
Forms Continued
Using Reports
Designing Reports

Advanced Features
Navigation Pane
View Relationship
Import Files
Export Tables/Queries
Pivot Charts & Tables

Queries
Create Queries
Modify Queries
Macros & Coding

Managing Databases
Print Database Objects
Splitting a Database
Database Administration
77-605 Review Questions

Conclusion
Tips for Taking the Exam
Exam Objectives & Questions
About the Author
MCAS Course Wrap

CLICK HERE TO BUY THIS CD


  UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841

  US & Canada
Marrutt Software Training
244 5th Ave # 1877
New York, NY 10001
United States
US Tel: 646-736-7932
US Fax: 646-895-7649