Intermediate and Advanced classes starting in March and April

Microsoft Excel, Intermediate Level 2    

This course teaches students to understand the use of charting features and organizing data.

It is designed for frequent users.
Chapter 1: Managing workbooks
Module A: Managing worksheets
Module B: Customizing Excel

Chapter 2: Named ranges
Module A: Using names in formulas

Chapter 3: Tables
Module A: Sorting
Module B: Filtering tables
Module C: Validation
Module D: Transposing data

Chapter 4: Summarizing data
Module A: Consolidation
Module B: Subtotals

Chapter 5: PivotTables
Module A: Creating and formatting PivotTables
Module B: Manipulating PivotTables
Module C: PivotCharts

Chapter 6: Presentation features
Module A: Conditional formats
Module B: Graphics

Chapter 7: Advanced charts
Module A: Special chart types
Module B: Sparklines

Chapter 8: Collaboration
Module A: Permissions
Module B: Shared workbooks
Module C: Web features
Dates: March 23, 25, 30
Time : 6 - 9 PM
Cost: $130 - book provided
Location: 500 Technology Way, Florence, KY
Registration Deadline: March 16
Microsoft Excel, Advanced Level 3   

This course teaches students advanced formula and macros.

Its design is for advanced users.
Chapter 1: Logical and Lookup Functions
Module A: Decision-making functions
Module B: Lookup and reference functions

Chapter 2: Advanced Formulas
Module A: Auditing and error-trapping
Module B: Formula options
Module C: Arrays

Chapter 3: Special functions
Module A: Date and time functions
Module B: Text functions
Module C: Other functions

Chapter 4: Importing and Exporting
Module A: The Power Pivot Data Model
Module B: Exporting data

Chapter 5: Analysis
Module A: What-if analysis
Module B: The Analysis Toolpak

Chapter 6: Macros and Forms
Module A: Recording macros
Module B: Running macros
Module C: Forms
Dates: April 20, 22, 27
Time : 6 - 9 PM
Cost: $130 - book provided
Location: 500 Technology Way, Florence, KY
Registration Deadline: April 13
Contact us for more information!

Call (859) 442-1130 or (859) 815-7796 to learn more!