Excel Basics

How to Use Conditional Formatting on Text Box in Excel (2 Ways)

In this article, we will show how to use Conditional Formatting on a Text Box in Excel. We often need text boxes to display a certain text or link ...

How to Use Navigation Pane in Excel (3 Handy Applications)

The navigation pane in Excel is a helpful tool that provides a quick and organized way to navigate through the various elements within your workbook. ...

How to Navigate Large Excel Spreadsheets (10 Useful Techniques)

We will demonstrate 10 useful techniques to navigate large Excel spreadsheets. We will use the following dataset. Method 1 - Use the Zoom ...

How to Use Navigation Keys in Excel (6 Examples with Shortcuts)

Here's a simple example of using navigation keys to navigate between worksheets. 6 Examples of Using Navigation Keys in Excel ...

How to Circle Something in Excel (2 Suitable Ways)

In this tutorial, we will explain how to circle something in Excel using 2 different methods. We'll use the following data set containing Name, Age, ...

How to Write a Paragraph in Excel Cell (5 Easy Ways)

To demonstrate the method, we will use the dataset of the Performance of the employees of a Company. The following methods all help you to fill out ...

How to Draw a Circle in Excel with a Specific Radius – 3 Methods

Method 1 - Utilizing the Parametric Equation of a Circle The parametric equations of a circle are: x = r cos(t)  y = r sin(t) x, ...

Visualisation Tools in Excel (10 Types with Detailed Explanation)

In any business or in the corporate sector, data visualisation is a crucial factor. For assessing the performance, or to take any decision based on ...

How to Create a Countdown Timer in Excel (with Easy Steps)

Step 1: Display the Countdown Timer Select cell B4. Go to the Home tab. From the Font group, pick the B icon to bold. Set the font size ...

How to Rotate Spin Button in Excel (With Easy Steps)

In this article, we will demonstrate how to insert and rotate a spin button in Excel to change a value. What Is a Spin Button? A Spin Button ...

Intersection of Row and Column in Excel Is Called a Cell

The intersection of row and column is usually called a cell in Excel. Thousands of cell integration creates a whole spreadsheet of Excel. This ...

[Fixed] Excel Compatibility Mode Not Responding

In this article, we will learn what to do if compatibility mode is not responding in Excel. Compatibility mode is a very important mode in Excel. We ...

How to Insert WordArt in Excel (2 Simple Methods)

In this tutorial, I am going to share with you 2 simple methods to insert WordArt in Excel. You can easily apply these methods in any set of data to ...

How to Make a Checklist in Excel Without Developer Tab

To make a list updated in an Excel worksheet, generally, we use a checkbox. In this article, using a checkbox we are going to check or uncheck a ...

How to Draw Circle in Excel (4 Simple Methods)

The sample dataset that represents circular components and values. We will use these number values to draw a circle in Excel. Method 1 - ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo