Latest Blog Posts

How to Update Pivot Table Range (5 Methods)

The sample dataset contains the Product Category, Quantity and Sales per State.     The dataset is configured as a Pivot ...

How to Fix a Circular Reference Error in Excel – A Guideline

  What is A Circular Reference? A circular reference occurs when a formula, either directly or indirectly, refers back to its cell reference, ...

How to Use VBA in an Excel Table – 9 Methods

This dataset showcases a table with headers. Method 1 - Creating a Table with VBA in Excel Declare the Table as a ListObject. ...

How to Get the Sheet Name in Excel (2 Methods)

Method 1 - Using Excel Formula Excel lacks a built-in function to directly retrieve the sheet name, but we can create a formula using the MID, ...

How to Format a Number with VBA in Excel (4 Methods)

In the below dataset, we have the same numbers in Columns B and C.  Method 1 – Using VBA NumberFormat Property Steps: Press Alt + ...

How to Insert a Picture in Excel Header

Below is a dataset that represents some data from an online article publisher. Follow the steps to insert a Header in the Excel dataset. If you know ...

How to Use an Excel Table Reference -10 Methods

The following sample Table contains students's marks. Method-1 -Using a Structured Reference as an Excel Table Reference Marks1 is the ...

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 Replace Special Characters in Excel

In the following dataset, the product codes are invalid because they have some unnecessary ™ characters inside. To replace these characters, we can ...

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 Create Excel Drop Down List from Table (5 Methods)

Method 1 - Creating a Drop-Down List from a Table with Validation To create a drop-down list from a table, we can use the validation option. This is ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo