$525 – $600

The Marquee Group - Data Manipulation with Excel – Part 2

Event Information

Share this event

Date and Time

Location

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

This hands-on course is intended for anyone who uses Excel extensively and who is already comfortable with the skills that are taught in Data Manipulation with Excel – Part 1.

This session covers advanced level Excel topics that are required to manage and analyze data.

Topics Include
Database Functions

  • Use Excel’s Database functions so that Excel can be used instead of Access
  • Learn common uses for the Database functions, some of the most underutilized tools in Excel


Static and Dynamic Naming

  • Discuss the rationale for using Static Names when building formulas
  • Learn to create Dynamic Named Ranges, one of the most powerful concepts in Excel which allows users to automatically update graphs, Lookup functions and Pivot Tables


Lookup Functions

  • Use some of Excel’s more advanced Lookup functions, including the INDEX function, and learn helpful applications for their use


Conditional Formatting

  • Use advanced conditional formatting tools to enhance the caliber of analytical output


Securing Data

  • Review Excel’s security features, including some lesser-known techniques to protect a spreadsheet
  • Use Excel’s Data Validation tool to restrict a cell’s contents


Who Will Benefit
This seminar is designed for anyone who wants to use Excel at an advanced level to manipulate data to create compelling financial analyses.

Eligible for CFA & CPA professional development hours.


Date & Time
Thursday, February 7, 2019
8:30 am to 5:00 pm
Lunch is provided

Special Instructions


Registration Deadlines

Early Payment Pricing: $525 + tax (if registration paid by January 24, 2019)

Regular Pricing: $600 + tax (registration closes on February 4, 2019)


*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.

Share with friends

Date and Time

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved