Electrosonic

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
How to Use Microsoft Access 2019 to Improve Efficiency

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 More
Microsoft Excel 2016 for Mac Versus Excel 2011 for Mac

Excel 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 More
How Businesses Become More Productive Using Microsoft Excel

How 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 More
Integration and Automation with Microsoft’s VBA

Integration 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 More
Free Excel Help – Arrays

A 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