We are going to learn about programming DO UNTIL loops. First, we are going to learn what loops are and why they are necessary. Then we are going to learn how to use a DO UNTIL LOOP.

Read More

While using VBA, you may have encountered many different errors (or bugs). These VBA errors fall into 3 categories:

1. Compile error
2. Runtime error
3. Logical error.

These VBA errors are discussed in below.

Read More

Have you ever had an Excel worksheet that needed specific input from the user for some calculations? Most applications rely on inputs from users to determine various functions or procedures. Excel has a number of functions that allow you to gather user input for your applications. This article will show you how to use the Excel VBA InputBox function to get user input for your worksheets.

Read More

We are going to learn how to sort data in columns with VBA instead of using Excel’s sorting feature. We are going to random sort the data in columns using VBA.

Read More

The solver in Excel is part of an analysis tool known as “What-If analysis”. You can use a solver to ascertain an optimal value in one cell known as the “target cell”.

Basically, a solver is used for a group of cells that are directly or indirectly related. Constraints can also be applied to minimize the value that can be used by Solver. We will provide a step-by-step guide on how to use Solver to find a solution to a business problem.

Read More

A company budget is a financial plan that outlines how a business will spend its money over a specific period of time. Budgets are typically created on an annual basis, but they can also be created for shorter periods of time, such as quarterly or monthly.

Read More

Excel is a very important application for the planning of household budget. A complete plan with Excel can help you see your expenses and incomes at a glance, ensuring that you plan your family’s finances effectively.

With Excel, you can automatically update changes using spreadsheet calculations. Preparing your household budget in this manner can help you do a lot of things such as planning for holiday expenses or preparing for Christmas.

This section shall take you step by step on the best way to prepare household budget in Excel. But before you begin, you need to have a computer with Excel spreadsheet (preferably the latest version) installed.

Read More

Excel Dashboard reports are becoming increasingly popular these days. They help the reader quickly comprehend raw data by presenting it in virtually rich tables and charts. They are interactive and give a comprehensive insight into business performance indicators, making them easier to change or filter to your preference.

Creating Excel dashboards can now be carried out without worrying yourself about additional software. If you are looking to build a KPI dashboard in Excel, follow these steps below:

Read More

Excel has a variety of tools that make analyzing, sorting, and compiling data easy. However, there are add-ins that can perform different functions to help you improve your efficiency and reduce the time spent on your Excel worksheet. Here are the top 11 Excel add-ins you need to incorporate into your Excel sheet for more efficiency.

Read More

In this article, we are going to learn how to refer to a cell in VBA. When using one of the most common task is to refer to a cell or a range of cell and then do something to it like changing the format of the cell or entering a formula in the cell. An example is highlighting the cell A1.

Read More