How to use the new TEXTSPLIT() function in Microsoft Excel Your email has been sent Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a character ...

Find and Replace is a useful feature in the Office suite programs which allows replacing an existing text with a new text. However, it can also be used to find and replace the color of the text. You ...

Imagine you’re working on a massive Excel spreadsheet, trying to sift through rows upon rows of data to find specific information. You’ve tried VLOOKUP and XLOOKUP, but they just don’t cut it for what ...

Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection, such as a certain column, or for the whole document. You can also reorder ...

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data ...

One way to display figures in an Excel table according to certain time periods is by using filter buttons. However, a better way to do this is to use a timeline, a dynamic filter option that allows ...

On the Draw tab, there are various drawing tools that you can use, namely: Select tool: Select objects such as ink, shapes, and text area. They are useful when working with objects behind the text. To ...

What if you could unlock the full potential of Excel’s dynamic arrays within your tables, making your data management more efficient and powerful? Integrating dynamic arrays within Excel tables can be ...