Latest Blog Posts

How to Apply Excel Text Format: 5 Methods

Method 1 - Format Numbers in Excel Select cell C5 to write this formula and press Enter. =TEXT(B5,"$###,###.00") You can see that ...

How to Merge, Find, and Unmerge in Excel: 9 Methods

Method 1 - How to Merge Cells in Excel Using Merge & Center Feature Select the cells from B5 to G5. Go to the Home tab. From the ...

How to Clear Content in Excel (4 Methods)

Method 1 - Clear Content Using a Keyboard Shortcut 1.1 Clear Content of a Single Cell Select the cell from which you want to clear contents and ...

The Cursor in Excel – All You Need to Know

This is the sample dataset. Download Practice Workbook Download the free Excel workbook here. Cursor in Excel.xlsm ...

How to Create and Use Scroll Bar in Excel (3 Easy Ways)

A scroll bar is a tool for displaying huge data tables from top to bottom or left to right and vice versa. Here is an overview of an Excel data ...

Title Bar in Excel – Everything You Need to Know

This is an overview.   Title Bar The title bar is the horizontal bar located at the top of the Excel window. It displays the name ...

Excel Data Types – Everything You Need to Know

This is an overview: The Number data type is displayed on the right side of the cells, whereas the Text data type is displayed on the left ...

Text Box in Excel – A Complete Overview

The sample dataset contains sales of different accessories in different locations. The text box below showcases a summary of the dataset, displaying ...

Excel Worksheets Basics – A Beginner’s Guide

This is an overview.     What Is an Excel Worksheet? An Excel worksheet is a grid-based document used for organizing and ...

Mail Merge in Excel – Purposes, Procedure, Uses & Limitations

Mail Merge is a powerful feature in Microsoft Word that allows you to personalize and send the same document (such as emails or letters) to multiple ...

Excel Drop-Down Lists: Create, Edit, Remove, Filter, Protect

  The dataset showcases online shopping information: ‘Order ID’, ‘Customer Name’, ‘Device’, ‘Order Date’, ‘Delivery date’, and ‘Payment ...

Database in Excel: Definition, Types, Creation, Free Templates

Database in Excel means gathering and arranging information on individuals, products, demands, transactions, etc. In this Excel tutorial, you will ...

Outline (Or Grouping) in Excel: Features, Creation, Uses & More

Below, we have a dataset containing Member ID, Joining Date, Name, State, Designation, and Member Type. We will outline or group these data based on ...

Excel Test Cases Template

Excel Test Cases Template: Knowledge Hub How to write test cases in excel sheet Test cases for banking application in excel sheet How to ...

Pivot Table in Excel: Create and Explore

What Is a Pivot Table in Excel? A Pivot Table is a data analysis tool in Excel. Its main purpose is to summarize and analyze a large amount of data ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo