Free Course : Microsoft Excel for Finance, Accounting & Financial Analysis

Free Course : Microsoft Excel for Finance, Accounting & Financial Analysis : Learn Excel tips & tricks for Accounting, Finance and Financial Analysis. Learn from the Bestselling Accounting Instructor

Description

Microsoft Excel has hundreds of functions and formulas to store, analyze, and alter data efficiently. However, no one really needs to know all of them to be able to work effectively on Excel.

In this course, you will learn key functions that are required most used by Finance and Accounting users when they are working with their business data. These functions include finding, replacing, sorting, filtering, summarizing, and analyzing data. Additionally, you will also learn how to bring in a particular data against a specific row parameter from other excel sheets.

Who should take this course:

  • Accounting students
  • Finance students
  • Accounting professionals
  • Finance professionals
  • Entrepreneurs and Business Owners with Finance knowledge
  • Investors with Finance knowledge

Who this course is for:

  • Accounting and Finance Students
  • Accounting and Finance Professionals

Topics Covered:

  • Calculation of depreciation with Excel formulas
  • Calculation of PV and FV with Excel formulas
  • Calculation of NPV with Excel formulas
  • Calculation of IRR with Excel formulas

Course content

  • Depreciation with Excel
  • Present value and future value
  • Net present value and IRR
  • Nominal and effective rate of intrest
  • Loan & Mortgage Repayment
  • Financial statement vertical and horizontal analysis

What you’ll learn

  • Accounting functions in Microsoft Excel
  • Finance functions in Microsoft Excel

This course includes:

  • 2.5 hours on-demand video
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Enroll Link : Click Here

Leave a Reply

Hey, wait!

Get Daily Off Campus, Freshers, Placement Drive, Free Courses, Internships Updates On Your Mail