St Cloud Technical & Community College
06.08.21 Advanced Microsoft Excel
#: HBCT   ID: 4249   Section: 02  
Description:
Learn advanced functions and formulas , Sparklines, PivotTables and PivotCharts, Slicer, and consolidated and linked worksheets. The hands-on classroom provides opportunity for practicing the newly-learned skills.                            
One 6-Hour session
Students will learn and practice the following:
· Practice using advanced functions such as IF, VLOOKUP
· Name cell ranges for use in functions
· Learn Sparklines
· Create PivotTables and PivotCharts
· Use the Slicer
· Consolidate and link worksheets and workbooks
 
Bring to Class:
This course will be held in the
Customized Training Building
1215 15th Street North
St Cloud   MN   56303
or Online via Zoom
Day(s):
Tu 
Time:
9:00 AM
Sessions:
1
Cost:
$149.00
Instructor:
Judy Field
Registration Cutoff Date:
6/7/2021
Dates & Times:
6/8/2021   9:00AM - 4:00PM