Latest Blog Posts

How to Organize Things Alphabetically in Excel (4 Methods)

Organizing data alphabetically is one of the most basic tasks in Excel. Indeed, it is also a valuable tool when working with large sets of data. ...

Search for Question Mark in Excel (4 Suitable Methods)

Microsoft Excel has several options to search for a specific text or character. In this article, we will show how to search for Question Mark in ...

Mail Merge in Excel without Word (2 Suitable Ways)

Looking for ways to mail merge in Excel without Word? Then this is the right place for you. If Microsoft Word is not available for some reason, doing ...

How to Make Address Labels in Word from Excel (With Easy Steps)

This tutorial will show you how to make address labels in Word from Excel. Labelling is essential in terms of marketing a product, tagging the ...

Using Excel to Clean and Prepare Data for Analysis (10 Examples)

Looking for ways of using Excel to clean and prepare data for analysis? Then, this is the right place for you. Sometimes, the data we get is not ...

How to Rearrange Columns Alphabetically in Excel (5 Methods)

In this article, we will demonstrate 5 easy methods for rearranging columns in Excel alphabetically. Method 1 - Using Excel Sort Feature ...

Excel Pivot Table Not Grouping Dates by Month (4 Solutions)

Dataset Overview The image below displays our dataset. We'll highlight common errors that might occur during the solution process and guide you on ...

How to do a Mail Merge from Excel to Excel (Easy Steps)

Scenario Often, users have a few customer mailing credentials in an Excel file and need to fetch additional credentials that match existing data in ...

How to Calculate Area of Irregular Shape in Excel (3 Easy Methods)

To illustrate the calculations, we will use the sample dataset below. Method 1 - Determine Area of Irregular Shape by Simple Calculation ...

How to Format a Column for Email Addresses in Excel: 2 Easy Ways

Method 1 - Format Column in Excel for Email Addresses with ‘Data Validation’ Feature STEPS: Select cells that you want to format for email ...

How to Group Rows in Excel by Name (3 Methods)

Dataset Overview Our dataset to demonstrate these methods includes product, category, and amount information for different countries: ...

How to do a Mail Merge from Excel to Outlook with Attachments (2 Methods)

Method 1 - With Single Attachment In this method, we’ll demonstrate how to perform a mail merge from Excel to Outlook with a single attachment. ...

How to Separate City and State in Excel – 3 Methods

The dataset includes the name of cities and states. Method 1 - Using the Excel Text to Columns Wizard Steps: Add two columns: City ...

How to Rearrange Data in Excel (5 Examples)

Below is a dataset containing information on a department store in three columns: Customer ID, Customer Name, and Sales. Method 1 - Using ...

How to Clean Up Raw Data in Excel (10 Suitable Ways)

In Excel, it is a common thing that you need to clean up your raw data. You might need to remove duplicates or find and replace some specific cells ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo