Unleash the power of Excel, Access, Word and VBA.
Welcome! I’m Ray Mills, founder of Excel and VBA Craftsman LLC and your seasoned Excel, Access, and VBA Automation Expert. With decades of experience, I help businesses streamline operations and optimize workflows through custom Microsoft Office solutions.
With over 30 years of experience as an auditor, controller, data miner, and MS Office developer—including work with major financial institutions like JP Morgan—I’ve built deep expertise in financial systems, data accuracy, and automation. Now retired from full-time corporate life,I offer my services through Excel and VBA Craftsman LLC at a competitive rate of $50/hour—delivering exceptional value through decades of hands-on experience as a developer, auditor, and business owner. You can trust that I bring both depth and practical insight to every solution.”
Think of Excel and VBA Craftsman LLC as your go-to partner for anything Excel, Word, Access, and VBA. Whether you’re looking to automate repetitive tasks, streamline complex workflows, or build custom tools, I provide tailored, high-quality solutions that address your unique business challenges.
Why Work With Me?
Beyond my technical proficiency, my diverse background sets me apart. As a former controller, auditor, and data miner, I understand the intricacies of managing financial data and creating systems that ensure precision and efficiency. This allows me to craft solutions that are tailored to your needs, whether you’re looking to optimize existing workflows or build entirely new systems from scratch.
In addition to my professional expertise, I leverage cutting-edge AI tools to enhance both my development speed and accuracy. By incorporating AI into my process, I’m able to quickly analyze complex data, optimize code, and deliver high-quality solutions in a fraction of the time. This means faster project turnarounds, increased efficiency, and above all, precise results that meet the highest standards.
Tailored Solutions That Work For You
In my portfolio, you’ll find a wide range of solutions designed to help clients just like you. I specialize in Access database design and Excel front-end integration, creating user-friendly systems that streamline data management. From developing intricate inventory and contract systems with Excel interfaces to crafting web scraping tools for platforms like Amazon, my versatility knows no bounds.
Whether you need a complete system overhaul or a simple automation solution, I’m here to provide custom solutions that work for your business, at a fraction of the cost you might expect for someone with my qualifications.
Below I’m showcasing my custom-built Excel Calendar add-in that’s designed to give you full control over your calendar’s appearance and functionality when using excel. Whether you need to mark specific days off, adjust the start of your week, or display up to four months at once, this add-in does it all! You can also add custom holidays and days off for ultimate personalization.
Created with advanced VBA coding, this tool is perfect for anyone looking to organize their schedule more efficiently and visually. It’s not just about functionality—it’s about putting your unique needs at the forefront. Check out the video Here to see how it works and learn more about how my expertise in Excel and Access VBA development can help streamline your workflow.Unleash the power of Excel, Access, Word, and VBA.backed by dual master’s degrees and decades of hands-on experience, you can trust that I bring both depth and practical insight to every solution.”

Excel and Access Blog Posts Favorites


For a long-term client, I transformed a chaotic spreadsheet system into a disciplined Contract Management System powered by a robust database and custom Excel menus. This streamlined workflows, minimized errors, and recovered lost revenue, directly improving their bottom line. Custom Excel menus enhance productivity by offering quick access to relevant tools, simplifying navigation for non-expert users, and maintaining consistency across projects. The result? A more efficient, user-friendly, and scalable solution that delivers real business impact.
Looking to take your business to the next level? A well-designed database combined with Excel’s front-end capabilities, including a custom calendar tailored to your needs, can streamline scheduling, enhance data management, and improve productivity. See my example to the left. You can read more about my custom calendars and get a free download here.