Microsoft Excel Dashboards And Reports (Menggunakan Microsoft Excel 2013/2016)

Lesson 1 : Custom & Conditional Formats

1. Creating a Custom Format
2. Create a custom number format
3. Conditional Formatting
4. Creating Conditional Formatting
5. Editing Conditional Formatting
6. Adding Conditional Formatting
7. Deleting Conditional Formatting from the Selected Range

Lesson 2 : Using Formulas & Functions

1. Relative Cell Reference
2. Absolute Cell Reference
3. Using Text Functions
4. Left Function
5. Upper Function
6. Concatenating the text values
7. Date Functions
8. Using Today Function
9. Calculating using Date Function
10. Using Sum Functions
11. Using CountA Functions

Lesson 3 : Working With Range Names

1. Using Range Names
2. Creating Range Names
3. Using Range Names in Formulas
4. Creating Range Names from Headings
5. Deleting Range Names
6. Creating 3-D Range Names

Lesson 4 : Using Advanced Functions

1. Using If Functions
2. Using Nested If Functions
3. Using Sum If Functions
4. Using Count If Functions
5. Using Vlookup Functions
6. Using HLOOKUP Functions

Lesson 5 : Managing Tables

1. Creating Tables
2. Naming the Table
3. Changing the Table Style
4. Creating a Total Row
5. Creating a calculated column
6. Using Filtering in Table
7. Removing the Duplicate Record

Lesson 6 : Using Auto Filter

1. Sorting Data
2. Using AutoFilter
3. Creating a Custom AutoFilter
4. Using Advanced Filter
5. Using Database Functions

Lesson 7 : Getting Most From Your Data

1. Creating Subtotal
2. Using Automatic Outline
3. Grouping Data Manually
4. Using Data Validation

Lesson 8 : Working With Charts

1. Creating a Chart
2. Formatting the Chart
3. Adding Labels
4. Changing the Chart Type, Data Source

Lesson 9 : Working With Pivot Tables

1. Creating Pivot Tables
2. Adding Pivot Table Report Fields
3. Refreshing Pivot Table Report
4. Changing the summary function
5. Creating report filter pages
6. Creating Pivot Chart

Lesson 10 : Using Shared Workbooks

1. Sharing a Workbook
2. Opening and Editing a Shared Workbook
3. Tracking Changes
4. Resolving Conflicts in a Shared Workbook
5. Linking Workbooks
6. Editing the Link
7. Consolidating Workbooks

Trainer : 

Para praktisi experts yang telah banyak memberikan training dengan topik Microsoft Excel Dashboards And Reports (Menggunakan Microsoft Excel 2013/2016) dengan menggunakan tools yang maksimal dalam mengembangkan Profesi & Karier dan meningkatkan kemampuan diri Peserta.

Biaya & Tempat Training Microsoft Excel Dashboards And Reports
(Menggunakan Microsoft Excel 2013/2016)