This video explains the WE LOOKUP function in Excel and how it can be used to quickly find and return data from tables. It ...

If you are looking to improve your Microsoft Excel spreadsheet and data analysis skills you may be interested in this Advanced Excel Tips & Tricks tutorial from the team over at SSIT. Mastering ...

This video shows how to split delimited data stored in a single Excel cell into multiple rows using built-in Excel tools. It ...

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

Recently Microsoft has introduced a game-changing set of functions in it’s Excel spreadsheet software that harness the power of Regular Expressions (REGEX) to streamline data extraction, cleaning, and ...

Form controls like checkboxes, radio buttons, and sliders add interactivity to your Excel forms. They allow users to make ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

How to apply Insights in Excel and what to look out for when you do Your email has been sent Microsoft is gradually rolling out a new feature for Office 365 subscribers called Insights in Excel. This ...