Start using Microsoft Excel with confidence!

Schedule: 6 hours / 1 days

THE NEW EXCEL

Microsoft Office Excel has a new design that makes your work easier, faster, and more efficient. The new Ribbon user interface puts the most commonly used commands in plain sight on your work surface instead of hidden on menus or in dialog boxes.

TRAINING OBJECTIVE

This program is designed for people who want to get more out of the latest Microsoft Excel with confidence. Learn Excel tips and techniques that will make your work you work faster, efficiently, and you will be able to do complex tasks in a matter of minutes or seconds.

USEFUL TOPICS COVERED

Instead of generic topics from standard courses,
we have picked the most useful features of Excel for our Basic/Intermediate Excel training program.
Get a handle on the new look of Excel.
The Essentials of Excel.
Data Management Basics.
Introduction to Excel Charts.
Pivot Tables and Pivot Charts.
Troubleshooting Formulas.

COURSE OUTLINE

BASIC TIPS

Keyboard shortcuts
Paste Special

CONDITIONAL FORMAT

Matching Condition & Applying Format
Picking Up Differences in a Quick Way

FUNCTION BASICS

The Meaning of the $ Sign
Relative, Absolute and Mixed Addressing
Formulas Reference Other Workbooks
Formula Auditing Tool

SORTING & FILTERING

Sorting by a Custom Sequence
Setting Up a Criteria Range

PIVOT TABLE

Pivot Table Basics
Setting Advanced Field Options

CHART

Formatting Chart
Charting to Highlight Comparisons Forecast vs. Actual Value Chart