because i can give full time & efficiency and expertise. my expertise include Excel, Sql, VBA.
1. Strong working knowledge of office excel tool like creating macros, Pivot Table, V-Lookup, H-Lookup, if-Condition and other relevant formula and functions.
• Vlookup, Hlookup, Arrays, SumIFs, CountIFs, Statistical Functions, Offset Function etc.
• Advance Data Analysis Techniques, Data Consolidation Techniques and Data Tracking.
• Charting with MS Excel, KPI Dashboard, Dynamic Chart and Dynamic Dashboard with changing range.
• Pivot Table with Advance functionalizes (Run Time addition of calculated field, Use of Slicer in Pivot Table).
• Macro (Recording, Editing, Writing and Executing).