Date/Time
Date(s)- Thursday, December 19, 2024
Time(s)- 2:00 pm - 4:00 pm
In Part 3 of this two-hour virtual training, Microsoft Office Excel, participants will learn Excel advanced functions and PivotTables. Topics will include:
Advanced Functions
• Using Array Formulas
• Using Lookup Functions
• Date and Time Functions
• Transpose Functions
PivotTables
• Creating and Managing
• Using the Data Slicer
• Calculated Fields and Items
• PowerPivot
• Managing Table Relationships
Conditional Formatting & Formula Checking
• Managing conditional formatting rules
• Custom conditional formatting using formulas
• Custom conditional formatting using function
• Checking for formula errors
• Evaluating formulas
Advanced Filtering
• Advanced Chart Elements
• Add a secondary Vertical Axis
• Dynamic Charts
• Chart Trendline
Instructor Carleen Dotson is a Certified Business Advisor with the Small Business Development Center and is also our Training Manager/Instructor. Carleen facilitates 95% of all SBDC training courses and also instructs several courses in QuickBooks and Microsoft Excel. Before joining the SBDC, Carleen was an instructor for 19 years. Teaching is just a part of who she is, and it shows in every session she facilitates.