Manipulate Data with the Advanced Filter
If you are familiar with Excel's AutoFilter tool, you also are familiar with its limitations. If you require extensive data manipulation, using Excel's Advanced Filter tool is the way to go. Read more...
MS-Excel - General Formatting Tutorials
Random Sorting
You can use Excel to pick three winners-1st, 2nd, and 3rd-chosen at random from a list in your spreadsheet. The easiest and fairest way to do this is to use Excel's RAND function in combination with its sorting capabilities. Read more...
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...
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...
Excel Pivot Tables
PivotTables are one of Excel's most powerful attractions, though many people don't knoww hat they do. Read more...
Convert Excel Formulas and Functions to Values
Most Excel spreadsheets contain formulas. Sometimes you may want to force only the result of a formula to occupy a cell, instead of leaving the formula in place, where it will change if/when the data it references changes. Read more...
Customize Cell Comments
Although cell comments serve the simple purpose of displaying a message to either yourself or another user, you can customize the cell comment so that it better reflects your intentions. Read more...
Convert Text Numbers to Real Numbers
Remember that numbers in Excel are right-aligned by default, and that text is left-aligned by default. Read more...
Control Conditional Formatting with Checkboxes
Conditional formatting, a feature available since Excel 97, applies formats to selected cells that meet criteria based on values or formulas you specify. Read more...
Validate Data Based on a List on Another Worksheet
This tutorial provides two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call. Read more...