Microsoft Excel – Part 3: Advanced Functions & PivotTables

Date/Time

Date(s) - Thursday, April 11, 2024
Time(s) - 2:00 pm - 4:00 pm

Register for Event Get Directions

Note: Our registration tool has changed. To register, you will be required to ‘+’ (add) a ticket and continue to the registration form.

Part 3 of our Microsoft Excel training will focus on the following topics:

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