Description

I will help you in accomplishing below listed and/or related requirements:

- Use VBA and macros to automate cleaning and transforming your Excel data

- Pivot tables and charts

- Convert/Export your Excel sheets to a CSV or PDF

- Importing files in automatically from CSV, other Excel spreadsheets

- VBA macros to Loop through entire excel data complete a task quickly

- Macros to prepare and send send emails via Outlook from Excel

- Compile and merge multiple sheets or files into a single sheet

- Convert formulae into values

- Creating Excel VBA User Form

- Create / Correct Simple / Complex Nested Formulas.

- Converting data into nice and simple dashboards for presentation

- Write customised macros to suit your requirements

- Creating Drop Down lists as per your requirement

I will also help you in implementing the below listed features into your excel files:

- Pivot Table

- Data Validation

- Apply formulas/Advance Filters

- Conditioning Formatting

- Dynamic Dropdown list

- VLOOKUP & HLOOKUP, INDEX-MATCH, OFFSET, SUMIF, COUNTIFS,