Formulate, And Automate Excel And Google Spreadsheets By Vba

About This Gig

I have a total of 7 years of experience in Microsoft excel. I have solved several complex problems by using excel formulas. I would really solve your problems related to excel and reduce your time by using advanced excel formulas, power queries, pivot tables, conditional formatting, etc.

My service Areas:

• Advanced Formulas >> 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.
• Error Fixing >> #NUM! #REF! #VALUE! #DIV/0, #N/A, #NAME? #NULL! 
• Excel Pivot Tables >> Slicer, Timeline, Formulas, Field Items and Sets, Design Table
• Excel Dashboards >> Automated Excel and Pivot Chart
• Data Analysis >> Data Comparison from Different Source
• Excel Power Queries
• Solution Any Excel Related Problem