Advanced Excel Archives - Page 14 of 64

How to Open a CSV File in Excel

Jul 12, 2024

Open CSV in Excel: Knowledge Hub Open CSV File in Excel Without Formatting Excel Open CSV with Delimiter Open CSV file in Excel with ...

Encryption in Excel: 3 Possible Methods

Jul 3, 2024

Method 1 - Encrypt an Excel File Using Encrypt with Password Feature Go to File>> Info>> Protect Workbook>> Encrypt with ...

Excel Read Only: All You Need to Know

Jun 6, 2024

Method 1 - Use ‘Open as Read-Only’ Feature to Make Excel File Read Only Go to File>> Info>> Protect Workbook>> Always Open ...

Excel Protect

Nov 11, 2025

Excel Protect: Knowledge Hub How to Protect Cells in Excel How to Protect Columns in Excel Protect Workbook in Excel ...

How to Unprotect a Workbook in Excel (5 Methods)

Jul 21, 2024

Dataset Overview Assume we have a dataset with two worksheets: Sales Record of Year 2021 and Sales Record of Year 2022. Both worksheets contain 7 ...

How to Unprotect a Workbook in Excel (5 Methods)

Tally in Excel (All You Need to Know)

Jul 4, 2024

In this article, we will discuss and demonstrate how to work with tallies in Excel. Creating tallies in Excel helps organize, analyze, and present ...

How to Create and Use a Dictionary in Excel

Aug 6, 2024

Here is an overview. Download Practice Workbook Dictionary in Excel.xlsm Example 1 - Creating a Data Dictionary in Excel Using an ...

How to Create and Use a Dictionary in Excel

Data Management in Excel

Nov 11, 2025

Data Management in Excel: Knowledge Hub How to Manage Data with Search Box in Excel << Go Back to Learn Excel

Search Box in Excel (With Filtering and Dynamic Search Box)

Jul 3, 2024

Here's an overview of implementing a search box via the FILTER function. Download the Practice Workbook Search Box.xlsx ...

Search Box in Excel (With Filtering and Dynamic Search Box)

Compatibility Mode in Excel (Find, Check, Save, and Turn Off)

Aug 3, 2024

This is an overview Click the image for a detailed view. Download Practice Workbook Compatibility Mode.xls Compatibility ...

Compatibility Mode in Excel (Find, Check, Save, and Turn Off)

Guite To Excel Metadata: View, Modify and Remove

Jul 7, 2024

How to View Excel Metadata Method 1 - Using Info Option Select File. Go to Info. We will get metadata. Method 2 - ...

Guite To Excel Metadata: View, Modify and Remove

Check for Issues Excel (Complete Guideline)

Nov 11, 2025

In this article, we will learn how to use the Check for Issues feature in Excel. Excel has long been a go-to tool for organizing, analyzing, and ...

Check for Issues Excel (Complete Guideline)

Catalogue in Excel

Nov 11, 2025

In this article, we will learn how to make various types of catalogues in Excel. Here we will show you how to make efficient catalogues of books that ...

Linking in Excel – A Complete Guide

Aug 6, 2024

This is an overview. Download Practice Workbook Download the practice workbook. Linking in Excel.xlsx Absolute vs ...

Mailing Labels in Excel (Prepare to Be Amazed)

Nov 11, 2025

Hi there! Are you tired of making Mailing Labels? Guess what you came to the right place. In this article, we will discuss all the steps of creating ...