Latest Blog Posts

How to Calculate Accumulated Depreciation in Excel: 9 Easy Ways

Method 1 - Apply Simple Depreciation Formula Steps: Click on the left button of the mouse to select empty cell D5. Write down the following ...

How to Create Toggle Button on Excel VBA UserForm

  Step 1 - Launch the Excel Developer Tab If you have the Developer tab on your ribbon, you can skip this step. Right-click on the ribbon ...

How to Subtract Dates to Get Years in Excel – 7 Methods

This is the sample dataset. Method 1 - Using the DATEDIF Function to Subtract Dates to Get Years STEPS: Enter the formula in D5: ...

How to Use COUNTIFS for Cells Not Equal to Multiple Text in Excel (2 Methods)

Dataset Overview We'll use the following dataset to explain these methods. It contains 3 columns, State, Product, and Sales. Method 1 - ...

Create Sunburst Chart with Percentage in Excel (with Easy Steps)

In this article, we will describe a step-by-step procedure to create a Sunburst Chart with percentage in Excel. What Is a Sunburst Chart? A ...

Calculate Sum of Years Digits Depreciation with Formula in Excel

Depreciation is a very common term in the case of assets. In general, it is the decline of an asset over a certain period of time. There are many ...

Excel COUNTIF to Count Cells Greater Than 1 (2 Examples)

  Method 1 - Counting Cells Greater Than 1 in a Single Column We have the Sales Status of a Store as our dataset. We'll find the number of ...

How to Convert Hex to Decimal in Excel (2 Practical Examples)

When working with numbering systems, Hexadecimal and Decimal both systems are significant from their own perspectives. So, it is a frequent need for ...

How to Use the Combination of COUNTIF and SUMIF in Excel

Method 1 - Determining Average Price Steps: Select the F5 cell and write down the following formula, ...

How to Calculate the Number of Weeks Between Two Dates in Excel

Dataset Overview We have a dataset named the Everest Base Camp Expedition timeline. Method 1 - Using the INT Function Subtract the ...

How to Lookup ZIP Code in Excel (4 Suitable Methods)

If you are searching for how to look up a ZIP code for the name of a country or city in Excel, then you have come to the right place. Today, in this ...

Advanced Use of COUNTIFS Function in Excel (9 Examples)

The COUNTIFS function is a more advanced version of the COUNTIF function in Excel. Whereas the COUNTIF function counts if one criterion in a single ...

How to Use COUNTIF for Non Contiguous Range in Excel

The COUNTIF function is one of the statistical functions. This function is used to count cells that meet a certain criterion. The focus of this ...

How to Format Hex Numbers with a Leading Zero in Excel – 2 Steps

Step 1 - Convert Decimal Numbers to Hex Format Using the DEC2HEX Function in Excel Enter the following formula: =DEC2HEX(B5) ...

How to Add 3 Months to a Date in Excel (4 Easy Methods)

To demonstrate how to add months to  a date in Excel, we'll use the following dataset representing a subscription, where column B shows the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo