Eventbrite, and certain approved third parties, use functional, analytical and tracking cookies (or similar technologies) to understand your event preferences and provide you with a customized experience. By closing this banner or by continuing to use Eventbrite, you agree. For more information please review our cookie policy.

Event Information

Date and Time

Location

Refund Policy

Refunds up to 7 days before event

Event description

Description

Event DescriptionThis hands-on course is an intensive program that will transform participants into Excel “Power Users”. The course is focused on the pertinent Excel tools that are required in a business environment to efficiently analyze and manipulate data and to create compelling financial analyses.

Topics IncludeData Analysis

Use numerous built-in Excel functions to interpret and manipulate data

Use Excel’s filters in conjunction with specific arithmetic functions to summarize large volumes of data

Learn to use many features of the Advanced Filter, one of the most helpful and least utilized tools in Excel

Incorporate widely used financial and arithmetic functions

Lookup Functions

Use a variety of intermediate and advanced Lookup functions to efficiently extract specific information

Learn multiple uses of the Vlookup and Offset functions, including ways to automate these functions

Create nested formulas to expand the flexibility of various functions

Managing Text

Use powerful Text functions to manipulate non-numeric variables

Convert non-recognizable values into useable numbers with the use of Text functions

Pivot Tables

Become proficient with Pivot Tables, one of the most powerful tools in Excel, to quickly analyze large quantities of data

Learn to use some the most effective and lesser known Pivot Table features

Who Will BenefitThis seminar is designed for anyone who wants to use Excel to manipulate data to create compelling financial analyses.

*Please note that student pricing is available. To obtain a 40% discount, please email a scanned copy or photo of your student ID that clearly shows your name and expiration date to info@marqueegroup.ca. Once we confirm your status as a current full-time student, we will provide you with a student discount code.