Latest Blog Posts

String Manipulation in Excel

String Manipulation in Excel: Knowledge Hub How to Count Number of Characters in a Cell in Excel How to Extract Text from a Cell in Excel ...

How to Change Date Format in Excel (4 Ways)

Dates are one of the most common data types we use in Excel. Using and interpreting dates can be confusing, as Excel has several formats to display ...

Excel Count Unique Values (A Complete Overview)

This article gives a complete overview on Excel count unique values. Here, I will try to explain counting unique values as well as distinct values in ...

Excel Unique Values

In this article, we have demonstrated all the necessary information that is related to Excel unique values. We will use functions and pivot table to ...

Amortization Schedule Excel Template

Amortization Schedule Excel Template: Knowledge Hub Amortization Schedule with Irregular Payments in Excel Excel Car Loan Amortization ...

How to Perform Excel Match? (8 Different Cases)

Finding matches is an integral part of data analysis. From searching out relevant information from a large dataset to finding errors by matching ...

How to Compare Dates in Excel (2 Methods)

Dataset Overview We'll use the following dataset to demonstrate these methods. We have two columns: Predicted Delivery Date and Delivery Date. Our ...

Excel Compare Columns

Here, we will learn Excel compare columns using different processes and formulas such as conditional formatting, IF function, EXACT function, AND ...

Excel Financial Statement Template

Excel Financial Statement Template: Knowledge Hub Construction Company Financial Statements in Excel How to Create Format for Projected ...

Serial Number in Excel (With Practical Examples)

Serial numbers are important for sorting, ordering, and maintaining the consistency of data in Excel. In this article, you will learn how to create a ...

How to Randomize in Excel? – 5 Methods

This is an overview.   Method 1 - Using the RAND Function to Get a Random Decimal Number Between 0 and 1 Go to C5 and enter ...

How to Use Geocoding in Excel – 2 Examples

Geocoding is the process of converting addresses or place names into geographic coordinates. Geographic coordinates are latitude and longitude. ...

Wildcard in Excel

Wildcard in Excel: Knowledge Hub Excel Match Wildcard in Lookup Array Search for Question Mark in Excel How to Remove Asterisk in Excel ...

How to Apply Abbreviation in Excel – Abbreviate Words and Numbers

This is an overview.     Method 1 - Combining the LEFT, MID, FIND & LEN Functions to Abbreviate in Excel Enter the ...

Finance Template in Excel

Finance Template in Excel: Knowledge Hub Excel Financial Statement Template Amortization Schedule Excel Template  Payment Voucher ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo