Excel Basics

How to Catalog Books in Excel – 2 Methods

Method 1 - Creating a Custom Catalog for Books Steps: Select the headings. Separate the columns with a borderline. Select a ...

SmartArt in Excel: Everything You Need to Know

OS Industries Ltd manufactures Men’s Shirts and sells in Texas, California, and New Mexico. The supply chain is showcased below with SmartArt. ...

How to Format Complex Numbers in Excel (4 Easy Methods)

Complex numbers are expressed as a+ib, where “a” is a real part of the complex number and “b” is an imaginary part of the complex number. For ...

How to Create a Workflow Tracker in Excel (with Easy Steps)

Step 1 - Creating a Dataset for the Workflow Tracker We have listed the tasks in the Task column. Input the starting dates in the ...

How to Create Alerts in Excel (4 Easy Methods)

In the below dataset we have three columns displaying Client names, Meeting Dates, and Alerts. Method 1 – Using the IF Function to Create ...

How to Perform Union Query in Excel (with Detailed Steps)

In this article, we will explain how to perform a Union query in Excel to merge multiple tables with one common column or row. Suppose we have 3 ...

[Fixed] Excel Navigation Arrow Keys Not Working

In this article, we will learn what to do if the Excel Navigation arrow keys are not working. This key allows us to control the way of navigation ...

How to Use English Dictionary in Excel (3 Handy Applications)

Looking for ways to use an English dictionary in Excel? Then, this is the right place for you. You can use an English dictionary to check spelling, ...

How to Create a Data Source in Excel – 6 Steps

“Running Project of DPR Construction”is the sample dataset. Recreate it:   Step 1 - Create a Basic Outline Select a cell to create ...

How to Hard Code in Excel (4 Easy Ways)

In this article, we will show how to hard code in Excel. Hard Code means stating a specific value into a formula or cell rather than referencing the ...

How to Use Scaling Option in Excel (4 Quick Ways)

Oftentimes, our Excel worksheets contain numerous columns which can throw a curveball when trying to print the spreadsheet on a single page. Fear ...

How to Navigate Between Sheets in Excel (10 Easy Methods)

Here are 10 simple ways to navigate between sheets in Excel: Method 1 - Clicking on the Sheet Name Tab Simply click on the desired sheet name tab, ...

How to Perform Cell Navigation in Excel (4 Easy Ways)

Cell navigation in Excel refers to the process of moving around and selecting different cells within a spreadsheet. It's a fundamental skill for ...

How to Create Union of Two Tables in Excel: 6 Simple Methods

The left table contains two columns titled Product Name and Cost Price. The right side holds the Product Name column and a column named Profit. ...

How to Create Notifications or Reminders in Excel (5 Methods)

  In the following dataset, you can see the Product and Supply Date columns. We have several Supply Dates that include dates both in the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo