Lesson 1. Custom & Conditional Formats

• Creating a Custom Format
• Create a custom number format
• Conditional Formatting
• Creating Conditional Formatting
• Editing Conditional Formatting
• Adding Conditional Formatting
• Deleting Conditional Formatting from the Selected Range

Lesson 2. Using Formulas & Functions

• Relative Cell Reference
• Absolute Cell Reference
• Using Text Functions
• Left Function
• Upper Function
• Concatenating the text values
• Date Functions
• Using Today Function
• Calculating using Date Function
• Using Sum Functions
• Using CountA Functions

Lesson 3. Working With Range Names

• Using Range Names
• Creating Range Names
• Using Range Names in Formulas
• Creating Range Names from Headings
• Deleting Range Names
• Creating 3-D Range Names

Lesson 4. Using Advanced Functions

• Using If Functions
• Using Nested If Functions
• Using Sum If Functions
• Using Count If Functions
• Using Vlookup Functions
• Using HLOOKUP Functions

Lesson 5. Managing Tables

• Creating Tables
• Naming the Table
• Changing the Table Style
• Creating a Total Row
• Creating a calculated column
• Using Filtering in Table
• Removing the Duplicate Record

Lesson 6. Using Auto Filter

• Sorting Data
• Using AutoFilter
• Creating a Custom AutoFilter
• Using Advanced Filter
• Using Database Functions

Lesson 7. Getting Most From Your Data

• Creating Subtotal
• Using Automatic Outline
• Grouping Data Manually
• Using Data Validation

Lesson 8. Working With Charts

• Creating a Chart
• Formatting the Chart
• Adding Labels
• Changing the Chart Type, Data Source

Lesson 9. Working With Pivot Tables

• Creating Pivot Tables
• Adding Pivot Table Report Fields
• Refreshing Pivot Table Report
• Changing the summary function
• Creating report filter pages
• Creating Pivot Chart

Lesson 10. Using Shared Workbooks

• Sharing a Workbook
• Opening and Editing a Shared Workbook
• Tracking Changes
• Resolving Conflicts in a Shared Workbook
• Linking Workbooks
• Editing the Link
• Consolidating Workbooks

• Program pelatihan berlangsung selama 2 hari, total 12 jam.
• Waktu pembelajaran pukul 09.00-16.00 WIB, setiap harinya.
• Materi disampaikan dengan pemaparan, latihan dan diskusi.
• Diperkaya dengan studi kasus, simulasi, dll.

• Modul pelatihan dan seminar kit.
• Sertifikat pelatihan dari penyelenggara.
• Makan siang, rehat kopi dan kudapan.
• Suvenir, bila persediaan masih ada.
• Diskon khusus bagi yang mendaftar dalam grup, lebih dari 3 orang.
• Tidak termasuk penginapan dan transportasi.

Lesson 1. Custom & Conditional Formats

• Creating a Custom Format
• Create a custom number format
• Conditional Formatting
• Creating Conditional Formatting
• Editing Conditional Formatting
• Adding Conditional Formatting
• Deleting Conditional Formatting from the Selected Range

Lesson 2. Using Formulas & Functions

• Relative Cell Reference
• Absolute Cell Reference
• Using Text Functions
• Left Function
• Upper Function
• Concatenating the text values
• Date Functions
• Using Today Function
• Calculating using Date Function
• Using Sum Functions
• Using CountA Functions

Lesson 3. Working With Range Names

• Using Range Names
• Creating Range Names
• Using Range Names in Formulas
• Creating Range Names from Headings
• Deleting Range Names
• Creating 3-D Range Names

Lesson 4. Using Advanced Functions

• Using If Functions
• Using Nested If Functions
• Using Sum If Functions
• Using Count If Functions
• Using Vlookup Functions
• Using HLOOKUP Functions

Lesson 5. Managing Tables

• Creating Tables
• Naming the Table
• Changing the Table Style
• Creating a Total Row
• Creating a calculated column
• Using Filtering in Table
• Removing the Duplicate Record

Lesson 6. Using Auto Filter

• Sorting Data
• Using AutoFilter
• Creating a Custom AutoFilter
• Using Advanced Filter
• Using Database Functions

Lesson 7. Getting Most From Your Data

• Creating Subtotal
• Using Automatic Outline
• Grouping Data Manually
• Using Data Validation

Lesson 8. Working With Charts

• Creating a Chart
• Formatting the Chart
• Adding Labels
• Changing the Chart Type, Data Source

Lesson 9. Working With Pivot Tables

• Creating Pivot Tables
• Adding Pivot Table Report Fields
• Refreshing Pivot Table Report
• Changing the summary function
• Creating report filter pages
• Creating Pivot Chart

Lesson 10. Using Shared Workbooks

• Sharing a Workbook
• Opening and Editing a Shared Workbook
• Tracking Changes
• Resolving Conflicts in a Shared Workbook
• Linking Workbooks
• Editing the Link
• Consolidating Workbooks

• Pembelajaran dengan metode video conference (live streaming).
• Pelatihan berlangsung selama 2 hari, durasi 10 jam. (5 jam per hari)
• Materi disampaikan dengan ceramah, tanya jawab, dan latihan.

• Modul pelatihan dalam bentuk softcopy.
• Sertifikat pelatihan diberikan dalam bentuk e-certificate.
• Bila membutuhkan sertifikat cetak, akan dikirimkan lewat jasa kurir.
• Souvenir, selama persediaan masih ada.