Latest Blog Posts - Page 76 of 411

How to Encrypt Cell Content in Excel – 2 Methods

Aug 2, 2024

The dataset showcases Account Names, Card Numbers, and passwords. To encrypt the Password: Method 1 - Applying VBA Macros to ...

How to Encrypt Cell Content in Excel – 2 Methods

How to Change Font in Excel to All Caps (8 Simple Ways)

Jul 6, 2024

The following dataset shows company department purchases. We will change the name font to all caps for the person related to the purchase. ...

How to Change Font in Excel to All Caps (8 Simple Ways)

How to Make a Checklist in Excel – 5 Steps

Aug 9, 2024

This is the sample dataset: Step 1 - Enable the Developer Tab Click Customize Quick Access Toolbar above the Home tab. ...

How to Make a Checklist in Excel – 5 Steps

Using Excel VBA to Scrape a Table from a Website – 4 Steps

Aug 12, 2024

This is a real-time data table from the investing.com website. STEP 1 - Open the Visual Basic Editor Go to the Developer tab and ...

Using Excel VBA to Scrape a Table from a Website – 4 Steps

How to Use Conditional Formatting in Data Labels in Excel

Jul 4, 2024

In this article, we will demonstrate how to use conditional formatting in data labels to present data in charts more eloquently. Download the ...

How to Use Conditional Formatting in Data Labels in Excel

Excel Practice & Exercises with SUM Function

Jun 4, 2024

Problem Overview You will get six exercises related to the SUM function. To illustrate the problems, we have used a dataset. This dataset represents ...

Excel Practice & Exercises with SUM Function

How to Scrape Data from a Website into Excel (2 Easy Methods)

May 19, 2024

To illustrate our methods, we'll use a table on a webpage (see the screenshot below) that we want to export into Excel for further analysis. ...

How to Scrape Data from a Website into Excel (2 Easy Methods)

How to Change Font Style in Excel (5 Easy Ways)

Aug 4, 2024

In this Excel tutorial, we will describe how to change font style. Changing font style in Excel is a process that enhances the visual appeal of the ...

How to Change Font Style in Excel (5 Easy Ways)

Excel Practice & Exercises with IF Function

Apr 19, 2024

This article contains seven Excel practice exercises related to the IF function. The problems are easy to solve, so you will only need a basic level ...

Excel Practice & Exercises with IF Function

How to Increase Font Size for Printing in Excel (2 Suitable Ways)

Jul 6, 2024

Method 1 - Apply Scaling Option to Increase Font Size for Printing in Excel STEPS: Click on File. Select Print. The Print ...

How to Increase Font Size for Printing in Excel (2 Suitable Ways)

How to Use REGEX to Match Patterns in Excel – 6 Examples

Aug 6, 2024

Example 1 - Using a Combined Formula to Match a REGEX Pattern in Excel REGEX will be: the total character length - 9, the first 3 - uppercase ...

How to Use REGEX to Match Patterns in Excel – 6 Examples

Excel VBA to Translate Language with Formula (With Easy Steps)

Jun 16, 2024

Codes for Different Languages Here's a short list of language codes for some languages. You will find the detailed list on the Google Cloud ...

Excel VBA to Translate Language with Formula (With Easy Steps)

How to Change Encoding in Excel -3 Methods

Aug 4, 2024

This is the sample dataset. Method 1 - Changing the Encoding by using the Web Options in Excel Steps: Select the File tab. ...

How to Change Encoding in Excel -3 Methods

How to Apply Abbreviation Using Formula in Excel

Jul 11, 2024

We will use the following sample data set to apply abbreviations. Method 1 - Combine TEXTJOIN, ISNUMBER, MATCH, CODE, MID, ROW, INDIRECT, ...

How to Apply Abbreviation Using Formula in Excel

How to Make a Recalculate Button in Excel (5 Easy Steps)

Jul 15, 2024

The Recalculate button allows you to update formulas in your dataset. If you’re using volatile functions that change over time, you’ll need to ...