Pelatihan tersebut membahas:
- 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
- Optimation 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 PivotTable Optimation
- Created and design worksheet report with using PivotTable
- How make and using PivotChart Optimation 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.
- How using of Format Cells for Locked and Hidden Cells
- How using of Using Allow Users to Edit Range ( Permission User Access Setting )
- How using of Protect Sheet ( Select Locked Cells and Select Unlocked Cells )
- Case study implementation
Testimoni Peserta Pelatihan Powerful Data Analysis & Dashboard Reporting With Excel 2010
“Terima kasih telah mengajar kami dengan baik”