Excel Business & Financial Modeling Course in Urdu / Hindi
4.5 (10 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
48 students enrolled

Excel Business & Financial Modeling Course in Urdu / Hindi

Excel Business Modeling Covers all advance techniques used besides advance excel skills for Business Intelligence
4.5 (10 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
48 students enrolled
Last updated 2/2020
Hindi
Current price: $72.99 Original price: $104.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 3 articles
  • 34 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Work comfortably with Microsoft Excel and many of its advanced features
  • Become one of the top Excel users in your team
  • Be much quicker at carrying out regular tasks
  • Know how to value a company
  • Be able to build a Valuation model from scratch
Requirements
  • Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Excel 2016
Description

***** COURSE UPDATED: January 2020 *****

Do you want to learn how to use Excel in a real working environment?

Are you about to graduate from university and look for your first job?

Are you a young professional who is looking to establish himself at his new position?

Would you like to become your team's go-to guy when it comes to Financial Modeling in Excel?

If so, then this is the right course for you!

A comprehensive guide to Financial Modeling in Excel:

  • Become an Excel expert

  • Learn how to build sound Financial Models and stand out at your job

  • An in-depth understanding of the mechanics of Company Valuation

  • Build your files in a professional way

  • Demonstrate superior Excel skills at work

What we offer:

  • Well-designed and easy-to-understand materials

  • Detailed explanations with comprehensible Case Studies based on real situations

  • Downloadable course materials

  • Regular course updates

By the completion of this course you will:

  • Work comfortably with Microsoft Excel and many of its advanced features

  • Become one of the top Excel users in your team

  • Be much quicker at carrying out regular tasks

  • Be able to build a Valuation model from scratch

  • Know how to create a model with multiple scenarios

About the course:

  • No significant previous experience is needed in order to understand the course well and fully benefit from its content

  • Unlimited access to all course materials

  • Emphasis on learning by doing

  • You can always contact us for any clarification completely free of charge

  • Our goal is to take your Microsoft Excel and Business Modeling skills to the next level

Make an investment that will be highly rewarded in terms of career prospects, positive feedback and personal growth.

People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills.

Just go ahead and subscribe to this course! If you don't acquire these skills now you will miss an opportunity to separate yourself from the others. Don't risk your future success! Let's start learning together now!

Who this course is for:
  • Graduate students who aspire to become investment bankers, financial advisory professionals, consultants etc.
  • Business and finance practitioners who are eager to improve their Excel and Financial Modeling skills
Course content
Expand all 49 lectures 05:37:31
+ Employee Database Management System
9 lectures 01:02:39
Data Cleaning & Reformatting Tricks
10:48
Important Info
00:47
FAQ's
00:53
Inserting Cell Fitted pictures Automatically in one click
11:07
Apply Auto Search Boxes
05:39
Employee Data extraction Technique
06:14
+ Automated Cheques Printing System
9 lectures 51:10
Formatting Cells and Currency Defaults
08:41
Covert amount in Figures to amount in words
08:48
Adjusting VBA Code to get accurate results
05:25
Connect word cheques template with excel
05:51
Edit Fields and Merge Results in Mail Merge
04:21
Toggle Field Codes to Apply Comma Style
05:01
Configure Gmail Account on Outlook
06:53
Sending Emails From Outlook
04:32
+ Excel Dashboard Reporting Using Power View
6 lectures 56:56
Database Management Part 1
14:56
Database Management Part 2 Pivot Reporting
10:50
Quick Reminder
01:30
Dashboard Reporting
17:24
Enable Power View In Excel
09:56
+ Advance Database Analysis Tools
3 lectures 36:24
Power Pivot Introduction
14:39
Using Power Pivot for pivot table
12:55
Using Scenario Manager
08:50
+ Using Google Sheets and Forms to Collect General Public Data in Bulk
5 lectures 40:51
FAQ's Leaving a Review
02:40
Collecting Bulk Data from people Automatically
12:55
Customizing Google Forms
08:19
How to Email Google Forms Professionally
07:24
Automated Cloud Backup of Excel Sheets
09:33
+ Funds Management in Excel
4 lectures 22:48
Funds Management Part 1
06:00
Funds Management Part 2
06:04
Funds Management Part 3
03:30
Funds Management Part 4
07:14
+ Automated Depreciation Schedules
7 lectures 43:26
Depreciation Schedule StrightLine Part 1
10:09
Depreciation Schedule StrightLine Part 2
05:24
Depreciation Schedules StarightLine Part 3
05:39
Depreciation Calculation Reducing balance Part 1
04:34
Depreciation Calculation Reducing balance Part 2
05:50
Quick Reminder
01:30
EMI Schedule Start
10:20
+ Frequently Asked Question (FAQs)
5 lectures 20:18
Payroll Problem 1 Seperating Date and Time Fields
04:27
Payroll Problem 1 Removing Duplicates with multiple criteria
02:17
Payroll Problem 1 Placing Time in Infront of Time Our With Formula
08:38
Payroll Problem 1 Calculating total Time of Employee Attendance
04:52
Bonus Section
00:04