|
Microsoft Certified Application Specialist (MCAS) Tutorials Online |
![]() |
|
Description
Microsoft Certified Application Specialist (MCAS)
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. |
01 Introduction
0101 MCAS Certification
0102 Getting Started
0103 Understanding IRM
0104 Using the Work Files
02 Windows Vista Exam (77-600)
0201 Manage Windows Firewall
0202 Internet Explorer Security
0203 Securing User Accounts
03 Remote Computing
0301 Network Terminology
0302 Network Connections
0303 Collaboration with Meeting Space
0304 Managing Remote Access
04 Customizing Devices
0401 Devices & Drivers
0402 Personalize Display Settings/Appearance
0403 Personalize Other Settings
0404 Start Menu/Taskbar/Notification Area
0405 Sidebar
05 Files & Folders
0501 Windows Explorer
0502 Manage & Secure Folders
0503 Advanced Searching
0504 Sharing Files
0505 77-600 Review Questions
06 Word 2007 Exam (77-601)
0601 Create & Customize Documents
0602 Page Layout: Personalization
0603 Page Layout: Columns/Arrange/Headers/Footers
0604 Pagination/Options/Settings
07 Visual Content
0701 Illustrations: Pictures & Shapes
0702 Illustrations: SmartArt Diagrams
0703 Format Text Graphically
0704 Insert & Modify Text Boxes
08 Organizing Content
0801 Structure Content by Using Quick Parts
0802 Tables & Lists
0803 Margins & Tabs
0804 References & Captions
09 Reviewing Documents
0901 Navigating Your Documents
0902 Tracking Changes & Comments
0903 Compare & Combine Documents
10 Sharing & Collaboration
1001 Prepare Documents for Sharing
1002 Access & Security
1003 Permissions/Information Rights Manager
1004 77-601 Review Questions
11 Excel 2007 Exam (77-602)
1101 Manipulating Data pt. 1
1102 Manipulating Data pt. 2
1103 Data Validation & Integrity
1104 Using Auto-fill
1105 Themes & Styles
12 Formulas & Functions
1201 Reference Data in Formulas
1202 Working with Formulas
1203 Summarize Data with Functions
1204 Conditional Logic (IF Statements)
13 Presenting Data Visually
1301 Conditional Formatting
1302 Create & Format Charts
1303 Charting Continued
1304 Sort & Filter
1305 Outlining & Subtotals
14 Collaborating & Securing Data
1401 Track Changes
1402 Preparing for Distribution
1403 Print Options
15 Advanced Features
1501 External Data
1502 Saving & File Formats
1503 77-602 Review Questions
16 PowerPoint 2007 Exam (77-603)
1601 PowerPoint Views
1602 New Presentations
1603 Using Masters
1604 Elements & Arrangements
17 Slide Content
1701 Insert & Format Text Boxes
1702 Manipulate Text
1703 Linking Content
18 Working with Visual Content
1801 SmartArt Diagrams
1802 Picture Styles
1803 Formatting Pictures
1804 Shapes & Other Techniques
1805 Charts & Tables
19 Collaborating & Delivering Presentations
1901 Review Presentations
1902 Secure & Share Presentations
1903 Printing Presentations
1904 Timing & Rehearsal
20 Animation
2001 Applying Animation to Text
2002 Applying Animation to SmartArt
2003 Working with Transitions
2004 77-603 Review Questions
21 Outlook 2007 Exam (77-604)
2101 Navigation
2102 Outlook Today & Mail
2103 Attachments
2104 Signatures
2105 Security & Digital Signatures
22 Scheduling
2201 Appointments & Events
2202 Meetings & Recurring Items
2203 Calendar Settings
2204 Sharing Calendar
23 Tasks
2301 Task Terminology
2302 Create/Modify/Complete Tasks
2303 Assign/Update/Respond to Tasks
24 Contact Information
2401 Terminology: Books/Lists/Folders
2402 Create & Modify Contacts
2403 Working with Business Cards
2404 Creating a Distribution List
25 Organizing Information
2501 Customizing Views
2502 Using Instant Search
2503 Folders & Junk Mail
2504 Rules to Organize Messages
2505 77-604 Review Questions
26 Access 2007 Exam (77-605)
2601 Database Design: Data Needs & Types
2602 Primary Keys
2603 Table Relationships
2604 Split Databases
27 Database Elements
2701 Getting Started
2702 Security Settings
2703 Tables & Fields
2704 Creating Forms
2705 Forms Continued
2706 Using Reports
2707 Designing Reports
28 Advanced Features
2801 Navigation Pane
2802 View Relationship
2803 Import Files
2804 Export Tables/Queries
2805 Pivot Charts & Tables
29 Queries
2901 Create Queries
2902 Modify Queries
2903 Macros & Coding
30 Managing Databases
3001 Print Database Objects
3002 Splitting a Database
3003 Database Administration
3004 77-605 Review Questions
31 Conclusion
3101 Tips for Taking the Exam
3102 Exam Objectives & Questions
3103 About the Author
sku |
|
