Latest Blog Posts

How to Declare Array in Excel VBA (3 Easy Ways)

If you want to run a VBA code in Excel, then you first have to declare an array. However, if you want to declare array in VBA, then you have landed ...

How to Calculate Confidence Interval for Population Mean in Excel

Confidence interval or CI is the measurement of the range of estimates for a particular parameter. This is an important concept in data analysis. As ...

How to Highlight Blank Cells in Excel VBA (6 Suitable Examples)

Sometimes, we want to highlight the cells which contain no data or empty strings. We can do it by using VBA. Here, you will find 6 ways to highlight ...

How to Highlight Blank Cells with Conditional Formatting in Excel

While working with a dataset in an Excel file, it is very normal that some cells may remain blank. If you apply any formula referring to the blank ...

Formula for Weekly Dates in Excel (5 Examples)

In this article we will demonstrate various formulas for Weekly Dates in Excel. We'll use the dataset below to illustrate our methods, and assign ...

How to Skip Hidden Cells When Pasting in Excel (2 Methods)

Why Are Hidden Cells Being Pasted in Excel? When you copy and paste data in Microsoft Excel, any hidden rows and columns within the selection are ...

How to Check If an Array Is Empty with VBA in Excel (3 Methods)

Below is a dataset on gangsters' secret names in the Serial No, Gangster, and Pseudonym columns. Set an Array with VBA in Excel Steps: ...

How to Lock a Structured Reference in Excel (2 Useful Methods)

If you are looking for how to lock a structured reference in Excel, then you are in the right place. While using Excel frequently we need to make ...

How to Skip Cells When Dragging in Excel: 4 Easy Methods

Method 1 - Combine OFFSET and ROW Functions to Skip Cells When Dragging Steps: Choose a cell to apply the formula. We selected cell (C5). ...

Excel Confidence Interval for Difference in Means (2 Examples)

This article illustrates how to calculate the Confidence Interval for a difference in Means in Excel, both by using Excel's statistical functions and ...

How to Clear Cell Content Based on a Condition in Excel – 7 Methods

This dataset contains similar data and an overview of the methods applied. The sample dataset showcases information about sports cars. ...

How to Merge Two Columns in Excel With a Space

Users often need to merge data from two columns in Excel. Often they merge data without space. That creates obscurity in the presentation of the ...

How to Graph Two Equations in Excel (with Easy Steps)

Excel is an excellent tool for plotting equations in a graph as it offers various types of graphs and many customizing features. If you are wondering ...

Calculate Unknown Concentration from Standard Curve in Excel

Method 1 - Generating a Standard Curve to Calculate Unknown Concentration in Excel Insert a scatter chart for our dataset. Select the range ...

Excel Conditional Formatting Based on Past or Due Date

Method 1 - Using Excel TODAY Function to Get Past or Due Date Steps: Insert the following formula in Cell D5- =C5<TODAY() Press ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo