Excel Basics

Relative Cell Reference Example in Excel (3 Criteria)

Are you looking for relative cell reference example in Excel? Then you are in the right place. Relative Cell Reference in Excel is one kind of cell ...

How to Create a Cash Bill Format in Excel (A step-by-step Guideline)

If you are a shop owner or have a small business, you might need a cash bill invoice to give to your customers with the cost of each purchased item ...

How to Use Less Than Or Equal to Operator in Excel – 8 Examples

This is an overview. The sample dataset contains information about two fruit stores. Example 1 - Compare String Values with ...

How to Count Rows with a Formula in Excel (5 Methods)

  Method 1 - Using the ROWS Function to Count Rows in Excel Steps: Enter the below formula in Cell D12: =ROWS(B5:D10) Here, ...

How to Merge Multiple Sheets into One Sheet with VBA in Excel?

We have a workbook consisting of 3 worksheets, Sheet1, Sheet2, and Sheet3. Each contains the sales record of some products for 3 different weeks. ...

How to Calculate Total Hours in Excel (9 Easy Methods)

Method 1 - Adding Time Values to Calculate Total Hours in Excel We have a duration list of several tasks. We will sum up the cells containing ...

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 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 ...

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. ...

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 ...

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 ...

How to Keep a Cell Fixed in Excel Formula (4 Easy Ways)

Method 1 - Use the F4 Key in Excel Formula to Keep a Cell Fixed We have a dataset of fruits with their weight, unit price, and total price. Sellers ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo