Consolidating Data from Different Worksheets
Excel's Consolidation feature makes short work of combining numerical data in tables stored on several different worksheets or even different workbook files. Read more...
MS-Excel Tutorials
Subcategoreis
Excel 2003 Functions and Formula General Formatting Getting Started
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...
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...
Excel's Editing Settings
This technique begins by covering how and when to change the direction in which the cell pointer moves when you press Enter and then gives you the lowdown on why you might want to disable the AutoComplete feature. Read more...
Streamlining Excel Program Startup
Quick-and-easy ways to launch the Excel program. Although the procedures outlined in this technique may seem really simple. Read more...
Refining Excel Worksheet
This tutorial describes how to move, delete, and rename worksheets, as well as protect them from being edited or altered. Read more...
MS-Excel Formulas
Excel can manipulate your data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as determining the calculation of a second-order differential equation. Read more...