Hi
I have Sound working experience in VBA with well proficiency in Advance Excel.
Excel proficiency:
Excellent in MS Excel (Formatting, Conditional formatting, Sorting, Filter, Pivot Table, Pivot Chart,
what if analysis, data validation, data extraction, Dynamic Dashboard Etc.
.FORMULAS:
• Logical Formulas: if, and, or, ifs, iferror, ifna, xor, Etc.
• Text Formulas: Right, Left, Mid, Find, Concatenate, Substitute, Replace, upper, Lower, Proper, Etc.
• Date & Time Formulas: Date, Edate, Eomonth, Networkdays, Workdays.int. time, timevlue Etc.
• Lookup and reference Formulas: Vlookup. Hlookup, Index, Offset, Choose, Match, Columns Etc.
• Math & Trig Formulas: Count, Countif, Countifs, Sum, sumif, Sumifs, Sumproducts, Aggregate, Etc.
• Arrya Formulas: Linking of Spread sheet with the help of Array, Array in Multiple formulas, Array
with Lookup functions, Lambda , Let , Map ,Advanced Use of formulas with Array. Use of Sumproduct
in critical situations Etc.
• Customize Working With Excel Like:- Report Automation, Dynamic Dashboard, Chart. Etc