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:
Create a Workbook Splash Screen
Create a Workbook Splash Screen
Splash screens provide that extra bit of polish to an application-not to mention that they keep you entertained while the application loads. Why shouldn't a spreadsheet do the same?
Difficulty:
Connect Buttons to Macros Easily
Connect Buttons to Macros Easily
Instead of giving every button its own macro, it's sometimes more convenient to create a single macro that manages all the buttons.
Difficulty:
Excel Calendar Control to Any Excel Workbook
Excel Calendar Control to Any Excel Workbook
With this tutorial, you can add the Calendar Control to any Excel workbook.
Difficulty:
Excel Display a
Excel Display a
Have you ever had one of those macros that seem to take forever to complete? If this is a problem with your macro, you can have Excel display a "Please Wait" message to the user.
Difficulty:
Count Words in a Cell or Range of Cells
Count Words in a Cell or Range of Cells
To get a word count of any cell or range of cells, we'll use a combination of SUBSTITUTE and LEN function/formulas.
Difficulty:
Password-Protect and Unprotect All Excel Worksheets
Password-Protect and Unprotect All Excel Worksheets
Password-Protect and Unprotect All Excel Worksheets
Difficulty:
Create Custom Functions Using Names
Create Custom Functions Using Names
Although referencing data by name is convenient, it's sometimes more helpful to store a constant value or even a formula, especially if you've been creating custom functions in VBA.
Difficulty:
Fill All Blank Cells in a List
Fill All Blank Cells in a List
Many of Excel's functions are designed to be used on lists. For most of these functions to work correctly, lists should not contain any blank cells, and column headings should be formatted differently from the data in the list.
Difficulty:
Add a Custom List to the Fill Handle
Add a Custom List to the Fill Handle
Once you have created a few of your own Custom Lists, it can be hard to remember the first item in the list that must be entered in a cell. This tutorial adds the list to the Fill Handle.
Difficulty:
Address Data by Name
Address Data by Name
Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy.
Difficulty:
Provide Decreasing Data Validation Lists
Provide Decreasing Data Validation Lists
Wouldn't it be useful if you could give users a list of options to select that decreases as options are used? You can create this nifty feature with the use of Data Validation and some Excel VBA code.
Difficulty:
Prevent Blanks/Missing Fields in a Table
Prevent Blanks/Missing Fields in a Table
You can easily manipulate the Data Validation feature of Excel to ensure that you have no blank cells within your list.
Difficulty:
Enable Grouping and Outlining on a Protected Worksheet
Enable Grouping and Outlining on a Protected Worksheet
In Excel 2000, Microsoft added many new levels of worksheet protection to Excel. Unfortunately, they neglected to add one that would allow Excel users to use Grouping and Outlining on a protected worksheet.
Difficulty:
Add More Levels of Undo to Excel for Windows
Add More Levels of Undo to Excel for Windows
With the tutorial in this section, you can change the registry so that you can undo up to 100 mistakes.
Difficulty:
Cell Ticked or Unticked upon Selection
Cell Ticked or Unticked upon Selection
Sometimes it's difficult to make choices with checkboxes. Fortunately, you can simplify this process using a basic bit of code.
Difficulty:
Total Tutorials in Category: 585