Created by Irfan Sharif | Last updated 1/2021
Duration: 2.5 hours | 6 sections | 26 lectures | Video: 1280x720, 44 KHz | 0.99 GB
Genre: eLearning | Language: English + Sub

Excel tips & tricks for Accounting, Finance and Financial Analysis.

Learn from the Bestselling Accounting Instructor

Accounting functions in Microsoft Excel

Finance functions in Microsoft Excel

Excel 2010 or later editionBasic working knowledge of ExcelDepreciation and common methods of depreciationBasic knowledge of Finance like value of money, compounding and discountingConcept of NPV and IRR

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.

\n

Who should take this course:

Accounting students

Finance students

Accounting professionals

Finance professionals

Entrepreneurs and Business Owners with Finance knowledge

Investors with Finance knowledge

\n



DOWNLOAD
uploadgig