Sign In
Manage PermissionsManage Permissions
|
Export Event

Title

Advanced Data Manipulation with Excel (1 Day Course) - SOLD OUT

Event Description

Advanced Data Manipulation with Excel (1 Day Course)

Event details:

CFA Society Ottawa is partnering with The Marquee Group to offer financial modeling training courses in 2018.  The Marquee Group's training mission is to ensure that everyone preparing financial models has the skills to do so in the most efficient and effective way possible. Professionals trained by Marquee provide their companies with greater financial insight and more accurate decision-making tools.

 Dates: 

Session 1: Wednesday, March 7th

Sessions will run from 8:30AM to 4:30PM each day.

 Participants will be required to bring their own laptops with Microsoft Excel installed

 

Location:

Ottawa Conference and Event Centre

http://ottawaconferenceandeventcentre.com/

200 COVENTRY RD. – ROOM 212

OTTAWA, K1K 4S3, CANADA

Parking is complementary

Morning snack will be provided; no outside food or beverages permitted

Cost: 

$550 per day for members/candidates/students

$650 per day for non-members

 

SOLD OUT

Advanced Data Manipulation with Excel (1 Day Course)

This 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 analysis.

The course covers intermediate and advanced level Excel topics.  As such, participants should have a good working knowledge of Excel prior to taking this course.  Assignments, handouts and examples will be used throughout the day.

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
  • Learn to use many features of the Advanced Filter, one of the most helpful and least utilized tools in Excel
  • Use a variety of intermediate and advanced Lookup functions to efficiently extract specific information
  • Learn multiple uses of the Lookup and Offset functions, including ways to automate these functions
  • Create nested formulas to expand the flexibility of various functions
  • Use powerful Text functions to manipulate non-numeric variables
  • Convert non-recognizable values into useable numbers with the use of Text functions
  • Learn to use some of the most effective and lesser known Pivot Table features
  • Use advanced conditional formatting tools to enhance the caliber of analytical output
  • Incorporate widely used financial and arithmetic functions
  • Use logical functions to create complex formulas
  • Learn numerous other tips, tricks and keyboard shortcuts to increase efficiency

 

 

Participants will be required to bring their own laptops with Microsoft Excel installed​

Speaker

 

Event Type

Society; Educational

Education Topic

 

Start Time

3/7/2018 12:00 AM

End Time

3/7/2018 11:59 PM

Event City

Ottawa

Event State/Province

ON

Event Country

Canada

Event Region

Americas

Location Info

Ottawa Conference and Event Centre

http://ottawaconferenceandeventcentre.com/

200 COVENTRY RD. – ROOM 212

OTTAWA, K1K 4S3, CANADA

Parking is complementary

CE Credits

 

SER Credit

 

Currency

CAD

Member Price

550

Non-Member Price

650

Candidate Price

550

Registration

​SOLD OUT

All Day Event

Yes

Recurrence

 

Date

3/7/2018

Attachments

Content Type: MyCFA Calendar
Created at 12/23/2017 9:52 AM by admin@cfaottawa.ca
Last modified at 2/17/2018 4:18 PM by admin@cfaottawa.ca