Excel Data Analysis Bootcamp for Finance Professionals

A Comprehensive Excel Training for the Serious Financial Data Analyst

Created by: Igor Ovchinnikov
The Silicon Valley's Secret Weapon of Training

What Will I Learn?

• Everything you need to start using Excel like a pro.
• Master Excel essentials: cell references, named ranges, tables, Auto-fill, Flash-fill, Text-to-columns, dynamic arrays, data validation and drop-down lists.
• Get comfortable with formulas and functions such as SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, UPPER, LOWER, PROPER, TRIM, CONCAT, TEXTJOIN and more.
• Feel at ease creating formulas that search and fill data automatically with VLOOKUP, INDEX, MATCH, XLOOKUP.
• The secrets of Excel dates and times: DATE, TIME, DAYS, DAYS360, WORKDAY, EDATE, CHOOSE, TEXT and other must-know functions for working with Excel dates.
• Create custom Excel functions with LET and LAMBDA.

Requirements

• No prior Excel knowledge needed. This course teaches everything you need to know.
• You have access to a computer with Microsoft Office suite installed so you can follow the course and practice.
• You are willing to put time to acquire serious data-analysis skills using Excel.
• You want to shine above the rest with your expertise of Excel tools.

Target audience

• Everyone who wants to master Excel and stand out from the crowd.
• Savvy business and data analysts.
• Banking and finance professionals.
• Future, current and former MBA students.
• Real-estate professionals.