As a small business owner, you will often have to work with others on an Excel worksheet. For example, if you have hired a sales or marketing consultant, you can give them an interactive worksheet for ...

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

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need. Clicking the "Insert Worksheet" button ...

Freeze results, hide sensitive logic, and boost performance by converting dynamic formulas into static values.

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

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