Latest Blog Posts

Excel VBA: Autofill Method of Range Class Failed (3 Solutions)

Autofill is a common feature of Microsoft Excel. When we want to spread any value, or formula from left to right or up to bottom we use this autofill ...

‘Not Equal to’ Operator in Excel (With 5 Examples)

In this tutorial, you will learn about the Not Equal To operator in Excel with examples and illustrations. Here's an overview of the basic use of the ...

How to Link Two Sheets in Excel – 3 Methods

Method 1 -  Using a Formula to Link Two Worksheets in Excel There are two Excel sheets:  Destination Sheet and Source Sheet. There is data in ...

How to List Sheet Name in Excel (5 Methods + VBA)

In this article, we'll discuss various ways to derive a list of sheet names in Excel. Unfortunately, there is no dedicated function to fetch a list ...

How to Group Duplicates in Excel (3 Easy Techniques)

Technique 1 - SUMPRODUCT Function to Group Duplicates ➤ Add the following formula in the first cell of the first empty column next to your dataset ...

How to Use Logical Operators in Excel (11 Examples)

If you are looking for some of the easiest ways to use logical operators in Excel easily, then you are in the right place. There are 6 types of ...

What are the Uses of CELL Color A1 in Excel? (3 Examples)

To learn about the CELL COLOR A1 you need to understand the CELL function first. This function returns information about the cell. The syntax of the ...

How to Lookup a Table in Excel (8 Methods)

Dataset Overview When working with large datasets, you often need to retrieve specific values. Excel provides a powerful feature called lookup ...

Using a Shortcut to Delete a Sheet in Excel – 5 Examples

Example 1 - Using a Keyboard Shortcut to Delete a Sheet in Excel 1.1. Regular Keyboard Shortcut To remove Sheet1: Press ALT + H + D + S. ...

How to Use ADDRESS Function in Excel?

In this article, we will learn about the ADDRESS function in Excel. We will also explore how to return cell value by address, cell address instead of ...

Tax Invoice Format in Excel (Download the Free Template)

In Microsoft Excel, you can create custom templates to save time filling and calculating often used files, such as invoices. Input your data, and the ...

Using Excel VBA to Find a Week Number – 6 Examples

Example 1 - Transform a Date into a Week Number The following dataset contains random dates, including the day. To find the week number: ...

Excel Advanced Filter Not Working (2 Reasons & Solutions)

  What Is the Advanced Filter in Excel? We can use the Advanced filter to perform complex filtering in Excel. For example, you can filter data ...

Excel VBA to Count Rows with Data: 4 Methods

Method 1 - Count Rows with Data Using Excel VBA in a Whole Sheet Steps: Right-click on the sheet title. Select View Code from the context ...

Create a Dynamic Chart Range in Excel (2 Methods)

Method 1 - Use an Excel Table to Create a Dynamic Chart Range in Excel Select the whole dataset. Press Ctrl + T keys. A dialog box ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo