Latest Blog Posts - Page 75 of 412

How to Write 1st 2nd 3rd in Excel (3 Easy Ways)

Jun 15, 2024

We will use the following dataset. It has three columns B, C, and D for the Student ID, Name, and Position. You can see the position has ordinal ...

How to Write 1st 2nd 3rd in Excel (3 Easy Ways)

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

Jul 6, 2024

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

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

How to Apply All Combinations of 3 Columns in Excel

Jul 2, 2024

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 Apply All Combinations of 3 Columns in Excel

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

Jun 13, 2024

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

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

Payroll Exercises in Excel: 5 Exercises

Aug 6, 2024

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)

Jul 4, 2024

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 Do Payroll Reconciliation in Excel (with Easy Steps)

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

Jul 5, 2024

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

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

How to Decode Base64 in Excel (2 Suitable Examples)

Apr 26, 2024

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 Decode Base64 in Excel (2 Suitable Examples)

Excel Solver Exercises: 8 Advanced Problems

May 27, 2024

This tutorial contains eight exercises related to the Excel solver. These problems are quite difficult to solve, requiring an advanced level of ...

Excel Solver Exercises: 8 Advanced Problems

How to Change Margins in Excel (2 Methods)

Jul 15, 2024

Understanding Margins in Excel In Excel, margins refer to the free or empty space around the edges of a sheet or paper. These margins indicate where ...

How to Change Margins in Excel (2 Methods)

How to Use PI(π) in Excel VBA (4 Easy Examples)

Jul 4, 2024

Example 1 - Using PI as a Single Value in Excel VBA We will use the pi as a Single value in Excel VBA. It will contain 7 figures. Steps: ...

How to Use PI(π) in Excel VBA (4 Easy Examples)

How to Change Font Size in Excel – A Complete Guide

Aug 2, 2024

The following datasets provide an overview. Changing the Default Font Size in Excel To change the default font size in Excel: Go to ...

How to Change Font Size in Excel – A Complete Guide

How to Make an Ogive Graph in Excel (with Easy Steps)

Jul 23, 2024

Step 1 - Creating Two Helper Columns We have a dataset of a company’s Remuneration Range and Frequency. Construct two columns named “Class ...

How to Make an Ogive Graph in Excel (with Easy Steps)

How to Add Suffix in Excel (4 Easy Ways)

May 26, 2024

How to Add Suffix in Excel: 4 Easy Ways Our sample dataset has three columns labeled Name, Suffix, and Email. Method 1 - Utilize CONCATENATE ...

How to Force Recalculation with VBA in Excel

Jun 19, 2024

Sometimes while executing formulas, incorrect values are returned despite the formulas being correct. This may happen as a result of dirty cells and ...