I will do anything in excel, macros, formulas and functions

Hi everyone,

I will AUTOMATE your repetitive works as per your requirements using (EXCEL VBA, MACROS, FORMULAS) and also create DYNAMIC & INTERACTIVE (USERFORM) for Data Entry, Reporting & DASHBOARD.

I have Over 10 years of experience and can provide following services:

Split the text/data/formula into different columns via VBA/MACRO

• IF Statement, Nested IF Function (AND, OR)
• SUMIF, SUMIFS / COUNTIF, COUNTIFS / IFERROR
• VLOOKUP / HLOOKUP / XLOOKUP
• INDEX / MATCH / FILTER / ADVANCE FILTER
• PIVOT Tables / PIVOT Reporting
• Drop Down List / Data Validation
• Conditional Formatting / Data Formatting
• Building Advance Formulas
• Remove Duplicates (VBA)
• Formula Automation / Linking Tables

VBA/MACROS/FORMULA related any issues as per your requirements

ADVANCE EXCEL SERVICES

• Add-Ins
• Login System
• VBA Functions, Macros
• Dashboard, Reports, Charts
• PIVOT Tables, Reports, Charts
• Dynamic & Interactive User Form
• Large Data Analysis, Reports
• Project Management system
• Inventory Management system
• Auto Invoicing, Payroll, Stock Trading Trackers
• Dynamic Database Creation, Automation via (VBA/Macros)

STATISTICAL ANALYSIS PERFORMED

· Regression

· Just Right Test

· Price Sensitivity Meter (PSM)