Excel for Finance

Banking, Finance, & Accounting

1. Distinguish between VLOOKUP and HLOOKUP functions.
2. Apply IFS conditions for effective decision-making.
3. Utilize AND and OR operators within IF statements.
4. Explore additional equations and formulas for financial analysis.
5. Master the use of pivot tables, pivot charts, and data visualization tools in Excel for financial modeling and analysis.

Enroll now

Who takes this course

Designed for finance professionals, analysts, accountants, and individuals working in financial roles who seek to enhance their Excel skills for more effective data analysis, financial modeling, and decision-making.

Course content

11 lectures • 01h 43m

Lecture 1: Intro

00:32 sec
Lecture 2: Lookup

13:02 min
Lecture 3: IFS

13:42 min
Lecture 4: IF& AND& OR

08:54 min
Lecture 5: Count& Small& large Equations

06:01 min
Lecture 6: Other Formulas

13:20 min
Lecture 7: Excel Tools Part 1

09:39 min
Lecture 8: Excel Tools Part 2

09:44 min
Lecture 9: Financial Equations

12:06 min
Lecture 10: Equations of Feasibility Studies

10:57 min
Lecture 11: Application on Financial Model

05:45 min

Meet your instructor

Aya Mohsen

Recorded Courses Subscription

Start watching our recorded courses in different fields with our great experts

1 Month

USD 15

Full access to all courses
Full access to material of courses
Engage with course instructors
Get certificate of completion

Subscribe Now

3 Months

USD 40

Full access to all courses
Full access to material of courses
Engage with course instructors
Get certificate of completion

Subscribe Now

1 Year

USD 70

Full access to all courses
Full access to material of courses
Engage with course instructors
Get certificate of completion

Subscribe Now

Have Question? Get in touch!

We are happy to answer your question regarding our services and programs that we provide.

Search for courses, vacancies, internships