Excel 2016 and Power BI Desktop (Extract from MS Site)

Excel 2016 and Power BI Desktop deliver a portfolio of tools that is unique in the industry. Together, they enable business analysts to more easily gather, shape, analyze, and visually explore their data. Power BI is a suite of business analytics tools that deliver insights throughout your organization. It helps anyone in your organization bring together data from a wide range of sources—Excel workbooks, on-premises corporate data, Azure services, and other popular cloud-based offerings like Salesforce.com or Marketo—to view and share using live dashboards and interactive reports. 

Learn more about how Power BI and Excel work together.

CA Vikram S. Mathur (22-Aug-2017)

Benefit of INDEX+MATCH over VLOOKUP Function


From the above figure, it is amply clear why the INDEX+MATCH combination of functions is much better than the VLOOKUP Function. For two reasons (a) it does not require that the worksheet data be sorted, only that the value being sought is unique, and (b) a reverse direction lookup is also possibe, as shown in the figure, where the Employee number is looked up using the name of the employee. Cheers !!

CA Vikram Shankar Mathur
12-Apr-2017 | 01:39 Hours IST

What is Object Oriented Programming (OOP) ?

To begin this article, I would like to refer you to the Definition of Object Oriented Programming (OOP) as per Wikipedia.org, which begins as quoted below:

Object-oriented programming (OOP) is a programming paradigm based on the concept of “objects“, which may contain data, in the form of fields, often known as attributes; and code, in the form of procedures, often known as methods. A feature of objects is that an object’s procedures can access and often modify the data fields of the object with which they are associated (objects have a notion of “this” or “self”). In OOP, computer programs are designed by making them out of objects that interact with one another.There is significant diversity of OOP languages, but the most popular ones are class-based, meaning that objects are instances of classes, which typically also determine their type.

Many of the most widely used programming languages (such as C++, Java, Python etc.) are multi-paradigm programming languages that support object-oriented programming to a greater or lesser degree, typically in combination with imperative, procedural programming.”

Now I know all of that must have sounded too technical for you, do not worry, I shall attempt to simplify matters somewhat hereunder. We begin with a graphic representation of what is a “Programming Paradigm”.


Essentially, we are talking about the problem that you face when you steel your mind  – you want to solve it ANYHOW and that become the “Programming Paradigm“. I think the above figure will now make slightly more sense than it did before, correct? So you first convert the “model” that you intend to convert into a program that will carry out the required computation, manipulation and re-arrangement of the basic concept you are required to put into practice in such a way that it delivers the required result, be it a complex operation or a simple one. In our case, let us say that an organization has requested you to create their monthly payroll register. A sample Payroll Register could look like the figure below.


From the above, we note that the basic object is the Employee. After that, we also note that for each employee, there would be some kind of Attendance Record – which either contains the daily working either in terms of Hours per Day, or Days per Month, depending on whether they are Skilled Workers or Office Workers, for example. Based on the Attendance Record, the Monthly Computation of Payroll involves calculations that give the Earnings they are eligible for, the Deductions from their pay and finally, the Amount Payable to them for the end of that particular accounting period for which the Payroll Register has been created, usually, it is for the Calendar Month, for example.

Now you have the following objects (a) Employee, (b) Attendance, (c) Attendance Units logged, (d) Payroll Earning Components, (e) Payroll Deduction Components and finally (f) Payroll Payable for that particular period.

That, friends, is what I would say is the simplest way that Object Oriented Programming can be explained, right? If you have any questions for the author, you are welcome to drop a line to exceltrainerahmedabad@gmail.com and I shall be quite delighted to answer them to the best of my abilities. Cheers !!

CA Vikram Shankar Mathur
14-Feb-2017 | 23:51 Hours IST | #CAVSM |

Excel VBA Training Center, Ahmedabad

Excel VBA Training Center, Ahmedabad is now a full fledged Facebook Page with effect from today (17-Jan-2017) after the Facebook Team accepted my claim for it. So now the page has a username of [@excelvbtc.ahmedabad].

This essentially means that the URL http://facebook.com/excelvbtc.ahmedabad will take you to that page, as will the shorter URL http://fb.me/excelvbtc.ahmedabad – as well as the fact that you can message the page using the URL http://messenger.com/t/excelvbtc.ahmedabad or alternatively use the shorter URL http://m.me/excelvbtc.ahmedabad and send a message to me via that page. Cheers !!

17-Jan-2017 | 01:02 Hours IST | #CAVSM |