Learn Microsoft Excel Online Free
Do you ever have to input a list of numbers into a spreadsheet, and some of the cells are blank? It can be difficult to keep track of what number is in which cell when you have to scroll up and down the sheet to look for the right spot. Well, today, I’m going to… read more »
This post will guide you how to count cells that are not blank or empty in a given range cells using a formula in Excel 2013/2016.How do I count the number of cells that are not blank in a particular range with a VBA macro in Excel. You should know that excel offers several count… read more »
In our daily work we may need to create a dynamical dropdown list and sort all values by alphabetical order. To create a dropdown list like this, we need to apply some built-in features like ‘Define Name’ and ‘Data Validation’ features, and we also need the help of formula which is combined with excel functions…. read more »
We often do statistics analysis by Excel in our daily work, and sometimes we need to count the percentage for different data in a series of data, so that we can see the data distribution of this series of data and we can also find out which data accounts the largest proportion. Due to different… read more »
This post will guide you how to count the number of cells with non-zero value with formula in Excel 2013/2016. Count the Number of Cells with non-zero value Assuming that you have a list of data in range A1:C6 which contain text string values. And you want to count the number of cells with non-zero… read more »
This post will guide you how to create dynamic named range that can expand automatically when you add a new value into the current range in Excel 2013/2016. How do I create a dynamic named range with a formula in Excel. How to create a dynamic named range by creating a table in Excel. Creating… read more »
This post will guide you how to pick a random name from a list in Excel. How do I select random value from a list or a table with a formula in Excel 2013/2016. Pick Random Name from a List Assuming that you have a list of names in range B1:B6, and you want to… read more »
This post will guide you how to generate all possible combinations with a formula in excel. How do I create list with all possible combinations of two lists in Excel. How to list all combinations from two separate list or range in Excel. Generate All Possible Combinations of Two Lists in Excel Assuming that you… read more »
This post will guide you how to create a chart that updates with new data automatically in Excel. How do I create self-updating chart in Excel. How to get charts to automatically update with new data point in your current worksheet. Or how to use defined names to update a chart with new data point… read more »
In the previous post, we talked that how to check if cell contains all of values from a list in excel, and this post will guide you how to test a cell if it contains one of several values in a range or a list in excel. How to check that at least one value… read more »
This post explains that how to check if a cell contains all of several values from a range in excel. How to check if cell contains all of many values in a list in excel 2013. How to check if all of values in a list can be found in a cell, if TRUE, then… read more »
This post will guide you how to reverse a list of values or a range of values in excel. How to reverse the order of a column data or a list of items using excel formula. How to reverse a range with sort command. How to reverse a list or column value with VBA. Reverse… read more »
This post will guide you how to use Excel COUNTA function with syntax and examples in Microsoft excel. Description The Excel COUNTA function counts the number of cells that are not empty in a range. And it returns the number of non-blank cells within a range or values. It can be used to count all… read more »
