byVissicomp Technology
in
July 20, 2017
Advance Excel
ADVANCE EXCEL
Fees:- 2500/- + 18% G.S.T
Duration:- 25 days
Contents:
Ø Pivot Table
Ø Logical function
(If, and, or, If not, sum-if, count, countif, countblank)
Ø Look up function
( V lookup, H lookup)
Ø Financial
function (PMT, PPMT,IPMT,PVF, RATE, NPER)
Ø Paste special
Ø Data validation
Ø Advanced Filter
Ø Creating macros
Ø Protection
Ø Consolidation
Ø Freezing panes
Ø Maths &
Statistical function (count, sum, average, rank date)
The above contents are listed considering the person
knows Excel basic.
0 comments:
Post a Comment