Quick Insertion and Deletion
This tutorial looks at insertion-and-deletion editing that goes beyond the mere cell level - where you're limited to just replacing or deleting a cell's particular contents. Read more...
MS-Excel - 2003 Tutorials
Spreadsheet Security
This tutorial looks at all three aspects of spreadsheet security, giving you pointers on the best ways to preserve the integrity of your spreadsheet as well as guard against its more sensitive information from falling into the wrong hands. Read more...
Quickly Finding the Workbook
This technique covers ways to quickly and easily find the workbook file you want. Read more...
Customizing Number Formats
This tutorial covers how to create custom number formats for your spreadsheets and how to assign them to Excel custom styles and toolbars for easy access. Read more...
Instant Range Formatting
Right after data entry comes formatting. When building a new spreadsheet, you don't stop to take the time to assign formats to the data entries you make (by typing dollar signs, commas, and the like). Read more...
Alignments for Data Entries
This technique looks at several of these less standard alignment options that you can apply to both text and numeric entries in the tables in your spreadsheets. Read more...
Saving Time with Excel Add-ins
Excel add-in programs provide a quick-and-easy way to extend the basic features of Excel. Most of the add-in programs created for Excel offer you some kind of specialized function or group of functions that extend Excel's computational abilities. Read more...
Excel's Error Checking to Your Needs
Anyone with any experience building Excel worksheets knows that formula errors, the bane of all spreadsheets, are inevitable. Whenever Excel cannot successfully calculate one of your formulas according to its internal rules. Read more...
Set your Spreadsheet Workspace
An Excel workspace (sometimes known as an arranged workspace) is really just a special file that keeps a record of all the workbooks open at the time you save the workspace. Read more...
Saving Your Worksheets So You Can Find Them
This technique concentrates on ways you can minimize the annoyance of not knowing where you saved a new workbook file. Read more...
