Example of Excel Data Table (6 Criteria)

We're going to use the sample information, containing the values for Capital, Growth Per Year, Total Revenue, Years, and Revenue in Years. ...

How to Convert Date from a String Using VBA – 7 Methods

This is the sample dataset. Method 1 - Using VBA to Convert Date to a Text String Step 1:  Go to Developer Tab >> Visual Basic ...

How to Use the VBA DateAdd Function in Excel

The VBA DateAdd function is under the date and time category of Excel’s VBA functions. By using this function we can add or subtract years, months, ...

A Daily Compound Interest Calculator in Excel (Template Attached)

Daily Compound Interest Formula in Excel The basic compound interest formula is shown below: Current Balance = Present Amount * (1 + interest ...

How to Sum Time in Excel (9 Suitable Methods)

  Method 1 - Using Excel Formula to Sum Time in Excel We will use the following dataset which contains the working hours of staff for Thursday ...

How to Use Excel QUOTIENT Function (4 Suitable Examples)

Excel QUOTIENT function falls under the Math & Trig category. The function takes two arguments: numerator (i.e., dividend) and denominator (i.e., ...

Calculate Future Investment Value with Inflation, Tax and Interest Rates

If you want to calculate future investment with inflation and nominal interest rates, then there is an essential article on How to calculate future ...

How to Use PROB Function in Excel (3 Examples)

Here's an overview of the PROB function in Excel. What Is Probability? Probability defines the chance of occurrence of an event. There ...

How to Use SKEW Function in Excel (2 Examples)

The SKEW function in Excel calculates the skewness of a range of data. The skewness is the deviation of the normal distribution which is a ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo