This is a full day seminar hosted by the Marquee Group [1] and the Lang School that combines interactive discussions with hands-on Excel computer work.

Date: Saturday, November 6th, 2021
Time: 9:00am - 5:00pm
Location: Online - Participants will be sent a link in advance of the course and must use their computer to participate.

**Microsoft Excel is required for this session.

Registration Deadline: 11:59pm on November 3rd. **Space is limited
Fee: This session is being offered for BComm students through the BCDC for ONLY $15.00 (a $125 value).
Registration Link: https://marqueegroup.ca/event/soh39/ [2]

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

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

About the Marquee Group

Established in 2002, The Marquee Group specializes in providing current and aspiring financial professionals the tools they need to master the most important areas of financial modeling and analysis. For several years, The Marquee Group has conducted the annual training programs at numerous banks, pension funds and business schools.