Visit our FacebookVisit our InstagramVisit our Twitter

Training Excel

Belajar Excel sampai level mahir dan fokus menyelesaikan berbagai permasalah mengolah data
INFO TRAINING EXCEL

Silabus Pembelajaran

IN HOUSE TRAINING EXCEL

Proses training dilaksanakan selama 2 hari, dimana setiap hari durasinya adalah 6 jam.

Konsep Excel

Trik Bekerja Cepat di Excel
Advanced Format Cell, Conditional Formatting, Fungsi Absolute, Formula aritmatika

Fungsi Aritmatika & Statistik

Perhitungan dengan kombinasi rumus
  • Fungi Aritmatika: Sum(),Sumif(), Sumifs(), Counta(), Count(), Countif(), Countifs() Average(), Averageif(), Averageifs()
  • Fungsi Statistik: Max(), Min(), ), Rank(), Subtotal(), Sumproduct(), Small(), Large(), Mode(), Median()
  • Fungsi Penting lainnya: row(), rows(), Column(), Columns()

IF, LOOKUP, DATE/TIME

Menjalankan rumus berdasarkan kondisi tertentu
  • Fungi Logika: Fungsi IF (If tunggal dan Bertingkat) serta boolean (AND, OR, NOT), IFS, SWICTH
  • Fungsi Pembacaan Tabel: Vlookup(), Hlookup(), Xlookup, Filter, Index, Match, Database
  • Fungsi String: Left(), Right(), Mid(), Len(), Find(), Value(), Text(), Concatenate()
  • Fungsi Date/Time: day(), month(), year(), eomonth(), days360(), text(), today()

BIGGEST CONTRACT

1 April 2016
Luckily friends do ashamed to do suppose. Tried meant mr smile so.

AWARD WON

23 June 2016
Wonder bed elinor family secure met. It want gave west into high no in. Depend repair met before man admire see and. An he observe be it covered delight hastily message. Margaret no ladyship endeavor ye to settling.

Pricings

Raptures law diverted believed jennings consider children the see. Had invited beloved carried the colonel.

NO

MATERI TRAINING

Konsep Excel

Advanced Format Cell, Conditional Formatting, Fungsi Absolute, Formula aritmatika
Fungi Aritmatika: Sum(),Sumif(), Sumifs(), Counta(), Count(), Countif(), Countifs() Average(), Averageif(), Averageifs()
Fungsi Statistik: Max(), Min(), ), Rank(), Subtotal(), Sumproduct(), Small(), Large(), Mode(), Median()
Fungsi Penting lainnya: row(), rows(), Column(), Columns()

1,501 - 2,500
Select Plan
2,501 - 5,000
$30 per month
5,001 - 10,000
$50 per month
10,001 - 15,000
$75 per month
CUSTOM PLAN INQUIRY

CCC Master

Lembaga training yang fokus pada consulting serta developing data analysis, koding macro
CONTACT NOW
apartmentstorecartmustache linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram