Advanced Microsoft Excel

Advanced Microsoft Excel

Data Handling

• Entering and editing data
• Data types
• Entering and editing formulas
• Absolute and relative call referencing
• Formulas evaluation and editing

Working with a worksheet

• Moving and copying data across sheets
• Copy and paste (including paste special)
• Copying formulas using Auto Fill
• Formula anchoring

Working with functions

• Basic structure of functions
• SUMIFs, COUNTIFs and SUMPRODUCTs
• IF and nested Ifs
• Conditional Formatting
• Data validation and creating drop down lists
• VLOOKUP and HLOOKUP
• INDEX and MATCH
• Data table & sensitivity analysis
• NPV and IRR
• Time Value of money functions

Advanced Functions

• Working with large data sets (sorting, sub totals, filtering, track changes
• Pivot tables, slicer, dashboard
• Goal Seek
• Scenario
• Chart, solver, sparklines

Metode Pelatihan: pembahasan konsep materi dan latihan praktek

Pembicara:
Prihandoko, S.Pd.

Tanggal:

• 15 – 16 Maret 2018
• 3 – 4 Juli 2018
• 2 – 3 Oktober 2018
• 11 – 12 Desember 2018

Jam Pelaksanaan:
09.00 – 16.00 WIB

Tempat:
Graha Mustika Ratu Lt 6
Jln. Gatot Subroto Kav.74-75
Jakarta 12870

Harga:
RP. 3.200.000,- nett/orang/program
include: handout materi, sertifikat, coffee break, 1x lunch
Diskon 10% untuk pendaftaran seminggu sebelum training ATAU Buy 2 get 1 free (cukup membayar Rp. 6.400.000 untuk pendaftaran 3 orang dari satu perusahaan untuk 1 program yang sama).

cforms contact form by delicious:days