Subscribe
Tutorial search

Excel Tutorials


We hope that you will enjoy our Excel tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel tutorial to our site. Thank you !

Sort by:
Manipulate Data with the Advanced Filter
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.
Difficulty:
Dynamic Ranges for Maximum Flexibility
Dynamic Ranges for Maximum Flexibility
A dynamic named range that resides within another dynamic named range can be very useful for things such as long lists of names.
Difficulty:
Random Sorting
Random Sorting
The easiest and fairest way to do this is to use Excel's RAND function in combination with its sorting capabilities.
Difficulty:
Sort by More Than Three Columns
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.
Difficulty:
Highlight Every Other Row or Column
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.
Difficulty:
Create 3-D Effects in Tables or Cells
Create 3-D Effects in Tables or Cells
It is easy to create this illusion yourself by applying formatting to a cell or range of cells.
Difficulty:
Use Replace to Remove Unwanted Characters
Use Replace to Remove Unwanted Characters
Using this tutorial, you can spare yourself the trouble of removing them by hand.
Difficulty:
Validation Lists Change Based Selection Another List
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.
Difficulty:
Support Multiple Lists in a ComboBox
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.
Difficulty:
Turn Conditional Formatting and Data Validation On and Off with a Checkbox
Turn Conditional Formatting and Data Validation On and Off with a Checkbox
Turn Conditional Formatting and Data Validation On and Off with a Checkbox
Difficulty:
Construct Mega-Formulas
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. With a little forethought and by working step by step toward the formula you need, however, you can tame those complex mega-formulas without fear.
Difficulty:
Count or Sum Cells That Meet Conditional Formatting Criteria
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.
Difficulty:
Count or Sum Cells That Have a Specified Fill Color
Count or Sum Cells That Have a Specified Fill Color
Using a bit of code, you can easily SUM or COUNT cells whose fill color was specified manually.
Difficulty:
Identify Formulas with Conditional Formatting
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
Difficulty:
Speed Up Code While Halting Screen
Speed Up Code While Halting Screen
When you record macros from within Excel, the code it generates often produces screen flicker, which not only slows down your macro, but also makes the macro's activity look very disorganized. Fortunately, you can eliminate screen flicker while at the same time speeding up your code.
Difficulty:
Total Tutorials in Category: 585