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 - Custom Review of your Excel problems and workbooks, bring specific questions and we will provide specific answers
Requirements: Each participant must bring a laptop installed with a recent version of Microsoft Excel.