Step Keyword in Excel VBA
Apr 20, 2020
You can use the Step keyword in Excel VBA to specify a different increment for the counter variable of a loop. This video explains how to do the same. You can use the Step keyword in Excel VBA to specify a different increment for the counter variable of a loop. Place a command button on your worksheet and add the following code lines: Dim i As Integer For i = 1 To 6 Step 2 Cells(i, 1).
How to use Goal Seek analysis tool In Excel
Mar 25, 2020
If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature. For example, suppose that you need to borrow some money. You know how much money you want, how long you want to take to pay off the loan, and how much you can afford to pay each month. You can use Goal Seek to determine what interest rate you will need to secure in order to meet your loan goal.
How To Use sparklines to show data trends In Excel
Mar 25, 2020
Looking for a way to visualize a large volume of data in a little space? Sparklines are a quick and elegant solution. These micro-charts are specially designed to show data trends inside a single cell.
In this article, you’ll learn all about Excel Sparklines and see some useful examples of it.
How to Calculate Compound Annual Growth Rate in Excel
Mar 18, 2020
Compound annual growth rate (CAGR) is the rate of return that would be required for an investment to grow from its beginning balance to its ending balance, assuming the profits were reinvested at the end of each year of the investment’s lifespan.
How to Count the Number of Cells that Contain Specific Text
Mar 18, 2020
Let's say you want to ensure that a column contains text, not numbers. Or, perhapsyou want to find all orders that correspond to a specific salesperson. If you have no concern for upper- or lowercase text, there are several ways to check if a cell contains text.
Usually with the IF function you test a cell for a complete match, but in this example we need a partial match on text.
How to Use Two-column Lookup in Excel
Mar 18, 2020
If you want to look up a value in a table using one criteria, it’s simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOKUP, MATCH, INDEX, etc. In this blog post, I’ll show you a few of those ways.
How to Remove Spaces in Excel
Mar 17, 2020
Sometimes, when you copy data from other locations and pasted them at Excel worksheet, there may be some extra spaces leaving at front or the end of strings in cells. It is time-consuming to delete the spaces one by one for making data looks tidy. Here this tutorial introduces the smart and easy ways help you to quickly remove leading and trailing spaces.
How to Use Forecast and Trend in excel
Mar 17, 2020
If you have historical time-based data, you can use it to create a forecast. When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you predict things like future sales, inventory requirements, or consumer trends.