Excel Basics Archives - Page 82 of 176

Formula to Create Email Address in Excel (2 Methods)

Jun 14, 2024

Suppose you have the following dataset. Method 1 - Combine CONCATENATE, LOWER, and LEFT Functions to Create Email Addresses Steps: ...

Formula to Create Email Address in Excel (2 Methods)

How to Create a Tally Chart in Excel – 3 Methods

Aug 3, 2024

The sample dataset showcases Candidate Names and their collected Votes. Represent the collected votes in a tally graph. ...

How to Create a Tally Chart in Excel – 3 Methods

How to Sort an Excel Sheet by Name (4 Easy Methods)

Jun 19, 2024

Method 1 - Applying Drag and Drop to Sort an Excel Sheet by Name Steps: Select any sheet, drag it using a Mouse, and drop it where you ...

How to Sort an Excel Sheet by Name (4 Easy Methods)

How to Make an Address Book in Excel: An Ultimate Guide

Jun 5, 2024

What Is an Address Book in Excel? Like the phone book in our phone, we can create an address book in Excel. In this book, we can store a lot of data ...

How to Make an Address Book in Excel: An Ultimate Guide

How to Calculate Outliers in Excel (5 Ways)

Jul 4, 2024

Method 1 - Using Sort & Filter to Calculate Outliers in Excel Step 1: Select the column header that you want to sort in your Excel ...

How to Calculate Outliers in Excel (5 Ways)

How to Group Columns Next to Each Other in Excel (2 Easy Ways)

Jun 26, 2024

Method 1 - Use Keyboard Shortcuts to Group Excel Columns Next to Each Other STEPS: Insert a new column between Group - 1 & Group - 2. ...

How to Group Columns Next to Each Other in Excel (2 Easy Ways)

How to Group Similar Items in Excel (4 Methods)

Jul 28, 2024

Method 1 - Row or Column-wise Grouping for Similar Items Sometimes, we need to group similar items based on rows or columns. In this section, I’ll ...

How to Group Similar Items in Excel (4 Methods)

How to Reverse the Order of Worksheets in Excel – 3 Methods

Aug 13, 2024

Method 1 - Reverse the Order of the Worksheets by Dragging them Steps: Place the cursor at the bottom-left corner of the Excel workbook. ...

How to Reverse the Order of Worksheets in Excel – 3 Methods

How to Format Addresses in Excel: 4 Easy Methods

May 16, 2024

Method 1 - Using FIND, LEFT, MID and RIGHT Functions Steps: Select cell D6. Write down the following formula in the cell. ...

How to Format Addresses in Excel: 4 Easy Methods

How to Calculate Average Excluding Outliers in Excel (4 Easy Methods)

Nov 11, 2025

The average of a range of data doesn’t always illustrate the perfect pictures. Sometimes there are outliers in the range that cause a deviation from ...

How to Calculate Average Excluding Outliers in Excel (4 Easy Methods)

How to Group Worksheets in Excel (3 Easy Ways)

Nov 11, 2025

Whenever someone is working with a very large dataset, grouping worksheets helps to perform tasks more easily. In Microsoft Excel, if you have the ...

How to Group Worksheets in Excel (3 Easy Ways)

How to Create a Tally Button in Excel: 2 Suitable Methods

May 28, 2024

Method 1 - Create a Spin Button in Excel Step 1: Insert a Spin Button You have to enable the Developer tab. Go to Developer tab > Insert ...

How to Create a Tally Button in Excel: 2 Suitable Methods

How to Separate Address Number from Street Name in Excel (6 Ways)

Nov 16, 2024

Suppose we have the following dataset. Let's separate the Street Numbers in the Address column into column D. Method 1 - Combining IF, ...

How to Separate Address Number from Street Name in Excel (6 Ways)

How to Split Inconsistent Address in Excel (2 Effective Ways)

Nov 11, 2025

This article illustrates how to split inconsistent address in Excel. There are several ways to split consistent addresses in MS Excel. For example, ...

How to Split Inconsistent Address in Excel (2 Effective Ways)

How to Create Multiple Groups in Excel (4 Effective Ways)

May 13, 2024

Watch Video – Create Multiple Groups in Excel The following dataset contains the names of the sales representatives for each ...