Microsoft Certified Application Specialist (MCAS) Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Microsoft Certified Application Specialist (MCAS)
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
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.
Choose your media type:
|
Introduction
|
|||
| MCAS Certification | (04:27) | T | |
| Getting Started | (03:26) | T | |
| Understanding IRM | (02:13) | T | |
| Using the Work Files | (02:48) | T | |
|
Windows Vista Exam (77-600)
|
|||
| Manage Windows Firewall | (05:09) | T | |
| Internet Explorer Security | (04:49) | T | |
| Securing User Accounts | (04:55) | T | |
|
Remote Computing
|
|||
| Network Terminology | (04:43) | T | |
| Network Connections | (05:23) | T | |
| Collaboration with Meeting Space | (05:39) | T | |
| Managing Remote Access | (04:41) | T | |
|
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) | ||
Course Information
| Course: | Microsoft Certified Application Specialist (MCAS) |
| Author: | Lauri Matson |
| SKU: | 33988 |
| ISBN: | 1-935320-41-6 |
| Release Date: | 2009-04-30 |
| Duration: | 9.5 hrs / 127 tutorials |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 782 courses, 81,350 video tutorials (20,800+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More
United States
Email this Page
Send us Feedback