Select Page

Resources & Blog: Vba

When is the right time to learn Visual Basic for Applications?

When is the right time to learn Visual Basic for Applications? Decide when to use the built-in Visual Basic for Applications tools or take your projects to the next level If you’ve ever tried to tackle a Microsoft Office Visual Basic for Applications (VBA) project yourself, then you know how daunting that can be.  While there are built-in Office tools to help you create macros and perform advanced data analysis, at some point you may realize that the default tools are not good enough.  By learning Visual Basic for Applications on your own, you can...

read more

Advanced Excel Data Analysis – Data Table

Advanced Excel Data Analysis – Data Table Data Tables can help you save time in Excel data analysis While working in Microsoft Excel on data analysis, there are a handful of built-in analysis tools available.  If you’re interested in studying the effect that a range of values has on the formula, you should consider setting up a data table. Let’s consider an investment analysis example to start.  Suppose that you want to see the future value of an investment with the annual deposit varying between $6,000 and $11,000.  You could...

read more

Custom Excel Visual Basic Application – Project Review – NM Industrial Service

Custom Excel Visual Basic Application – Project Review – NM Industrial Service Creating a custom solution for a better Excel workflow Project Description Nate Martinez Industrial Services (NMIS), an industrial construction services company out of Denver, recently reviewed their workflows and found some deficiencies in the ways in which they were using Microsoft Excel to create their submittal forms.  Digital Workshop Center stepped in to create a custom Excel and Visual Basic Application (VBA) to help streamline their processes and help save them tremendous amounts of...

read more