MICROSOFT EXCEL ADVANCE for Finance Computer Short Course in Sialkot - Sialkot

Tuesday, 13 February 2018

Item details

City: Sialkot, Punjab
Offer type: Offer
Price: Rs 15,000

Contacts

Contact name Mirza Shaban Zafar
Phone 03216161065

Item description

Excel for Finance (Course outlines
Excel Basics
Spreadsheet, Cell, Row, Column, Address, Formula Bar, Navigation Bar, Basic Formulas, Row freeze, column freeze, panel freeze, transposition, linking
Financial Statement Analysis
Data collection, Ratio calculation, Horizontal and Vertical Analysis
Forecasting and Budgeted Financial Statements
Time Value of Money
Present value, Future Value, Annuity, Perpetuity
Risk and Return
Use of Internet to find data using secondary research (Finance Databases
Stock Rate of Return, Portfolio Return, Portfolio Risk
Statistical Functions
Descriptive, Correlation, Regression
Security Valuation
Interest Based Bond, Zero Coupon Bond, Stock Valuation, Dividend Discount
Capital Budgeting
Net Present Value, Internal Rate of Return, Payback Period, Profitability Index
Cost of Capital
Working Capital Management
Cause and effect relation study using Excel
Charts and Diagrams
Excel Advanced ( Course Outline
Spreadsheet
Row
Column
Cell
Address of cell
Formula Basics
Cell formatting
Cell width and height
Tabular Calculations
Scatter Diagrams
Linear relation
Date function
Auto Serial
Edit Tools
Sheet and Workbook
Workbook Protection
Printing a workbook
Basic formulas
Charts and types of charts
Making invoices
Maintaining records
Types of errors
Average
Variance
Standard deviation
Minimum
Maximum
Power