Learn Excel

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

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

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

How to Format Cells in Excel: Everything You Need to Know

  What Options Are Available to Format Cells in Excel? 1. Ribbon Commands The Ribbon has various commands for formatting a cell in Excel. You ...

Excel Cells Basics – A Beginner’s Guide

A cell is the smallest unit of an Excel worksheet. Each cell has a unique address. The cell address is a combination of a column letter and a row ...

How to Print in Excel – Basic Guidelines for Beginners

Here's an overview of the Print menu in Excel. You can choose your printer, and you can change print settings including what to print, how many ...

How to Split in Excel (Text, Numbers, Cells & Columns)

The overview shows the summary of splitting first and last names, separating numbers from text, and splitting cells vertically across rows. Here, the ...

Data Validation in Excel: A Complete Guideline

In this tutorial, you will learn everything about Data Validation from its purpose to how to apply it in your Excel worksheet. In the image ...

Understanding Excel Parts and Components

In the following image, you can see the basic parts of an Excel window. ⏷ What Is an Excel Workbook? ⏷ Basic Parts of Excel Window ⏷ ...

How to Export Data from Excel to Doc, PDF, CSV, XML, vCard

This is an overview.   1. Using the “Save As” Command to Export Excel Data to Text or CSV File This is the sample dataset. To ...

Find and Replace in Excel (A Complete Guideline)

In this blog post, you will learn how to find and replace data in Excel- Using the Find and Replace tool Using the Go to Special feature for ...

How to Extract Data from Excel – 10+ Basic & Advanced Methods

This is a dataset of Order Management. And this is our sample dataset. Method 1 - Extracting Data from Excel Manually Select ...

Excel Formula List (40+ Useful Formulas to Master Excel)

In the following image, you see some students with their marks in English. We have calculated the total marks, average marks, total no. of students, ...

Guide to How to Add, Use and Remove Filter in Excel

Method 1 - Add Filter in Excel Using Home Tab Select a random cell in the range or the whole range => navigate to the Home tab => Editing ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo