1. Create Excel
2.
Add values to cell as a table
3.
Save in different formats
4.
Create a Table
5.
Sort table
6.
Reference values from a different sheet
7.
Add chart
8.
Load data from different files
9.
Formulas – create own formulas
10.
Functions
a.
Date and time Functions
i.
06-12-2016
ii.
Take YEAR,MONTH,DAY () functions
1.
Need date to be in correct format
2.
Else won’t work
iii.
Add number of days à
Cell value +5
iv.
Add number of Years, Months, days to date . Use
DATE() function
1.
=DATE(YEAR(B14)+4,MONTH(B14)+5,DAY(B14)+3)
v.
Get current date
1.
Now()
vi.
Get components of time HOUR(),MINUTE(), SECOND()
vii.
Add hour, minute, second to date or time. Use
TIME() function
1.
TIME(HOUR(B24)+2,MINUTE(B24)+2,SECOND(B24+3))
11.
Print file – collate
a.
How you print , when you print few sets.
b.
Eg: let’s say you print 4 sets.
i.
Whether one after the other set or
ii.
Print page 1, 4 times and page 2 four times…..
like that
12.
String manipulations
a.
Concatenate two strings , with &
b.
Extract left most , Right most characters LEFT(cell,
number), RIGHT(..)
c.
From middle , =MID(E37,2,5) – get a range of 5
characters starting from position 2
d.
Get
length, =LEN(E37)
e.
Find the position of a string =FIND("Th",E37)
f.
Substitute =SUBSTITUTE(E37,"Tharindu","Jones")
13.
Stat functions
a.
AVERAGE, AVERAGEOF, Median,MODE, Std deviation
(stddev(),
b.
min, max, large small
No comments:
Post a Comment