Excel Basics Archives - Page 23 of 176

How to Catalog Books in Excel – 2 Methods

Aug 10, 2024

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

How to Catalog Books in Excel – 2 Methods

SmartArt in Excel: Everything You Need to Know

Aug 9, 2024

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

SmartArt in Excel: Everything You Need to Know

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

Nov 11, 2025

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 Format Complex Numbers in Excel (4 Easy Methods)

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

Jul 23, 2024

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 a Workflow Tracker in Excel (with Easy Steps)

How to Create Alerts in Excel (4 Easy Methods)

May 11, 2024

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 Create Alerts in Excel (4 Easy Methods)

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

Jul 29, 2024

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

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

[Fixed] Excel Navigation Arrow Keys Not Working

Nov 11, 2025

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

[Fixed] Excel Navigation Arrow Keys Not Working

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

Nov 11, 2025

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 Use English Dictionary in Excel (3 Handy Applications)

How to Create a Data Source in Excel – 6 Steps

Aug 3, 2024

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

How to Create a Data Source in Excel – 6 Steps

How to Hard Code in Excel (4 Easy Ways)

Nov 11, 2025

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)

Nov 11, 2025

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 Use Scaling Option in Excel (4 Quick Ways)

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

May 14, 2024

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