Latest Blog Posts

How to Get Data Points from a Graph in Excel (2 Methods)

Method 1 - Using VBA Code Select the graph from which you want to extract data points. Create a new worksheet and name it ...

How to Use SLM Method of Depreciation 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 ...

How to Delete Empty Columns with Header in Excel (4 Easy Ways)

The article will provide you with some quick tricks to delete empty columns with a header in Excel. While working on an Excel worksheet, you may need ...

How to Create a Table from Another Table in Excel (3 Easy Ways)

Method 1 - Merging Multiple Columns to Create Table from Another Table in Excel Steps: We use the table below for this example: Select ...

How to Add a Text Suffix with a Custom Format in Excel – 5 Examples

Example 1 - Adding a Text Suffix (e.g. Kg) for Mass The dataset below showcases multiple weight values. There is no unit. To add “Kg” as suffix ...

How to Calculate the Straight Line Depreciation Using a Formula in Excel – 3 Methods

This is the sample dataset: “Depreciation Schedule for a Car”.   Method 1- Using an Arithmetic Formula  Steps: Enter the ...

How to Remove Prefix 91 in Excel (4 Easy Ways)

Column B has a list of phone numbers that begin with 91. We'll remove the prefix. Method 1 - Using the REPLACE Function to Remove Prefix ...

How to Find a ZIP Code from an Address in Excel (2 Easy Ways)

Our dataset includes the Addresses of ABC Company employees. Our goal is to find the ZIP Codes from the given addresses. Method 1 - ...

How to Randomize a List Without Duplicates in Excel – 4 Methods

The dataset showcases a List of Stock Prices.   Method 1 - Using the INDEX, SORTBY, and SEQUENCE Functions Steps: Select B16 ...

How to Add Prefix Without Formula in Excel (2 Easy Ways)

Sometimes, we have a dataset in Excel and we may want to add a common prefix to all the data. We can do that quite simply in Excel without even using ...

How to Check Encoding of Excel File (With Easy Steps)

To check the encoding of an Excel file, we need to view the file in XML format. An Excel file is actually a compacted form of multiple XML files that ...

Ageing Formula with Current Date in Excel (4 Examples)

We will use the sample dataset below to illustrate how to calculate the Age from the current date. Method 1 - TODAY and INT Functions to ...

How to Create Metadata in Excel (4 Easy Ways)

When you prepare, access, or publish a Microsoft Excel workbook, it can have content that you do not wish to expose to others while sending the ...

How to Shuffle an Array Using Excel VBA (4 Examples)

If you want to shuffle an array using Excel VBA, then this article will help you a lot. As we have demonstrated here 4 different ways of shuffling an ...

How to Write CO2 in Excel (5 Easy Methods)

We often need to write different mathematical, chemical, or other types of expressions while presenting data in Excel. Most of the equations have ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo