Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Life Purpose Meditation Personal Transformation Neuroscience Emotional Intelligence
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-26 07:01:32
30-Day Money-Back Guarantee
Finance & Accounting Accounting & Bookkeeping Excel

Microsoft Excel for Finance, Accounting & Financial Analysis

Excel tips & tricks for Accounting, Finance and Financial Analysis. Learn from the Bestselling Accounting Instructor
Rating: 4.4 out of 54.4 (1,064 ratings)
73,990 students
Created by Irfan Sharif
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

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

Requirements

  • Excel 2010 or later edition
  • Basic working knowledge of Excel
  • Depreciation and common methods of depreciation
  • Basic knowledge of Finance like time value of money, compounding and discounting
  • Concept of NPV and IRR

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


Why you should learn Excel for Finance and Accounting:

This course will change the way you work and will save your hours otherwise spent on complex calculations. You will be able to calculate the values you need for analysis and decisions just by writing small and easy formulas. The rest of your time can then be spent on tasks that matter! 



Prerequisite:

This course expects you to have basic knowledge of Excel, Finance, and Accounting. Let me be more precise on what you should know before starting this course.

Excel:

  • Basic navigation and cell formatting

  • Basic maths functions like plus, minus, multiply and divide

Accounting:

  • Concept of depreciation and methods of depreciation

Finance:

  • Concept of Time Value of Money

  • Present Value and Future Value concept

  • Conversion from present value to future value, and from future value to present value 

  • Concept of Discount factor and Annuity

  • Concept and calculation of NPV

  • Concept of calculation of IRR


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


Money-Back Guarantee: 

Nothing to lose! If you will not be satisfied with the course, Udemy offers 30 days money-back guarantee!


Introduction to the teacher:

Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty

I am a Certified Chartered Accountant (ACCA) from the UK with 12 years of professional work and teaching experience and have taught more than 4,000 students in class and 80,000+ students on Udemy!

I have implemented accounting software and ERP at various organizations and have expertise in financial transformation. I have been leading accountancy practice for small and medium-sized entities for the last 4 months and have frequent interaction with entrepreneurs. So I know what exactly do entrepreneurs need to know to well manage their books. So, Microsoft Excel is what I use most of my day! I love this software, not just because it enables us to do a lot with data, but also because it is very simple and easy to use.

Who this course is for:

  • Accounting and Finance Students
  • Accounting and Finance Professionals
  • Aspiring Financial Analysts
  • Business owners with finance knowledge

Course content

8 sections • 33 lectures • 2h 44m total length

  • Preview05:40
  • Preview07:42
  • SYD - Sum of Years Digits Method
    05:56
  • DDB - Double Declining Balance
    08:56
  • VDB - Variable Declining Balance
    12:51

  • Introduction to PV and FV
    06:04
  • Calculating FV - Future Value
    05:44
  • Calculating PV
    02:55
  • Calculating PV of Annuity
    07:33
  • Calculating FV of Annuity
    05:38
  • Calculating FV with changing interest rates
    02:34

  • Preview05:02
  • XNPV
    02:20
  • IRR - Internal Rate of Return
    06:59
  • XIRR
    01:56

  • Converting Nominal Rate to Effective Rate
    07:24
  • Converting Effective rate to the nominal rate
    01:28

  • PMT
    06:53
  • PPMT
    05:07
  • IPMT
    01:39
  • CUMIPMT
    01:56

  • Preview05:25
  • Yield (Investor's required rate or kd)
    03:36

  • Goal Seek
    05:46
  • Goal Seek - Example
    02:11
  • Data Table
    02:29
  • Two Way Data Table
    03:15
  • Scanerio Manager
    05:28

  • Profit & Loss Statement - Horizontal Analysis
    04:11
  • Profit & Loss Statement - Trendlines
    02:56
  • Balance Sheet - Trendlines and Horizontal Analysis
    04:07
  • Profit & Loss Statement - Vertical Analysis
    08:12
  • Balance Sheet - Vertical Analysis
    04:26

Instructor

Irfan Sharif
Bestselling Trainer | Chartered Accountant | PwC Alumni
Irfan Sharif
  • 4.4 Instructor Rating
  • 6,074 Reviews
  • 195,791 Students
  • 6 Courses

Experienced finance professional with practical experience of teaching accountancy and finance.  

I am Certified Chartered Accountant (ACCA-UK), with a rich experience of providing finance and accountancy services to large organizations of banking, FMCG and professional services sectors. I have worked as a Consultant at "PwC" and as Finance Manager at a FTSE 100 MNC. Now I am leading Accountancy Service of "Excelsious" where we provide Accountancy and Finance services to small and medium sized entities. 

Throughout my career I have been associated with professional education as a visiting member of faculty at prestigious professional colleges and universities for ACCA, CA and MBA. Over this time, I have helped more than 4000 students successfully achieve their aspirations and professional education goals. I am really excited about the enhanced learning experience of teaching online and sharing my knowledge and expertise with a wider audience. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.