Comprehensive Video Tutorials

Excel 2007 (MCAS) Beginner to Advanced Online Training

CareerVision Training
Online

£ 48 - ($ 186.131)
+ IVA

Información importante

  • Curso
  • Online
  • Duración:
    Flexible
  • Cuándo:
    A definir
  • Campus online
Descripción

Microsoft Excel 2007: MCAS Microsoft Certified Application Specialist Exam Training Course Curriculum:



New Features

Starting in Excel

Basic Navigation

Working with Data

Formulas and Functions

Formatting Data

Working with Worksheets

Printing

Level Summary

Use AutoSum and AutoFill

Use the Vlookup Function

Use Themes, Styles and Formats

Use Table Styles

Insert Cells, Rows and Columns

Cut, Copy and Paste Cells

Manage Worksheets

Adjust Page Layout



Templates

Sorting and Filtering

Navigating in Excel

Working with Comments

Using Name Box

Controlling and Validating Data Entry

Controlling What You See

Using Drawing Tools

Charting

Level Summary

Create a Hyperlink

Use AutoFilter

Sort Data in a Range or Table

Use the Subtotal Command

Use Advanced Filter

Create a Custom List

Use the Name Box and Go To

Add, Edit, and Delete Comments



Advanced Data Tools

Advanced Formula and Function Tools

Protecting and Reviewing Your Work

Merging and Consolidating

Working with External Data

Macros

XML

Trusting and Privacy in 2007

Excel Options

Level Summary

Use Scenarios

Audit a Formula

Use a PivotTable Report

Consolidate Data

Track and Review Changes

Use Goal Seek

Validate Data

Use Conditional Formatting

Summary

Información importante
Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Online

¿Qué aprendes en este curso?

Excel
IT
MS Excel

Programa académico

PACKAGE INCLUDES: • Instructor Led Video Training - 12 Months Online On-Demand Access
• Demos and Lab Learning
• Multimedia Presentations and Self-Paced Navigation
• Practice Review Quizzes

COURSE DESCRIPTION Our MCAS Excel 2007 training course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Excel 2007 Exam 77-602, you achieve Microsoft Certified Application Specialist (MCAS) status in Excel 2007.

The Microsoft Certified Application Specialist Certification, (MCAS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007.

As a Microsoft Certified Partner, we follow the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed. We are so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!


COURSE OUTLINE

Microsoft Excel 2007: MCAS Microsoft Certified Application Specialist Exam Training Course Curriculum:

New Features
Starting in Excel
Basic Navigation
Working with Data
Formulas and Functions
Formatting Data
Working with Worksheets
Printing
Level Summary
Use AutoSum and AutoFill
Use the Vlookup Function
Use Themes, Styles and Formats
Use Table Styles
Insert Cells, Rows and Columns
Cut, Copy and Paste Cells
Manage Worksheets
Adjust Page Layout

Templates
Sorting and Filtering
Navigating in Excel
Working with Comments
Using Name Box
Controlling and Validating Data Entry
Controlling What You See
Using Drawing Tools
Charting
Level Summary
Create a Hyperlink
Use AutoFilter
Sort Data in a Range or Table
Use the Subtotal Command
Use Advanced Filter
Create a Custom List
Use the Name Box and Go To
Add, Edit, and Delete Comments

Advanced Data Tools
Advanced Formula and Function Tools
Protecting and Reviewing Your Work
Merging and Consolidating
Working with External Data
Macros
XML
Trusting and Privacy in 2007
Excel Options
Level Summary
Use Scenarios
Audit a Formula
Use a PivotTable Report
Consolidate Data
Track and Review Changes
Use Goal Seek
Validate Data
Use Conditional Formatting
Summary