My service Areas:
· Advanced Formulas >> Nested Loop>> VLOOKUP, HLOOKUP, INDEX, MATCH, IF, OR, AND, NOT, IFERROR, LEFT, RIGHT, LEN, MID, FIND, SUBSTITIUTE, CONCATENATE, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, LARGE, SMALL, ROUND, ROUNDDOWN, ROUNDUP, SUM, SUMIF, SUMIFS, DATE Function etc.
Pivot Tables >> Automated Dashboard, Pivot Chart, Slicer, Timeline
Excel Dashboards and Charts
Data Analysis
Dynamic Business Reports
Excel Template
Fast Data Entry
Error Fixing >> #NUM! #REF! #VALUE! #DIV/0, #N/A, #NAME? #NULL! etc.
Data Validation
Conditional Formatting
Removing Duplicate Data
Power Query
Solve any excel formula related problem as per requirement