How to Create a Hierarchy of the State City and Zip Code in Excel

To express an address, usually we need state, city name, and code. In a state, there are several cities. And under one city there are several zip ...

How to Convert Column to Row with Comma in Excel (3 Ways)

Method 1 - Using TEXTJOIN Function Using the TEXTJOIN function is one of the most efficient ways to convert column to row with comma. The TEXTJOIN ...

How to Make an Interactive Calendar in Excel (2 Easy Ways)

The sample dataset below will be used for illustration. Method 1 - Making Interactive Monthly Calendar in Excel Step 1: Open a new ...

How to Change Date Alignment in Excel: 8 Simple Methods

Method 1 - Change Date Alignment with Text to Columns Feature STEPS: Select the date range D5:D8. Go to Data > Data Tools > Text to ...

How to Calculate Average Days in Excel (2 Easy Ways)

In Excel, when we need to calculate the average days of different dates depending on our data set, you may find it somewhat difficult. This article ...

How to Align Currency Symbol in Excel: 3 Easy Ways

Method 1 - Using Accounting Number Format to Align Currency Symbol Highlight the range or cell then select Accounting as Number Format from the ...

How to Align Columns in Excel (4 Easy Methods)

If you are looking for special tricks to know how to align columns in Excel, you've come to the right place. There are numerous ways to align columns ...

How to Calculate Aging of Accounts Receivable in Excel

Here is the dataset for today’s article. There are some orders with due dates and amounts. We will calculate the Aging of Accounts Receivable using ...

Balance Sheet Format for Construction Company in Excel: 9 Methods

Method 1 - Insert Current Assets Insert the amount for the current assets. A current asset is a term on a company’s balance sheet that might be ...

How to Convert Radians to Degrees in Excel (3 Easy Methods)

Method 1 - Converting Radians to Degrees Using the DEGREES Function Select the cell to store the result. In our case, the cell is C6. ...

How to Make an Accelerated Aging Calculator in Excel

Certainly, Microsoft Excel is a popular and useful tool for performing complex equations. Now, wouldn’t it be great if we could calculate accelerated ...

How to Use AVERAGEIFS Function for Multiple Columns

  Example 1 - Calculating the Average Price Our dataset is a Price Chart of Shoes. We'll determine the Average Price based on a few factors. ...

How to Remove Tracer Arrows in Excel

Tracer Arrows is a widely used tool in Excel. Though it is very helpful, we may want to remove these from the sheet after our desired work is done. ...

How to Convert Text to Currency in Excel – 5 Methods

Method 1 - Applying Cell Formatting Steps: Choose the cell range containing text data. Here, C5:C10. Go to the Home tab and, select Number. ...

How to Use Formula for Late Attendance in Excel

Step 1: Arranging Dataset Put the Name in column B, the Starting Time in column C, and the Actual Time in column D. We will use this dataset ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo