Latest Blog Posts

How to Create Price Tags in Excel (with Quick Steps)

In this article, we will demonstrate how to create price tags in Excel with sample data columns. You can adapt the data according to your needs. ...

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

Excel Practice & Exercises with SUMIF Function

This article contains 7 practice exercises for the Excel SUMIF function. You will need a basic understanding of accounting and Excel to solve all the ...

How to Calculate Greek Delta in Excel – 4 Steps

What Are Option Greeks? Option Greeks are monetary indicators of how sensitive the price of an option is to the factors that determine it, such as ...

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 Add Text to Textbox Using Excel VBA (3 Effective Ways)

Method 1 - Typing Value in VBA to Add Text to Textbox in Excel Go to the Insert tab and click on the Text Box under Text. Click on the ...

The Font Changes Automatically in Excel – 2 Solutions

This is the sample dataset. Solution 1 - Using the Format Cells Feature Steps: Select the whole dataset and right-click. Choose ...

How to Put Space in Text Box in Excel (2 Cases)

Method 1 - Changing Space Between Lines in an Excel Text Box ⏩ Steps: Click on the Text Box. Select the whole text of the box and ...

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 Count Months from Date to Today by Using Excel Formula

This article will demonstrate how to count months from date to today in Excel by using different functions like MONTH, DATEDIF, YEARFRAC, and YEAR. ...

How to Calculate Delta in Excel – 2 Examples

Example 1 - Computing the Delta Percent in Excel The sample dataset contains sales information. To compare sales in 2021 and 2022, calculate delta ...

Excel Accounting Practice Problems – 8 Exercises

Download Practice Workbook You can download the Excel file here. Accounting Practice Problems.xlsx Problem Overview There ...

How to Insert a Text Box in Excel – 5 Methods

Method 1 - Add a Text Box using the Insert Tab Steps: Go to the Insert tab. Click Text Box.. The cursor will show a cross. ...

How to Use VBA to Change Textbox Text in Excel: 3 Easy Methods

  Method 1 - VBA Changing Textbox Text in Excel Steps: Go to Insert>Text>Text Box options. Create the Text box according ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo