What you will learn:
• Working with Graphics
o Conditional Formatting
o Sparklines
o Charting
• Financial Functions
o PMT
• What If Analysis Tools
o Goal Seek
• LOOKUP Functions
o VLOOKUP
o HLOOKUP
o Index/Match (if time permits)
• Data views
o Freeze Panes
o Split
o New Window
• Sorting & Filtering Data
• Subtotaling
• Pivot Tables
• Pivot Charts
• Customization
o Quick Access Toolbar
o Ribbon
o Advanced Options
Time: 9 am – 3:30 pm
All costs include all materials, lunch per day, and 2 coffee breaks.
Cancellation Policy: Written notice must be received by the BCFCA 2 weeks prior to receive any refund.