Microsoft Excel XP Certification


Full Description
Welcome to Microsoft Excel XP Certification

Our Excel XP gives you the comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. You'll be able to easily analyze data with charts, Microsoft PivotTable views and graphs. And, use automatic formatting to create data-rich spreadsheets. Our interactive series will show you how to utilize all of the tools contained within the most popular spreadsheet program on the market! This course can be taken in a self-directed pace. You will have 1 year access to this course.


Outcomes:

  • You will be able to apply this knowledge in the workplace
  • You will have an appreciable understanding of the subject matter
  • You will be trained in a systematic manner designed to get you up to speed on the subject matter in a short period of time


Assessment:

Testing as part of the course through exam simulation engines.

Course Information (see above or below lessons, outlines, activities, etc.)
Course Details

Excel XP

Introduction

Excel XP

Program Setup

Excel XP

The Basics: Formulas

Excel XP

Formulas Continued

Excel XP

Setting Up a Spreadsheet

Excel XP

Templates

Excel XP

Printing

Excel XP

Advanced Formulas

Excel XP

Relative/Absolute Reference

Excel XP

Charts

Excel XP

Wrap-Up

Excel XP

Introduction

Excel XP

Fill/Trends

Excel XP

Cell Formatting

Excel XP

Formatting

Excel XP

Conditional Formatting

Excel XP

Importing/Exporting Data

Excel XP

Using Filters

Excel XP

Web Publishing

Excel XP

Work Space

Excel XP

Conditional/Sum Wizard

Excel XP

Validation Rules

Excel XP

Tracking Precedents

Excel XP

Goal Seek/Lotus 123 Help

Excel XP

If Statement

Excel XP

Wrap-Up

Excel XP

Introduction

Excel XP

Cell Referencing

Excel XP

Paste Special

Excel XP

Formula Construction

Excel XP

Named Ranges

Excel XP

Shared Workspace

Excel XP

Password Protect

Excel XP

Macros

Excel XP

Pivot Tables

Excel XP

Wrap-Up

Contact Hours: 24