Advanced Microsoft Excel

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