O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Certified Application Specialist (MCAS)

Video 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.

Table of Contents

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