How to Calculate Hours Between Two Times in Excel (6 Methods)

  Method 1 - Calculating Hours Between Two Times by Subtracting Them in Excel We’ve created the following data table to calculate the hours ...

How to Use LOG Function in Excel: 10 Methods

Method 1 - Using LOG Function in Excel with Default Base Argument (Log10) Apply the LOG function without specifying the base argument; then it is ...

How to Convert Date to Text YYYYMMDD (3 Quick Ways)

In Excel, the date and time are stored as numbers. This allows the user to perform calculations with these dates and times. However, you might want ...

How to Use CODE Function in Excel (5 Examples)

The CODE function, an Excel Text function returns a numeric code for the first character of a text string. The returned numeric code is based on the ...

How to Create a Data Table in Excel (7 Ways)

We'll use the following table to demonstrate creating a data table in Excel. Method 1 - Creating a One-Variable Column-Oriented Data Table ...

How to Use DCOUNTA Function in Excel (5 Examples)

When we need to count the number of non-empty cells in a given database, the Excel DCOUNTA function is the perfect function for the job. In this ...

How to Calculate Weighted Moving Average in Excel (3 Methods)

Weighted moving average is one form of moving average that is used to smooth out time-series data with an aim to decrease the effects of random, ...

How to Use Excel STDEV Function (3 Easy Examples)

The standard deviation of any data collection can be calculated using the STDEV function in Excel. The standard deviation displays how far one value ...

How to Use Excel INDIRECT Range (8 Easiest Ways)

To explain the INDIRECT function, we'll use a dataset that represents sales information for 4 quarters. The dataset has 5 columns: Salesperson, ...

How to Calculate Percentage of Total in Excel? (2 Methods)

Suppose you have a list of your daily or monthly transactions. You want to know in which transaction category you are spending the most. You can get ...

How to Use Excel PPMT Function (3 Suitable Examples)

The Excel PPMT function falls in the financial functions category. PPMT calculates periodic payments on loans or investments that have a specified ...

How to Switch Rows and Columns in Excel (5 Methods)

The dataset below shows the market share of smartphone companies. Method 1 – Using the Paste Special (Transpose) Steps: Select the ...

How to Use GAMMA Function in Excel (With Example)

The Gamma function is widely used in science, business, and engineering. It is useful for the variables which are always positive. For example, the ...

How to Use INDIRECT ADDRESS Functions in Excel: 4 Examples

Example 1: Used for Indirect Referencing We have two tables and we want to have the values of the sales of the first table in the second table in ...

How to Use FV Function in Excel (4 Easy Examples)

The FV function is a default function of Microsoft Excel which is categorized as a financial function. It helps to figure out the future value of an ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo