Excel tutorial on how to round time in Excel. Excel has many rounding functions, but, we’ll use MROUND in this tutorial because I like how it’s able to round up or round down to whatever multiple we want to use. There are many reasons why you may need to round time, but, a common use […]
Excel Tutorials
How to Combine Contents in Cells in Excel – Tutorial
Excel tutorial on 4 ways to join cells in Excel. We’ll look at how to use ampersand (&) in Excel, then CONCATENATE, followed by the CONCAT function and, lastly, the TEXTJOIN function. Ampersand and CONCATENATE are both used in Excel to combine contents cells and are pretty much interchangeable. & is a calculation operator (kind of […]
How to Use Fractions in Excel (+ video tutorial)
There are times when you may want to display your numbers as fractions in Excel. And using fractions in Excel is actually super easy to do! All you need to do is format your cells with Fraction formatting. 2 Ways to Apply Fraction Formatting in Excel Click to Watch Tutorial 1. Format Your Cells as […]
Convert Time to a Number in Excel – Tutorial (with video)
Depending on what you’re calculating, you may need to know how to convert a time format to a number in Excel. This will come in handy if you need to calculate total time, for example. And doing so is all about knowing the right math! What to Know About Time Values in Excel Excel sees […]
Time-Saving Excel Keyboard Shortcuts (+ video tutorial)
Using keyboard shortcuts in Excel, instead of reaching for your mouse all the time, is a great way to save time. Even if it takes a second to reach for your mouse, that time adds up if you reach for your mouse repeatedly. Using keyboard shortcuts can help you work faster and be more efficient […]
How to Set Character Limit in Excel Cells (+ video tutorial)
There may be times when you want to limit how many characters can be entered in a cell or group of cells in Excel. Setting a limit on the number of characters that can be entered in some cells can help reduce inputting mistakes. For example, if you need users to enter addresses, your spreadsheet […]