This comprehensive course is a hands-on instructor led program that will teach you the essentials of Microsoft Excel.

Introduction – Range, Worksheets, Workbooks

Basics – Ribbon, Format Cells, Find/Replace, Templates, Data Validation, Keyboard Shortcuts, Customizing the Toolbar, Dialog Boxes, Task Panes, Printing, Sharing, Protecting

Functions & Formulas – Count & Sum, Logical, Cell References, Date & Time, Text, Lookup & Reference, Financial Functions, Statistical Functions, Common Formula Errors, Array Formulas

Data – Sort, Filter, Conditional Formatting, Charts, Graphics, Pivot Tables, Tables, What-If Analysis, Solver Tool, ToolPak

Question & Answer