Important Class Notes
Maximize your productivity and become an Advanced Excel power user! Discover advanced functions and formulas as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and practice advanced data filtering. Apply advanced chart formatting options and create more complex charts. Work with PivotTables and PivotCharts, export and import data, and query external databases. Understand the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, run and record macros and explore VBA code. Instruction provided by The Training Associates, an award winning training firm. Lunch is included. Must register by October 28.
 
Class Number 64242
Catalog Number 47-103-401
Class Title Advanced Excel for Business
Semester / Year Fall 2015
Units 0.20
Instructor NonEmployee,WITC
Course Fee  $139.00
Senior Fee  $113.32

 

 

Location New Richmond
Building WITC New Richmond Campus
Instruction Mode In Person (Classroom)
Room Day(s) Time Date(s)
0157F08:00a-04:00p11/13
 
Class Description
Learn fundamental spreadsheet skills. Come prepared with basic computer skills.
 
Important Class Notes
Maximize your productivity and become an Advanced Excel power user! Discover advanced functions and formulas as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and practice advanced data filtering. Apply advanced chart formatting options and create more complex charts. Work with PivotTables and PivotCharts, export and import data, and query external databases. Understand the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, run and record macros and explore VBA code. Instruction provided by The Training Associates, an award winning training firm. Lunch is included. Must register by October 28.

Additional Course Offerings
(Click any column heading to sort.) 
Class Number Catalog Number Class Title Location Instruction Mode Start Date View Course Information
64308  47-103-401  Computers: MS Excel Beginning  Superior  In Person (Classroom)  09/18  View Course Information 
64377  47-103-401  Computers: MS Excel Intermedi  Superior  In Person (Classroom)  10/16  View Course Information 
64378  47-103-401  Computers: MS Excel Intermedi  New Richmond  In Person (Classroom)  10/23  View Course Information 
66339  47-103-401  Excel B: Formulas & Functions  New Richmond  In Person (Classroom)  09/10  View Course Information 
66342  47-103-401  Excel B: Formulas & Functions  New Richmond  In Person (Classroom)  09/11  View Course Information 
66344  47-103-401  Excel B: Formulas & Functions  New Richmond  In Person (Classroom)  09/11  View Course Information 

 


 

WITC Home Page