Excel Basics

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. ...

[Fix:] Hyperlink to Website Not Working in Excel

Hyperlinks in an Excel file can relate to the location of a file on the computer or a place inside the same worksheet. Furthermore, hyperlinks might ...

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 Make Alphabetical List in Excel (3 Ways)

To make your dataset cool and presentable Sorting alphabetically is one of the most used functions in Excel. Throughout this article, we will learn ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo