Title Language  : 

Find a Course... Try for Free!

 

Microsoft Certified Application Specialist (MCAS) Tutorials

Course Content
Microsoft Office is the foundation of most business computer systems; understanding its power and utilizing its productivity is crucial in today’s environment. The Microsoft Certified Application Specialist (MCAS) certification is a series of performance-based exams of the Microsoft Office Suite. The exams focus on the use of these programs in a "real world" enviroment: Microsoft Office Word 2007, Excel 2007, PowerPoint 2007, Access 2007, Outlook 2007, and Windows Vista. Acquiring MCAS Certification places a candidate above the rest when searching for new positions and advancement opportunities. This course prepares you for MCAS exams 77-600 through 77-605 by teaching the skills you need to master in each of the programs to achieve the highest standards of performance and efficiency. To begin learning today, simply click on the movie links.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

«« Hide This
Introduction
MCAS Certification (04:27)
Getting Started (03:26)
Understanding IRM (02:13)
Using the Work Files (02:48)
Windows Vista Exam (77-600)
Manage Windows Firewall (05:09)
Internet Explorer Security (04:49)
Securing User Accounts (04:55)
Remote Computing
Network Terminology (04:43)
Network Connections (05:23)
Collaboration with Meeting Space (05:39)
Managing Remote Access (04:41)
Customizing Devices
Devices & Drivers (03:51)
Personalize Display Settings/Appearance (04:08)
Personalize Other Settings (03:22)
Start Menu/Taskbar/Notification Area (05:38)
Sidebar (03:50)
Files & Folders
Windows Explorer (04:48)
Manage & Secure Folders (05:18)
Advanced Searching (04:03)
Sharing Files (04:16)
77-600 Review Questions (06:01)
Word 2007 Exam (77-601)
Create & Customize Documents (05:21)
Page Layout: Personalization (04:17)
Page Layout: Columns/Arrange/Headers/Footers (05:39)
Pagination/Options/Settings (05:33)
Visual Content
Illustrations: Pictures & Shapes (04:57)
Illustrations: SmartArt Diagrams (04:26)
Format Text Graphically (05:16)
Insert & Modify Text Boxes (03:08)
Organizing Content
Structure Content by Using Quick Parts (03:44)
Tables & Lists (05:22)
Margins & Tabs (05:38)
References & Captions (05:39)
Reviewing Documents
Navigating Your Documents (05:33)
Tracking Changes & Comments (05:37)
Compare & Combine Documents (04:41)
Sharing & Collaboration
Prepare Documents for Sharing (04:40)
Access & Security (04:18)
Permissions/Information Rights Manager (03:43)
77-601 Review Questions (05:40)
Excel 2007 Exam (77-602)
Manipulating Data pt. 1 (04:41)
Manipulating Data pt. 2 (04:50)
Data Validation & Integrity (04:21)
Using Auto-fill (05:35)
Themes & Styles (03:29)
Formulas & Functions
Reference Data in Formulas (04:39)
Working with Formulas (04:59)
Summarize Data with Functions (04:08)
Conditional Logic (IF Statements) (05:14)
Presenting Data Visually
Conditional Formatting (05:58)
Create & Format Charts (03:51)
Charting Continued (05:48)
Sort & Filter (03:10)
Outlining & Subtotals (04:04)
Collaborating & Securing Data
Track Changes (04:41)
Preparing for Distribution (03:50)
Print Options (03:21)
Advanced Features
External Data (04:21)
Saving & File Formats (04:04)
77-602 Review Questions (05:45)
PowerPoint 2007 Exam (77-603)
PowerPoint Views (03:03)
New Presentations (04:43)
Using Masters (03:33)
Elements & Arrangements (05:13)
Slide Content
Insert & Format Text Boxes (04:47)
Manipulate Text (05:22)
Linking Content (02:53)
Working with Visual Content
SmartArt Diagrams (04:27)
Picture Styles (04:08)
Formatting Pictures (03:49)
Shapes & Other Techniques (04:50)
Charts & Tables (04:26)
Collaborating & Delivering Presentations
Review Presentations (03:28)
Secure & Share Presentations (03:30)
Printing Presentations (05:00)
Timing & Rehearsal (03:48)
Animation
Applying Animation to Text (06:21)
Applying Animation to SmartArt (04:43)
Working with Transitions (04:01)
77-603 Review Questions (04:56)
Outlook 2007 Exam (77-604)
Navigation (05:11)
Outlook Today & Mail (05:59)
Attachments (04:12)
Signatures (03:12)
Security & Digital Signatures (05:13)
Scheduling
Appointments & Events (03:46)
Meetings & Recurring Items (04:24)
Calendar Settings (04:21)
Sharing Calendar (04:26)
Tasks
Task Terminology (04:29)
Create/Modify/Complete Tasks (02:58)
Assign/Update/Respond to Tasks (03:22)
Contact Information
Terminology: Books/Lists/Folders (03:05)
Create & Modify Contacts (05:25)
Working with Business Cards (04:04)
Creating a Distribution List (03:43)
Organizing Information
Customizing Views (04:46)
Using Instant Search (04:43)
Folders & Junk Mail (04:53)
Rules to Organize Messages (04:43)
77-604 Review Questions (04:43)
Access 2007 Exam (77-605)
Database Design: Data Needs & Types (06:08)
Primary Keys (04:58)
Table Relationships (04:52)
Split Databases (05:46)
Database Elements
Getting Started (03:28)
Security Settings (02:56)
Tables & Fields (05:18)
Creating Forms (03:37)
Forms Continued (04:57)
Using Reports (04:16)
Designing Reports (05:54)
Advanced Features
Navigation Pane (04:19)
View Relationship (06:22)
Import Files (05:00)
Export Tables/Queries (03:52)
Pivot Charts & Tables (04:05)
Queries
Create Queries (04:38)
Modify Queries (04:36)
Macros & Coding (03:36)
Managing Databases
Print Database Objects (04:53)
Splitting a Database (03:37)
Database Administration (05:11)
77-605 Review Questions (04:35)
Conclusion
Tips for Taking the Exam (04:37)
Exam Objectives & Questions (03:18)
About the Author (01:41)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft Certified Application Specialist (MCAS)
Author: Lauri Matson
SKU: 33988
ISBN: 1-935320-41-6
Duration: 9.5 hrs / 127 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products