Latest Blog Posts

How to Calculate Years of Service in Excel (4 Easy Ways)

We have the following dataset which contains the Employee Name, Joining Date, and End Date of employees. We will calculate the Years of Service for ...

How to Sum Multiple Rows and Columns in Excel

The sample dataset contains the sales records of 5 products over 3 months. We will sum this dataset by rows and columns. Method 1 - Using ...

How to Round to Nearest 1000 in Excel (7 Easy Methods)

Here's an overview of the different ways you can round numbers to the nearest 1,000. Let's dig into each option. Method 1 - Using Excel ...

How to Calculate Working Days in Excel Excluding Weekends and Holidays

Consider a dataset with start and end dates for employees, where we need to calculate how many working days they had. There are a few ways to do so. ...

How to Perform a Spelling Check on the Active Worksheet in Excel

Spell checking is mandatory sometimes while working on an Excel Worksheet. In this article, we will see how to perform a spelling check on the active ...

How to Apply a Custom Number Format With Multiple Conditions in Excel

The following GIF shows that the custom number format is changing based on multiple conditions. Depending on the values you enter in the cell, the ...

How to Round Numbers in Excel Without Formula (3 Quick Ways)

Method 1 - Round Numbers with Decrease and Increase Decimal Commands in Excel Excel has the built-in feature under the Home tab from which you can ...

How to Count Cells with Specific Text in Excel (5 Easy Ways)

We have a dataset here with information on fruit names and their amounts. We want to find the number of cells that have the name Apple in them. ...

How to Use VLOOKUP and HLOOKUP Combined Formula in Excel

Steps: In cell D14, insert the following formula. =IF(VLOOKUP(B14,$B$4:$D$11,3,FALSE )>=30000, VLOOKUP(B14,$B$4:$D$11,3,FALSE)*20%, ...

How to Calculate IRR (Internal Rate of Return) in Excel (8 Ways)

  What Is Net Present Value? If you have $1000 today, you can invest it in a business or buy a product today and sell it later, or at least ...

Data Validation Based on Another Cell in Excel (4 Examples)

How to Do Data Validation in Excel? Take a dataset that includes student ID, student name, and age. We would like to make a data validation where ...

How to Add a Secondary Axis in Excel – 3 Methods

Compare the Quantity column and Average Sales Price columns. Min and Max values in the Quantity column are 112 and 150, whereas Min and Max values in ...

How to Calculate Monthly Payment in Excel: 2 Handy Methods

Method 1 - Using Direct Formula to Calculate Monthly Payment This is the mathematical formula that calculates monthly payments: M = ...

How to Copy a Worksheet in Excel (4 Smart Ways)

The process of copying worksheets is a very common phenomenon among excel users. Especially, when the dataset gets quite large, we tend to copy the ...

How to Change Orientation of Worksheet to Landscape in Excel

Method 1 - Applying Landscape Command to Change Orientation of Excel Worksheet Steps: Go to the Page Layout tab. From the Page Setup group, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo