Microsoft Excel Basic Tour
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.
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.
Matching Condition & Applying Format
Picking Up Differences in a Quick Way
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 Basics
Setting Advanced Field Options
Charting to Highlight Comparisons Forecast vs. Actual Value Chart