If You Love Excel – Here is Why You Need to Learn VBA

You are good with Excel. You love it. It gets the job done. You even heard about Macros, or VBA, but pushed it aside. It is not for you, you said to yourself. It is too complicated, you thought. I am here to tell you: it is exactly what you need to do next. Here is why.

The plain motivation at sight

Would you skip learning how to drive a car had I told you it can get you to your destination hundreds and thousand times faster than your bicycle?! I don’t think so.

Operating a vehicle may sound difficult, if not frightening, if all you’re used to is riding your bike. Still –...

Continue Reading...

Frequently Asked Questions on the Excel VBA Inner Circle Program

I received many questions on The Excel VBA Inner Circle program since it was launched. I summarize here the most frequent questions and my answers to them.

Last week I published a Blog post I thought would be all you may need in order to choose the right Inner Circle plan for you.

However, I am still getting some questions from some Excel enthusiasts about the program.

Today’s post is dedicated to those still having questions.

Frequently Asked Questions

Q:           I already learned Excel VBA and get along pretty well. Why should I...

Continue Reading...

How to choose the best Excel VBA Inner Circle plan for your career?

career Dec 03, 2020
The Excel VBA Inner Circle offers a wide range of services to support all Excel VBA enthusiasts. If you just want to start learning Excel VBA or you are a top Excel VBA consultant already – the Inner Circle got you covered. Here is a guide to help you choose the right plan for you

What is The Excel VBA Inner Circle program?

The Excel VBA Inner Circle is a professional “club” in which Excel users can learn, get support, and practice VBA.

The program offers three subscription plans, each designed to promote you as an Excel professional in different stages of your career.

...

Continue Reading...

A story about a customer request and the delivered Excel VBA solution

A rare glimpse of the “behind the scenes” work on an Excel project. From the raw customer request through the business requirements analysis report up to the delivered solution. Impressions from the first Excel VBA Inner Circle workshop.

The first Excel VBA Inner Circle monthly workshop took place two days ago.

The monthly workshop is a deep dive into some aspect of Excel VBA and SQL programming and career. I expose advanced VBA programming, code, user experience considerations, data design and processes planning, and any professional aspect having to do with Excel VBA and SQL.

...
Continue Reading...

How the Excel VBA Inner Circle Came to Be?

These days, I am launching a unique home for Excel VBA enthusiasts and professionals. This is a result of a careful examination of the Excel VBA market, constant dialog with customers and years of projects, authoring and teaching. Here is the story of the Excel VBA Inner Circle.

Where do Excel VBA professionals Meet?

Microsoft Office is one of the most ubiquitous software serving almost every business and many individuals. In 2016, windowscentral.com estimated 1.2 Billion Office users worldwide.

When I segmented for Excel AND VBA interest in Facebook Ads Manager, Facebook found 400,000...

Continue Reading...

105 Excel VBA Functions Explained: My New Course Launched Today

What makes this course unique * What is this course about * What did it take to produce this course * Is this course right for you?

Not that I planned to launch this new course when everybody is glued to the computer screen waiting for the Corona scare to pass by, but today is the day, and it’s out!

Those of you who follow me for a while, already know the wide portfolio of services and products I offer, all about developing business software with Excel VBA and leading many others to become such consultants.

IF you’ve completed my flagship course: Computer Programming with Excel...

Continue Reading...

Career Options for Excel VBA Developers

What can you do as an Excel developer? Can you make a living out of it? Is it worth anything in the job market? Here’s my take…

What Kind of an Excel VBA Developer are You?

You might be surprised this question is even raised. Intuitively, once you’re an “Excel VBA Developer”, then you’re an “Excel VBA Developer”. Right?! Well, let’s look closer.

Consider Joe. Joe is an accountant in a large corporation. He is an avid Excel user, really stretching the grid and built-in functions. Joe started recording some Macros to automate some tasks....

Continue Reading...

How a Small “Excel fix” turns into a Full-Blown Project

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...

Continue Reading...

What Does it Take to Become a Successful Business Software Consultant?

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...

Continue Reading...

Why isn’t VBA Popular Amongst Software Programmers?

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...

Continue Reading...
Close

50% Complete

Two Step

Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!