Latest Blog Posts

How to Use Excel Exponential Function of Base 10: 6 Examples

Method 1 - Use Exponential Function POWER of Base 10 Steps: Select a blank cell C5 where you want to keep the exponents. Use the formula ...

How to Use the VBA Textbox Properties in Excel – 4 Steps

What Is a VBA TextBox? A TextBox is a box that receives data. It is a part of the UserForm. To insert a TextBox in a VBA UserForm: ...

Create an Alternative to the Datepicker in Excel – 2 Easy Methods

The datepicker feature of Microsoft Excel is only available for the Windows 32-bit version. This is the sample dataset. Method 1 - Use ...

How to Get Remainder in Decimal in Excel (3 Suitable Ways)

Excel can be very helpful in determining remainders. One might need these remainders in Integer or in decimal format. In this article, we will show ...

How to Perform Pattern Matching in Excel – 2 Methods

This is the sample dataset. Check if the texts follow this pattern: The total character length is 9. The first 3 characters are uppercase ...

How to Hide Textbox Using Excel VBA (with Quick Steps)

Insert a Textbox in an Excel Worksheet Steps: In the Insert tab, click on the Text Box command from the Text group. The mouse cursor ...

How to Create Concentric Circle Chart in Excel (with Easy Steps)

Step 1 - Creating the Dataset with the Proper information We have a list of processes in a company which we'll chart. Insert the list in a ...

How to Filter Using RegEx in Excel (with Simple Steps)

We have the Store Location of different cars in different stores. The Serial Number follows a RegEx pattern but there are some cars that have the ...

How to Use Negative Exponents in Excel – 3 Methods

In the following dataset, you can see the Base and Exponent columns. The Exponent column has negative exponents. Method 1 - Using Keyboard ...

How to Add Superscript in Excel (8 Easy Methods)

Suppose you are in a situation to add a superscript, a letter written just above the standard line, in your Excel data. But you don’t know how to do ...

How to Display Exponents in Excel: 7 Simple Methods

Method 1 - Using Superscript Effect To display exponents by applying the Superscript effect, follow the steps: Insert the values of Number and ...

How to Solve Network Optimization Model in Excel (3 Cases)

Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can perform network optimization in the blink of an eye. In ...

How to Recalculate in Excel (2 Built-In Options + Bonus)

Recalculation means calculating the existing formula based on the change of data in Excel. When we input any formula in a cell of Excel, we get the ...

Excel VBA: How to Divide Without Remainder (2 Easy Ways)

In this article, we will demonstrate how to divide without remainder in Excel in two ways using VBA. To illustrate the methods, we'll use the ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo