I will create and fix excel formula, chart, graph, pivot table, dashboard

About This Gig

Hi, I am Srabani. I can help you to fix any issue of your Excel and Googlesheet and I can design and automate your work using formulas, functions, charts/grapgs, Macros/VBA.

SERVICES DETAILS

FORMULA MAKING: Formula issues fixing & Creating new formula 

REMOVE DUPLICATE,SUMIFS, COUNTIFS,VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, IF, NESTED IF, FILTER, UNIQUE, SORT, ROUND, DATE & TIME, SMALL, LARGE, RANK, CONCATENATE, OFFSET, TRIM, SUBSTITUTE, Solving any Excel and Googlesheet formula as per the requirement.

ERROR FIXING: #VALUE, #N/A, #REF, #NUM, #CAL, #NULL, #NAME?, #DIV/0, #####, Circular Reference etc.

PIVOT TABLE: Pivot Charts, Time Line, Slicer, Power Pivot

TEMPLATE/TRACKER: Project Management, Gantt Chart, Inventory Mnanagement, Budget, Invoice, Calendar, Vacation Itinerary, Leave/Holiday, Loan Amortization, Sales and Marketing. 

SPREADSHEET: Excel & Googlesheet Data Entry, Cleaning, Formatting, Organizing, Sorting & Analysis. Building any custom automated spreadsheet.

VISUALIZATION: Presenting data professional way by charts/graph & Dashboard.

IMPORTANT: Please must discuss about your requirements before placing order to avoid any misunderstanding.