Latest Blog Posts

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

In the dataset below, we have 3 columns showing Product ID, Product Name, and Sales (units). Method 1 – Using Excel Illustrations Feature ...

How to a Create Animation in Excel VBA (Easy Steps)

Step 1 - Select Sample Items for Animation in Excel In this tutorial, we’ll use a football as our main sample item. When you press the “Start” ...

How to Convert Complex Numbers to Polar Form in Excel

Introduction to the Polar Form of Complex Numbers Complex numbers are commonly written in x+iy format, where i stands for √(-1), x is the real ...

How to Do Web Scraping Without Browser with Excel VBA

VBA web scraping without using the browser is a unique scraping method that enables automatic data collection from websites and export to Excel. ...

Excel Text Box Not Showing: 3 Methods

Method 1 - Text Box Removed from Main Tab Solution: We will show how to retrieve this option. Move the cursor to the main tab. Press the ...

How to Create a Burn-up Chart in Excel (With Easy Steps)

Step 1 - Create a Dataset with Proper Parameters We have arranged the dataset of a project in the Dates, Estimated Project, Estimated Progress, ...

How to Circle a Text in Excel – 3 Easy Methods

This is the sample dataset. Method 1 -Using Basic Shapes to Circle a Text in Excel Steps: Go to the Insert tab and click Shapes. ...

Advanced Excel Test: 11 Tricky Exercises

In this tutorial are eleven problem exercises for the Excel test on advanced topics. You will need an advanced understanding of Excel to solve all ...

How to Delete a Text Box in Excel – 3 Methods

This is the sample dataset. Method 1 - Applying a Generic Method to Delete Text Box in Excel To delete the text box with its borders: ...

How to Create Permutation Table in Excel (4 Easy Methods)

Permutation tables are very useful when the order and position of our data are important. In computer science, they play an essential role in sorting ...

How to Decrypt Excel File Without Password (2 Easy Ways)

We'll the following Excel sheet to showcase decryption. It contains a sales overview. If I try to edit something in this Excel sheet it shows ...

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

Sigma is the Greek alphabet's eighteenth letter. The lowercase letter sigma (σ) denotes the standard deviation in math and statistics. In math, the ...

How to Get Remainder in Excel (3 Simple Methods)

In this article, we will demonstrate 3 easy methods to obtain the remainder in Excel using the following dataset that contains numbers for division. ...

How to Use VBA to Get Value from Userform Textbox in Excel

What Is Excel VBA TextBox? In Excel VBA, a TextBox is a user interface element that allows users to input data. The sample worksheet Student ...

How to Use the COMBIN Function in Excel – 4 Examples

This is an overview The Excel COMBIN Function Objective determines the total possible number of combinations in a given number of items. ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo