a oNeat a LooYkshut anth &ales details and use the

Kunctions'-TRIM and CLEAN

TRIM Removzs duplicot1 shacu , [Link] at the

stoyt and end b& atuct stnq
campl
A|=
t

Grcal s hun"
=TRIH CA)

"cLEAN - Removes dupllcat [paus, and 6paces at the

start and end ofa tuct strnq
erampla

= LEANCA)
A XLOte a toOAksheet unth fudnt mak [Link]
Sorting and Eltuing Funchians.
Strting Ranges can be stoYLd uatng the s0nt.
Q6ending Qndbont descanding commands
. 5eluct aange
click the sont and Heu mur
" cick the óoyt (ommand

Rtuin: BHeus ane applizd by selecting

command.
asang
and clicking the 7ite
. Select oange
. cick the 6oyt and h ter name
click the 5lter rom mand
 H K M
D GT

EMPLOyEE 5ALARY
Basicpay HRA DA lthey
deducton G0s, Net Net Bonw inNetamaht
Hand
'5lNo| Emp klo: lameDesignation pay beducto amourt
4500 8000 3450o 1O00 BS600 SO00So600
E lD0 6ales 30000
Joy
El01 Managagen +50000250TS00o934S0 tO00 0so0 34S00 (2 8000
52 Jake A
ccountant SoO001500SoO0S00 62500 (oo0 GO0002r000&S0 00
Elo3 12200300000200
Jay Secmetay 60000000 GO00&00 4SO0OO00
E (D4 Ama clerk QSODO3750asoo TSO 31250 12S0O42000
E IDS 5ona MD (2100oSO00o|41000
10 0000 IsO00 too00sOO0 250 00 1000
Eto6 Rose sales 35600S00OSo600
30000 4s003000 34S 0o
O 8 Elo4 chns Mechan'c |400006500 120C 4800o o00o 64800
ElDr Lia 4SOD0aS0S00asOa34SoJO00
Elo9 Feliz
Hanager
becretany GO000 Q000 GoO0&00SoOo(oO0 220030000toNO

let Date cwt7ioung: tme

=
BONUS =
||-1-
Q05 = = -

JQN5S
PM=

Net aMOunt n
-50 Basic TIHE DATE DATE
values "
3neat
hand ho * p0y
so (Yeax,
t
amOunt Basic CIQ.5,8) caluot wowinkathhet
Bonus pay)
(025,10
IL)
6alony emol ue
monthday) details
and details:
ue
bonu dat
and
 Add thre monxe columns. Fbxt momuLast mame and enaiL
Fnd the alues of Kxt mamL, kast mame and email.
(Bastmame (at namu@amailtom)-tAL tut danttions.
Bast mam - heft /A2, FNDl A2)-D

=helt (a2,520xch " A2)-)

|6tcond mam= Right CA2 len CA2) Seonch (u "A))
E-mail - CONLLA TCBa, " , ce,"Qamail:tom")
xample
Nome = Jackson Oang
Fst mame = keft A2, HND " M, A2)-1)
=Jackóon (B)
Second name= Right [A2, lun CAa)-6eoxuh ( D, A2))

.E-mail= (oNLCAT (Ba", Cd, lamail tom)

=Jackson-Oangg gmail tom
4 inte youn data 6f bixth and todau's date in tuoo calle
Snd yaux aa in days..mantha, and yeow:
wUunt ag -DATEDIE (AL, ToDAYy")&Yeaxs,
kDATEDIE(A), TODA Y),"YM)&'Nonths
&DATED IE (AL, TO DAX()," HD ")2 "Days"

Date ol Biy th 13-10-Q006

To dau's Date i l- l0-302s
IL Honths, LDays
 PRODUCT TOTAL6HEE
REGION
bouth TV 10,000
34,00 O
10 Prpau a uoankshut unth salu dtaia Makia giuat
East FRIDG E
60,000
table havin4ponduck and catqony in Dua lahal
west 8,000
Novth OVEN Pivot toablu
S0ath FRIDGE 38,500
" Select the tabla
Ea st GRINDER
4)20O
" Go to the inAet tab on th1 fzcal rib6on
west FAN 2, 350 " cuck pivot tabe
Novth COMPUTER 9,000 5elect fouisting w0oskahast
South IRON BOX L,S00 Drag and drnh eld
East TV 12, SOO

west OVEN 4,890

AC S5, 000
North

Roo labels Sum o& ToTAL SA LES

SO 700
east
34000
FRIDGE 4200
GRINDER
12S00
TV

Novtb 7200o

AC SSO0
COMPUTER q000
OVEN 8000

50 u-th So ooo

38500
FRIDGE tS00
IRON Bx
l0000
TU
E wst 70Q40
AC 60000
FAN 2350
0VEN 4890
Gnand Total