Microsoft Excel for the Corporate Financial Analyst

سرفصل های دوره

Master key formulas and modeling techniques needed to become an Excel power-user and stand out in your workplace

1. Introduction

1. Introduction

2.1 LinkedIn Profile.html

2. Instructor Background

2. Improving Productivity

1.1 What I Use Razer Ornata Chroma Gaming Keyboard.html

1. Choosing a Good Keyboard

2.1 Essential Keyboard Shortcuts.pdf

2. Keyboard Shortcuts

3. Quick Access Toolbar

3. Basic Excel Operations

1. Navigating with the Arrow Keys

2. Cell References

3. Filtering Data

4. Grouping Rows and Columns

5. Paste Special

6. Pivot Tables

7.1 Basic Excel Operations Practice.xlsx

7. Practice Exercise

4. Formatting Best Practices

1. Why does this matter

2. Where to Begin

3. Number Formats

4. Alignment

5. Format Painter

6. Font Color, Fill Color, Borders, & Conditional Formatting

7. Footnotes

8.1 Financial Modeling Color Coding.html

8. Color Coding

9.1 Basic Excel Operations Formatting Practice.xlsx

9. Practice Exercise

5. The Core Formulas

1. Section Intro

2. The Lookup Concept

3. XLOOKUP

4. VLOOKUP

5. INDEX(MATCH())

6. INDEX(MATCH(),MATCH())

7. The If(s) Concept

8. IF Statements

9. The AND Operator

10. The OR Operator

11. Nested IF Statements

12. IFERROR

13. SUMIFS

14. COUNTIFS

15.1 The Core Formulas Practice.xlsx

15. Practice Exercise

6. Text Functions

1. Section Intro

2. CONCATENATE

3. LEFT and RIGHT

4. MID

5. FIND and LEN

6. TRIM

7. Combing Text Functions

8.1 Text Functions Practice.xlsx

8. Practice Exercise

7. Essential Calculations for Corporate Financial Analysts

1. Weighted Averages

2. Growth Rate

3.1 Compound Annual Growth Rate Formula.html

3. CAGR (Compound Annual Growth Rate)

4.1 Essential Calculations for Corporate Finance Practice.xlsx

4. Practice Exercise

8. Dynamic Excel Model Overview

1.1 Coffee Shop Sales Analysis Completed.xlsx

1.2 sales.csv

1. Model Structure

2. Prepping Source Data

3. Summary Data Tab

4. Presentation Tab

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training