Excel Training for Finance and Operations

 

Month
Date
Location
Upcoming Event
April
4/11/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Pivot Tables
Event is Full
This course is an introduction to Pivot Tables in Excel. Attendees will learn how to format data for a pivot table as well as how to create a pivot table.
4/11/2023
1:00 PM - 3:00 PM
Zoom Video
Excel: PowerPivot
Event is Full: Accepting Wait List Registrations
Wait List Spaces Remaining: 5
An introduction to PowerPivot to connect multiple data sets to create a data model.
4/12/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Dashboards
Event is Full: Accepting Wait List Registrations
Wait List Spaces Remaining: 4
This course covers an introduction to creating charts and using the ideas application in excel. We will then cover how to incorporate pivot tables and pivot charts into a reporting dashboard. Basic excel formatting skills are required and an understanding of pivot tables recommended.
May
5/9/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Intro to Formulas
Spaces Remaining: 2
An introduction to creating formulas and utilizing excel functions for calculations and reports. Functions will include, sum, sumif, Vlookup, and more.
5/9/2023
1:00 PM - 3:00 PM
Zoom Video
Excel: IF Statements
Event is Full: Accepting Wait List Registrations
Wait List Spaces Remaining: 9
An Introduction to using IF, IFS, and SumIF in excel.
5/10/2023 10:00 AM
Zoom Video
Excel: Conditional Formatting
Spaces Remaining: 6
This training is a basic introduction to conditional formatting in Excel.
June
6/13/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Pivot Tables
Event is Full: Accepting Wait List Registrations
Wait List Spaces Remaining: 7
This course is an introduction to Pivot Tables in Excel. Attendees will learn how to format data for a pivot table as well as how to create a pivot table.
6/13/2023
1:00 PM - 3:00 PM
Zoom Video
Excel: PowerPivot
Event is Full: Accepting Wait List Registrations
Wait List Spaces Remaining: 8
An introduction to PowerPivot to connect multiple data sets to create a data model.
6/14/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Dashboards
Event is Full: Accepting Wait List Registrations
Wait List Spaces Remaining: 6
This course covers an introduction to creating charts and using the ideas application in excel. We will then cover how to incorporate pivot tables and pivot charts into a reporting dashboard. Basic excel formatting skills are required and an understanding of pivot tables recommended.