Preparing for the MCAS Excel 2007(50041A)

Formation Office Automation Curriculum - Preparing for the MCAS Excel 2007(50041A) in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.

1050.-/d

ID : 679

Goal : This curriculum provides students with an overview of the MS Office Excel 2007 features and functions that pertain to the objectives of the corresponding MS Business Certification credential.

Audience : This training is intended for beginning to intermediate-level users who want to learn the core capabilities and essential skills for working with Excel 2007.

Prerequisites : Before attending this training, students must have basic computer knowledge

Goals :

- Introduction

- Understand the new user interface

- Use the improved formatting capabilities

- Create a workbook

- Modify a workbook

- Modify a worksheet

- Customize the Excel 2007 program window

- Enter data quickly

- Find and replace workbook data

- Verify and extend workbook data using proofing and reference tools

- Organize data using tables

- Name groups of data

- Create formulas to calculate values

- Summarize data that meets specific conditions

- Find and correct errors in calculations

- Format a cell

- Define styles

- Apply a workbook theme

- Make numbers easier to read

- Training Conclusion

Pedagogical method : Examples based training, as well as synthesis exemples. Exam preparation is done on a half day included in training schedule (useful as recapitulative exercise, if missed exam).

Suggested duration for presentiel training (days) : 2

Suggested duration for on-line training (days) : 2.4

Daily price in face-to-face : 1050 CHF

Daily price in remote : 504 CHF

Daily price in remote for students : contact us (only if student card!)

Daily price in remote (with recording) : 5250 CHF

Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).

Book

- Title : Excel 2007 - Preparing the MCAS exam - Exam 77-602

- Author(s) : Collectif

- Pages : 293

- ISBN : 9782746048805

Tags : excel, ms excel, mcas, 2007, excel 2007, mcas certification, trainng excel, training ms excel, training excel 2007, training excel mcas.

Contents