Search for a file in folder and subfolders (VBA)

The image above demonstrates a user-defined function in cell range B6:D7 that allows you to search a folder and subfolders […]

Search for a file in folder and subfolders (VBA)

The image above demonstrates a user-defined function in cell range B6:D7 that allows you to search a folder and subfolders […]

How to use the NOMINAL function

The NOMINAL function calculates the nominal annual interest rate based on the effective rate and the number of compounding periods […]

How to use the MULTINOMIAL function

The MULTINOMIAL function calculates the ratio of the factorial of a sum of values to the product of factorials. Formula […]

How to use the MINIFS function

The MINIFS function calculates the smallest value based on a given set of criteria. Formula in cell E3: =MINIFS(C3:C10,B3:B10,"A") The […]

The easiest way to check if a cell has a value is, in my opinion, to use the equal sign […]

How to use the MINVERSE function

The MINVERSE function calculates the inverse matrix for a given array. This function is useful for solving equations with multiple variables. […]

Count a given pattern in a cell value

The formula in cell B6 counts how many times the string (D3) is found in a cell value (B3) even […]

How to create a stacked column chart

The stacked column chart is great for comparing parts of a whole and how they change over time or categories. […]

How to use the NORM.INV function

The NORM.INV function calculates the inverse of the normal cumulative distribution for a given mean and standard deviation. Formula in […]

How to use the SPLIT function [VBA]

The picture above shows a user-defined function (UDF) that splits the string in cell B3 using delimiting character "|". The SPLIT function […]

How to graph a Normal Distribution

The chart above is built using the NORM.DIST function and is called Normal Distribution or Bell Curve chart. This curve is often […]

How to use the NORM.DIST function

The NORM.DIST function calculates the normal distribution for a given mean and standard deviation. Formula in cell C7: =NORM.DIST(C2,C3,C4,C5) Excel […]

How to use the WEBSERVICE function

The WEBSERVICE function gets data from a web service on the Internet or Intranet. The function returns a #VALUE error […]

Extract k-th word in cell value

The formula displayed above in cell range D3:D9 extracts a word based its position in a cell value. For example, […]

How to align a chart with the cell grid

This trick is so simple and also an incredible time-saver if you want to build beautiful worksheets or dashboards where […]

In this article, I am going to show you two ways on how to find blank cells. Both techniques are […]

How to quickly select blank cells

In this smaller example, column D (Category) has empty cells, shown in the picture above. If your column contains thousands of […]

How to add a macro to your Excel Quick Access Toolbar

The Quick Access Toolbar is located at the very top of your Excel window, I highly recommend that you place your […]

How to quickly select a cell range

Selecting cell ranges in Excel can sometimes be a real pain scrolling forever it seems. There is a quick and easy […]

Highlight cells based on coordinates

The picture above shows Conditional Formatting highlighting cells in cell range F3:Y22 based on row and column values in column B […]

How to use the DSTDEVP function

The DSTDEVP function calculates the standard deviation based on a population. The function also allows you to specify criteria applied […]

How to use the DSTDEV function

The DSTDEV function calculates an estimation of the standard deviation based on a sample of a population. The function also […]

How to use the DPRODUCT function

The PRODUCT function multiplies numbers that match a condition or criteria in a database. Formula in cell B15: =PRODUCT (B6:D12, 3, […]

How to use the DCOUNTA function

The DCOUNTA function counts nonempty cells in a column you specify, in a database where records also meet a condition […]

How to use the DCOUNT function

The DCOUNT function counts cells containing numbers and that meet a condition or criteria. Formula in cell D3: =DCOUNT(B6:D12,3,B2:C3) The […]

How to use the DAVERAGE function

The DAVERAGE function calculates an average based on values in a list or database that meet specific conditions. Formula in […]

How to use the FORECAST.LINEAR function

The FORECAST.LINEAR function calculates a value based on existing x and y values using linear regression. Use this function to […]

How to use the BITXOR function

The BITXOR function calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. XOR […]

How to use the BITRSHIFT function

The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and […]

Count cells equal to any value in a list

The formula in cell F9 counts the number of cells in column B (Values1) that are equal to any of the […]

How to use the BITLSHIFT function

The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits. Formula in […]