Sort by More Than Three Columns
Excel's Sort feature is limited in that it enables you to nominate no more than three data fields by which to sort. Read more...
MS-Excel Tutorials
Subcategoreis
Excel 2003 Functions and Formula General Formatting Getting Started
Create 3-D Effects in Tables or Cells
Whenever you see a nifty 3-D effect in a program or application such as Excel, you are actually seeing an illusion created by specific formatting. Read more...
Highlight Every Other Row or Column
You've surely seen Excel spreadsheets that have alternating row colors. For instance, odd-numbered rows might be white, while even-numbered rows might be gray. Conditional formatting makes this easy. Read more...
Use Replace to Remove Unwanted Characters
Using this tutorial, you can spare yourself the trouble of removing them by hand. Read more...
Validation Lists Change Based Selection Another List
Validation needs can vary depending on the context in which the validation is used. However, you can create a spreadsheet in which one validation list changes depending on what you select in another. Read more...
Support Multiple Lists in a ComboBox
When working with multiple lists, you can force a list to change by using a combination of option buttons plus a ComboBox. Read more...
Turn Conditional Formatting and Data Validation On and Off with a Checkbox
Data validation can make it far less likely that a user will accidentally enter incorrect data. Sometimes, you might need to make it easier to enter data that otherwise would be flagged as incorrect. Read more...
Count or Sum Cells That Meet Conditional Formatting Criteria
Once you can see the results of conditional formatting, you might want to create formulas that reference only the data that was conditionally formatted. Read more...
Identify Formulas with Conditional Formatting
Once a formula is entered into a cell, you can tell whether the cell is a static value or a value derived from a formula only by clicking in each cell and looking in the Formula bar, or by pressing Ctrl-~ (tilde). This tutorial fills that gap with a custo Read more...
Formulas that Reference Other Workbooks
Excel formulas get pretty complicated when a mega-formula references another workbook. Read more...
Construct Mega-Formulas
Mega-formulas-a formula within a formula, within a formula-are enough to send even the most seasoned Excel veteran running for the hills. Read more...
Determine the Number of Specified Days in Any Month
When you're creating calendar-related applications, especially payrollapplications, you sometimes need to know how many times a given day of the week appears in a particular month. Read more...
Show Total Time As Days, Hours, and Minutes
When you add hours in Excel, you can have the result return as total hours and minutes, but unfortunately, not as days, hours, and minutes. Displaying that will take some extra work. Read more...
Use the VLOOKUP Function Across Multiple Tables
Although VLOOKUP itself is very handy, it is restricted to looking in a specified table to return a result, which sometimes is not enough. You can escape this limitation with the INDIRECT function. Read more...
Return the Weekday of a Date
This tutorial shows how to extract the weekday of any date by using the WEEKDAY function. Read more...
