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

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Is it possible in ...

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

To add a sheet to a workbook using VBA: Depending on the result you want to achieve, you can either use the: Copy method => For a copy of an existing sheet Add method => To add a new blank sheet to ...

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive ...

Picture this: you've created an all-singing-all-dancing Microsoft Excel workbook, but when you share it with others, they have no idea where to start. That's why you need a homepage worksheet that ...

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