Excel Basics

How to Sort IP Address in Excel (6 Methods)

Excel treats an IP address as text. Therefore the Sort & Filter tool in Excel cannot sort IP addresses correctly. This article shows 6 different ...

Hyperlink in Excel Not Working (3 Reasons & Solutions)

In Excel sheets, we often use Hyperlinks to link any sheet or page. Sometimes Hyperlinks may give you reference errors or links can be broken etc. In ...

How to Insert a Clustered Column Chart in Excel

Without a doubt, charts in Excel are an outstanding tool to portray any data graphically instead of showing a complex table with lots of fields. More ...

[Solved!] Excel Sort Not Working (2 Solutions)

Sorting data is one of the easiest and most frequently used operations in MS Excel. What if the sort command doesn’t work properly? This article will ...

How to Add Sort Button in Excel (7 Methods)

The sort button in Excel is a very powerful and useful feature that will let you sort the information in a large Excel worksheet without any hassle. ...

How to Extract Hyperlink from URL in Excel (3 Methods)

In this article, we’ll learn how to extract hyperlink from URL in Excel using three different methods. We often work with data from various sources ...

How to Remove Sort in Excel (3 Easy Methods)

In this article, we will demonstrate to you how to remove sort in Excel. In Microsoft Excel, we often sort data for the convenience of our work. ...

Cannot Insert Row in Excel (Quick 7 Fixes)

The created data sheets are not fixed so you may need to update them by inserting rows, columns, or various formulas, values from time to time, but ...

How to Remove Outliers in Excel (3 Ways)

Finding outliers and removing them is a very common task to analyze data in statistics, data mining, machine learning etc. There are so many ways ...

How to AutoFill from List in Excel (8 Quick Ways)

Often we need to use AutoFill for filling the cell or cell range downwards, upwards, and so on instead of entering the data repeatedly. How would you ...

How to Insert Row Below in Excel (5 Methods)

Sometimes we need to place a blank row in our Excel worksheet to input missed data. In this article, you’ll get to know the methods in Excel to ...

How to AutoFill Months in Excel (5 Effective Ways)

We often need to put the month name in our worksheet in Excel. In the case of small datasets, it is possible to input the names of the months ...

How to Remove Dashes from SSN in Excel?

The general SSN (Social Security Numbers) numbers are created by 9 digits with two dashes. The pattern is AAA-BB-CCCC. When we want to make a list of ...

[Fix] Excel Fill Series Not Working (8 Causes with Solutions)

With the help of the Fill Series feature of Excel, a lot of time can be saved and the calculation process becomes faster, but unfortunately, ...

Types of Tables in Excel: A Complete Overview

In this article, we will discuss all 3 types of Excel tables, how to create them, and how to use them effectively. Microsoft Excel is one of the most ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo