|
A skilled, top-notch financial analyst needs to be able to
efficiently perform detailed data analysis. This course will teach
you advanced Excel tools that streamline your process and allow you to
conduct more in-depth analysis.
Learn more effective ways to apply commonly-used formulas; discover
often overlooked Excel formulas; analyze data using functions such as
pivot tables, vlook-up, subtotals, and regression analysis; enhance your
spreadsheets with drop boxes, data validation, and automate alternate
row shading; and learn how to build and automate simple macros.
You will leave the class better prepared to leverage the capabilities
of Microsoft Excel for maximum efficiency and improved analysis.
Bring your laptop to class (with Excel installed and a CD ROM
drive) to get the most out of this “hands-on” course. PC
laptops recommended. Familiarity with Excel is the only
prerequisite.
Note: To maximize the educational value of this
program, it is strongly recommended that you have a basic understanding
of Excel and are familiar with its functions and features. Lack of basic
Excel skills will impede your ability to effectively acquire and
implement the techniques and shortcuts that are presented in this
program. If you have any questions, or for further information, please
call the Education Department at 212.541.4530 x 42.
Level: Advanced
|
