Excel 1: Core Data Analysis

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

Date: Saturday, January 28, 2023
Time: 9:00 a.m. – 5:00 p.m.
Cost: $13.27 + HST ($15 total)
Location: Zoom Virtual Conference
    
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

Register for the course here! [1] Registration is set to close at 11:59 p.m. on January 24th, for us to adequately prepare for the session. 

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