The Ctrl + End shortcut deserves special mention as it instantly takes you to the last cell containing data, which is perfect for quickly assessing the size of your dataset. If Ctrl + End takes you ...

Since most formatting options in Excel are accessible through the Home tab on the ribbon, you need to use the keyboard shortcut key to activate this option. For this reason, all the commands in this ...

Excel 2019 adds six new functions for doing calculations. TEXTJOIN and CONCAT let you combine text strings from ranges of cells with or without using a delimiter separating each item, such as a comma.

An Excel macro is a recorded sequence of Excel commands and actions that you can play back as many times as you want. Macros can be used to automate just about any sequence of tasks in Excel, ...

For example, you probably learned long ago that pressing Ctrl+C to copy and Ctrl+V to paste is quicker than clicking on the menus to accomplish the same task. Don’t stop there. Excel’s shortcut menus ...

As with most Excel commands, the first step is to specify the range of cells that you want to analyze by highlighting them. Then, you set the criteria or condition. As is the case with conditional ...

If you run a vlookup, then you can tell the cell (f5) to look for a value in a column (let’s say, “bus”), and then return a value from another column in the same row (“blue”).

Excel Online supports these functions. About RANDBETWEEN() and CHAR() in Excel. You’re probably familiar with both of these functions already, but it might never occur to you to use them together.