​Advanced Excel for Data Analysis

​Advanced Excel for Data Analysis

This event has been cancelled. If you have any questions, please contact the event planner directly.

 
 BxpxvhhI_Advanced Data Science
 
Course Goals & 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.

Learning Objectives:
  • Learn how to minimize as much manual labor as possible in data analysis 
  • Learn to use the most overlooked Excel formulas that will make your life easier 
  • Learn powerful functions built in Excel that streamline your analysis

Details

  • When

  • Wednesday, March 18, 2020
    9:00 AM - 5:00 PM
    Eastern Time

  • Where

  • CFA Society Washington, DC
    1401 New York Ave NW,
    Washington, District of Columbia 20006
    USA

Outlook Outlook
iCal iCal
Google Google
Yahoo! Yahoo!
MSN MSN
Top