Advanced Microsoft Excel

Bagikan :

Deskripsi

1. Data Handling

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

 

2. Working with a worksheet

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

 

3. 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

 

4. Advanced Functions

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

 

Tanggal: 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

 

Lokasi:

Penyelenggara

C&G Training Network

Training Provider

Sejak berdiri pada tahun 2000, C&G Training Network bekerja dalam worldwide network, antara lain sebagai anggota Asean Training Network (ATN), American Society for Training Development, bekerjasama dengan Supply Chain Management Society – Asia, dan berafiliasi dengan TeachMe Teamwork, USA serta International Centre for Organizational Management – UK dan International Association of Administration Professionals – USA . Hal ini membuat kami mampu memberi materi pelatihan yang up to date dengan layanan maksimal dan biaya yang sangat reasonable.


Lowongan Pekerjaan

×