Excel Basics

How to Change Compatibility Mode in Excel (2 Easy Ways)

In Microsoft Excel, there are several options to save a workbook. Each option has its own features. You may also find some files in Compatibility ...

How to Overline Text in Excel (4 Easy Ways)

One might need to put a line over text for various purposes. For instance, Means and Vectors are expressed by putting a bar on the top of a text in ...

How to Use Spin Button in Excel (2 Suitable Examples)

You may occasionally need to change the cell value. Changing a cell's value every time is challenging. In that case, Excel provides you with a ...

How to Create Floating Text Box in Excel (2 Easy Ways)

While working in Excel, we often need to create a floating text box. A floating text box allows us to display the contents of a cell anywhere in an ...

How to Put a Circle Around a Number in Excel (4 Quick Tricks)

In this tutorial, I am going to share with you 4 quick tricks to put a circle around a number in Excel. You can easily apply these methods in any set ...

[Solved] Excel Text Box Not Showing (3 Reasons & Solutions)

The text box is one of the lucrative features of Excel. Using text boxes, there are lots of advantages. We can declare anything without writing ...

How to Circle Text in Excel (3 Easy Ways)

Sometimes you might need to enclose a text inside a circle to highlight it or for some other purpose while working on Excel. You can do this easily ...

How to Delete Text Box in Excel (3 Easy Ways)

In this article, I will show how to delete a text box in Excel in three ways. While working on an Excel worksheet, you need to handle different ...

How to Insert Sigma Symbol in Excel (8 Easy Ways)

Microsoft Excel is a very effective software. Excel's tools and functions enable us to perform an infinite number of operations on a dataset. We need ...

How to Randomize List of Names in Excel (8 Easy Methods)

Data sorting is frequently a crucial step in any data study. It can help in data organization, detect patterns, or discover the minimum and maximum ...

How to Use Excel Exponential Function of Base 10 (6 Examples)

Sometimes you may need to use an exponential function. Furthermore, if you are a researcher then most of the time you may need to use the exponential ...

How to Use Negative Exponents in Excel (3 Easy Methods)

If you want to use negative exponents in Excel, you have come to the right place. Here, we will walk you through 3 easy and effective methods to do ...

How to Display Exponents in Excel (7 Simple Methods)

To display Exponents in Excel: Select a cell and change the Number Format to Text. Select the characters to display as exponents. Go to ...

[Solved!] Font Changes Automatically in Excel

While working in Microsoft Excel, sometimes we face problems with font changes. This happens when we have a default setting applied in our Excel ...

How to Put Space in Text Box in Excel (2 Cases)

It is a common scenario to add spaces between texts in an Excel cell. You have added blank spaces, applied the find and replace feature in the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo