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

Q: How can I insert new worksheets in my Excel workbook without having to constantly set up headers and footers in those new worksheets? A: Excel 2003, 2007 and 2010 allow you to duplicate a worksheet ...

We can create a master sheet in a Workbook and link other sheets to it, and create links to access them instantly. This gives us a lot of convenience in managing data and multiple sheets. It makes it ...

To create a pivot table, check that all the columns and rows are titled the way they should be, and then select PivotTable on the Insert tab. Better yet, try the Recommended PivotTables option to see ...

Q. Is there a list of standard Excel design rules we should be following as we create new Excel worksheets? A. By following a common set of spreadsheet design rules, companies can produce more ...

If you're not using these worksheet-related tricks, you're working harder than you have to! Susan Harkins shares five of her favorites. We all have features and commands that we use more than others.