Latest Blog Posts

How to Convert String to Double in Excel VBA (5 Methods)

  What is the CDbl Function? The VBA CDbl function converts an expression to a double. You'll see the following scenario if you insert the ...

How to Convert Week Number to Date in Excel (2 Suitable Methods)

Method 1 - Using the DATE and WEEKDAY Functions to Convert Week Number to Date There are no straightforward functions to convert the week number to ...

Create Late Payment Interest Calculator in Excel and Download for Free

Here's an overview of the late interest calculator we're building in the article. You can follow along or download the template to use immediately. ...

How to Calculate the Annual Growth Rate in Excel – 3 Methods

Method 1 - Calculate the Compound Annual Growth Rate in Excel This is the basic formula: =((End Value/Start Value)^(1/Time Periods)-1 This ...

How to Auto Number or Renumber after Filter in Excel (7 Easy Ways)

Suppose a company has employee records in a worksheet. The worksheet has four columns: Serial, Name, Department, and Joining Date. The company might ...

How to Calculate 7 Day Moving Average in Excel (4 Ways)

What Is the Moving Average? The moving average is a type of average of numbers where the time frame remains the same but the data keeps updating as ...

How to Convert a Column into a Comma Separated List With Single Quotes – 5 Methods

Download Practice Workbook Download the practice workbook to exercise. Convert Column to List.xlsm The dataset contains information ...

Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)

In this article, we’ll demonstrate the easiest ways to calculate the percentage in Excel using absolute cell references. What are Absolute ...

How to Calculate Reverse Percentage in Excel (4 Easy Examples)

Example 1 - Calculate Reverse Percentage Manually in Excel We will use the following sample dataset that contains the percentage of the total amount ...

How to Apply Percentage Formula in Excel for Marksheet (7 Applications)

  Method 1 - Fundamental Percentage Formula in Excel for a Marksheet If we want to determine what percentage of A is B we will use the ...

How to Concatenate Two Columns in Excel with Hyphen: 9 Quick Methods

Method 1 - Using the CONCATENATE Function to Concatenate Two Columns with a Hyphen Steps: ➤ Use the following formula in cell D4. ...

How to Calculate Bacterial Growth Rate in Excel: 2 Easy Methods

Method 1 - Using an Exponential Formula to Calculate Bacterial Growth Rate in Excel Bacteria in cultures follow exponential growth. From ...

How to Convert Percentage to Number in Excel (5 Easy Ways)

Method 1 - Convert Percentage to a Number from the Home Tab Let's use a dataset that contains the information of sales for two months of some ...

How to Convert Single Columns to Rows in Excel with Formulas – 4 Methods

Method 1 - Excel Formulas with OFFSET Function to Convert One Column to Multiple Rows Steps: Enter the formula in D5. ...

How to Use The Keyboard Shortcut to Freeze Panes in Excel (3 Methods)

The dataset includes the Product Name, the Price, and the product's percentage of value-added tax (VAT). Method 1 – Shortcut to Freeze ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo