Welcome, visitor! [ Register | LoginRSS Feed | 

 

Call for price

MICROSOFT EXCEL ADVANCE for Finance Computer Short Course in Sialkot

  • Phone: 03216161065
  • City: sialkot
  • Country: Pakistan
  • Listed: February 13, 2018 6:01 am
  • Expires: 80 days, 19 hours
MICROSOFT EXCEL ADVANCE for Finance Computer Short Course in Sialkot

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
Square root
If function
Types of errors
Percentage
Advanced learnings:
Advanced formatting
Forecasting
Simulations
Installation of Data analysis tool
Use of Data analysis tool

When you call, don't forget to mention that you found this ad on Oxdeal.pk.

Ad Reference ID: 7005a827f181bfb6

No Tags

  

Sponsored Links

Related ADS

short course in rwp-NITT

short course in rwp-NITT...

Call for price

Location : rawalpindi

Import Export Documentation Di

Import Export Documentation Di...

Call for price

Location : sialkot

Professional Accounting Diplom

Professional Accounting Diplom...

Call for price

Location : sialkot

Office Management Computer Ope

Office Management Computer Ope...

Call for price

Location : sialkot

IELTS Preparations Classes wit

IELTS Preparations Classes wit...

Call for price

Location : sialkot

AutoCad 2D 3D Professional Civ

AutoCad 2D 3D Professional Civ...

Call for price

Location : sialkot

AutoCad 2D 3D Professional Mec

AutoCad 2D 3D Professional Mec...

Call for price

Location : sialkot

Dynamic Website Development De

Dynamic Website Development De...

Call for price

Location : sialkot

To inquire about this ad listing, complete the form below to send a message to the ad poster.

Information about the ad poster

Avatar Photo

Other items listed by sadiakanwal

Latest items listed by sadiakanwal »