### Display Formula and Value Simultaneously

Ever need to display a formula and value simultaneously in the same spreadsheet? This could not be easier to...

#### Start Learning

### Separate Numbers after a symbol

This quick tutorial will demonstrate how to separate numbers after a symbol in Excel. In our example, we have a list of...

### Subtract If Greater than Zero

Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a...

### Universal Basic Income from a Republican?

Could a Universal Basic Income work in the US?

### Add Text to Beginning Number in Excel

Easily learn to Add Text to the beginning of a Number in Excel. In many instances, you are required to format number...

### What is Tableau?

Learning Tableau for Data Visualization Tableau GUI Tableau is a data visualization tool used...

### Writing Your First Macro

Learning to write your first macro in excel is very exciting. In this tutorial we will write and run our first simple...

# Excel Tutorials

#### Functions

### ROUND Function

The ROUND function in Excel returns a number rounded to a given number of digits. This can be used to round a...

### FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function...

### MINUTE Function

The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59.

### RANK Function

The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists in ascending...

### TRUNC Function

The TRUNC function in Excel returns a truncated number based on a specified number of digits. This specified number of digits is...

### Create a Drop Down List

If you want to force user for selecting data from the fixed data items and prevent user from entering custom data for any cell then you have to add drop down list option for that...

#### Formulas

### Subtract If Greater than Zero

Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a...

### Use a Letter to Represent a Value in Excel

This tutorial will show you how to use a letter to represent a specific value. Using this process, you can perform mathematical...

### Annual Growth Rate in Excel

Annual Growth Rate in Excel Calculating the Annual Growth Rate in Excel is very easy. Annual growth rates are...

### Sum if date is greater than

Sum if date is greater than a specified date. In this example, we will use the following formula to sum a range...

### Percent Change Formula in Excel

Quickly Calculate Percentage Change in Excel.

#### LATEST Additions

### ISERROR Function

The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!,...

### Rule of 500 Calculator – Astrophotography

The Rule of 500 Calculator in Excel is a simple document to let you quickly determine the maximum shutter speed for shooting Astrophotography....

### Full-Frame Crop Factor Calculator in Excel

Easily determine the Full-Frame Crop Factor of your various lenses using the following calculator in Excel. If you shoot with a Full-Frame or...

### PPMT Function

The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to determine...

### NPER Function

The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods of...

### “We can’t connect to” in Excel

"We can't connect to" pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are you...

### CUMPRINC Function

The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent...

### YEARFRAC Function

The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax:

### Add Text to End Number in Excel

Easily learn to Add Text to the End of a Number in Excel. This simple trick will allow you to format numbers with...