Excel Basics

Using an Excel Formula to Work with Positive and Negative Numbers – 6 Examples

This is an overview. Overview of Excel Formulas for Working with Positive and Negative Numbers Example 1 - Converting Negative Numbers to ...

Excel Conditional Formatting Icon Sets with Relative Reference (2 Examples)

What Is Relative Reference? In Excel, a cell reference is typically relative. This means that the reference adjusts based on the cell’s location. ...

How to Create a Table with Existing Data in Excel

We will use a dataset containing information about some Sellers' Sales Amounts. It also includes the Region and Dates of the sales. STEP 1 ...

How to Add Header in Excel (5 Quick Methods)

In this article, we will discuss some methods to add a header in Excel. We can insert a header on each page of our Excel worksheet, which typically ...

What is an Unqualified Structured Reference in Excel?

The image below differentiates a Structured Reference from an Explicit Reference. Structured Reference and Its Types Structured ...

How to Lock the Zoom in Excel Using VBA – 7 Steps

 Step 1 - Open the VBA Window Press ALT+F11 to open the VBA window. Select Insert >> Module. Step 2 - Create the Sub ...

How to Create New Sheets for Each Row in Excel (4 Easy Methods)

Watch Video – Create New Sheets for Each Row in Excel Suppose you have the following dataset: Method 1 - Using an Excel Pivot ...

How to Use HLOOKUP with Structured Reference in Excel

What Is a Structured Reference? A structured reference is a term that refers to using a table name in an Excel formula in lieu of a usual cell ...

How to Create Multiple Sheets in Excel with Different Names (3 Methods)

  Watch Video – Create Multiple Sheets with Different Names in Excel The sample dataset has 3 different titles for 3 sheets. ...

How to Insert Sheet from Another File in Excel (3 Easy Ways)

To explain the methods shown in this tutorial, we will use two Excel files. The name of the first workbook is Insert Sheet from Another File, and the ...

How to Create Table of Contents in Excel (6 Suitable Ways)

We will use a sample dataset, which has 2 Columns, Product and Sales, across 5 worksheets, Dataset, Sales of January, Sales of February, Sales of ...

Find and Replace Tab Character in Excel (2 Suitable Ways)

We have 5 cells that have the tab character inside. We want to find and replace these tab characters. Method 1 - Using the Find and ...

How to Use Drawing Tools in Excel (2 Easy Methods)

Method 1 - Using the Drawing Tools from the Insert Tab We'll draw a simple flow chart. Steps: Choose “Shapes” from the “Insert” option. ...

How to Fix If Undo and Redo in Excel Are Not Working (3 Simple Solutions)

  Solution 1 – Open Excel in Safe Mode STEPS: Go to the Windows search bar. Enter Excel.exe /Safe. You’ll get the application, as ...

How to Zoom in on a Map Chart in Excel (5 Methods)

Dataset Method 1 - Zooming in on a Map Chart in Excel Using Paste Special In this method, we’ll utilize the Paste Special feature to zoom ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo