Latest Blog Posts - Page 212 of 587

How to Use VLOOKUP with Multiple Criteria in Different Columns

Nov 11, 2025

Whilst working in Microsoft Excel, we’ve all faced a scenario where we need to look up a value from a dataset based on a few criteria. Now, even with ...

How to Use VLOOKUP with Multiple Criteria in Different Columns

How to Create a Monthly Schedule in Excel (3 Simple Ways)

Jul 4, 2024

Watch Video - Create a Monthly Schedule in Excel Method 1 - Using Excel Templates to Create Monthly Schedule in Excel Step 1 ...

How to Create a Monthly Schedule in Excel (3 Simple Ways)

How to Swap Non-Adjacent Cells in Excel (3 Easy Ways)

Nov 11, 2025

If you are looking for ways to swap non-adjacent cells in Excel, this article is for you. Swapping values can be time-saving for correcting any ...

How to Swap Non-Adjacent Cells in Excel (3 Easy Ways)

How to Create an Account Statement in Excel (with Easy Steps)

May 23, 2024

Watch Video – Create an Account Statement in Excel Step 1: Prepare an Appropriate Outline The first step is to create ...

How to Create an Account Statement in Excel (with Easy Steps)

How to Move Watermark in Excel (with Easy Steps)

Nov 11, 2025

A watermark is a logo, text, picture, or pattern. We usually superimpose it onto another image or dataset intentionally. The main purpose of a ...

How to Move Watermark in Excel (with Easy Steps)

How to Get Cell Value by Address in Excel: 6 Simple Methods

Jul 7, 2024

Method 1 - Get Cell Value Using ADDRESS Function Steps: Go to cell D4 and insert the following formula: =INDIRECT(ADDRESS(10,2)) ...

How to Get Cell Value by Address in Excel: 6 Simple Methods

How to Spell Out Number Without Currency in Excel (2 Methods)

Jul 22, 2024

Dataset Overview Let’s say, we have a dataset with some Numbers with 2 decimal points. Our goal is to spell these numbers in words without ...

How to Spell Out Number Without Currency in Excel (2 Methods)

How to Export HTML Table with Formatting to Excel

Jul 12, 2024

We have a DOCTYPE HTML code that contains information about several Customers. We will create an HTML table using Notepad. Step 1 - Create ...

How to Export HTML Table with Formatting to Excel

How to Show Equation in an Excel Graph (with Easy Steps)

Jun 18, 2024

The dataset, Sales Report of ABC Traders, has 2 columns indicating Days and Sales. We will look at 3 easy steps for showing equations in an Excel ...

How to Show Equation in an Excel Graph (with Easy Steps)

[Fixed!] Excel VLOOKUP Partial Match Not Working

Nov 11, 2025

One of the most powerful functions in Excel is the VLOOKUP function. It helps to find any specific data or value from a large dataset. Even it works ...

[Fixed!] Excel VLOOKUP Partial Match Not Working

How to Use the VBA Sumifs with Multiple Criteria in the Same Column – 3 Steps

Aug 14, 2024

This is the sample dataset. Step 1 - Create a New Module in Visual Basic Window Select Developer. Choose Visual Basic. In ...

How to Use the VBA Sumifs with Multiple Criteria in the Same Column – 3 Steps

How to Maintain Accounts in an Excel Sheet – 4 Templates

Aug 8, 2024

The sample dataset showcases the transaction history of a shop. Template 1- Maintaining Expense Accounts for a Shop in Excel Sheet Steps: ...

How to Maintain Accounts in an Excel Sheet – 4 Templates

Excel VLOOKUP with Multiple Criteria in Horizontal & Vertical Way: 5 Methods

Jul 4, 2024

Method 1 - Use a Helper Column to Left to Match Multiple Criteria with VLOOKUP Steps: Create a helper column on the left side of your dataset. ...

Excel VLOOKUP with Multiple Criteria in Horizontal & Vertical Way: 5 Methods

How to Create Mind Map from Data in Excel (2 Common Ways)

Jul 27, 2024

Method 1 - Creating a Mind Map with SmartArt Feature Steps: Go to the Insert tab> click the Illustration option> select SmartArt from ...

How to Create Mind Map from Data in Excel (2 Common Ways)

Using the Excel COUNTIFS Function with Multiple Criteria and the OR Logic – 3 Examples

Aug 12, 2024

The sample dataset contains information about Products, their Payment Status and Quantity. To count the number of laptops and keyboards with ...