Latest Posts
2

What You Can Do with VBA

What You Can Do with VBA

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. VBA is a very rich programming language. It has thousands of uses. A few things are listed below that you ...

READ MORE +
1

Introduction to VBA Macros

Introduction to VBA Macros

Here I am starting introducing you with the Visual Basic for Applications (VBA) macro language. VBA is a key component. Excel users use VBA macros to customize and automate Excel. This chapter will ...

READ MORE +
0

SUMPRODUCT() function in Excel

SUMPRODUCT() function in Excel

SUMPRODUCT function: Syntax  SUMPRODUCT (array1, , , ...)SUMPRODUCT function: Example Example: =SUMPRODUCT(A2:B4, C2:D4). This example say that components (A2, A3, A4, B2, B3, and B4) of Array1 ...

READ MORE +
0

Reverse What-If Analysis in Excel

Reverse What-If Analysis in Excel

In our this series of articles: What-If Analysis in Excel, we have discussed what-if analysis— the process of changing values of input cells to observe the results on other dependent cells. This ...

READ MORE +