Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Q. I use a spreadsheet that includes a list of machine parts identified by both words and numbers—for example, Part 2312. Since the cells contain both text and numbers, how can I sort them in ...

For instance, to cause Excel to highlight any cell that contains the word "profit," press "Ctrl-A" to select all cells and follow the steps described to navigate to the "Format Cells" text box.

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...