Self Study, Microsoft Certified Application Specialist Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

This highly effective Microsoft MCAS Tutorial Video course offers a great learning tool and practice aid for users studying for any of the Microsoft Certified Application Specialist exams. Covering tests 77-600 to 77-605, users will learn what they need to know to receive certification in Microsoft Word 2007, Excel 2007, PowerPoint 2007, Outlook 2007, Access 2007 and Windows Vista. Taught by longtime software and Microsoft productivity expert Lauri Matson, the course is meant to take users who are already familiar with the programs and help them prepare for the requirements of the Microsoft Certified Application Specialist ( MCAS ) certified test. The training is divided into subject-specific video tutorials, so users who do not need to study for all of the exams can easily watch only the lessons they need. Available both online via subscription or as one package on CD / DVD, this is a convenient resource for anyone preparing for the Microsoft Certified Application Specialist exam. The video tutorial is Mac and Windows compatible, so you can watch it from the comfort of your own desk or from virtually any computer.

Associated Tutorials: Microsoft Visual Studio 2008 | Microsoft Office | MCTS Exam 70 642 | MS Word 2010 Tutorial | Microsoft Outlook 2010 Tutorial | Microsoft Access 2010 | Microsoft SharePoint 2010 (70-667) | Cisco ICND2 (Exam 640-816)

Microsoft Certified Application Specialist Tutorial CD / DVD

When you order this MCAS Video Tutorial CD You'll Receive...
Over 9.5 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn MCAS from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" I used to use Excel on a daily basis but hadn't touched in years...Got a new job where I had to use it again and your tutorial got me back to where I was and then some in just a matter of days. "Barry Eastment, Florida

MCAS Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 9.5 Hours in Duration and Covers 127 Lessons.
Welcome Topics for the Windows Vista Test (77-600) Fnndamentals of Remote Connection and Computing
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
Basics of Device Management
  • Working with Device Manager
  • Windows Customization Features
  • Other Personalization Options
  • Customizing the Start Menu/Taskbar/Notification Area
  • Using the Windows Sidebar
Understanding Windows Files & Folders
  • Using Windows Explorer
  • Windows Folder Features
  • Vista Searching Capabilities
  • Using Public Folders
  • 77-600 Exam Problems
MS Word 2007 Exam Problems (77-601)
  • How to Create Documents and Customize Settings
  • Customizing Your Page Layout
  • Page Layout Setup and Arrangement Options
  • Document Interface Options
Including Visual Elements
  • Working with Pictures & Shapes
  • Workign with SmartArt Diagrams
  • How to Format Text as Graphics
  • Creating & Editing Text Boxes
Document Organization
  • Organizing with the Quick Parts Tool
  • Tables & Lists
  • Working with Margins & Tabs
  • Including References & Captions
Options for Reviewing Word Documents
  • Navigating Your Documents
  • Tracking Changes & Comments
  • Compare & Combine Documents
Sharing Word Documents and Collaboration
  • Preparing a Document for Sharing
  • Security & Access Options
  • Managing Document Permissions
  • 77-601 Exam Problems
Understanding the Excel 2007 Text (77-602)
  • Data Manipulation Video One
  • Data Manipulation Video Two
  • Checking Data and Maintaining Integrity
  • Working with Auto-fill
  • Excel Theme & Style Options
Working with Formulas & Functions
  • Understanding Data Referencing in Excel
  • Understanding Excel Formulas and Functions
  • Using Functions to Summarize Data
  • Understanding Conditional Logic (IF Statements) in Excel
Understnding Visual Presentation in Excel
  • Using the Conditional Formatting Feature
  • Creating and Setting Up Charts
  • Workign with a Single Point Chart
  • Working with the Sorting & Filtering Features
  • Using Outlining & Subtotals Features
Collaboration and Data Security in Excel
  • Working with the Track Changes Feature
  • Preparing to Distribute a Workbook
  • Understanding Excel Print Options
Advanced Excel Tools
  • Importing/Exporting Data
  • Working with Excel File Formats
  • 77-602 Exam Problems
Understanding the PowerPoint 2007 Test (77-603)
  • Understanding PowerPoint Views
  • Creating a New Presentation
  • Working with Masters
  • Basic Powerpoint Elements & Arrangements
Creating Slide Content
  • Working with Text Boxes
  • Editing Text
  • Including Web Links
Working with Graphic Content
  • Including SmartArt
  • Understanding Picture Styles
  • How to Format Images
  • Working with Geometric Shapes & Other Techniques
  • Including Tables & Charts
Collaboration & Presentation Features
  • About Powerpoint's Review Features
  • Permissions & Security Options
  • Powerpoint Print Options
  • Preparing to Give a Powerpoint Presentation
Including Animation
  • How to Animate Text
  • How to Animate SmartArt
  • Utilizing Transition Features
  • 77-603 Exam Problems
Understanding the Outlook 2007 Test (77-604)
  • Navigating the Outlook UI
  • Understanding Outlook Today & Mail
  • Understanding Attachments
  • Applying Signatures
  • Security Features & Applying Digital Signatures
Scheduling Features
  • Creating Appointments & Events
  • Setting Meetings & Creating Recurring Events
  • Calendar Customization Options
  • Sharing Calendar
Working with Outlook Tasks
  • Understanding Task Terminology
  • Using the Tasks Feature
  • Task Delegation Options
Understanding Contact Information
  • Working with Books/Lists/Folders
  • Creating and Editing Contacts
  • Utilizing Business Cards
  • Utilizing Distribution Lists
Organizing Information
  • View Customization Options
  • Utilizing the Instant Search Feature
  • Working with Folders & Junk Mail
  • Applying Rules to Messages
  • 77-604 Exam Problems
Understanding the Access 2007 Test (77-605)
  • Database Design Terms and Concepts
  • Understanding Primary Keys
  • Understanding Table Relationships
  • Working with Split Databases
Fundamental Elements of a Database
  • First Steps
  • Applying Security Options
  • Understanding Tables & Fields
  • How to Build Forms
  • Using Forms
  • Utilizing Reports
  • Creating Reports
Understanding Access's Advanced Features
  • Understanding the Navigation Pane
  • Viewing Relationships and Primary Keys
  • Importing Data
  • Exporting Data
  • Inserting Pivot Charts & Tables
Understanding Queries
  • Beginning a Query
  • Modifying a Query
  • Utilizing with Macros & Coding
How to Manage Access Databases
  • How to Print Individual Objects
  • The Database Splitting Feature
  • Understanding Database Administration
  • 77-605 Exam Problems
Wrapping Up
  • Test Day Tips
  • Course Review
  • Tutor Info

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this MCAS Training CD

Title MCAS
Tutor Lauri Matson
Other tutorials by Lauri Matson
Videos 127 Lessons- Video run time: 9.5 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2009
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are available on this title
264 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn MCAS from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Access Tutorials | Microsoft Outlook Training | Quickbooks | Microsoft Word| Online MCAS Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.