Latest Blog Posts

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

How to Divide Without Remainder in Excel (3 Effective Methods)

Division is a very important mathematical operation. When a number (dividend) can’t be divided exactly by another number (divisor) then there remains ...

Excel Accounting Practice Problems – 8 Exercises

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

[Solved:] Excel Subscript Not Working

If you are looking for a solution to Excel subscripts not working, then you are in the right place. While dealing with various numbers or digits we ...

How to Truncate Numbers in Excel (8 Suitable Methods)

Truncating a number means decreasing the number of digits from the decimal section or from the right side of that number in mathematics. In Excel, ...

How to Find Combinations Without Repetition in Excel

Combinations in mathematics is a concept that is quite important in various areas of mathematics, particularly in probability and statistics. It is a ...

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 Create All Combinations of 6 Columns in Excel (2 Methods)

While dealing with an Excel worksheet, you may need to generate all the combinations of a certain number of columns. Finding these combinations ...

Units of Production Depreciation Method with Formula in Excel

There are many ways of calculating Depreciation. Units of Production is one of them. The main objective of this article is to explain how to ...

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 Create a Data Table with 3 Variables – 2 Examples

Example 1 - Using a PivotTable to Create a Data Table with 3 Variables Enter Principle, Months, and Rates in B5:D12. Click E5 and ...

How to Truncate Text in Excel: 6 Methods

Method 1 - Applying LEFT Function to Truncate Text in Excel Steps: Select a new cell D5 where you want to keep the result. You should use ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo