Master Program Calendar

Advanced Excel for Data Analysis

Thursday April 14, 2011 9:00 AM - 5:00 PM
NYSSA Conference Center
Available as: Live Session;Online;
Categories: Financial Modeling & Analysis Tools, Professional Development

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

 

 

Program Details

Fees 
Member $570 | $675

Level = Advanced

Credits
CE/CPE = 7 

Instructor                        
Hamilton Lin, CFA 

Additional Information 
Bring your PC laptop with Microsoft Excel installed and a CD-ROM drive. Mac applications may not be as effective.

Download Catalog     
Register via Mail/Fax     
Policies and Procedures


Online Format

View description and register.
Use code NYSSA and Receive 10% off.

Note
Fees, class time and required technology may differ. CE/CPE credits for online course will be administered by Wall St. Training, a preferred partner of NYSSA

Privacy Policy    |    Contact Us

The New York Society of Security Analysts, Inc, © NYSSA
1540 Broadway, Suite 1010, (entrance on 45th Street), New York, NY 10036