Tom Warren is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft Excel used to only allow two types of data: text and numbers.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

Small databases of a few rows, to a few thousand rows, can often be created more quickly and easily in Microsoft Excel, than by using a dedicated database system. Excel is available as a stand-alone ...

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 ...

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up ...

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...