Excel Basics

How to Ignore Blank Cells in Range in Excel (8 Ways)

  Consider the following dataset containing the Selling Price and Cost Price of some products of a company. We will use it to demonstrate how ...

How to Create a Formula in Excel to Change Date by 1 Year

In this tutorial, we will learn how to create a formula in Excel to change the date by 1 year. While you are working with date type information you ...

How to Set Cell to Blank in Formula in Excel (6 Ways)

We'll use the example dataset, which includes information on Region, Product, Quantity Price, and Sales. There are some blank cells in the Quantity ...

How to Copy and Paste Formulas from One Workbook to Another in Excel

  Method 1 – Using the Paste Option to Copy Formulas from One Workbook And Paste to Another Steps: Go to Book1 and copy the data (E5:E10) ...

How to Delete Infinite Columns in Excel (4 Methods)

Excel 2007 and all the newer versions have 16384 columns in total. When you are working with a smaller dataset, these huge numbers of unused columns ...

How to Delete Multiple Rows in Excel at Once (5 Easy Ways)

The dataset below, Sales of "ABC" Company, shows sales information for products on various dates. It has four columns: Order ID, Product, Amount, and ...

How to Convert Degrees Decimal Minutes to Decimal Degrees in Excel

Calculation for Converting Degrees Decimal Minutes to Decimal Degrees 60 minutes is equal to one degree: 1° = 60' 1/60 degrees equals one ...

How to Delete Hidden Sheets in Excel (2 Effective Methods)

  Method 1 - Remove Hidden Sheets by Applying the Inspect Document Function in Excel We've hidden some sheets in the workbook. Steps: ...

How to Convert Percentage to Decimal in Excel: 7 Methods

Method 1 - Convert Percentage to Decimal Using the General Format Steps: Select Cell C5 to Cell C10. From the Home tab, go to Number group. ...

How to Copy and Paste in Excel and Keep Cell Size (7 Examples)

Step 1 – Using the Context Menu The dataset below contains information on employees’ Names, Duration of work, and wage Amounts for Project 1 ...

[Fixed!] Excel Found a Problem with One or More Formula References in This Worksheet

While working with formulas you may make some silly mistakes that were not noticed by you and then you can get the error message saying, “Excel found ...

[Fixed!] AutoFill Formula Is Not Working in Excel Table (3 Solutions)

In this article, we will provide three solutions to the ‘autofill formula is not working in excel table’ problem. Excel tables benefit us greatly ...

How to Copy and Paste in Excel without Formulas (7 Easy Methods)

We have a dataset containing sales data along and total sales. We have used Excel functions to get the Total Sales. We will show you how to copy and ...

Drag Number Increase Not Working in Excel (A Solution with Easy Steps)

Sometimes the AutoFill feature in Excel does not work to autoincrement numbers when dragging through rows or columns. Here's an overview of the ...

How to Undo Delete Sheet in Excel – 3 Methods

  Method 1- Making a Copy of an Existing Sheet to Undo Delete Sheet in Excel Step 1: Click File. Click Save As. Save ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo