Short Excel Course for New Financial Analysts

By the end of this course, you will have mastered the most essential Excel tools, which are deemed necessary for any finance professional.

Buy €48,00 Free Preview

Course curriculum

1. Course Contents
  FREE PREVIEW
1. 2.1 Basic Excel Tools
2. 2.2 Quick Overview of the Ribbon and Workspace Area
3. Quiz
4. 2.3 Data Entry
5. Quiz
6. 2.4 Basic Formatting
7. Quiz
8. 2.5 Edit Rows & Columns
9. Quiz
10. 2.6 Insert Formulas
11. Quiz
12. 2.7 Copy, Cut, Paste & Paste Special
13. Quiz
14. 2.8 Absolute and Relative Cell References in Formulas
15. Quiz
16. 2.9 Quick Access Toolbar
17. Quiz
1. 3.1 Functions
2. 3.2 IF
3. 3.3 DOUBLE IF
4. 3.4 IFERROR
5. Quiz
6. 3.5 SUM, SUMIF & SUMIFS
7. 3.6 AVERAGE, AVERAGEIF & AVERAGEIFS
8. 3.7 MEDIAN
9. 3.8 MAX & MIN
10. 3.9 COUNT, COUNTIF & COUNTIFS
11. 3.10 COUNTA
12. Quiz
13. 3.11 &
14. Quiz
15. 3.12 VLOOKUP
16. 3.13 HLOOKUP
17. 3.14 CHOOSE
1. 4.1 Financial Concepts & Functions
2. 4.2 Introduction to Capital Budgeting
3. Quiz
4. 4.3 Introduction to Annuity
5. Quiz
6. 4.4 Net Present Value (NPV)
7. Quiz
8. 4.5 Internal Rate of Return (IRR)
9. Quiz
10. 4.6 Payback Period
11. Quiz
12. 4.7 Compound Annual Growth Rate (CAGR)
13. Quiz
14. 4.8 Loan Amortization Schedule
15. Quiz
1. 5.1 Common Excel Tools
2. 5.2 Excel Shortcuts
3. Quiz
4. 5.3 Format Painter
5. Quiz
6. 5.4 Sort & Filter
7. Quiz
8. 5.5 Wrap Text
9. Quiz
10. 5.6 Merge & Center
11. Quiz
12. 5.7 Freeze Panes
13. Quiz
14. 5.8 Custom Formatting
15. Quiz
16. 5.9 Text to Columns
17. Quiz
18. 5.10 Set Print Area
19. 5.11 Hyperlinks
20. 5.12 Remove Duplicates
1. 6.1 Advanced Excel Tools
2. 6.2 Data Validation-List
3. Quiz
4. 6.3 Conditional Formatting
5. 6.4 Trace Precedents & Dependents
6. Quiz
7. 6.5 Ctrl+[ , Clrl+G & F5
8. Quiz
9. 6.6 Goal Seek
10. Quiz
11. 6.7 Solver
12. Quiz
13. 6.8 Sensitivity Analysis - One Variable
14. 6.9 Sensitivity Analysis - Two Variables
15. 6.10 Pivot Tables
16. Quiz
17. 6.11 Pivot Charts
18. 6.12 Slicers
19. 6.13 Macros
20. Quiz
1. 7.1 Excel Charts
2. 7.2 Line Charts
3. 7.3 Bar Charts
4. 7.4 Stacked Bar Charts
5. 7.5 Pie Charts
6. 7.6 Waterfall Charts
1. 9.1 Outro

About this course

€48,00
97 lessons
1.5 hours of video content

Discover your potential, starting today

Enroll today

Course Reviews

Plain and simple lessons

Christos Angelopoulos

Diving into the Short Finance Lessons, I gotta say, my Excel skills and finance know-how were basically non-existent. But, this course legit turned that around. It broke down the whole financial analysis thing into bite-sized pieces, using examples and quizzes that were straight-up engaging. Felt like I was leveling up with every module, making those complex concepts way more relatable and easier to get a grip on.

Read Less

It was nice!

Spyros Kontelis

Small and informative

Read Less

Easy-to-digest and fully comprehensible information on how to use Excel.

Giannis Papadopoulos

Very well structured and comprehensible courses, without unnecessary details. Apt observations and clear guidance!!

Read Less