How to Change Page Margins to Wide in Excel

In this article, I will show you how to change page margins to wide in Excel. While working on an Excel workbook, sometimes you may need to plot any ...

How to Delete Every Other Column in Excel: 5 Easy Ways

Method 1 - Use Custom Sort Feature to Delete Every Other Column Steps: Add row 3 over the header row. Input the following formula in cell ...

How to Find 2 Letter State Abbreviations in Excel (4 Ways)

Indeed, while working in Excel we may need to obtain the abbreviation of the State names. Though there is no dedicated function to do this, however, ...

How to Create a Membership Database in Excel – 6 Easy Steps

Step 1- Set the Headings Set the headings for the database. Here, ID, Name, Cell No, and Zone. Step 2- Enter the 1st ...

How to Make Name Tags in Excel (with Easy Steps)

Name Tags are used very often for practical purposes. This is a useful trick frequently used for efficient data management. In this article, I am ...

How to Delete All Sheets Except One in Excel (2 Quick Methods)

While working in Microsoft Excel, sometimes we need to delete all sheets from a workbook except one sheet or the active sheet. But doing it one by ...

How to Delete Hidden Columns in Excel (2 Simple Methods)

Method 1 - Using the Inspect Document Feature in Excel to Delete Hidden Columns STEPS: Select column D. Right-click and choose Hide. ...

Mastering Excel Charts: 8 Tricky Exercises for Practice

In this tutorial, you’ll be presented with eight challenging Excel chart exercises to enhance your skills. To approach these problems effectively, ...

How to Delete All Rows Not Containing Certain Text in Excel?

In the following dataset containing information about some fruits, Apple is listed multiple times. Let's delete all the rows except those containing ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo