Search TeachExcel

New Excel Help Service!

We need your input to help create a new Live Online Excel Help service.

Please take our survey and let us know your thoughts!

Excel Survey

Have a great day!

Don


Featured Excel Content


Excel Tip
This free excel macro allows you to open any program on your computer from excel. You can open a media player, file viewer, image editor, internet browser, PowerPoint, Word, Outlook, or any other program on your computer. This is a really useful macro to, in essence, combine excel's functionality with that of another program. The vba code below ca ...
 
Excel Tip
This Excel macro filters data in Excel in order to display the top 10 items from the data set. The macro uses the autofilter feature and xltop10items operator in Excel. The top 10 items from a list applies to number formatting in Excel and means the top ten highest values or numbers within the list. This is a good way to narrow down results in Exc ...
 
Excel Tip
This macro will send the current workbook in an email through Microsoft Outlook. The Macro allows you to send the most recently saved version of the excel file you are working in as an attachment. You must use the email client Outlook and you will need to have an internet connection. The specifics of the email are all contained within the macro. T ...
 
Excel Tip
This free Excel UDF (user defined function) returns the first word from a cell in Excel. This extracts the first word from a sentence or just a string of words or characters. This is a really easy to use function and very helpful when working with text manipulation in Excel. There are two arguments, text and separator. The separator argument is op ...
 
Excel Tip
This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can filter the data based on values in column A and then Column B etc. You can also have separate criteria for every column. This allows you to be able to narrow your data sets down to just exactly what you need to view; this is similar t ...
 
Excel Tip
Add background images and photos to your comments in Excel with this macro. This macro uses a really cool feature in Excel that allows you to set a photo or image from your computer as the background image for a comment. This allows you to spruce up your comments to make them less boring or simply in line with the them of your workbook or workshee ...
 
Excel Tip
Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data into an Excel bar chart. This is a great macro because it is so simply and therefore easy to integrate into any existing projects of macros for Excel. This macro has a hard-coded (static) range as the reference for the source data ...
 
Excel Tip
Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a great little macro that allows you to automatically add a drop down menu to any cell within a worksheet in Excel. This is part of the data validation features in Excel and this macro, since it is self-contained, is very easy to add to any other macro you may be u ...
 
Excel Tip
This macro allows you to send an email to a list of recipients through excel. The email will be sent through Outlook and the list of recipients is in excel. The message or body of the email is a word document located anywhere on your computer. The entire macro is run through excel and the email addresses used are listed in excel. When you run the ...
 
Excel Tip
Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from a selection of data on the worksheet. As this macro is currently set, the range from which the line chart will be created is a static range that is hard-coded into the macro. This is a bare-bones version of this macro and is in th ...
 
Excel Forum