Excel Basics Archives - Page 15 of 176

How to Add the Excel Feathered Theme

Jul 15, 2024

In Excel, you will find different types of themes that can improve the readability of the dataset. Usually, a feathered theme is not added to Excel ...

How to Create Dynamic Table in Excel: 3 Quick Ways

Jul 9, 2024

We'll use the following simple dataset of employees to demonstrate how to create more dynamic tables. Method 1 - Using the Excel Table and Named ...

How to Create Dynamic Table in Excel: 3 Quick Ways

How to Create Dynamic Table of Contents in Excel (3 Easy Methods)

Jul 29, 2024

A dynamic table of contents in Excel allows users to create an interactive and automated index for their workbooks. By linking sheet names and ...

How to Create Dynamic Table of Contents in Excel (3 Easy Methods)

Excel Convert Timestamp to Time (4 Easy Ways)

Jun 11, 2024

Download Practice Workbook Converting Timestamp to Time.xlsm Method 1 - Convert Timestamp to Time Using Combination of TIME and MID ...

Excel Convert Timestamp to Time (4 Easy Ways)

How to Insert an Excel Table from an Image

May 13, 2024

We will add a table from the below image for the methods below. Method 1 – Using an Image Saved in File Explorer Steps: Select a ...

How to Insert an Excel Table from an Image

Excel Scientific Notation Without e (7 Quick Tricks)

Jul 9, 2024

Download the Practice Workbook Convert Scientific Notation to Number.xlsx Method 1 - Apply the INT Function to Convert Scientific ...

Excel Scientific Notation Without e (7 Quick Tricks)

Excel Refresh All Not Working (Reasons and Solutions)

Nov 11, 2025

The "Refresh All" feature in Excel is essential for retrieving up-to-date data and sustaining correct analyses. However, at certain times this ...

Excel Refresh All Not Working (Reasons and Solutions)

How to Fit Long Text in One Cell in Excel – 6 Methods

Aug 9, 2024

Download Practice Workbook Download the worksheet here. Fit Long Text in One Cell.xlsx How to Fit Long Text in One Cell in Excel : ...

How to Fit Long Text in One Cell in Excel – 6 Methods

How to Create Drop Down List from Another Workbook in Excel

Jun 6, 2024

Create a master dataset and save the file as “Master Dataset”. You can name it anything you want. Our workbook’s name is Master Dataset. ...

How to Create Drop Down List from Another Workbook in Excel

220++ Keyboard Shortcuts in Excel ( for Quick Navigation)

Jun 20, 2024

In this article, you will learn to over 200+ shortcuts in Excel with practical examples. Click on the image to get a detailed view How Do ...

220++ Keyboard Shortcuts in Excel ( for Quick Navigation)

How to Use Sheets Tab in Excel? (All Things You Need to Know)

Nov 11, 2025

The Sheets tab is an important part in Excel. It has multiple uses. You can rapidly choose one or more sheets by selecting them from the Sheets tab. ...

How to Use Sheets Tab in Excel? (All Things You Need to Know)

How to Protect Cells in Excel (All You Need to Know)

Nov 11, 2025

Protecting Excel cells means locking certain or all cells in the Excel worksheet to prevent any unwanted changes. In this free Excel tutorial, we ...

How to Protect Cells in Excel (All You Need to Know)

How to Change Number Format in Excel

Nov 11, 2025

Change Number Format in Excel: Knowledge Hub How to Convert European Number Format to US in Excel How to Convert Percentage to Decimal in ...

How to Make a Roster in Excel (with Detailed Steps)

Apr 23, 2024

Here's a roster template that we will be making throughout this article. You can follow along and make changes if you want a modified version, or ...

How to Make a Roster in Excel (with Detailed Steps)

How to Make a List in Excel (All Things You Need to Know)

Aug 4, 2024

In the following overview image, we selected a range as the source in the Data Validation dialog to create a drop-down list. ⏷Ways of ...