Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel for Finance and Accounting - Intermediate Tutorial

Learnit Training via YouTube

Start learning Write review
GetSmarter Ad

AI Adoption - Drive Business Value and Organizational Impact

Learn More → Pragmatic Institute Ad

AI Product Expert Certification - Master Generative AI Skills

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Dive into an intermediate-level tutorial on Excel for finance and accounting professionals. Master essential functions like NPV, IRR, and IPMT, and learn to create various charts including stock, area, and football field charts to visually represent financial data. Explore key Excel tools such as Pivot Tables to enhance productivity, and apply newly acquired skills to real-world scenarios involving income statements, balance sheets, and cash flow statements. Cover topics ranging from date and time functions, data validation, and lookup functions to goal seek, scenario manager, and loan schedule calculations. Gain practical knowledge to improve day-to-day workflow and efficiently handle financial data in Excel.

Syllabus

Start
Introduction
Date and Time Functions
Data Validation
VLOOKUP
INDEX and MATCH
XLOOKUP
Goal Seek and Scenario Manager
PV and FV
NPV
XNOV
IRR
Loan Schedule with PMT
PPMT
IPMT
CUMIPMT
Loan Schedule Templates
Conclusion

Taught by

Learnit Training

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Excel for Finance and Accounting - Intermediate Tutorial

  • Shiwani
    This course provided an exceptional learning experience, seamlessly blending theoretical concepts with practical, real-world applications. The curriculum was well-structured, moving logically from foundational principles to more complex topics, which made the material accessible yet challenging. I particularly appreciated the instructor’s engaging teaching style and the clarity of the video demonstrations. The hands-on projects were instrumental in reinforcing my understanding and allowed me to build a portfolio I am proud of. While the final module was quite intensive, the comprehensive resources provided ensured I stayed on track. Overall, this course significantly boosted my confidence and professional skill set.
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.