A common source of errors in Excel is "the gap"—a situation where you add new data to the bottom of a list, but your formulas ...

Over the course of business, you may find yourself with copious Excel files that you want to combine into a single workbook to make life a little easier. Excel 2010 allows you to copy or move ...

Microsoft Excel is a spreadsheet application that you can use to record data, make calculations and create charts. In this article I’ll introduce you to the basics of working in Excel. We’ll look at ...

I use custom views, the selection pane, clean UI toggles, and other tools to present my workbook professionally.

Excel files can be complicated worksheets with pages of data, calculations and cross-referenced information. With all that information, it's no wonder you might feel panicked when one of your ...

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.

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