A Member of the CFA Institute Global Network of Societies
Course Goals and Overview:
This course focuses on how to effectively and efficiently utilize Microsoft Excel for data analysis. A financial analyst will not only use Excel to build financial models, but also to crunch a large data dump. Learn how to minimize as much manual labor as possible, thereby saving time and performing more detailed analysis quickly. Apply commonly-used formulas in new and different ways; uncover often over-looked Excel formulas; streamline number crunching and analysis via functions and tools including pivot tables, sumif, sum+if, transpose, working with arrays, vlook-up, subtotals, and regression analysis; enhance your spreadsheets with drop-down boxes, data validation techniques, automation of alternate row shading; take Excel to the next level with emphasis on automation.
Please Note: Participants will need to bring a laptop with them to the course.
CFAW Members: $495.00
No upcoming dates scheduled. Please check back.
Copyright ©2017 CFA Institute | All Rights Reserved.