Banking, Finance, & Accounting

Excel for Finance

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 • 1 hour 43 minutes
  • Lecture 1: Intro
    32 seconds
  • Lecture 2: Lookup
    13 minutes 2 seconds
  • Lecture 3: IFS
    13 minutes 42 seconds
  • Lecture 4: IF& AND& OR
    8 minutes 54 seconds
  • Lecture 5: Count& Small& large Equations
    6 minutes 1 second
  • Lecture 6: Other Formulas
    13 minutes 20 seconds
  • Lecture 7: Excel Tools Part 1
    9 minutes 39 seconds
  • Lecture 8: Excel Tools Part 2
    9 minutes 44 seconds
  • Lecture 9: Financial Equations
    12 minutes 6 seconds
  • Lecture 10: Equations of Feasibility Studies
    10 minutes 57 seconds
  • Lecture 11: Application on Financial Model
    5 minutes 45 seconds

Meet your instructor

Aya Mohsen

Aya Mohsen

A Corporate Finance Professional, possessed CMA, FMVA and CFC, with 14 years of experience in Investments, Decision Support, Reporting, Operational Excellence, Strategy, Corporate Development, Budgeting, Controlling, ERPs Implementations and Risk Management in Telecommunications, FMCGs and Retail.
Working currently as Strategic Planning and Corporate Development Senior Manager at Telecom Egypt and previously held the positions of Feasibility Studies Director at NTRA - UNDP, Finance Decision Support Manager at Telecom Egypt, Team Leader Budgeting and Accounting at Juhayna and Regional Reporting Accountant at Al-Futtaim (for Egypt & Levant)
Beside being part time Finance Instructor at several universities and training institutes delivering CMA, Business Analytics, Finance for Non-finance

Visit Linkedin

Subscriptions

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

1 Month Subscription
USD 15
Benefits
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
1 Year
USD 70
Benefits
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
3-Months group subscription
USD 40
Benefits
  • All one month subscription perks
  • Access for three months
  • Access for 3 users