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
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
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
Related ads
OFFICE MANAGEMENT Course Outline MS EXCEL Files & Worksheets Making New Excel File Saving, Opening…
A- Office Management Computer Operator Basic Diploma Short Course in Sialkot (Sialkot, Punjab)
This Course is consist of Four Major Software as detailed under: CURRICULUM Section 1: 1 Ms Word…
Networking Diploma Course in Sialkot Cantt, CCNA Course in Sialkot Cantt, CCNP Course in Sialkot…
Center for continued professional development only institute which provide quality education with…
Advanced Excel Course in Rawalpindi advanced formula Advanced Excel Course (Rawalpindi, Punjab)
Start Now a Advanced Excel Course in Rawalpindi. Advanced Excel Course Duration in one Months…
we have been serving since last year in order to provide quality computer education to our…
Course Title: Basic Computer IT Course Course Overview: The Basic Computer IT course at…
Center for continued professional development only institute which provide quality education with…
Creative college of it & business management affiliated with sindh board of technical education…
