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. It 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..
Microsoft Certified Application Specialist Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac

Introduction
Windows Vista Exam (77-600)
Remote Computing
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 Review Questions
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
Excel 2007 Exam (77-602)
- Manipulating Data pt. 1
- Manipulating Data pt. 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
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
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
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
About this MCAS Training CD
| Title : | MCAS |
|---|---|
| Tutor : | Lauri Matson
Other tutorials by Lauri Matson |
| Videos : | 127 Lessons- Video run time: 9.5 Hours |
| Availability : | Immediate Dispatch |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2009 |
| Work files | Yes |
| Price US / Canadian Sales | $99.95 |
176 In Stock

- Learn MCAS from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you.
- It's Cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
- This title also has Closed Captions, which add clarity and help with retention. It also benefits users who are deaf / hearing impaired.
Want to hear what our customers say about our products?
Microsoft Excel 2007 | Microsoft Visual Studio 2008 | Microsoft Word 2007 | Microsoft Outlook 2007 | Microsoft Access 2007 | Microsoft Office | MCTS Exam 70 642
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.
You can have access to every title we list on this site for just $30 per month. When you sign up, you get instant access with absolutely no restrictions or limits. Log on from any location and learn as much as you like.



