Date/Time
Date(s) - Thursday, April 11, 2024
Time(s) - 2:00 pm - 4:00 pm
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