Computer Applications in
 
Finance | Mid Term

ABS
NEGATION
PRODUCT
SUMPRODUC
Weighted Average

SUM
SUMIF
SUMIFS
AVERAGE
AVERAGEIF
AVERAGEIFS
COUNT
COUNTIF
COUNTA


FIND
SEARCH
LEN
RIGHT
LEFT
UPPER
LOWER
PROPER
CONCATENATE
INDIRECT


CONVERT TEXT TO COLUMNS

Merging text from two cells
Importing Text
Find first large


FILL SERIES
Create series of repeating numbers
Panel data firm and year identifiers
Fill down - Ctrl + D
Range Selection say upto 10000 cells

ABSOLUTE
RELATIVE


DISPLAY FORMATS
NUMBERS
DATES
CURRENCY
PERCENTAGE



Time Value of Money
PMT
RATE
NPV
PV
FV
NPER
AMORTIZATION
Multiple compounding and PMT


Capital Budgeting Tools
NPV
IRR
PROFITABILITY INDEX
PAYBACK PERIOD


FORMATTING
CONDITIONAL FORMAT
FILTERS
GO TO
SPECIAL GO TO
DRAGGING
ADDING COLUMNS
DELETE COLUMN
ADD CELLS
DELETE CELLS


DATA VALIDATION
Numbers
Text
Decimal points
Dates
Lists


PROTECT WORKBOOK
PROTECT SHEET
PROTECT RANGE
PROTECT CELL
PROTECT FILE
ENABLE FORMATTING ON UNLOCKED CELLS


IF
NESTED IF
AND and OR


LINKING CELLS TO OTHER SHEETS

RATIOS
FORMAT PAINTER


OTHER FUNCTIONS
CHANGING BETWEEN FORMULA AND VALUES
Converting all formulas to values
Paste special
Extended clipboard
Format all numbers
Format all formulas
Format all errors
Select all text on a sheet




ĉ
Attaullah Shah,
Oct 16, 2019, 9:24 PM
Ĉ
Attaullah Shah,
Oct 16, 2019, 9:24 PM
Ĉ
FV.xlsx
(9k)
Attaullah Shah,
Oct 16, 2019, 9:24 PM
Ĉ
Attaullah Shah,
Oct 16, 2019, 9:24 PM
Ĉ
Attaullah Shah,
Oct 16, 2019, 9:24 PM
Ĉ
Attaullah Shah,
Oct 16, 2019, 9:24 PM
Ĉ
Attaullah Shah,
Oct 16, 2019, 9:24 PM
Ĉ
tvm.xlsx
(10k)
Attaullah Shah,
Oct 16, 2019, 9:24 PM