Advanced Excel

How to Anchor Cells in Excel (with Easy Steps)

If you are looking for how to anchor cells in Excel, then you are in the right place. While using Excel, we often need to use formulas where we have ...

How to Calculate Bootstrapping Spot Rates in Excel (2 Examples)

  Example 1 - Bootstrapping Spot Rates for Annual Bond The below dataset, Yield to Maturity of Annual Treasury Bond, includes the Par Value, ...

Anchoring Columns in Excel (2 Efficient Ways)

In Excel, we often need to do various types of mathematical calculations. Anchoring columns is a common practice when performing these calculations. ...

Data Validation with RegEx in Excel (With Easy Steps)

In Microsoft Excel, there is no inbuilt function named RegEx. Rather we have to create it manually in the workbook. This function is required to ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo