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

Open any Program from Excel
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 ...
View Excel Tip
 
Filter Data to Show the Top 10 Items from a Data Set in Excel - AutoFilter
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 ...
View Excel Tip
 
Email Current Workbook & or Other Attachments
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 ...
View Excel Tip
 
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
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 ...
View Excel Tip
 
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
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 ...
View Excel Tip
 
Add Background Photos / Images to Comments in Excel
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 ...
View Excel Tip
 
Create a Bar Chart With a Macro in Excel
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 ...
View Excel Tip
 
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
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 ...
View Excel Tip
 
Send Emails through Outlook using Email Addresses from Excel and text from Word
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 ...
View Excel Tip
 
Create a Line Chart with a Macro in Excel
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 ...
View Excel Tip
 
Excel Forum