|
This course will cover the following:
· Introduction to Excel
* Getting Started with Excel
* Creating a Workbook
* Using Editing and Style Tools
* Exploring Home Tab Commands
· Working with Formulas and Functions
* Exploring Formula Basics
* Working with Functions
* Using Logical and Financial Functions
* Rounding and Nesting Functions
· Enhancing Worksheet Appearance
* Building Charts
* Inserting Shapes
* Using Images and SmartArt Graphics
· Expanding Uses of Workbook Data
* Using 3-D References
* Working with Tables
* Using Named Ranges and Structured References
· Auditing, Analyzing, and Consolidating Data
* Using Auditing Tools
* Using What-If-Analysis (optional)
* Consolidating and Linking Workbooks
· Exploring Macros, Templates, and Workgroups
* Working with Macros
* Using Templates
|