I develop Excel applications using a cross-section of Excel's capabilities; these include Visual Basic for Applications (VBA), Pivot Tables, and Power Query.
My services include:
- Building custom applications using VBA
- Creating macros to automate repetitive tasks
- Creating custom functions when built-in worksheet functions are not enough
- Cleaning and preparing data for analysis
- Analyzing data with pivot tables