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:

  • 2 – 3 Oktober 2018
  • 11 – 12 Desember 2018
Pendaftaran Online | infoseminar.web.id
  1. Judul Training di atas bisa dijadikan sebagai topik INHOUSE TRAINING. Jika Anda membutuhkan bantuan free konsultasi bisa hubungi (021) 27972488 / 08998121246
  2. (required)
  3. (valid email required)
  4. (required)
  5. (required)
  6. (required)
  7. (required)
  8. Captcha
 

cforms contact form by delicious:days