Learn Excel

How to Create Alerts in Excel – 4 Examples

This is an overview. Download Practice Workbook Create Alerts.xlsm Example 1 - Using the Conditional Formatting to Set Up ...

How to Use Operators in Excel? (All You Need to Know)

Operators specify the type of calculation in an Excel formula. For example, arithmetic operators indicate addition, subtraction, multiplication, or ...

190+ Most Used Excel Functions List by Category

    70 Most Popular & Common Excel Functions by Alphabetical Order Function Name Objective AND Checks whether ...

Excel Formulas

Excel Formulas: Knowledge Hub How to Create a Formula in Excel How to Show Formulas in Excel Why Formula Is Not Working in Excel? How ...

Excel AutoFill (16 Useful Examples)

Here's an overview of the AutoFill feature when working with days of the week. Download the Practice Workbook Excel AutoFill.xlsm ...

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

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

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo