Certified Application Specialist (MCAS)

Visuel non disponible

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.

Formateur : Lauri Matson
Enregistré sur PC | Langue: Anglais
Durée : 9h5 | Leçons: 127

Compatible Mac, Windows & iPad (en VOD)
143,52 € En stock

Acheter sur CD
ou DVD
Acheter des Crédits
pour Consultation
En savoir plus >>


TVA incluse, Hors Livraison 143,52 €

Accès à l'unité

Cette formation nécessite crédits

10 Crédits 10,00 € TTC commander
35 Crédits 30,00 € TTC commander
60 Crédits 50,00 € TTC commander
130 Crédits 100,00 € TTC commander

  • Customizing Devices

    • (03:51) Devices & Drivers
    • (04:08) Personalize Display Settings/Appearance
    • (03:22) Personalize Other Settings
    • (05:38) Start Menu/Taskbar/Notification Area
    • (03:50) Sidebar

  • Files & Folders

    • (04:48) Windows Explorer
    • (05:18) Manage & Secure Folders
    • (04:03) Advanced Searching
    • (04:16) Sharing Files
    • (06:01) 77-600 Review Questions

  • Word 2007 Exam (77-601)

    • (05:21) Create & Customize Documents
    • (04:17) Page Layout: Personalization
    • (05:39) Page Layout: Columns/Arrange/Headers/Footers
    • (05:33) Pagination/Options/Settings

  • Visual Content

    • (04:57) Illustrations: Pictures & Shapes
    • (04:26) Illustrations: SmartArt Diagrams
    • (05:16) Format Text Graphically
    • (03:08) Insert & Modify Text Boxes

  • Organizing Content

    • (03:44) Structure Content by Using Quick Parts
    • (05:22) Tables & Lists
    • (05:38) Margins & Tabs
    • (05:39) References & Captions

  • Reviewing Documents

    • (05:33) Navigating Your Documents
    • (05:37) Tracking Changes & Comments
    • (04:41) Compare & Combine Documents

  • Sharing & Collaboration

    • (04:40) Prepare Documents for Sharing
    • (04:18) Access & Security
    • (03:43) Permissions/Information Rights Manager
    • (05:40) 77-601 Review Questions

  • Excel 2007 Exam (77-602)

    • (04:41) Manipulating Data pt. 1
    • (04:50) Manipulating Data pt. 2
    • (04:21) Data Validation & Integrity
    • (05:35) Using Auto-fill
    • (03:29) Themes & Styles

  • Formulas & Functions

    • (04:39) Reference Data in Formulas
    • (04:59) Working with Formulas
    • (04:08) Summarize Data with Functions
    • (05:14) Conditional Logic (IF Statements)

  • Presenting Data Visually

    • (05:58) Conditional Formatting
    • (03:51) Create & Format Charts
    • (05:48) Charting Continued
    • (03:10) Sort & Filter
    • (04:04) Outlining & Subtotals

  • Collaborating & Securing Data

    • (04:41) Track Changes
    • (03:50) Preparing for Distribution
    • (03:21) Print Options

  • Advanced Features

    • (04:21) External Data
    • (04:04) Saving & File Formats
    • (05:45) 77-602 Review Questions

  • PowerPoint 2007 Exam (77-603)

    • (03:03) PowerPoint Views
    • (04:43) New Presentations
    • (03:33) Using Masters
    • (05:13) Elements & Arrangements

  • Slide Content

    • (04:47) Insert & Format Text Boxes
    • (05:22) Manipulate Text
    • (02:53) Linking Content

  • Working with Visual Content

    • (04:27) SmartArt Diagrams
    • (04:08) Picture Styles
    • (03:49) Formatting Pictures
    • (04:50) Shapes & Other Techniques
    • (04:26) Charts & Tables

  • Collaborating & Delivering Presentations

    • (03:28) Review Presentations
    • (03:30) Secure & Share Presentations
    • (05:00) Printing Presentations
    • (03:48) Timing & Rehearsal

  • Animation

    • (06:21) Applying Animation to Text
    • (04:43) Applying Animation to SmartArt
    • (04:01) Working with Transitions
    • (04:56) 77-603 Review Questions

  • Outlook 2007 Exam (77-604)

    • (05:11) Navigation
    • (05:59) Outlook Today & Mail
    • (04:12) Attachments
    • (03:12) Signatures
    • (05:13) Security & Digital Signatures

  • Scheduling

    • (03:46) Appointments & Events
    • (04:24) Meetings & Recurring Items
    • (04:21) Calendar Settings
    • (04:26) Sharing Calendar

  • Tasks

    • (04:29) Task Terminology
    • (02:58) Create/Modify/Complete Tasks
    • (03:22) Assign/Update/Respond to Tasks

  • Contact Information

    • (03:05) Terminology: Books/Lists/Folders
    • (05:25) Create & Modify Contacts
    • (04:04) Working with Business Cards
    • (03:43) Creating a Distribution List

  • Organizing Information

    • (04:46) Customizing Views
    • (04:43) Using Instant Search
    • (04:53) Folders & Junk Mail
    • (04:43) Rules to Organize Messages
    • (04:43) 77-604 Review Questions

  • Access 2007 Exam (77-605)

    • (06:08) Database Design: Data Needs & Types
    • (04:58) Primary Keys
    • (04:52) Table Relationships
    • (05:46) Split Databases

  • Database Elements

    • (03:28) Getting Started
    • (02:56) Security Settings
    • (05:18) Tables & Fields
    • (03:37) Creating Forms
    • (04:57) Forms Continued
    • (04:16) Using Reports
    • (05:54) Designing Reports

  • Advanced Features

    • (04:19) Navigation Pane
    • (06:22) View Relationship
    • (05:00) Import Files
    • (03:52) Export Tables/Queries
    • (04:05) Pivot Charts & Tables

  • Queries

    • (04:38) Create Queries
    • (04:36) Modify Queries
    • (03:36) Macros & Coding

  • Managing Databases

    • (04:53) Print Database Objects
    • (03:37) Splitting a Database
    • (05:11) Database Administration
    • (04:35) 77-605 Review Questions

  • Conclusion

    • (04:37) Tips for Taking the Exam
    • (03:18) Exam Objectives & Questions
    • (01:41) About the Author
Formateur : Lauri Matson
Langue : Anglais
Durée : 9h5
Nombre de séquences vidéo : 127 		SKU : 33988
Réf :
ISBN : 1-935320-41-6

Descriptif :

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.




Lauri Matson

Lauri Matson owns and operates a successful consulting business specializing in accounting and computerization. Her company assists small and midsized companies with accounting, networking, and administrative solutions. She has over 30 years of accounting and administrative experience and has taught over 20,000 students in seminar and college settings. As an active consultant, she combines the day-to-day hands-on experience with the tips and tricks that are necessary to successfully incorporate an optimized database in today’s business intelligence systems.

Vous souhaitez recevoir l'aide d'un formateur expérimenté pour parfaire votre apprentissage ? C'est possible grâce a notre centre de formation accompagnée a distance.

Nouveaux Parcours

Tous les parcours »
  • Profitez de conseils personnalisés grâce a des entretiens téléphoniques réguliers avec votre formateur.
  • Confrontez-vous a la réalité des entreprises grâce aux exercices proposés pendant la formation.
  • Obtenez une Attestation de Formation Professionnelle.
  • Contactez-nous pour le financement de votre formation par votre OPCA.