*** NEW COURSE LAUNCHED: 105 Excel VBA Functions Explained - Click Here ***

The Full Dev to QA to Prod Cycle with Excel VBA Projects

When developing, delivering and maintaining software solutions, you need to manage the Dev-QA-Prod cycle. This is no different when developing an Excel based application * Here’s how I do it

The Basics of Development Lifecycle

After you finish developing a scoped application, you need to pass it over to QA – Quality Assurance. The QA folks are abusing the software and document their exceptional findings: logical errors, software errors, user experience issues, environment conflicts, and the like. Often, issues classified as important will bounce back to development for fixing....

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

Excel VBA: Late Binding or Early Binding?

When using external function libraries in VBA, you need to choose between late biding and early biding * What is it, why chose one over the other and how is it done properly?

When the offered VBA functionality is not enough

With VBA you can flexibly write just the code you need for your program. It is a flexible, functional programming language that is also aware of the Excel Object Model. You can easily access and manipulate almost all of the Excel objects: Worksheets, Cells, Charts, Tables, Shapes, Printing settings and much more.

However, there are objects and tasks that are not readily...

Continue Reading...

Dashboards as a Trigger and Entry Point to Operational Transactions

Dashboards typically come from the Business Intelligence world. Updating the operational DB come from the transactional world. Why not connect the two for a full insight-to-action experience?

In a project I delivered this week to a new customer in Australia, it hit me that I have combined dashboards with updating data records for long time. Intuitively, as I envision the customer’s line of thought, I usually allow the user to cross the lines and open an update screen straight from a dashboard.

What’s the Big Deal?

In the traditional data-centric approach to business information...

Continue Reading...

Microsoft Office vs. Google Office Suite – How Will This Battle Turn Out?

Microsoft dominates the Enterprise. Google Offers native “cloud” office solutions. Microsoft is storming the cloud with full power. Google is widely used for email, web-search and gaining a foothold in Enterprise too. How will this play out?

The idea for this Blog post came as I was forwarded a similar question on Quora to answer. I’ll offer my perspective for the discussion on this question.

  1. Microsoft was always best at identifying new tech trends too late, but successfully bridge the gap and win the market. That’s because they’re much better as a marketing...
Continue Reading...

Protection Strategies in Excel

Why protect your Excel Worksheets? How to do it right? How to employ a protection strategy in a tight business application based on Excel? Can you protect your IP vested in your VBA code? Read this before you deliver your next Excel project to your customer

All Protection Options Available for You

Before we explore the business motivation and possible strategies for protecting your work, let’s recap all of the protection options we have in Excel:

  • Password-protect your Workbook file. This option will require a password you set, when the Workbook is opened. The Workbook will not even...
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...

Software Solutions for SMB: What’s Right for You?

You know you can’t run your business on Word and Excel only, unless your plan is to stay small. With all the options popping up, how do you go about making the right investments today, that will best balance your current resources with future growth?

When starting a business, and even during its first years, many seem to pay little attention to their Information Systems (or software solutions). Why? Because it’s one of those things that doesn’t stop the show, and isn’t really taught in business schools as a strategic enough lever. There are much more pressing issues...

Continue Reading...

From a Developer’s Workshop: Developing the Ultimate Excel Date Picker

Making an attractive Excel product that runs on every Windows computer is challenging * What were my main considerations, tricks and compromises? Read on…

Most of you are probably already familiar with the recent addition to my Excel mastery offerings: The Ultimate Excel Date Picker. If you’re not, now is the time to pause and have a look: https://morsagmon.com/datepicker.

Product vs Project

Unlike a customer-specific project, the Date Picker is a standard product. What’s the difference, you’re asking? A project is designed to meet specific needs of a particular...

Continue Reading...

The Wonders of SUMPRODUCT – The Powerful, Less Used, Excel Function

excel excel-application Feb 06, 2020
SUM, AVERAGE, COUNTIF, VLOOKUP – these are a few of the most popular Excel functions. If you’re advanced, or in a specific profession, you may also use DSUM, NPV, REPLACE – to name a few. Even if you heard of, or used, SUMPRODUCT – be prepared for a surprise.

As I was updating myself with Excel questions in Quora this morning, considering what to post in my Quora Excel VBA Expert Space, I came across this question: What is the most useful Excel function that no one ever uses? I needed less than a second to shout out: SUMPRODUCT!

The purpose of SUMPRODUCT

The...

Continue Reading...
1 2 3
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!