Latest Blog Posts

How to Tabulate Data in Excel (4 Methods)

The sample dataset has some products, along with their price per unit (kg) and the amounts. Method 1 - Use Insert Tab Option to Tabulate ...

How to Create a Tally VAT Invoice Format in Excel (with Easy Steps)

In real life, we need to create a tally VAT in invoice format. Using Microsoft Excel, you can easily create a tally VAT in invoice format. This is a ...

Horizontal Cylindrical Tank Volume Calculator in Excel

Formulas for Horizontal Cylindrical Tank Volume Calculator The volume of a  cylinder can be of two types: fully and partially filled. Partially ...

How to Calculate Price Per Square Meter in Excel: 3 Handy Methods

Method 1 - Dividing Total Cost by Total Area to Calculate Price Per Square Meter The following table has Total Area in m2, Total Price, and Price/m2 ...

How to Calculate Annual Sales in Excel (4 Useful Methods)

In Excel, you can do any kind of sales-related calculation quite easily and speedily if you know some quick and smart methods. We are used to finding ...

How to Convert Lbs to Kg in Excel (3 Easy Methods)

We have a dataset of some Patient Names and their Weight in pounds. Method 1 - Use the CONVERT Function to Convert Lbs to Kg in Excel ...

How to Add Notes in Excel (The Ultimate Guide)

To add a note to a cell in your worksheet: Select a cell. Go to Review, then to Notes, and select New Note. You’ll see a banner next ...

How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel – 4 Methods

The dataset contains people's names and their height in mm. To convert the height to feet and inches: Method 1 - Using the Excel CONVERT ...

How to Calculate Sales Growth over 5 Years in Excel (3 Ideal Examples)

Business sectors preserve their necessary information in Excel. They have to perform various operations according to their requirements. The sales ...

How to Calculate Peak Area in Excel (2 Effective Methods)

  The sample dataset is a graphical representation of the equation y=sinx ranging from 0 to pi. The graph has a peak at sin (pi/2) where the ...

How to Calculate Range in Excel (5 Handy Methods)

We have made a dataset of Sales of Shoes and Bags in 2021 at different stores. We'll use it to apply various range functions. Method 1 - ...

How to Calculate Selling Price Per Unit in Excel (3 Easy Ways)

Looking for ways to know how to calculate the selling price per unit in Excel? Then, this is the right place for you. In regular life, we have to ...

How to Remove Pound Sign in Excel (8 Easy Methods)

Suppose we have a dataset of a shop's Product Name, Quantity, Unit Price, and Total Sold Amount. The amounts are displayed in pounds. Let's remove ...

How to Calculate Age in Excel from ID Number (4 Quick Methods)

Let’s consider the following dataset (in B4:C14) with people's Names and their ID Numbers. The first 6 digits in ID Numbers represent the date of ...

How to Calculate Selling Price in Excel (4 Easy Methods)

Arithmetic Formula to Calculate Selling Price Before calculating a selling price in Excel, it's important to know the appropriate formulas. If we ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo