Excel Basics

How to Apply Conditional Formatting Using Checkbox in Excel

In this tutorial, I am going to share with you 3 practical examples of how to apply conditional formatting using a checkbox in Excel. You can easily ...

How to Turn on Auto Calculate in Excel (2 Easy Ways)

Today, we are going to show how to turn on auto-calculate in Excel. When the auto calculate is turned on, Excel considers the changes made to a ...

How to Create Floating Cells in Excel (2 Easy Methods)

In this article, I will show how to create floating cells in Excel. In many situations, we need to display a group of cells always floating on the ...

How to Use Conditional Formatting to Compare Dates in Excel

Conditional formatting is a fundamental aspect of using Microsoft Excel. This enables us to locate certain values within a huge or random set of ...

How to Use Format Painter for Multiple Rows in Excel

The Format Painter tool is handy for copying the format of cells to single or multiple rows. It's like copying the style of one row and painting it ...

How to Change Font Within Formula in Excel (3 Easy Ways)

Looking for ways to change font within formula in Excel? Then, this is the right place for you. By changing the font within the formula, you may make ...

[Fixed!] Drop Down List Ignore Blank Not Working in Excel

What Is Drop Down List? A drop-down list allows the user to choose text or numbers from a list rather than typing them into a cell. To insert a ...

How to Turn Off AutoComplete in Excel (3 Easy Approaches)

Excel offers duplicate values from related cells when we start entering data into a cell, and we can take those identical values by pressing Enter at ...

[Fixed!] Null Error in Excel (3 Possible Solutions)

In this article, we will discuss reasons for #Null! Error in Excel and their possible solutions. #Null! The error occurs when we forget to use a ...

How to Use OFFSET for Cell Reference in Excel (5 Easy Ways)

If you are looking for some special tricks to know how to use OFFSET for cell reference in Excel, you've come to the right place. We’ll show 5 ...

How to Create A Product Catalog in Excel: 5 Methods

Method 1 - Make the Dataset Ready Collect the information about the mobiles stored in the shop. Collect the images of the mobiles that are ...

How to Perform Linear Extrapolation in Excel (with Easy Steps)

Extrapolation is known as extending a current trend into the future or applying sample study findings to the entire population. In this article, we ...

How to Create Navigation Buttons in Excel (2 Easy Ways)

When dealing with a large number of worksheets in an Excel file, we may need to include buttons on the worksheet to execute macros that let us travel ...

How to Write X Bar or Hat in Excel (4 Methods)

The X Bar symbol is used in statistics frequently. Method 1 - Use Symbol Command to Write X Bar in Excel Steps:  Select the ...

How to Use Spin Button to Display Negative Values in Excel

A spin button helps to increase or decrease values easily by clicking on the button easily. But, you can not get negative values directly by using ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo