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 […]
Excel Tutorials
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 […]
How to Make a Drop Down List in Excel – Tutorial
Excel tutorial on how to make a drop down list in Excel. We’ll walk through an example of how to create and then edit a dropdown list in an Excel spreadsheet. You’ll also see how you can add a custom message to the items in your drop down list and, if you’d like, you can […]