Latest Blog Posts

How to Truncate Dates in Excel (4 Methods)

Method 1 - Using INT Function Background The INT function treats date/timestamp data as integers and decimals (date as integer & time as ...

What Is the Use of Pivot Table in Excel: 13 Useful Methods

Look at the following dataset; we have the company's sales data.   Method 1 - Getting Sum of Amount by a Specific Criterion, i.e., ...

How to Create a Payroll Calculator in Excel – 7 Steps

Step 1- Set up Employer Data Create a header. Create 2 columns and enter the sub-header. Enter the Duration of Work/Week, Hourly ...

How to Sum All Possible Combinations in Excel – 4 Steps

Step 1 - Initiating the Solver Add-in Make sure your Solver Add-in feature is active. Go to File > Options. Select Add-Ins and click ...

How to Concatenate with Delimiter in Excel (5 Easy Ways)

Method 1 - Use the “&” Operator to Concatenate with Delimiters Let's use a dataset that has first and last names in two columns. We will join ...

Excel Test for an Accounting Interview: 11 Exercises

Exercise 1 –  Use of Formatting There are twenty-one cash transactions. Your task is to change the formatting of the expenses to red. Then, find ...

How to Find Y Intercept in Excel (3 Effective Methods)

We have Y-values in Column B and X-values in Column C. The values for Y are obtained via linear equation. Method 1 - Using the Excel ...

How to Randomize List of Names in Excel: 8 Easy Methods

Method 1 - Utilizing Sort Feature Steps: Select the entire dataset for which you want to do your task. We copied C5:C15 data in D5:D15. ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo