Latest Blog Posts

How to Find If the Date Is Within 3 Months in Excel – 5 Methods

The sample dataset showcases the End Dates of different projects. To see if the End Date is within 3 months from the Current Date: ...

Excel VBA: Copy Range to Clipboard (7 Suitable Examples)

How to Enable the Clipboard Shortcut in Excel Steps Go to the Home tab on the ribbon. Select the dialog launcher arrow from the ...

Excel Formula If Date Is Greater Than 2 Years (3 Examples)

Example 1 - Use the DATEDIF Function to Return a Specific Text If a Date Is Greater Than 2 Years We will apply the DATEDIF function to calculate the ...

How to Delete What If Analysis in Excel (2 Simple Methods)

After applying What-If Analysis, Excel will often prevent the deletion of data from the source data or the output. In this article, we will explain ...

How to Go to the End of Excel Sheet (2 Quick Methods)

While working in Microsoft Excel we often use shortcuts to finish tasks in time. Although at the time of working on a worksheet we need to move to ...

How to Create a Search Box in Excel (4 Easy Methods)

We have a dataset regarding the Bill Status of a Corporation. This dataset consists of four columns: Customer ID, Customer Name, Bill, and Status. We ...

How to Solve a Cubic Equation in Excel (2 Ways)

We've arranged the equation on a worksheet using the following image for our calculation process. Here, we have shown the variables and the ...

How to Move Up and Down in Excel (5 Easy Ways)

To shift a row upwards using the Shift key and mouse, we first choose a row and then place it in the upper position. You will notice that the ...

How to Reverse Names in Excel (5 Handy Methods)

Method 1 - Using Flash Fill Feature to Reverse Names in Excel Steps: Enter the first name in your desired order as shown below. ...

How to Draw an AON Network Diagram in Excel (3 Examples)

Below is a template to draw an AON network diagram. The acronym ST stands for Start Time, RT for Run Time and ET for End Time. Method 1 - ...

How to Show Grand Total with Secondary Axis in Pivot Chart

While creating a Pivot Chart in Excel, showing the Grand Total can help understand the chart and increase clarity. If you are curious to know how you ...

How to Create Reference with Another Workbook in Excel (5 Ways)

We use Excel basically to ease our workload and save work time. For this, sometimes we refer to another cell in an Excel sheet or another sheet of an ...

How to Trace Errors in Excel – Quick Steps

To trace errors in Excel: Click the error cell >> go to Formulas >> Formula Auditing >>  Error Checking >> Trace Error. ...

[Fixed!] Cut and Paste Not Working in Excel

Need to learn how to solve if Cut and Paste not working in Excel? If you are looking for such unique tricks, you’ve come to the right place. The most ...

Find String in Column and Return Row Number in Excel (7 Ways)

We have a sample dataset that contains Sales Person and Sales information. We will find a name from the column named Sales Person and return the row ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo