Excel 1: Core Data Analysis Seminar

This is a full day seminar that combines interactive discussions with hands-on Excel computer work.

Date: Saturday, March 2, 2024
Time: 9:00 a.m. - 5:00 p.m.
Cost: $44.25 + HST ($50 total)
Location: Zoom Virtual Conference

**Register by Feb 28th to attend.

Overview:

• This course has been designed specifically to prepare participants for the rigor and expectations of manipulating and synthesizing data in a business environment
• Assignments, handouts and examples will be used throughout the session
• Students should have a strong working knowledge of Excel prior to taking this course

Course Benefits:

• Transforms participants into Excel "Power Users"
• Bridges the gap between academic course work and real-world application
• Prepares students for employment in the business world
• Covers topics included in the training provided by major banks and corporations
• Individualized attention from instructors
• Experiences instructors are seasoned financial professionals

Learning Topics:

• Use numerous built-in Excel functions to interpret and manipulate data
• Use various filters in conjunction with specific arithmetic functions to summarize large volumes of data
• Use Lookup functions to efficiently extract information
• Create nested formulas to expand a functions' flexibility
• Incorporate widely used financial and arithmetic functions
• Use powerful Text functions to manipulate non-numeric variables
• Use logical functions to create complex formulas
• Become proficient with Pivot Tables to quickly analyze and format large quantities of data
• Learn to use many valuable keyboard shortcuts

For further information, please contact Nicole Drexler at ndrexler@uoguelph.ca