Excel for Finance


Excel is essentially a complete small-scale enterprise management system itself with substantial power. Unfortunately, its capabilities are largely under-appreciated and overlooked. Excel can handle much larger problems than most users recognize—including those who have used it for years. It is flexible and can solve a wide diversity of financial and other business problems.

Excel provides a wide variety of functions and tools that can be used for analysis of financial data. So, its binding for finance professionals to possess Excel skills.

This course is designed to equip with the skills to use Excel for a wide range of financial analysis and reporting requirements.

SESSION 1: Navigation and Data

  • Navigation, Arrow Keys, SHIFT & CTRL
  • Inserting & Editing Cells, Rows and Columns
  • Deleting Cells & Commenting
  • Freezing Rows & Splitting the Screen
  • Special Paste: Your New Best Friend
  • Sorting
  • Filtering

SESSION 2: Formatting and Style

  • Introduction to Formatting & Style
  • Formatting Walkthrough
  • The Five Rules for Financial Modeling
  • Cell Dimensions
  • Styling Fundamentals
  • Styling Practice
  • Special Paste Review
  • Applying Special Paste to the Model
  • Best Practices for Number Formatting
  • Forward Multiples
  • Negative Numbers & Percentages
  • Go To Special
  • Grouping Data

SESSION 3: Formulas and Conditionals

  • Introduction to Formulas & Conditionals
  • Best Practices for Formulas and Conditionals
  • Relative and Absolute Values Part 1
  • Relative and Absolute Values Part 2
  • Sum, Max, Min, Average, Median, Rank, Percentile, Bonus
  • Concatenation Part 1
  • Concatenation Part 2
  • IF
  • Asking IF Twice
  • Formula Error
  • AND
  • OR
  • Cell Color
  • Custom Formulas
  • Hidden Values
  • Test

SESSION 4: Charts

  • Introduction to Charts
  • Best Practices for Charts
  • The Basics
  • Selecting Data In Column Cahrts
  • Customize Your Chart Part 1
  • Customize Your Chart Part 2
  • Line
  • Columns

SESSION 5: Time Value of Money

  • Understand and be able to apply the concepts of the time value of money.
  • Recognize the sensitivity of financial payoffs to changes in interest rates and other conditions that business managers must cope with.
  • Tailor a series of future cash inflows or outflows necessary to satisfy present or future business objectives.
  • Use Excel’s financial commands to convert future values to their equivalent present values, and vice versa.
  • Use Excel’s financial commands to determine the net present value of a series of future cash flows.
  • Calculate periodic payments for mortgages and other loans to identify how much of each payment goes to paying off the principal and how much goes to paying interest.
  • Use Excel’s Goal Seek and Solver tools to achieve an objective.
  • Create one- and two-variable input tables to do sensitivity analysis.

SESSION 6: Financial Statement Analysis

  • Create spreadsheets for financial statements
  • Identify the three key financial statements of corporations (i.e., the income statement, balance sheet, and statement of cash flows) and describe their contents and purposes.
  • Follow the standard formats for organizing items on financial statements.
  • Interpret the items on financial statements and recognize how they’re related.
  • Recognize when errors have been made in financial statements.

SESSION 7: Forecasting

  • Use Excel’s Chart Wizard to create a scatter plot of a set of data values.
  • Select noncontiguous cell ranges for plotting.
  • Insert different types of trend lines on a scatter plot to see which best fits a set of data values.
  • Use Excel commands (e.g., INTERCEPT, SLOPE, and CORREL) and tools (e.g., LINESTand LOGEST) to create a statistical model that follows the trend of historical data for annual revenues.
  • Corporate Executives in marketing, production and non-finance functions
  • Sales Executives
  • Client Servicing Executives
  • Account Managers
  • Customer Support Executives and Call Centre Executives of financial products in banks and other financial intermediaries.
  • Direct Sales Associates operating in the financial services industry Investors
  • 12 Hours

    Rs. 15,000

    For further details regarding contents,
    E-mail: training@bseindia.com