I will fix excel formulas, errors and solve excel spreadsheet
MS Excel Expert
Level 2
Has met high performance criteria and has a proven track record for meeting client expectations.
Highly Responsive
Known for exceptionally quick replies
About this Gig
Dear Valued Customer,
I am Subrata Chandra Modak. I have a total of 8 years of professional experience in Microsoft Excel, Power Query, Macros and Google Sheet.
My service:
Advanced Formulas >> INDIRECT, ARRAY FORMULA, VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, IF, OR, AND, NOT, IFERROR, LEFT, RIGHT, LEN, MID, FIND, COUNTIF, COUNTIFS, MAX, MIN, LARGE, SMALL, ROUND, ROUNDDOWN, ROUNDUP, SUBSTITIUTE, CONCATENATE, COUNTBLANK, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, DATE Function etc.
POWER PIVOT TABLES >> Automated Dashboard Design, Pivot Chart, Slicer, Timeline
Data Analysis
Excel Power Query
Dynamic Business Reports
Excel Template
Error Fixing >> #NUM! #REF! #VALUE! #DIV/0, #N/A, #NAME? #NULL! etc.
Data Validation in Excel sheet.
Conditional Formatting in Excel
Removing Duplicate Data
Solve any excel related problem according to requirements.
Note: You are requested to discuss the project before placing an order. So that, I can provide you with professional work to your 100% satisfaction.
Platform:
Excel
Development technology:
Power Query
Expertise:
Formatting
•
Fixing
•
Pivot tables
•
Formulas
•
Functions
