Precision Solutions for Excel, Access, and VBA.
Automate Excel tasks If you’re still performing repetitive tasks in Excel manually, you’re likely wasting hours every week without realizing it. Tasks like formatting, data cleanup, report generation, and copying data between sheets can all be streamlined—or fully automated. If you Automate Excel Tasks (particularly tedious ones) you can improve productivity and staff morale The […]
Why Excel Files Become Slow and Unstable If you’re dealing with a Excel file that crashes, freezes, or takes forever to respond, you’re not alone. Many Excel users unknowingly build processes that gradually turn a workbook into a bloated, slow Excel file, leading to frustration and lost productivity. The good news is that most of […]
When a UDF looks up data from an Access table, Excel can end up calling the function hundreds or even thousands of times during recalculation. Without a cache, each call hits the database (a.k.a. server trips), opening connections, running queries, and slowing things down unnecessarily. By loading the product table into a VBA Dictionary the […]
IntroductionUsing Access as a backend transforms Excel from a bloated storage container into a fast, lightweight calculation and reporting tool. Over time, even the cleanest spreadsheets suffer from workbook creep—the slow, steady expansion of data, formulas, and hidden “temporary fixes” that turn a perfectly good model built two years ago into today’s slow, oversized, and […]
Dynamic Gantt Charts In this video, I demonstrate how to create a dynamic Gantt Chart in Excel using VBA, including annotated “Event” diamonds to highlight key moments, like delays due to vandalism or bad weather. You’ll learn how to: Use VBA to create and add shapes (rectangles and diamonds) for chart visualization. Add event-specific code […]