Learn Excel

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

Excel Number Format (from Toolbar, Ribbon and Dialog Box)

In this Excel tutorial, you will learn how to apply the number format. You can access number formatting options from the toolbar, ribbon, and number ...

Entering and Editing Data in Excel

Entering and Editing Data in Excel: Knowledge Hub How to Enable Editing in Excel How to Press Enter in Excel Without Changing Cells Making ...

How to Convert Text to Number in Excel? (Complete Guideline)

In this Excel tutorial, we will discuss various ways to convert text to number format, including using Error Checking, Paste Special, Text to Columns ...

How to Convert Numbers to Text in Excel (4 Methods)

Method 1 - Using the TEXT Function The TEXT function in Excel can convert any value to text, including numbers. You can also specify a specific ...

Excel Shapes

Excel Shapes: Knowledge Hub Inert Shape in Excel Align Shapes in Excel Excel VBA Shape Position << Go Back to Learn Excel

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

Data Entry in Excel (Basic, Form Creation & Error Handling)

In this article, we are going to learn about data entry in Excel. We will learn about the basics of data entry, form creation, and error handling. ...

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 Use Navigation in Excel?

In this article, you will learn how to -Navigate within Excel cells and worksheets -Move across selected ranges for navigation -Use the scroll ...

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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo