Excel Basics

How to Sort Numbers in Excel (8 Quick Ways)

We'll use a sample dataset that contains the salary information of a particular employee with the Employee Name, Region, and Salary columns. ...

How to Remove Prefix in Excel (6 Methods)

The following sample dataset shows some student IDs that start with ID and the Name of the corresponding IDs in Column C and Column B respectively. ...

How to Create a Hyperlink in Excel (5 Easy Ways)

Method 1 - Hyperlink Using an URL Microsoft Excel automatically creates a hyperlink when you insert a URL in a cell. If your given URL is valid, it ...

How to Remove Negative Sign in Excel (7 Methods)

Method 1 - Remove the Negative Sign in Excel Using the ABS Function We have a list of numbers in cells B4:B10 with both positive and negative. ...

How to Sort a Unique List in Excel – 10 Methods

The sample dataset showcases Employee Name, ID No., Salary & Rank.   Method 1 - Getting a Sorted Unique List 1.1. Using the ...

How to Total a Column in Excel (7 Effective Methods)

To illustrate our methods for totaling a column, we'll use the following sample dataset. Method 1 - Using the SUM Function 1.1  - Sum ...

How to Fix “Wrap Text Not Working” in Excel (4 Possible Solutions)

Understanding the Wrap Text Feature in Excel In Excel, the Wrap Text feature is crucial for improving text readability. Let’s consider a dataset ...

How to Remove Gridlines in Excel for Specific Cells (2 Methods)

Excel has horizontal and vertical gray lines called Gridlines. Gridlines separate one cell from another. Here's an overview of what a table looks ...

How to Sort Data in Excel Using a Shortcut (7 Methods)

Method 1 - Excel Shortcut for Single Column Sorting In this method, we’ll demonstrate how to sort a single column using Excel shortcuts. Let’s ...

How to Sort and Filter Data in Excel – A Complete Guideline

This is the sample dataset: After sorting data based on Profit, in descending order: Filter the dataset based on “South”: ...

How to Sort in Ascending Order in Excel (6 Methods)

Dataset Overview In the following example we have some random numbers in a column. After sorting in ascending order, it will look like the following ...

How to Remove a Header in Excel – 4 Methods

The header in the sample dataset is Product Order Records. Method 1 - Using the Page Setup to Remove a Header in Excel Go to Page ...

How to Remove Percentage in Excel (5 Quick Ways)

Method 1 - Remove Percentage Using General Format in Excel Select the cell or cell range from where you want to remove the percentage. Open the ...

How to Use Boolean Operators in Excel: 4 Methods

Method 1 - Application of NOT Boolean Operator Step 1: Go to Cell F5. Write the below code: =NOT(D5=5) Step 2: Press ...

How to Remove Borders in Excel (4 Quick Ways)

Method 1 - Use the Excel Borders Drop-Down to Remove Borders STEPS: Select the Cell or Range of Cells where the Border is. In the Font ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo