Microsoft Excel 2007 Beyond For Office Automation

Microsoft Excel 2007 Beyond For Office Automation

Tanggal
19-20 Desember 2012

Pukul
09.00 – 16.00 WIB

Tempat
Hotel HARRIS/AMARIS/IBIS TAMARIN
Jakarta

Invetasi
Rp. 3,750,000 / Peserta
Including : Tas Eksklusif, Sertifikat, Lunch & Coffebreak
Materi Pembicara Hard and Soft Copy (Flashdisk 4 GB)

OUTLINE

1.     What’s New in Excel 2007
2.     Read of Ribbon menu
3.     Database import
4.     Cell Address Automation.
5.     Data Sort
6.     Conditional Formatting
7.     Consolidate method.
8.     String Function
9.     Numeric Function.
10.     Remove Duplicates Tools
11.     Single and Multiple IF() Function.
12.     Logic Operator AND and OR.
13.     Table Function and Operational Table.
14.     How to make union field key
15.     Auto Filter with union field key
16.      PivotTable method.
17.      PivotChart method.
18.      Format Cells for Locked and Hidden Cells
19.     Training Evaluation

FASILITATOR
Robbi Wijaya SE MM
Profile Pembicara akan kami sertakan dalam UNDANG TRAINING