Excel Training for Finance and Operations

 

Month
Date
Location
Upcoming Event
January
1/17/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Intro to Formulas
Spaces Remaining: 13
An introduction to creating formulas and utilizing excel functions for calculations and reports. Functions will include, sum, sumif, Vlookup, and more.
1/17/2023
1:00 PM - 3:00 PM
Zoom Video
Excel: IF Statements
Spaces Remaining: 19
An Introduction to using IF, IFS, and SumIF in excel.
1/18/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Conditional Formatting
Spaces Remaining: 19
This training is a basic introduction to conditional formatting in Excel.
February
2/14/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Pivot Tables
Spaces Remaining: 14
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.
2/14/2023
1:00 PM - 3:00 PM
Zoom Video
Excel: PowerPivot
Spaces Remaining: 15
An introduction to PowerPivot to connect multiple data sets to create a data model.
2/15/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Dashboards
Spaces Remaining: 14
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.
2/28/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Intro to Formulas
Spaces Remaining: 20
An introduction to creating formulas and utilizing excel functions for calculations and reports. Functions will include, sum, sumif, Vlookup, and more.
2/28/2023
1:00 PM - 3:00 PM
Zoom Video
Excel: IF Statements
Spaces Remaining: 15
An Introduction to using IF, IFS, and SumIF in excel.
March
3/1/2023 10:00 AM
Zoom Video
Excel: Conditional Formatting
Spaces Remaining: 15
This training is a basic introduction to conditional formatting in Excel.
April
4/11/2023
10:00 AM - 12:00 PM
Zoom Video
Excel: Pivot Tables
Spaces Remaining: 15
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
Spaces Remaining: 15
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
Spaces Remaining: 15
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: 20
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
Spaces Remaining: 15
An Introduction to using IF, IFS, and SumIF in excel.
5/10/2023 10:00 AM
Zoom Video
Excel: Conditional Formatting
Spaces Remaining: 15
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
Spaces Remaining: 15
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
Spaces Remaining: 15
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
Spaces Remaining: 15
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.