Functions / Formulas

There are times you may want to prevent duplicate entries in Excel. For example, if you’re working with a list of invoice numbers and don’t want to accidentally repeat any of them. You can limit the number of times a number (or word) is repeated in a column, row, or a selected range of cells […]

You’ve likely gotten a spreadsheet with dates in one column and times in another column. And it’s up to you to combine them – like in a timestamp. You quickly realize that concatenating them isn’t going to work. Don’t panic! It’s actually super easy to combine the date and time from separate cells in Excel. […]

Whether you need to calculate an equation with Pi or simply display a Pi symbol, there are a few ways you can use Pi in Excel spreadsheets. Use the Pi Function to Use the Value of Pi in Excel WATCH: How to Use Pi in Excel – Tutorial Yes, there is a Pi function in […]

Excel tutorial introducing array formulas. We’ll go over what an array formula is in Excel, how to use one, and end with some tips to keep in mind when using array formulas. First, in Excel an array refers to a group of values – they could be in a row, column or both. An array […]

The CONVERT function in Excel helps you do unit conversions from one measurement unit to another. For example, if you need to convert mph to km/hr. There are a TON of measurement units you can convert to and from! Some common ones are for weight and mass, distance, speed, time, and temperature, but there are […]

Excel tutorial on 4 ways to round in Excel. We’ll look at ROUND, ROUNDUP, ROUNDDOWN and MROUND functions. It might seem odd that there are so many rounding functions but having them helps add flexibility to meet the needs of different projects. Here’s how these rounding functions differ: 1. What is the ROUND function in […]