Excel Basics Archives - Page 48 of 124

How to Group Data by Month in Excel: 2 Useful Methods

Jun 1, 2024

Method 1 - Grouping Data by Month Automatically Step 1 - Create a Pivot Table Select the entire dataset. Click on the Insert ribbon at the ...

How to Group Data by Month in Excel: 2 Useful Methods

Why Formula Is Not Working in Excel (15 Reasons & Solutions)

May 16, 2024

We'll use a dataset that contains student Names and their scores in Math and English. We will go through some of the most common fixes when formulas ...

Why Formula Is Not Working in Excel (15 Reasons & Solutions)

How to Create a Color Scale with Conditional Formatting Based on Another Cell

Jul 15, 2024

Dataset Overview Suppose you have a dataset with daily wages and sales data. You want to format the wages column using a color scale based on the ...

How to Create a Color Scale with Conditional Formatting Based on Another Cell

How to Make Excel Run Faster with Lots of Data: 11 Ways

Jul 6, 2024

Method 1 - Trying to Avoid Array Formulas to Make Excel Run Faster with Lots of Data Array formulas can kill your time while doing calculations. It ...

How to Make Excel Run Faster with Lots of Data: 11 Ways

Conditional Formatting Data Bars Different Colors

Jul 7, 2024

We have a dataset that depicts the ongoing project status in percentage. We want conditional formatting data bars in different colors. ...

Conditional Formatting Data Bars Different Colors

How to Improve Excel Performance with Large Files (15 Effective Ways)

Jun 17, 2024

Method 1 - Avoid Using Volatile Functions Volatile functions can be defined as a function in which Excel will recalculate every time there is a ...

How to Improve Excel Performance with Large Files (15 Effective Ways)

How to Use 4 Color Scale Conditional Formatting in Excel (2 Examples)

Jul 15, 2024

Excel's default conditional formatting only goes up to a 3-color scale, so more colors need to be implemented manually. We’ll use a sample dataset ...

How to Use 4 Color Scale Conditional Formatting in Excel (2 Examples)

How to Create Barcode in Excel (3 Easy Methods)

Jun 11, 2024

Watch Video – Create Barcode in Excel Method 1 - Apply IDAHC39M Font to Create Barcode in Excel Steps: Download the IDAHC39M font ...

How to Create Barcode in Excel (3 Easy Methods)

How to Generate Code 128 Barcode Font for Excel

Jul 3, 2024

Note: The given VBA user-defined function Code128 can only be used in the Windows operating system. It will not work properly in Mac OS. ...

How to Generate Code 128 Barcode Font for Excel

How to Make Excel Move Automatically to the Next Cell: 4 Suitable Methods

Jul 3, 2024

Method 1 - Using VBA to Make Excel Move Automatically to Next Cell Steps: Go to the Developer tab >> click on Visual Basic. The ...

How to Make Excel Move Automatically to the Next Cell: 4 Suitable Methods

How to Stop Calculating 8 Threads in Excel (14 Effective Ways)

Jul 3, 2024

Method 1 - Disable Multi-Threaded Calculation Steps Click on the File tab. Select Options. You'll get a dialog box named ...

How to Stop Calculating 8 Threads in Excel (14 Effective Ways)

How to Use Code 39 Barcode Font for Excel (with Easy Steps)

Apr 23, 2024

Step 1 - Downloading a Suitable Code 39 Barcode Font Close all of your office applications. Download the code 39 barcode font using ...

How to Use Code 39 Barcode Font for Excel (with Easy Steps)

How to Capitalize All Letters Without Formula in Excel (4 Methods)

Jun 23, 2024

Method 1 - Using the Flash Fill feature to Capitalize All Letters We have a dataset of different Student names and IDs. We want to put the names in ...

How to Capitalize All Letters Without Formula in Excel (4 Methods)

How to Apply Conditional Formatting with 3 Color Scale in an Excel Formula – 2 Methods

Aug 4, 2024

The sample dataset is a large Excel worksheet containing information about several students. Method 1 - Using the IF Function to Apply ...

How to Apply Conditional Formatting with 3 Color Scale in an Excel Formula – 2 Methods

How to Open Large Excel Files Without Crashing (10 Methods)

Jun 17, 2024

Method 1 – Removing Excel Add-ins Steps: Go to the File tab on your ribbon. Select Options from the left side of the backstage view. ...