Advanced Excel Archives - Page 62 of 64

Creating Email Addresses from a Single Column with Flash Fill, TEXT Formulas & Commentator’s Text Formula Suggestions

Nov 11, 2025

Using Flash Fill This is a question that is often asked namely, how to extract data from one column into another format or more than one column. ...

Creating Email Addresses from a Single Column with Flash Fill, TEXT Formulas & Commentator’s Text Formula Suggestions

Navigating Excel Table (7 Simple Techniques)

Nov 11, 2025

Navigating an Excel table is just like navigating within a worksheet. You can use a mouse or you can use the keyboard to navigate within a table. In ...

Navigating Excel Table (7 Simple Techniques)

How to Insert or Delete Rows and Columns from Excel Table

Nov 11, 2025

The Table is a wonderful feature of Excel. A table contains a group of data and we can use those data combinedly and perform any operation on the ...

How to Insert or Delete Rows and Columns from Excel Table

How to Remove Duplicate Rows in Excel Table

Nov 11, 2025

This post will deal with imposters! No, I mean table duplicate entries. We will be able to manage them, remove them, tame them according to our ...

How to Remove Duplicate Rows in Excel Table

How to Use Sort and Filter with Excel Table (4 Suitable Ways)

Nov 11, 2025

When you have a large table as a dataset then most of the time, you may need to Sort and Filter in Excel. In this post, I will discuss how you can ...

How to Use Sort and Filter with Excel Table (4 Suitable Ways)

How to Use Wildcards in Excel (4 Easy Methods)

Jul 15, 2024

In this article, we will demonstrate how to use wildcards in Excel. Wildcard characters such as the asterisk "*", question mark "?" and tilde "~" ...

How to Use Wildcards in Excel (4 Easy Methods)

How to Get Unique Values in Excel (5 Easy Ways)

Jul 31, 2024

The sample dataset contains 200 rows of data with 5 columns. Method 1 - Using Advanced Filter Excel Advanced filter helps you to extract ...

How to Get Unique Values in Excel (5 Easy Ways)

How to Convert Text to Columns in Excel (3 Cases)

Aug 6, 2024

In this article, we will demonstrate 3 practical uses of Excel's Text to Columns feature: splitting the columns of a table in various ways, ...

How to Convert Text to Columns in Excel (3 Cases)

How to Enter Date and Time in Excel: 8 Quick Methods

May 28, 2024

Method 1 - Keyboard Shortcuts to Enter Current Date & Time in Excel Steps: Enter the date, and select cell B5. Hold the Ctrl (control) ...

How to Enter Date and Time in Excel: 8 Quick Methods

How to Use Excel Objects to Create an Art Portfolio

Nov 11, 2025

If you are looking for the procedures to use Excel objects to create an art portfolio easily, then this article will be helpful for you. So, let's ...

How to Use Excel Objects to Create an Art Portfolio

How to Make Negative Numbers Red in Excel (4 Easy Ways)

Jul 4, 2024

Let's use a dataset (B4:D8) in Excel that contains the Main Balance, Transaction and Present Balance. We can see 3 negative numbers in cells C5, C6, ...

How to Make Negative Numbers Red in Excel (4 Easy Ways)

How to Format Excel to Print (13 Simple Tips)

Jul 21, 2024

Dataset Overview We'll use a dataset containing some names of fruits under Product and their Sales value of 4 months (January to April) to ...

How to Format Excel to Print (13 Simple Tips)

How to Import and Use Data into Power Pivot in Excel

Nov 11, 2025

PivotTable is a useful tool when we want to analyze or slice data to gain important insights. It is the main way to analyze data. But it also has ...

How to Import and Use Data into Power Pivot in Excel

How to Extract Data from Website to Excel Automatically

Jun 27, 2024

We want to collect data from webpage of the U.S. Energy Information Administration showing information on petroleum prices. Step 1 - Using ...

How to Extract Data from Website to Excel Automatically

How to Import Data from Website to Excel with VBA Code: 2 Ideal Methods

Jun 3, 2024

Method 1 - Import Specific Data from Website to Excel VBA MsgBox STEPS: Go to the Developer tab from the ribbon. Click on Visual Basic from ...