Excel Basics

Excel Not Sorting Numbers Correctly (4 Reasons with Solutions)

Reason 1 - Numbers Have Non-printable Characters The sample dataset contains product price data copied from the internet and formatted in Excel ...

How to Show Percentage Change in Excel Graph (2 Methods)

Dataset Overview In the following dataset, we have a company’s Profit during the period March to September that we will use to illustrate the two ...

How to Filter Multiple Values in One Cell in Excel (4 Methods)

The sample worksheet contains information about several sales representatives of Armani Group. The name of the Products and the Revenue Earned by the ...

How to Display Day of Week from Date in Excel (8 Ways)

Here's a simple dataset of some dates that we'll convert into days of the week. Method 1 - Using the TEXT Function to Display the Day of ...

How to Highlight Partial Text in Excel Cell (9 Methods)

Suppose you have the following dataset. Method 1 - Using the SEARCH Function to Highlight Partial Text in Excel Cell Steps: Select ...

Print Titles in Excel Is Disabled, How to Enable It?

We will use the dataset below to demonstrate why Print Title doesn’t work in certain cases and how we can resolve the issue.  Reason 1 - ...

How to Make a Percentage Bar Graph in Excel -5 Methods

.This sample dataset contains 3 columns: Quarter, Brand, and Share, regarding the global shipment of smartphones in the last quarter of 2021. ...

How to Correct a Spill (#SPILL!) Error in Excel (7 Easy Fixes)

Let's look at some of the scenarios where you could get the #SPILL! issue and how to correct them. We are going to use the following dataset, which ...

How to Extract Data from Image into Excel (With Quick Steps)

Data extraction from images, a feature available on the subscription-free Excel 365 mobile app, is very effective method of importing data. ...

The Insert Row Option is Grayed out – 9 Solutions

The following picture highlights the problem and the solution. Solution 1 - Press Windows+R and Change the Microsoft Excel AppData ...

How to Move Columns in Excel Tables (5 Methods)

To demonstrate our methods, we'll use the following table containing Last Name, First Name, Salary and Department columns. We used Excel 365 in this ...

How to Insert a Column Between Every Other Column in Excel (3 Methods)

We’ll use the following dataset that represents some fruit prices for three consecutive months. Method 1 - Use a Keyboard Shortcut to ...

How to Extract Data from Excel Sheet (6 Effective Methods)

We have a dataset containing 5 columns and 9 rows including headings. Let's extract data from this Excel worksheet to another worksheet. ...

How to Update Hyperlink in Excel Automatically (2 Ways)

We have a dataset containing brief information about some books, their writers, and hyperlinks where you can find these books to read. We will use ...

How to Format a Phone Number with Extension in Excel – 3 Methods

The image below showcases phone numbers with extensions before and after formatting: Method 1 - Using a Custom Number Format Each phone ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo