Jadwal Pelatihan Online Training – Powerful Database Analysis and Dashboard Reporting with Excel 2010 Tanggal Tempat Kota 18 - 19 Agustus 2020 - -
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 Training Online – Powerful Database Analysis and Dashboard Reporting with Excel 2010
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
Created and design Cells Graphic with using Spark Lines , Created and Design Worksheet Report With Using Pivot Table , Created and design worksheet with using Sparklines object , Creating a Drop-Down List in a Cell , Criteria and Output Data Query , How make active and using solver analysis tool pack , How make Advance Filter , How make and using analysis function , How make and using Consolidate Methods , How make and using data analysis method , How make and using Data Table Method for one cell input and two cell input , How make and using Data Validation , How make and using Data Validation Automation with Table Function , How Make and Using Pivot Chart Optimization with Slicers Panel , How Make and Using Pivot Table Optimization , How make Ranking Values , How using Auto Filter with union field key and Custom Filter , How using Operational Table with ADVANCE LOOKUP Function , Optimization Filtering Column in Database , Performing a LOOKUP function , Powerful Database Analysis And Dashboard Reporting With Excel 2010 , Removing Duplicate Rows , Step by step operation for external data converting process to Excel database , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Aceh , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Ambon , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Bali , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Balikpapan , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Bandung , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Banten , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Batam , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Bekasi , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Cilegon , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Jakarta , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Lombok , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Makassar , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Malang , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Maluku , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Padang , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Pekanbaru , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Riau , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Samarinda , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Semarang , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Solo , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Surabaya , Training Powerful Database Analysis And Dashboard Reporting With Excel 2010 Yogyakarta , Using the Excel Built-In Data Entry Form
