Don’t Settle for Local: Excel & Access Makes Virtual Programming Simple! You’re a business owner or executive who recognizes inefficiencies in your use of Microsoft Office applications. You know a professional Microsoft consultant, programmer, and trainer can help to significantly improve your processes, reporting, and data utilization, but sadly, there are very [...]
3 Things That Make Working with Excel and Access So Simple At Excel & Access, LLC, we strive every day to help you and your company store and utilize data in a way that is effective, user-friendly, and efficient by providing benchmark Microsoft Application solutions in all of the Microsoft applications. When it comes [...]
Excel & Access Onboards Microsoft MVP Bob Umlas As a recognition granted by Microsoft, Microsoft Most Valuable Professionals, or MVPs, are tech experts who passionately share their knowledge with the community. They possess a profound understanding of Microsoft products and services and can bring together diverse platforms, solutions, and products to solve real-life [...]
3 Reasons It’s Important to Continuously Train Your Staff Microsoft programs such as Excel, Access, and Power Bi are powerful tools that can help your team get organized, save time, and achieve your aims and goals. However, despite being user-friendly and easy to understand, investing in continuously training your team on these programs [...]
VBA: Move executing line anywhere Summary Okay, so this may be a bit weird for a blog post, but my mind was blown when I saw this. An extremely nice gentleman by the name of Jordan Webb of EXOS showed me this. More proof that you can learn anything, anywhere, anytime, from anybody. Thank you [...]
Create Before/After Query Update Events Returning a web query can be very handy. Unfortunately if you want to run any code when this refreshes, there's no native way to do this. We can, however, create an event for this with a few short steps. This will all be done inside the Visual Basic [...]
Formula to check if an Excel Table is filtered Maybe you'll never have the need for this, to use a formula to see if a range is filtered. Maybe you will. There are a few indicators we have already to tell if a range is filtered or not. We can look at the [...]
How do Excel Tables remember formulas If you've used tables before you have seen your formulas automatically expand and contract with your data. This is a pretty handy feature of the tables. Some might say they just copy and paste the formulas, but this is not true. (See this blog post to see why structured [...]
Import Access Data into Excel via Power Query Much has changed since 2018; the year Microsoft Excel went dynamic. The way people import Access data into Excel has dramatically changed too. These days, Power Query is how data importation is done. There is no need to use VBA, no need to copy and paste. Simply [...]
Delete Duplicate Emails via MS Excel VBA Need: Do you have the need to delete duplicate emails from Microsoft Outlook? Perhaps you have accidentally created hundreds of duplicates, and your pst file is so vast you do not have the time nor the energy to remove each of them manually. In this case it [...]
