Excel Advance for Data Managing

"Excel Advance for Data Managing" training is a training program designed to provide knowledge and skills in analyzing data at an advanced level. This training is also to be able to see trends in data by using the prediction feature in Excel. So by processing the data, it is hoped that participants will be able to analyze data in the current situation and also predict data in the future.

After completion of this program, participants will be better able to:

• Protection : File, Workbook, Worksheet, Range & Cell
• Data managing : Pivot table, Pivot chart, Slicer & Timeline, Dashboard
• Data managing : Conditional Formatting, Text to Column, Flash Fill, Remove Duplicate, Data Validation, Consolidate
• Data prediction : Forecast, Scenario Manager, Goal Seek, Data Table
• Data managing : Power Query, Power Pivot
• Data cleaning : Trim, Exact, Len, Concatenate, Right, Mid, Left, Proper, Upper, Lower
• Data logical & lookup : If, And-Or, If Error, Aggregate, Vlookup, Hlookup, Index-Match