loading
reading
writing
saving
searching
Excel problems? Broken, complicated or built by someone else? (Nashville)
QR Code Link to This Post
I specialize in understanding, fixing, modifying, and improving existing Excel systems, as well as building new ones from scratch. Whether you have a single troublesome formula or a complex multi-worksheet application, I'm happy to take a look.
Inherited or undocumented Excel systems
• Understanding and documenting an existing system
• Fixing problems when the original developer is no longer available
• Modifying systems as business requirements change
• Improving or expanding an existing system rather than starting over
Fixing and improving existing spreadsheets
• Broken or mysterious formulas that need to be figured out and fixed
• Troubleshooting spreadsheets that don't produce the expected results
• Analyzing and reorganizing existing workbooks
• Improving spreadsheets that have become difficult to use or maintain
Building spreadsheets from scratch
• Custom spreadsheets that calculate complicated or specialized information
• Dashboards and reporting tools
• Custom calculators and tracking systems
• Multi-worksheet Excel applications
• Complex formulas and, when appropriate, VBA
• I’ve developed Excel applications including golf scoring and handicapping, tournament payout systems, Wordle game solver app, project tracking systems, equipment catalogs, cost reporting and invoice reconciliation, and other custom applications.
Data cleanup and organization
Do you have a large list of information that has become a mess? I can reorganize, clean up, sort, structure, and format data so that it becomes useful and manageable. This can include customer or client lists, mailing lists, equipment lists, project data, and other large collections of information.
Large Excel projects
I am especially suited to projects where an organization needs a complete Excel application built from scratch, especially when the project involves multiple interconnected worksheets, complex calculations, data manipulation, and even VBA.
Business forms
I can help small businesses develop a complete suite of professional business forms.
I previously developed a complete system for building business forms that look like a graphic design company created them. These forms, developed in Excel, are professional in appearance and functionality, but you would never guess they were created in Excel.
Using this system, I developed more than 100 business forms for a healthcare construction management company, including forms used for project management, reporting, meetings, and other business processes. Samples are available upon request.
Forms can be deployed to suit business needs:
• Excel (or web-based system) to be filled out on a computer
• Fillable PDF
• Paper-based for manual entry
Availability and rate
• Available 15-20 hours per week
• Rate starts at $50 per hour
• All inclusive project pricing is preferred whenever scope can be clearly defined.
• Free estimates. No fees charged until we agree on work and price.