Despite your best efforts, it's almost impossible to prevent all formula errors from cropping up. Possibly the worst thing about this is that the errors often tend to spread far and wide, given the web of formula interdependencies in a spreadsheet. Read more...
This tutorial acquaints you with a very versatile and, in the long run, great timesaving feature that Excel calls data validation. Read more...
With AutoFill, you can fill out a sequential series of entries (such as months of the year or days of the week) across a row or up or down a column simply by entering the first entry in the series and then dragging the cell pointer by its Fill handle. Read more...
This tutorial looks at ways you can use conditional formatting to alert yourself when certain key values change in your spreadsheet (for better or worse). Read more...
In this tutorial, you find out how to use all three of these procedures to save time in a worksheet that you access and edit on a somewhat regular basis. Read more...
This tutorial covers how to add Excel workbooks to a SharePoint Web site for review by team members. Read more...
Because cell selection is one of the most basic and regularly performed worksheet task, knowing how to efficiently select ranges of cells in the spreadsheet can go a long way toward making you a truly effective worker. Read more...
Usually when one thinks of spreadsheets, art is the last thing that comes to mind. When used with some self-restraint - graphic images can not only add interest to your otherwise mundane tables and list of numbers but also make their data read better. Read more...
AutoCorrect is Excel's attempt to save you time when doing data entry in a spreadsheet. It anticipates what you enter and, if necessary, corrects it or converts it into special types of data such as live hyperlinks and smart tags. Read more...
The subject of this tutorial is getting Web data from the Internet or some other source into your Excel worksheets. Read more...