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 Crop sensor camera, chances are …
Excel Basics
Learn the basics of Excel by reviewing easy to follow tutorials, tricks, and tips.
“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 will probably received an error message …
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 specified Text at the end. …
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 with Text at the beginning. The …
Delete Multiple Rows of data
In some cases, there is a need to delete multiple rows of data in Excel. When dealing with large data sets, there are several ways you can delete …
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 Serial numbers that were exported into …
Tip Calculator Template
Learn to create a tip calculator template in Excel. This basic template allows you to setup a tip calculator for splitting up bills. It also allows you to …
Calculate Work Days in Excel
Calculate Work Days in Excel Using the following Functions Learn how to calculate work days for a given year, or multiple years, in Excel. There are multiple functions …
Sum if between
To sum if between in Excel, we need to use the SUMIFS Function and define our criteria.