Skill Level: Advanced
Use Excel to make your life easier! By linking data among multiple worksheets, you have the ability to produce reports, budgets, or track expenses and profits. In this class we cover the advanced functionality of the Excel program including Filters, Macros, Protecting Worksheets and Advanced Formulas and Functions.
An understanding of Excel Basics (such as sorting, auto-sum, adjusting column/row sizes, etc.) or our Excel 1 class is needed.
Some of the things you will learn in this class:
- Advanced Formulas
- IF Statements
- Charts and Graphs
- Calculating Interest and Payments
- Linking Data between Worksheets
- Protecting Data
- Creating Drop Down Lists
- Subtotals
- Data Validation
- Removing Duplicates
- Macro Basics
- PivotTables
- And more!
Scheduled Classes:
Click here to view the Calendar for a complete class schedule.
All classes are 1 day classes, held during the day (9:00am-3:30pm) unless otherwise noted.
Cost of Class: $140.00