I will fix, create and troubleshoot your excel formulas and functions

Need help with Excel formulas, functions or simple automation?

I will fix, create and troubleshoot Excel formulas and help automate repetitive spreadsheet tasks with simple macros and buttons.

I can help with:

• Fixing broken or incorrect Excel formulas
• Creating formulas from scratch
• XLOOKUP and VLOOKUP
• IF, IFS and IFERROR
• SUMIF, SUMIFS, COUNTIF and COUNTIFS
• INDEX and MATCH
• Date, text and logical functions
• Formula errors such as #N/A, #VALUE!, #REF! and #DIV/0!
• Formulas across multiple worksheets
• Simple VBA macros
• Simple buttons and forms
• Basic spreadsheet automation
• Simple data source connections when included in the package
• 
  

Every solution is tested before delivery to make sure it works correctly with your workbook.

For Standard and Premium packages, source code and documentation are included where applicable.

Please contact me before ordering if your project involves complex VBA applications, advanced Power Query, external APIs, large databases, advanced dashboards or extensive automation.

If you are unsure which package fits your workbook, send me a message with your requirements and, if possible, the Excel file or a sample!