Vlookups/Hlookups and Pivot Tables are my specialty. Your spreadsheets will be well structured with named ranges, data validation rules, if statements, conditional formatting, and whatever else is needed. I know which worksheet functions to use for a given task. Whatever is needed to get the job done, I will find a way. Over the past 20 years I have created countless spreadsheets for clients as a business analyst and am able to manipulate data fast and efficiently.
Projects are typically broken down into 3 different tasks:
Data Import and/or Entry (manually type or import from a CSV file, SQL Query, etc)
Data Cleanup (remove duplicates, standardize inconsistent data values, etc.)
Data Enrichment and Transformation (add formulas, parse and split fields, lookup additional values)
Data Reporting and Analysis (create PivotTables/Charts to display and analyze the data).
Please feel free to reach out to me if you are interested in my services.
Regards,
Robert (aka "Dr. Pivot")