Latest Blog Posts

How to Stop Excel from Truncating Text (3 Easy Methods)

While working in Microsoft Excel, often users have to input long texts in a cell. By default, Excel hides these long texts after a certain limit or ...

How to Count Cells with Specific Value in Excel (5 Easy Methods)

Suppose we have a dataset of the Book Name, Published Year, Author, and Genre of some books. There are a variety of ways in which we can count ...

How to Change Treemap Order in Excel (with Easy Steps)

  Step 1 - Making a Data Set with Proper Parameters Create a dataset and insert the values. Step 2 - Insert a Treemap Chart ...

How to Abbreviate Numbers in Excel: 3 Easy Methods

Method 1 - Apply a Predefined Format to Abbreviate Numbers Steps: Select column D to format it. Right-click on the selected range. ...

How to Find All Combinations of 1 Column in Excel (2 Handy Ways)

In mathematics, calculating combinations of a certain number of characters is a very common practice. In fact, we can count these combinations in ...

Convert Scientific Notation to x10 to the Power of 3 in Excel

Method 1 - Use Formula to Convert Scientific Notation to x10 to the Power of 3 Format in Excel 1.1 Combine LEFT, TEXT and RIGHT Functions STEPS: ...

How to Use Exponent Symbol in Excel (4 Easy Methods)

In this article, I will show you how to use the exponent symbol in Excel. In many calculations, we need to use the exponent form of mathematical ...

How to Add Text Box in Excel Graph (2 Simple Ways)

Creating graphs from data in Excel helps a lot with data analysis. Sometimes we want to add a text box to the graph which makes the graph and its ...

How to Create an Interactive Checklist in Excel (Easy Steps)

Dataset Overview To demonstrate the steps, we will use the dataset of the Home Office Checklist with answers. In Column B, we have information about ...

How to Import a Table from a Website to Excel (2 Easy Ways)

We will explore a sample website from which we will fetch a table. In this case, we will visit microsoft.fandom.com. The following website has a ...

How to Randomize a List in Excel Into Groups: 5 Suitable Ways

Method 1 - Randomize a List in Excel Into Groups Using RAND Function Steps: Select the C5 cell and copy the following formula into it. ...

How to Use Web Scraping with Excel VBA (3 Suitable Examples)

Web Scraping is a process of extracting data from websites and converting it into a format that can be easily accessed and analyzed. Microsoft Excel ...

How to Convert a Text Box into a Cell in Excel – 3 Steps

The dataset showcases Employee Name, Location (TextBox), and Location (Cell). Step 1 - Creating a Dataset Insert a column with the ...

How to Insert Inverted Delta Symbol in Excel (8 Easy Methods)

Excel is a very useful tool to do a large number of calculations using mathematical equations. Mathematical equations often include different ...

How to Calculate Sigma in Excel (3 Effective Methods)

We have the Student Name in column B, ID in column C, and Mark in column D. We'll calculate the sigma value for marks. Method 1 - ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo