Just a small Excel fix. Just a couple of tables as a temporary solution. Just a little help with some formulas * How small Excel problems turn into a large-scale, business software. Happens to me all the time…

Just a small patch...

Couple of weeks ago, I was approached by a business owner, with this story: he’s offering an online service that matches home loaners with investors. For every mortgage need, he matches many small investors (any person, basically) to fund this loan. Loaners’ monthly receivables are distributed to the loan’s funders, short of the...

Becoming a successful figure in any field required a combination of skills, resources, knowledge and experience. Why is one lawyer so successful while others are not? How about marketing consultants? * What is the recipe for a successful business software consultant?

The last two Blog posts clarified some questions about choosing VBA as the programming language for your business software consultant career. I presume by now you have come to appreciate the opportunity, and the alignment of your career goals with VBA. Frankly, you can take the Excel VBA courses I offer and find your way. This...

A glimpse at any major open positions board will quickly reveal VBA is not among the popular programming languages out there, when it comes to business applications. This is surprising, considering the fact it is the language used in MS-Access, a database-oriented applications development environment that is part of the MS-Office 365 Business Suite, and the underlying language of the other, most popular MS-Office Suite of applications.

Brief VBA History

Ever since it was introduced in 1993 with Excel 5.0, VBA hesitantly played in between two fields: Microsoft’s Office applications...