43 STUDENTS ENROLLED

    Featured Testimonial

    The Greatest Strength of the instructor explain material clearly and indicate important points to remember and also shows genuine interest in...Read more

    Profile photo of neha

    Anamika Gaur

    CS Qualified

    Learn Financial Modeling in Excel and have a chance to walk into a job and work like a pro from day one!
    In this training course, expert training provider takes you through the Beginner to Pro in Excel covering all the Basics of excel, along with Advanced Excel and VBA and the Ultimate Guide to Company Valuation using the worlds most popular spreadsheet software.

    In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The trainer slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel for Financial Modelling.

    By the completion of this online training course, you will be able to:

    • 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 P&L statement from a raw data extraction
    • Be able to build a Cash Flow statement
    • Know how to value a company
    • Be able to build a Valuation model from scratch
    • Know how to create a model with multiple scenarios
    • Know how to create professional and good-looking advanced charts

    What are the requirements?

    • Microsoft Excel 2010 or Microsoft Excel 2013
    • Basic understanding of Accounting principals and financial statements

     

    What am I going to get from this course?

    • Over 250 lectures and 18 hours of content!
    • Work comfortably with Microsoft Excel and many of its advanced features
    • Become one of the top Excel users in your team
    • Know how to create professional and good-looking advanced charts
    • Be much quicker at carrying out regular tasks
    • Visual training method, offering users increased retention and accelerated learning.
    • Breaks even the most complex applications down into simplistic steps.
    • Be able to build a Cash Flow statement
    • Know how to value a company
    • Be able to build a Valuation model from scratch
    • Know how to create a model with multiple scenarios

     

    What is the target audience?

    • Aspiring Investment Bankers
    • Graduates who pursue a career in Corporate Finance
    • Professionals who would like to deepen their Valuation skills
    • Business and finance practitioners who are eager to improve their Excel and Financial Modeling skills

    For Course Curriculum click on the Course Curriculum in left side menu or click here

    Course Curriculum

    Basic Excel Calculation
    Methods and Shortcuts to Open Excel FREE 00:02:00
    Basic Excel Calculations FREE 00:04:00
    Define Ranges to Perform Calculations 00:02:00
    Absolute and Relative Reference in Excel FREE 00:03:00
    Mixed References FREE 00:03:00
    Write a 3D function and How to Consolidate 00:04:00
    Useful Quick Excel Shortcuts
    Shortcut to Autosum, Copy, Paste 00:03:00
    How to repeat Previous Task ? 00:02:00
    Shortcut to Fill Down, Fill Right 00:01:00
    How to Insert and Delete Rows and Columns ? 00:02:00
    Show and Hide Ribbon with shortcut keys 00:02:00
    Use of Ribbon without Mouse 00:03:00
    How to Customise the Shortcuts ? 00:05:00
    How to Customize Ribbon 00:04:00
    Paste Special
    Paste Value, Format, Formulas, Comments only with Paste Special 00:04:00
    Update Value without Formulas 00:02:00
    How to Transpose Data from Column to Row 00:02:00
    Link Data with Paste Special 00:02:00
    If Conditional Function
    Use of IF Condition for Single Criteria 00:03:00
    Use of IF Condition for Multiple Criteria 00:04:00
    Use of IF & AND function for Multiple Criteria 00:04:00
    Use of IF & AND Function with OR Function 00:04:00
    Nest IF Function for Multiple Grades 00:05:00
    Conditional Formatting
    Use Conditional Formatting to Colour Cell Based on Content 00:00:00
    Identify Bottom and Rop Numbers using Conditional Formatting 00:03:00
    Display Data with Data Bar 00:02:00
    Use a Formula to Format the Cell 00:05:00
    Rounding Functions
    Int, Trunc, Odd, Even Functions 00:06:00
    Round, Roundup, Rounddown Functions 00:03:00
    Mround, Ceiling, Floor Functions 00:03:00
    Mathematical Functions
    Max, Min, Median, Average, Sum Function 00:03:00
    Count, Counta, Countblank 00:02:00
    Rank the List with Rank Function 00:03:00
    Large and Small Functions 00:03:00
    Introduction to IF related Functions 00:03:00
    Use of SUMIF Function-part-1 00:05:00
    Use of SUMIF Function-Part-2 00:04:00
    Use of Average IF Function 00:05:00
    Use of SumIFs and AverageIFs Functions 00:04:00
    Use of Count IF Function 00:05:00
    Use of Count IFs Function 00:03:00
    Database Functions
    Introduction of Data Base Functions 00:03:00
    Using DSUM Function for AND Criteria 00:06:00
    Using DSUM Function for OR Criteria 00:04:00
    Using DGET Function to Find Single Record 00:03:00
    Text Functions
    Use of Right,Left,Mid Functions to Extract Text 00:06:00
    Use of Find, Search, Len Function 00:05:00
    Use of Trim, Proper, Upper, Lower Function 00:04:00
    Use of & and CONCATENATE Function 00:05:00
    Use of Rept and Len Function to Display Initial Zero 00:04:00
    Use of Replace & Substitute Functions 00:06:00
    Advanced Use of Text Functions with Example 00:07:00
    Advance Use of Right, Mid, Left Functions 00:10:00
    How to Extract Worksheet Name with Text Functions 00:06:00
    How to Extract Workbook Name with Text Functions 00:04:00
    Validation and Protections
    How to Prevent From Entering incorrect values 00:04:00
    How to Validate Huge range of values 00:03:00
    How to Protect the whole worksheet with password 00:04:00
    How to Keep few cells unprotected while entire worksheet is protected 00:05:00
    Document Encryption & Mark as Final 00:03:00
    Is and Lookup Functions
    Introduction to ISNumber, ISError, ISBlank Functions 00:07:00
    Use of IF, Match and ISError & ISNumber Functions 00:06:00
    Simple Use of Choose Function 00:04:00
    Use of Choose Function to make Scenario Analysis 00:05:00
    Use of Vlookup to extract Record from Table like Data 00:05:00
    Advance use of Vlookup, IF and ISError Functions 00:06:00
    Use Hlookup Function with Match Function 00:04:00
    Combined Use of Vlookup and Hlookup with IFerror 00:07:00
    How Index Function is much better than Vlookup & Hlookup 00:06:00
    Indirect Function-Prepare an Output Sheet 00:05:00
    Financial Functions
    Use of FV & PV Functions to analyse Investment Returns 00:05:00
    Use of FV Schedule Function in Case of Variable Interest Rates 00:02:00
    Effective & Nominal Rates with Effect & Nominal Functions 00:04:00
    Use of IPMT, PPMT, PMT Functions to Prepare Debt Repayment Schedule 00:06:00
    Use of CumIPMT and CumPrice Functions 00:04:00
    Date and Time Functions
    Introduction of Date & Time Functions and Format Convention 00:06:00
    How to Change Default Date and Time Format 00:03:00
    Custom Formatting of Dates 00:04:00
    Today & Now Functions to Enter Current Date and Time 00:04:00
    Weekday Function to Identify the Day of Week 00:04:00
    Weekday and Networkday Functions 00:03:00
    How to Find Age with DatedIF Function 00:04:00
    Edate & Emonth Functions 00:04:00
    How to Extract Year, Month, Day from Given Dates 00:02:00
    How to use Autofill to write Date Series 00:04:00
    Whatif Analysis and subtotal
    Use of Goal Seek to get a particular Result 00:03:00
    How to Summarize Data using sub total tool 00:05:00
    How to Use Data Table for Sensitivity Analysis 00:05:00
    Scenario Manager for Different Outcome 00:05:00
    Charts
    Introduction to Chart Elements and Chart Types 00:07:00
    How to Create First Chart and Display Specific Data 00:03:00
    Learn to Create Instant Chart, Use Switch & Move Buttons 00:05:00
    Learn to Change the Default Chart, Give Title, Save as Template 00:08:00
    Understanding the Use of Legends, Chart Title, Axis, Data Labels, Gridlines etc 00:07:00
    How to add an Average to the Chart 00:03:00
    How to Create Double Axis Chart to display values with huge difference 00:02:00
    How to Create a pie Chart 00:04:00
    Formatting of Pie Chart & Key Features 00:05:00
    Pie to Bar and Seperate Peices of Pie Chart 00:07:00
    Pivot Table
    Introduction to Pivot Table 00:08:00
    How to Find Out Values as % of Grand Total and Column/Row Total in Pivot Table 00:07:00
    How to Display Revenue by Quarter in Pivot Table 00:05:00
    Use of Calculated Field for calculating commision on revenue 00:03:00
    Use of External Data Connections to import data from different file 00:03:00
    Consolidate Sheets through pivot wizard 00:04:00
    Filter the pivot table by Row and Column label 00:03:00
    Adding and Removing Subtotal and Grand Totals 00:04:00
    Conditional Formatting in the Pivot Table 00:04:00
    Create your First Pivot Chart 00:03:00
    Change Chart Type, Formatting, Filter Column 00:05:00
    Array Function
    Introduction to Array Functions 00:07:00
    Multiple Condition Test with Array Function 00:03:00
    How to Count Uniques Enteries in List 00:05:00
    How to Transpose Data with Link 00:04:00
    How to Combine Multiple Functions with Array 00:05:00
    Recording and Basics of Macro VBA
    How to Record Basic Excel Work and Assign Shortcut 00:07:00
    How to Enter Data in same worksheet-First Macro 00:08:00
    How to Enter Data in Different Worksheet-Second Macro 00:04:00
    How to Insert Title or Comment to Macro 00:03:00
    How to Save a Macro File 00:02:00
    Dealing with Macro Security 00:02:00
    Use of Input Box and Formula Command 00:09:00
    Use of Inputbox, Msgbox, Formula in different way 00:08:00
    Inserting Command Button and Assigning Short Cut Key 00:06:00
    How to Create Personal Macro 00:04:00
    How to delete a personal macro and personal macro workbook 00:04:00
    Usefull VBA Commands
    How to write value to a cell using VBA 00:04:00
    How to affect all cells in a worksheet using VBA 00:02:00
    How to cut and paste data from one sheet to another sheet using macro VBA 00:06:00
    Break Points and Call Command in VBA 00:06:00
    Select, Add, Rename and Delete Worksheet using VBA 00:08:00
    How to add data in another sheet using macro VBA 00:08:00
    How to Handle the error in macro-part-1 00:11:00
    How to Handle the error in macro-part-2 00:06:00
    Use of Excel Formulas and Functions in VBA
    How to use Offset Function to put variables in excel dynamically 00:08:00
    Assign Result based on marks using IF, Offset and for Next Command 00:07:00
    Assign Grades based on marks using IF, Offset and for Next Command 00:06:00
    Use of Do While and Do Until 00:08:00
    Use of Vbyesno on Msgbxo to provide flexibility in running macro 00:06:00
    Use of Formula Command with for Next Command 00:06:00
    Use of Do While and for Next Command 00:14:00
    Recording macros with Relative References 00:03:00
    Transpose the Data with Do While Loop-part-1 00:10:00
    Transpose the Data with Do While Loop-part-2 00:05:00
    How to Create User Defined Function 00:10:00
    Work Sheet and Wook Book Events
    Introduction to Events-Activate & Deactivate Events 00:04:00
    Autofit Column Width with Change Event 00:05:00
    Workbook Opening and Closing Events 00:03:00
    User Form in Excel
    Understanding First Basic Userform 00:02:00
    Basic Example on How to create Userform-part-1 00:06:00
    Basic Example on How to create Userform-part-2 00:04:00
    Use of Userform without defining Variables 00:02:00
    Use of Combobox to provide defined list 00:04:00
    Case Studies on VBA
    How to Transfer data to another work book automatically with VBA 00:12:00
    How to Transfer data to another workbook based on criterias with VBA 00:13:00
    Introduction to Basic Charts in Excel
    Introduction to Chart Elements & Chart Types 00:07:00
    Create your First Basic chart and display specific details 00:03:00
    How to Create Instant Chart, use of switch & Move Buttons 00:05:00
    How to Change the default Chart, give title, save as template 00:08:00
    Understand the use of Legends, Chart Title, Axis, Data Labels, Gridlines etc 00:07:00
    How to add average to the Charts 00:03:00
    How to Create Double Axis Chart to display values with huge difference 00:02:00
    Create Simple Pie Chart 00:04:00
    Formatting of Pie Chart & Key Features 00:05:00
    Advanced Knowledge of Pie Chart 00:07:00
    Basic Excel Dashboard
    How to Create Scrolling Table with Scroll bar and Vlooup 00:09:00
    How to Prepare a Scrolling Chart 00:14:00
    Chart Based Comparing Dashboards
    Sample Comparative Dashboard 00:07:00
    Comparative Dynamic Chart with two Combo Box 00:09:00
    Dynamic Dashboard with Multiple Check Boxes 00:13:00
    Use of Conditional Formatting in Dashboard
    Roll Over Dashboard 00:13:00
    How to Highlight Row and Cloumn 00:08:00
    How to Display values with colour 00:10:00
    Static Dashboard to Analyse Huge Raw Data 00:13:00
    How to Prepare Performance Indicator with Chart 00:10:00
    Basic Financial Modelling
    What is Financial Modelling 00:08:00
    First Step of Financial Modelling – How to gather historical data and prepare income statement 00:06:00
    How to do historical analysis on the basis of projection parameters or criteria 00:08:00
    How to form the assumptions for making forecast of the income statement on the basis of historical analysis 00:05:00
    Forecasting of Income Statement 00:08:00
    How to Prepare Depreciation Schedule for forecasting income statement – Part 1 00:08:00
    How to Prepare Depreciation Schedule for forecasting income statement – Part 2 00:04:00
    How to calculate Basic EPS, Diluted EPS, Dividend per Share – Forecasting of Equity of Company – Part 1 00:07:00
    Forecasting of Equity of Company – Part 2 00:06:00
    Linking of different items of balance sheet with income statement and different schedules 00:06:00
    Projection of working capital and making its schedule 00:07:00
    Prepration of Cash Flow statement 00:08:00
    Prepration of Debt Schedule for Cash Flow statement – Part 1 00:07:00
    Preparation of Debt Schedule – Part 2 00:06:00
    Completion of Cash Flow Statement and Balance Sheet 00:05:00
    Case Study-Colgate Palmolive
    Preparing Income Statement from Annual Report of Colgate Palmolive – Part 1 00:07:00
    Preparing Income Statement from Annual Report of Colgate Palmolive – Part 2 00:04:00
    Removal of items from Income Statement which are irrelevant and non-recurring 00:06:00
    Adjustments related to stock based compensation, other expenses, equity income from associates 00:07:00
    Calculations & Adjustments related to depreciation 00:06:00
    Final Discussion on Cleaning of Historical Reported Income Statement 00:04:00
    Extracting details of balance sheet in excel and making certain adjustments 00:04:00
    Deciding parameters for projections 00:07:00
    Preforming historical analysis for projections 00:05:00
    Checking management guidelines about items included in the income statement 00:04:00
    Making assumptions for future forecast 00:05:00
    Forecasting income statement on the basis of assumptions 00:05:00
    Preparing depreciation schedule – Part 1 00:06:00
    Preparing depreciation schedule – Part 2 00:05:00
    Forecasting basic and diluted weighted average shares and calculating basic and diluted EPS 00:05:00
    How to calculate options proceeds from conversion of options into equity and how to calculate treasury stocks for buy back of shares 00:03:00
    Linking of equity schedule to the balance sheet to calculate closing equity 00:03:00
    Projection of other items of balance sheet like intangible assets, goodwill etc. 00:03:00
    Projection of equity investments in associates 00:04:00
    Forecasting of working capital 00:05:00
    How to forecast cash flow statement – Identifying items of CFS 00:02:00
    Forecast cash flow statement – Linking CFS items with respective schedules, BS, IS 00:05:00
    Preparation of Debt Schedule for CFS – Part 1 00:05:00
    Preparation of Debt Schedule for CFS – Part 2 00:06:00
    Valuation of Company-Relative Valuation (Trading Combos)
    Introduction to Structure of Model – Part 1 00:05:00
    Introduction to Structure of Model – Part 2 00:05:00
    Making draft structure of model (Valuation Sheet) 00:06:00
    Bring items of Income Statement in the Model (Valuation Sheet) 00:05:00
    Creating dynamic formula for calculating last 12 months details 00:03:00
    Calculating Enterprise Value 00:05:00
    Model to calculate dilution from diluted securities 00:07:00
    How to prepare switches and currency convertors 00:06:00
    Linking currency exchange rate with the valuation sheet 00:05:00
    How to convert currency used in valuation sheet into desired currency 00:06:00
    Use and preparation of calendarization of financial data 00:03:00
    How to put the dynamic formula for calendarization 00:09:00
    How to prepare calendarization on valuation sheet 00:05:00
    Ways in which calendarization can be done – An important step 00:03:00
    Calculations of Multiple for output sheet 00:03:00
    Preparation of Relative Valuation Output Sheet with Indirect Function 00:06:00
    Valuation of Company-Discounted Cash Flow (DCF) - Valuation of MNCs
    How to calculate free cash flow to firm – Unlevered FCF 00:05:00
    Understanding the Discount Rate 00:04:00
    Calculating cost of Equity 00:09:00
    Calculating Cost of Debts and Preferred Stock 00:06:00
    Finding out Weight of Debt and Equity – Part 1 00:10:00
    Finding out Weight of Debt and Equity – Part 2 00:01:00
    Calculating Cost of Capital 00:03:00
    Calculating present value (PV) of free cash flow to firm 00:07:00
    Calculation of Terminal Value using Perpetual & Multiple Method – Part 1 00:08:00
    Calculation of Terminal Value using Perpetual & Multiple Method – Part 2 00:02:00
    Calculation of Intrinsic Value of Company’s Shares 00:06:00
    Senstivity Analysis on Share Price 00:04:00
    Download Videos
    Download Basic Excel Videos 00:00:00
    Download Excel VBA Videos 00:00:00
    Download Excel Dashboards Videos 00:00:00
    Download Financial Modelling Videos 00:00:00

    Course Reviews

    4.8

    31 ratings
    • 1 stars0
    • 2 stars0
    • 3 stars0
    • 4 stars0
    • 5 stars0

    No Reviews found for this course.

    © 2015-17 Takshila Learning. All Rights Reserved.
    Request Callback
    For course & fee related queries, Leave your details and our counsellor will get back to you or Call us at 8800-999-280
    • This field is for validation purposes and should be left unchanged.

    Login

    Create an Account Back to login/register