Latest Blog Posts

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

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

Excel Order Form Template

Excel Order Form Template: Knowledge Hub GST purchase order format in excel Tally purchase order format in excel << Go Back ...

Inserting Columns in Excel – 11 Methods

This is an overview: Download Practice Workbook Download the practice workbook. Inserting Column.xlsm This is the sample ...

How to Select Column in Excel (6 Easy Ways)

Here's an overview of how you can select a column by giving it a name. Read on to learn more. Download the Practice Workbook Select ...

Excel Roster Templates

Excel Roster Templates: Knowledge Hub How to Create Weekly Duty Roster Format in Excel How to Create Automatic Schedule Generator for Free in ...

ARM Amortization Schedule Excel Template [Free Download]

Instructions: Open the ARM Amortization Schedule template and insert all the required inputs in the blue-shaded area of the Input Values column. ...

Row Height Excel (All Things You Need to Know)

Here's a basic overview of selecting a row header to see its height. Download the Practice Workbook Row Height Excel.xlsx ...

Indentation in Excel – 5 Methods

This is an overview. Download Practice Workbook Download the workbook and practice. Indentation in Excel.xlsx Method 1 - ...

Excel Accounting Number Format (Apply and Customize)

Here's an overview of where you can find the Accounting format to apply it to cells. Download the Practice Workbook Accounting Number ...

Formatting Currency in Excel (Format, Change & Remove)

This is the sample dataset. Download Practice Workbook Download the practice workbook. Currency Format in Excel.xlsx How ...

How to Apply Excel’s Auto Formatting (Add, Customize, Use & Remove)

What Is Auto Formatting in Excel? Auto formatting in Excel simplifies the process of making your data visually appealing. It provides ready-made ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo