How to Add Prefix to Entire Column in Excel (4 Simple Methods)

Method 1 - Apply CONCATENATE Function to Add Prefix in Excel Concatenate is defined as joining or combining. The CONCATENATE function connects text ...

How to Apply All Combinations of 3 Columns in Excel

Method 1 - Use Power Query Steps: Create 3 separate tables for 3 columns. Select the first column and press Ctrl+T. Create Table ...

How to Multiply Pi in Excel (with 3 Practical Cases)

What is the value of Pi? I know it's a difficult question. Excel has an inbuilt PI function which is accurate up to 15 decimal points and can be used ...

How to Convert Decimal Number to Hexadecimal (Hex) in Excel

In the dataset below, we have some positive and negative decimal numbers. Let's convert them to hexadecimal using 2 different methods. ...

Payroll Exercises in Excel: 5 Exercises

Download Practice Workbook Download the Excel file here. Exercises of Payroll.xlsx Problem Overview The first dataset shows ...

How to Do Payroll Reconciliation in Excel (with Easy Steps)

We have a sample dataset with salary sheets of a company called SOFTEKO. Let's assume the current month is October. Step 1 - Open Salary Sheet ...

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 Show All Combinations of 5 Columns in Excel

Combination is a common task in our day-to-day professional life in different aspects. In Microsoft Excel, we can easily show all the combinations ...

How to Write Subscript in Excel (7 Effective Ways)

One of the frequently used features in Excel is the ability to format text, numbers, and formulas to make them more visually appealing and easier to ...

How to Generate Payroll in Excel VBA (with Easy Steps)

The following dataset shows Employee Information containing the “Employee Name,” “Pay Rate,” “Total Work Time,” “Overtime Rate,” “Total Overtime,” ...

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 Make a Daily Checklist in Excel (2 Simple Methods)

A checklist displays some items, tasks, etc. and beside them, attached boxes where we can put a mark for denoting whether the task is complete or ...

How to Calculate Working Days Excluding Sundays in Excel

If you are looking for how to calculate working days in Excel excluding Sundays, then you are in the right place. In every office and other ...

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 Sort Numbers with Letter Suffix in Excel (4 Useful Methods)

In our regular life, we often notice numbers with suffix letters such as product code, zip code, account code, insurance numbers, and lots more. But ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo