Excel Data Analysis Bootcamp for Finance Professionals

Focused View

Igor Ovchinnikov

14:21:44

7 View

1. Introduction

1. Introduction.mp4

01:19

2. Which Excel.mp4

02:31

2. Excel-Basics Crash Course

1. About This Section.mp4

00:34

2.1 XBM-04-Basic Concepts and User Interface.zip

2. Basic Excel Concepts and the User Interface.mp4

12:35

3.1 XBM-05-Creating Worksheets and Entering Data.zip

3. Creating Worksheets and Entering Data.mp4

11:15

4. The AutoFill Tool.mp4

09:14

5.1 XBM-07-The Flash-Fill Tool.zip

5. The Flash-Fill Tool.mp4

12:33

6.1 XBM-08-Text-to-Columns.zip

6. Text-to-columns.mp4

10:01

7.1 XBM-09-Introducting Excel Formulas and Functions.zip

7. Introducing Excel Formulas and Functions (Part 1).mp4

05:28

8.1 XBM-09-Introducting Excel Formulas and Functions.zip

8. Introducing Excel Formulas and Functions (Part 2).mp4

09:18

9.1 XBM-10-Excel A1 Style References.zip

9. Excel A1-Style Cell References.mp4

10:03

10.1 XBM-11-Excel Names.zip

10. Excel Named Ranges.mp4

10:20

11.1 XBM-12 Excel Tables and Structured References.zip

11. Excel Tables and Structured References.mp4

13:58

12.1 XBM-13-Array Formulas and Dynamic Arrays.zip

12. Array Formulas and Dynamic Arrays.mp4

08:32

13.1 XBM-14-Concatenate Text Strings.zip

13. Concatenating Text Strings.mp4

07:40

14.1 XBM-15-Text Functions.zip

14. Text Functions.mp4

04:04

15.1 XBM-16-Formatting Basics.zip

15. Excel-Formatting Basics.mp4

11:19

16.1 XBM-17-Drop-down Lists with Data Validation.zip

16. Drop-down Lists with Data Validation.mp4

15:57

17.1 XBM-18-Conditional Summary Functions (SUMIFS AVERAGEIFS COUNTIFS).zip

17. Conditional Summary Functions (SUMIFS AVERAGEIFS COUNTIFS).mp4

07:53

18.1 XBM-19-LA-Excel-Basics Crash Course Homework (ASSIGNMENT).zip

18. Excel-Basics Crash Course Homework (ASSIGNMENT).mp4

01:22

19.1 XBM-19-LS-Excel-Basics Crash Course Homework (SOLUTION).zip

19. Excel-Basics Crash Course Homework (SOLUTION).mp4

25:37

3. Lookup and Reference Functions

1.1 XBM-20-VLOOKUP.zip

1. VLOOKUP Tutorial (Approximate Match).mp4

08:21

2.1 XBM-20-VLOOKUP.zip

2. VLOOKUP Tutorial (Exact Match).mp4

07:12

3.1 XBM-24-25-MATCH and INDEX.zip

3. MATCH Function Tutorial.mp4

04:29

4.1 XBM-24-25-MATCH and INDEX.zip

4. INDEX Function Tutorial.mp4

03:50

5.1 XBM-24-25-MATCH and INDEX.zip

5. MATCH and INDEX (Exact Match).mp4

07:28

6.1 XBM-24-25-MATCH and INDEX.zip

6. MATCH and INDEX (Approximate Match).mp4

04:08

7.1 XBM-26-XLOOKUP.zip

7. XLOOKUP Tutorial (Exact Match).mp4

06:29

8.1 XBM-26-XLOOKUP.zip

8. XLOOKUP Tutorial (Approximate Match).mp4

02:53

9.1 XBM-28-LA-Excel Lookups Practice (ASSIGNMENT).zip

9. Excel Lookups Practice (ASSIGNMENT).mp4

01:35

10.1 XBM-28-LA-Excel Lookups Practice (SOLUTION).zip

10. Excel Lookups Practice (SOLUTION).mp4

19:44

4. Excel Dates and Times (Basics)

1. Overview of Excel Dates-and-Times System.mp4

12:47

2. Entering Dates and Times in Excel Spreadsheets.mp4

04:18

3. Regional Settings on Windows.mp4

05:08

4. Regional Settings on Mac.mp4

03:27

5. Playing with Random Date Values.mp4

08:50

6. Playing with Random Time Values.mp4

05:28

7. Playing with Random Date-and-Time Values.mp4

09:01

8. Formatting Dates (Part I).mp4

09:57

9. Formatting Dates (Part II).mp4

09:08

10. Formatting Time Values.mp4

07:40

11. Formatting Date-and-Time Values.mp4

07:38

12. Formatting for Elapsed Time.mp4

08:03

5. Excel Date and Time (Calculations)

1. The DATE and the TIME Functions.mp4

06:36

2. Date & Time Calculations.mp4

05:34

3. The TEXT Function.mp4

06:50

4. Separating Date from Time.mp4

06:48

5. The WORKDAY and WORKDAY.INTL Functions.mp4

07:35

6. The DATEDIF Function.mp4

04:24

7. YEARFRAC Function.mp4

02:45

8. The DAYS and DAYS360 Functions.mp4

03:10

9. The NETWORKDAYS and NETWORKDAYS.INTL Functions.mp4

05:12

10. The EDATE Function.mp4

02:33

11. The CHOOSE Function.mp4

10:00

12. Calculating the Fiscal Year of a Date.mp4

07:31

13. Working with Dates and Times Stored as Text.mp4

05:55

14. Introduction to the LET Function.mp4

04:09

15. The LET Function Example (Parsing a String).mp4

08:29

16. The LET Function (Microsoft Support Example).mp4

07:49

17. The LET Function (Fiscal Year Calculation Example).mp4

05:44

6. Creating Custom Functions

1. LAMBDA Function (Introduction).mp4

04:29

2. Custom AGE function with LAMBDA and DATEDIF.mp4

04:50

3. Custom Fiscal Year Function with LAMBDA.mp4

06:43

7. Excel What-if Analysis Tools

1. Calculate Loan Payments (PMT Function Tutorial).mp4

04:38

2. Excel Goal-Seek Tutorial.mp4

05:34

3. Excel Data-Table Tutorial.mp4

10:10

4. Excel Scenario-Manager Tutorial.mp4

05:41

8. Data Visualization With Excel Charts

1. Excel Charts Basics.mp4

14:59

2. Chart Elements.mp4

08:11

3. The Select-Data Tool.mp4

09:07

4. Combination Charts (PC).mp4

05:34

5. Combination Charts (Mac).mp4

08:52

6. Excel Charts Practice (ASSIGNMENT).mp4

02:01

7. Excel Charts Practice (PC SOLUTIONS).mp4

34:31

8. Excel Charts Practice (MAC SOLUTION).mp4

29:10

9. Traditional Excel Pivot Tables Tutorial

1. Pivot Tables - Getting Started.mp4

13:35

2. Pivot Table Design Tab Totals and Subtotals.mp4

12:38

3. Pivot Tables Summarization Functions.mp4

09:03

4. Pivot Charts.mp4

05:09

5. Pivot Tables Show Values As Options.mp4

08:25

6. Pivot Tables Refresh.mp4

02:00

7. Pivot Tables - Grouping Dates.mp4

06:04

8. Pivot Tables - Grouping Numbers.mp4

03:42

9. Pivot Tables - Grouping Selection.mp4

04:39

10. Pivot Tables - Filters Area.mp4

05:03

11. Pivot Tables - Slicers and Timelines.mp4

09:54

12. Pivot Tables - Practice Lab (ASSIGNMENT).mp4

02:13

13. Pivot Tables - Practice Lab (SOLUTION).mp4

22:01

10. Transform and Clean Data with Power Query

1. Power Query Introduction 1.mp4

19:48

2. Power Query Introduction 2.mp4

16:25

3. Power Query-Remove Rows.mp4

06:56

4. Power Query-Split Columns.mp4

09:37

5. Power Query-Pivot and Unpivot.mp4

11:58

6. Power Query-The Format Tool.mp4

07:00

7. Power Query-The Extract Tool.mp4

04:14

8. Power Query-Merge Columns.mp4

05:07

9. Power Query-Custom Columns.mp4

07:10

10. Power Query-Dates and Times.mp4

07:45

11. Append Data (Part 1).mp4

12:34

12. Append Data (Part 2).mp4

12:49

13. Connect Power Query to a Folder.mp4

08:48

14. Merge Queries (JOINS).mp4

15:07

15. Merge Queries (VLOOKUP).mp4

07:19

Description

A Comprehensive Excel Training for the Serious Financial Data Analyst

What You'll 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.

Who is this for?

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.

What You Need to Know?

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.

More details

Description
Dear Aspiring Excel Wizard,
Are you ready to elevate your Excel skills to new heights?
If you answer YES, I invite you to embark on a learning journey with me into the wonderful world of Excel. If you join this course, I practically guarantee that your skills will jump to a higher orbit almost overnight.
I am so confident because I meticulously designed it for people like you who are serious about their skills and aspire to master Excel as quickly and as deeply as humanly possible.
Thatâ€™s why I believe this comprehensive course is going to be your gateway to mastery of one of the most sought-after skills in todayâ€™s job market.
This is not one of those regular courses, which are a dime a dozen. No way!
It is a transformative learning experience that helps you build your skills step by step, nourishes your mind with fresh knowledge and creative ideas and gently leads you towards mastery. So you can transform yourself into a true Excel wizard.
Hereâ€™s what you are getting with this course:
Lifetime access to the entire training so you can hone your skills anytime you choose.
Excel-basics crash course: Where it all begins. A smooth journey through the fundamentals, paving the way for mastery. This is where you build a strong understanding of the most important Excel topics. Such as user-interface tools, Flash-fill, Auto-fill, Text-to-columns, cell references, tables, named ranges, dynamic arrays.
How to create drop-down lists with data validation tools in Excel.
Formulas and Functions: The backbone of Excel.
Lookup and reference tutorials: VLOOKUP, INDEX, MATCH, XLOOKUP.
Concatenation: Formulas to join text strings with CONCAT, TEXTJOIN or the ampersand operator.
How to transform text values with UPPER, LOWER, PROPER, TRIM functions.
The basics of professional formatting of spreadsheets.
Date and Time Mastery: A comprehensive training on how to work with dates and times in Excel. From formatting to calculations. Master date and time functions: DATE, TIME, DATEDIF, WORKDAY, WORKDAY.INTL, YEARFRAC, NETWORKDAYS, NETWORKDAYS.INTL, DAYS, DAYS360.
How to calculate fiscal years based on dates.
How to create custom functions with LET and LAMBDA.
Excel what-if analysis tools: Goal seek, Data Table, Scenario Manager.
Data Visualization: A picture is worth a thousand numbers. Bring your data to life. Learn to present data with Excel charts that impress, captivate and inform.
Pivot Tables: Unravel the secrets of summarizing and analyzing large data sets effortlessly. This is where data bows to you, revealing its hidden gems through your newfound mastery.
Practical homework (Lab) assignments with solution walk-throughs.
And more...
Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

Igor Ovchinnikov is a professional corporate trainer who lives in San Francisco California. He has more than 15 years of experience in software and professional-development (AKA “soft-skills”) training. Among his major former and present happy clients are Stanford University, Apple, Boston Scientific, Genentech, Google, Stryker Endoscopy, Bayer, University of California, Altera and many others—all over Silicon Valley. His focus is on rapid skills development by using advanced cognitive-psychology based teaching techniques. He is renowned for his legendary crystal-clear explanations and instructions that make complex concepts extremely easy to understand and remember. He holds a Master’s degree in English, Literature and Linguistics with focus on effective teaching methodologies. He also holds a Master of Business Administration degree from the Ohio State University’s Max Fisher College of Business. Plus, he is certified as Project Management Professional (PMP) by Project Management Institute (PMI). Before his successful teaching career, he worked for Price Waterhouse Coopers and IBM.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.