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:
Hide and Restore Toolbars in Excel
Hide and Restore Toolbars in Excel
Attach a custom toolbar to your spreadsheet that doesn't get in the way of the end user's settings for other spreadsheets when yours is closed.
Difficulty:
Excel Three-Criteria Limit for Conditional Formatting
Excel Three-Criteria Limit for Conditional Formatting
You can use VBA to tutorial conditional formatting to use more than three criteria on your data. In fact, you can use the code to apply virtually an unlimited number of criteria.
Difficulty:
Retrieve a Workbook Name and Path
Retrieve a Workbook Name and Path
Every now and then you might want a cell to return the name of a workbook, or even the workbook's filename and path. With this tutorial, it's easy to retrieve a workbook's name and path.
Difficulty:
Run Procedures on Protected Worksheets
Run Procedures on Protected Worksheets
Excel macros are a great way to save time and eliminate errors. However, sooner or later you might try to run your favorite Excel macro on a worksheet that has been protected, with or without a password, resulting in a runtime error. Avoid that problem with the following tutorial.
Difficulty:
Automatically Add Date/Time to a Cell upon Entry
Automatically Add Date/Time to a Cell upon Entry
Enter a static date, or date and time, into a corresponding cell after data is entered into other cells.
Difficulty:
Distribute Macros
Distribute Macros
Although you can distribute a macro along with a workbook, if you want to distribute only the macro's functionality, an Excel add-in is the way to go.
Difficulty:
Create a List of Workbook Hyperlinks
Create a List of Workbook Hyperlinks
Use a bit of Excel VBA macro code to create a list of hyperlinked Excel workbook names on any Excel worksheet.
Difficulty:
Convert Formula References from Relative to Absolute
Convert Formula References from Relative to Absolute
Change absolute formula references to relative references, vice versa, or a mix of absolute and relative columns and rows.
Difficulty:
Find a Number Between Two Numbers
Find a Number Between Two Numbers
Enhance Excel's Find feature to search for the first occurrence of a number that falls between two specified numbers.
Difficulty:
Name a Workbook with the Text in a Cell
Name a Workbook with the Text in a Cell
When you save your workbook, use the text of a selected cell as your filename.
Difficulty:
Password-Protect a Worksheet from Viewing
Password-Protect a Worksheet from Viewing
Keep prying eyes from viewing a worksheet, unless they have the password.
Difficulty:
Sort Worksheets
Sort Worksheets
One of the most commonly used functions in Excel, sorting is usually performed on a list, table, or range of cells, but you can take things a step further and sort your worksheets as well.
Difficulty:
Excel  Tutorial: How to make a loan payment calculator using the PMT function
Excel Tutorial: How to make a loan payment calculator using the PMT function
This calculator can be used by a borrower or lender to establish a payment amount based on an initial loan amount, annual interest rate, repayment term and periods.
Difficulty:
Run a Macro at a Set Time
Run a Macro at a Set Time
Many times it would be great to run a macro at a predetermined time or at specified intervals. Fortunately, Excel provides a VBA method that makes this possible.
Difficulty:
Use CodeNames to Reference Sheets in Excel Workbooks
Use CodeNames to Reference Sheets in Excel Workbooks
Sometimes you need to create a macro that will work even if the sheet names that it references change.
Difficulty:
Total Tutorials in Category: 585