Date/Time
Date(s) - Thursday, August 29, 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
Note: Our registration tool has changed. To register, you will be required to ‘+’ (add) a ticket and continue to the registration form.