• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

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.

Course Microsoft Certified Application Specialist (MCAS) Author Lauri Matson SKU 33988 ISBN 1-935320-41-6 Release Date 2009-04-30 Duration 9.50 hrs / 127 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags Microsoft

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 Views 03:03 New Presentations 04:43 Using Masters 03:33 Elements & Arrangements 05:13

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