Excel Training for Finance and Operations

 

Month
Date
Location
Upcoming Event
August
8/23/2022
10:00 AM - 12:00 PM
Zoom Video
Excel: Charts (Zoom Online Training)
Spaces Remaining: 18
This course covers an introduction to creating charts and using the ideas application in excel. We will then cover how to edit chart areas, manipulate data series in charts, and more. Basic excel formatting skills are required.
8/24/2022
10:00 AM - 12:00 PM
Zoom Video
Excel: Pivot Tables (Zoom Online Training)
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.
8/24/2022
10:00 AM - 12:00 PM
Zoom Video
Excel: Pivot Tables - Cancelled
Registration Closed
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.
8/25/2022
10:00 AM - 12:00 PM
Zoom Video
Excel: Power Pivot
Spaces Remaining: 17
An introduction to PowerPivot to connect multiple data sets to create a data model.
September
9/20/2022
10:00 AM - 12:00 PM
Administrative Office Building (AOB), 104 Airport Drive, Room 3101
Excel: Conditional Formatting
Spaces Remaining: 12
This training is a basic introduction to conditional formatting in Excel.
9/21/2022
10:00 AM - 12:00 PM
Zoom Video
Excel: Intro to Formulas
Spaces Remaining: 12
An introduction to creating formulas and utilizing excel functions for calculations and reports. Functions will include, sum, sumif, Vlookup, and more.
9/22/2022
10:00 AM - 12:00 PM
Zoom Video
Excel: IF Statements
Spaces Remaining: 14
An Introduction to using IF, IFS, and SumIF in excel.
October
10/25/2022
10:00 AM - 12/25/2022 12:00 PM
Zoom Video
Excel: Dashboards
Spaces Remaining: 11
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.
10/26/2022
10:00 AM - 12:00 PM
Zoom Video
Excel: Pivot Tables
Spaces Remaining: 13
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.
10/27/2022
10:00 AM - 12:00 PM
Zoom Video
Excel: PowerPivot
Spaces Remaining: 12
An introduction to PowerPivot to connect multiple data sets to create a data model.
November
11/15/2022
10:00 AM - 12:00 PM
Administrative Office Building (AOB), 104 Airport Drive, Room 3101
Excel: Conditional Formatting
Spaces Remaining: 14
This training is a basic introduction to conditional formatting in Excel.
11/16/2022
10:00 AM - 12:00 PM
Administrative Office Building (AOB), 104 Airport Drive, Room 3101
Excel: Intro to Formulas
Spaces Remaining: 15
An introduction to creating formulas and utilizing excel functions for calculations and reports. Functions will include, sum, sumif, Vlookup, and more.
11/17/2022
10:00 AM - 12:00 PM
Administrative Office Building (AOB), 104 Airport Drive, Room 3101
Excel: IF Statements
Spaces Remaining: 15
An Introduction to using IF, IFS, and SumIF in excel.