Have you ever had an Excel worksheet that needed specific input from the user for calculations? Learn how to create an input box in Excel using VBA to gather user data. Most applications rely on inputs from users to determine various functions or procedures. Excel has a number of input box functions that allow you to gather user input for your applications. This guide will show you how to use the Excel VBA InputBox function to create input boxes and 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

In this article, we are going to learn how to insert and use a toggle button in an Excel worksheet. A toggle button is used to indicate a state, such as Yes/No or a mode, such as On/Off. The button alternates between an enabled and disabled state when it is clicked. For example, you can use the toggle button to hide and unhide rows, hide and unhide columns, hide and unhide a chart, switch between design mode and edit mode, or as an alternative to the check box. Either way, you can see that toggle buttons are very useful.

Read More

In this Excel lesson, you will learn how to insert Scroll Bar to your worksheet. Also you will find out how useful is to insert it to make your worksheet more interactive and dynamic.

Read More