Advanced Excel

How to Extract Data from Multiple Web Pages into Excel

The dataset we will use has two columns called Year and URL, which link to articles of top movies for the respective year. We will use those URLs to ...

How to Create an Audit Checklist in Excel (With Easy Steps)

  An Overview of an Audit Checklist In the following picture, you can see an overview of an Audit Checklist. We will show you how you can ...

How to Resample Time Series in Excel (3 Examples)

Dataset Overview Here, we have the following time series and the gap between time is 0.1, starting from 0 to 10. With respect to these time periods, ...

How to Find and Replace RegEx Patterns in Excel (3 Examples)

User-Defined Function in Excel VBA That Will Find and Replace RegEx Patterns VBA Code: Public Function Find_Replace_RegEx(main_txt As String, pat ...

[Solved!]: Cannot Open Encrypted Excel File (2 Quick Fixes)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes we ...

How to Import a Table from a Website to Excel (2 Easy Ways)

We will explore a sample website from which we will fetch a table. In this case, we will visit microsoft.fandom.com. The following website has a ...

How to Find & Replace Text Using Regex in Excel

In this article, we will explain how to find and replace text with a particular pattern using Regex in Excel. Excel doesn’t have any built-in ...

How to Make Checklist with Conditional Formatting in Excel

In general, conditional formatting is now an integral part of the Microsoft Excel experience. This helps us identify particular values in a random or ...

How to Use REGEX without VBA in Excel (with Easy Steps)

If you are using REGEX without VBA in Excel, this article may help you in this regard. REGEX is the abbreviated form of the term "regular ...

How to Decode Base64 in Excel (2 Suitable Examples)

    Method 1 - Apply an Excel VBA Code for a HTML Decode String Steps: Go to the Developer tab from the ribbon. Click on ...

How to Create a Drop Down Checklist in Excel (with Quick Steps)

Below is a dataset of several students' names. Of these students, only 3 passed. We want to create a drop-down checklist containing these ...

How to Encrypt Cell Content in Excel – 2 Methods

The dataset showcases Account Names, Card Numbers, and passwords. To encrypt the Password:   Method 1 - Applying VBA Macros to ...

How to Scrape Data from a Website into Excel (2 Easy Methods)

To illustrate our methods, we'll use a table on a webpage (see the screenshot below) that we want to export into Excel for further analysis. ...

How to Anchor Text Box in Excel

Anchoring the text box in Excel means fixing the position of the text box relative to a specific location. This ensures that the text box remains in ...

How to Create Excel File from Metadata with CSV File

Microsoft Excel is a powerful tool to create a dynamic database. We can store the data of our device folders or browsers which is called Metadata. In ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo