$525 – $600

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

Friends Who Are Going
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.

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

Special Instructions

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