Latest Blog Posts

How to Fix If TRIM Function Not Working in Excel: 2 Solutions

The Trim Function can trim extra leading and trailing spaces within text cells in Excel. Normally, the spaces given before a word are called ...

How to Lookup Value from Another Sheet in Excel (3 Easy Methods)

There are a few relatively simple methods you can use to look up data from another sheet in Excel. To demonstrate the capabilities of these methods, ...

How to Split First And Last Name in Excel (6 Easy Ways)

The sample dataset contains two columns: Full Name and Account Number. We'll split the Full Name column. Split the First and Last Name in ...

How to Split Screen in Excel (3 Ways)

Excel’s split screen option is a great way to view your work simultaneously at the same time. You can even visualize your work vertically or ...

Transport Bill Format in Excel (Create in 4 Simple Steps)

What Is an Excel Transport Bill Format? A transport bill is a type of receipt provided by a transport service. The overview of a bill template is in ...

How to Group Dates in Pivot Table: 7 Methods

Method 1 - Group Dates by Years in Pivot Table Steps Select any date from the pivot table. Go to the PivotTable Analyze, and from the ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo