|
Any skilled financial analyst on top of his or her game needs to be able to efficiently execute detailed data analysis. This course will teach you advanced Excel tools that will streamline your process and enable you to conduct more in-depth analyses with sophisticated number crunching. Leverage the capabilities of Excel for maximum efficiency and improved analysis.
In this course you will:
-
Develop more efficient ways to apply commonly used formulas.
-
Discover often-overlooked Excel formulas.
-
Analyze data using functions such as pivot tables, look-up, subtotals, and regression analysis.
-
Maximize Excel functions with arrays and complex SUMIF construction.
-
Enhance your spreadsheets with drop boxes, data validation, and automated alternate row shading and more.
Prerequisite: Intermediate proficiency using Excel.
Who Should Attend?
Bankers, financial analysts, investment advisors/consultants, portfolio managers, traders, investors, compliance staff/auditors and others interested in advanced data analysis techniques.
Note: Bring your PC laptop with Microsoft Excel installed and a CD-ROM drive. Mac applications may not be as effective.
|
|
Program Details
|
|
Date
Tuesday, May 22, 2012
Time
9:00 a.m.–4:00 p.m.
Fees
Member $469 | Nonmember $499
Level = Advanced
Credits
CE/CPE = 6
Instructor
Wall St. Training (Hamilton Lin
scheduled)
Additional Information
Register via Mail/Fax
Policies and Procedures
|
|
Online Format
|
|
Register for the online version.
Use code NYSSA and receive 10% off.
Note: Fees, class time, and required technology may differ. Wall St. Training, a preferred partner of NYSSA, will administer CE/CPE credits for the online course.
|
|