Date/Time

Date(s) - Thursday, August 29, 2024
Time(s) - 2:00 pm - 4:00 pm

Register for Event Get Directions

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.