A New Microsoft Excel Client and Their Unique Need We had a company call us with a request to document their Excel files. The person that wrote them, formulas and macros, left. We documented two file consisting of over 20 sheets and 1,000 lines of VBA code by producing a 10 page PDF. […]
Read More
Document
How to Use Microsoft Access 2019 to Improve Efficiency Find out more about Microsoft Access and learn how the Excel Consultant team can use its functions to develop databases that enhance efficiency Read Gregg’s complete post here: With Office 2019 Currently Pending release, is this perhaps the perfect time to update your version […]
Read MoreMicrosoft Excel 2013 to Excel 2016 for Windows: What’s the Difference? Are you considering making the change from Microsoft Excel 2013 to Excel 2016 for Windows? If so, what’s the difference between the two? How do you decide? Read on to learn more about this new software from Excel Consultant’s experts. It’s that […]
Read MoreExcel 2016 for Mac Versus Excel 2011 for Mac: The Inside Scoop from Excel Experts It’s a common computerized conundrum: the latest software is out, but is it what you want? Is it something IT will approve and support? Should you switch from your reliable, existing program to the flashy, new, exciting, and supposedly […]
Read MoreHow Businesses Become More Productive Using Microsoft Excel Said another way, How Do Businesses “Excel Efficiently“ Fact: Did you know that 60% of the Excel 2013 templates that come within Microsoft Excel were done by our company. Yes, several of our Microsoft Excel MVP’s worked on our organization’s project for Microsoft. Some project! […]
Read MoreIntegration and Automation with Microsoft’s VBA If you want to get the most out of your Microsoft desktop productivity tools, such as Excel, Access, and Microsoft’s Power BI you will need to maximize both integration and automation with Microsoft’s VBA. VBA is the glue that binds the various Microsoft Office applications, in addition to […]
Read MoreA variable which has is a similar type but holds a different value is what an array means. It is used in almost every programming language which can also be mixed or paired to different variables for a simple or more complicated structure of data. Due to the property of an array that it holds […]
Read More