Udemy

The Ultimate Microsoft Excel Course

Learn Excel with a Touch of Finance from a Chartered Accountant and Corporate Banker
Free tutorial
Rating: 3.8 out of 5 (5 ratings)
419 students
1hr 42min of on-demand video
Hindi

Master Microsoft Excel from Beginner to Advanced
Learn the most common Excel functions used in the Office
Automate your day to day Excel tasks by mastering the power of Macros and VBA
Wild Card Characters in Excel no one talks about
Create dynamic report with Excel PivotTables
Problem-solving using Solver & What-if Analysis
Wow your Boss with Dynamic Charts
Make data DISAPPAER but still use it for Calculations (Pro Hack)
Access to a Finance Professional with 10+ years of experience in Excel

Requirements

  • Microsoft Excel 2010, 2013, 2016, Excel 2019 or Office 365

Description

To master Microsoft Excel is an inevitable skill one needs especially if you're or want to work in the field of Accounting & Finance, not only in India but anywhere in the world.     

I'm a Chartered Accountant & ex-Corporate Banker putting my decade of experience into this course to guide you step by step in Hinglish (English with a mix of Hindi) through the beginner to advanced level and beyond.

As you participate in this course you will not only master Excel tools but also build a solid foundation for financial modeling and valuation.

At the completion of this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets

  • Managing large sets of data

  • Formatting data like never before

  • Make data DISAPPEAR but still use it for Calculations (Pro Hack)

  • The Art of Printing Excel Sheets

  • Mastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, SUBTOTAL and many more...)

  • Importing Data from various sources including the internet

  • Create dynamic report with Excel PivotTables

  • Getting over the dreadful Custom Cell formats

  • Wild Card Characters in Excel no one talks about.

  • Conducting What-if Analysis

  • Problem-solving using Solver

  • Automate your day-to-day Excel tasks by mastering the power of Macros and VBA

  • Creating Dynamic Charts

Enroll now and take the next step in mastering Excel and become the Excel champ at your workplace!

Who this course is for:

  • Commerce graduates
  • Chartered Accountants
  • Company Secretary
  • Cost Accountant
  • MBA
  • Anyone willing to make a career in Finance & Accounting
  • If you're willing to take up Financial Modelling & Valuation, this course is the stepping stone for you.

Instructor

Chartered Accountant
Kuldeep Sharma
  • 4.3 Instructor Rating
  • 64 Reviews
  • 1,882 Students
  • 6 Courses

Kuldeep is a Chartered Accountant by qualification. He is experienced in the field of project financing and financial analysis for over 8 years. He has been working in the Commercial Business Banking division of a reputed bank managing an asset portfolio of over INR 3 Billion to his credit.

He also teaches Financial Modelling & Valuation, Project Financing, Financial Statement Analysis, Corporate Finance etc. He's been a mentor to numerous students both offline and online. He has been into teaching for over a decade which is very well reflected in his teaching style.

Experienced in Banking and Financial services, his work exposure includes financial modeling, financial analysis, financing green-field projects, working capital finance, corporate debt-restructuring, strategic debt-restructuring, loan documentation, exposure to various loan products, LCs & BGs and similar activities.

In his spare time, he likes cruising across the hills on his Royal Enfield somewhere in the North-Eastern region of India.

Top companies trust Udemy

Get your team access to Udemy's top 26,000+ courses