Powerful Database Analysis and Dashboard Reporting with Excel 2010

PENDAHULUAN

Selama ini Microsoft Excel dianggap sebagai software pengolah data angka yang komprehensif dan sangat powerful. Banyak user dari berbagai departemen di perusahaan, seperti SDM, marketing, atau Humas yang menggunakan Excel untuk beragam proses pengolahan data dalam pekerjaan mereka sehari-hari. Namun demikian, sesungguhnya masih banyak fungsi dan fasilitas Excel yang belum digali dan diaplikasikan dalam praktek pengolahan data, khususnya sebuah database bank yang kompleks (banyak variabel) dan berjumlah besar.

MATERI

• Step by Step Operation for External Data Converting Process to Excel Database
• Created and Design Worksheet With Using Sparklines Object
• How Using Auto Filter with Union Field Key and Custom Filter
• Optimization Filtering Column in Database
• How Make Advance Filter (Criteria and Output Data Query)
• How Make and Using Consolidate Methods
• Removing Duplicate Rows
• Using the Excel Built-In Data Entry Form
• Creating a Drop-Down List in a Cell
• How Make Ranking Values
• Performing a LOOKUP Function
• How Using Operational Table with ADVANCE LOOKUP Function
• How Make and Using Pivot Table Optimization
• Created and Design Worksheet Report With Using Pivot Table
• How Make and Using Pivot Chart Optimization with Slicers Panel
• Created and Design Cells Graphic With Using Spark Lines
• How Make and Using Data Validation
• How Make and Using Data Validation Automation With Table Function
• How Make and Using Data Table Method for One Cell Input and Two Cell Input
• How Make and Using data Analysis Method (What If Analysis)
• How Make and Using Analysis Function
• How Make Active and Using Solver Analysis Tool Pack

METODE PELATIHAN

Pre test

Presentation

Discussion

Case Study

Post test

Evaluation

FASILITAS

Training Kit

Hand out

Certificate

Lunch + 2x Coffee Break

Souvenir

Form Pre-Registrasi

	Data Materi Training
Topik Training	: Powerful Database Analysis and Dashboard Reporting with Excel 2010
Link
*Jumlah Peserta	Estimasi Jumlah Peserta yang di ajukan
*Nama Peserta Yang Didaftarkan
	Personal Data
*Nama
*Jabatan	Jabatan/Divisi/Departement
*Nama Perusahaan
*Alamat Perusahaan
*Email Perusahaan
*Email Alternatif	eg: gmail, yahoo, hotmail
*Telepon Kantor
Ekstensi
*Handphone
	* Harus di isi
	Submit

SIMILAR ARTICLES

February 19, 2025

Training Online – Pembinaan dan Sertifikasi K3 Operator Boiler Kelas I (Kapasitas >10 Ton) Blended by KEMNAKER RI

February 19, 2025

Advanced Strategic Communication

February 19, 2025

Cashflow and Capital Management