Our Excel Courses

Latest Forum Posts

Copy data before TOTAL row from userform to sheet
Oct 2, '24 at 4:37 am
Answers: 2
Sum TOTAL for each column in last row
Sep 28, '24 at 4:47 am
Answers: 1
Automatic Dates
Sep 26, '24 at 11:36 am
Answers: 1
Tooltips on Shapes and Buttons not Displaying
Sep 26, '24 at 1:34 pm
Answers: 0
suddenly show error for code was work without problem
Sep 25, '24 at 4:44 am
Answers: 1
import web data Without ID or Class but simple text
Sep 24, '24 at 1:50 pm
Answers: 0
Exclude auto count record based on specific condition
Sep 20, '24 at 3:18 am
Answers: 2

Free Excel Training!

Help me create the best free Excel training experience on the web!

Today, I launch the Requested Tutorials feature that you can see below. Using this feature, I want to work with you to create the content that you want.

We start-off with a brand new course for UserForms in Excel. The goal is to create an expectional training guide for building UserForms in Excel so that you never have to pay to learn this material.

View the UserForms course outline in this blog post and feel free to leave your feedback there.

I need your help to create the content, and I look forward to working with you in a collaborative manner in order to create an extensive, open, and free learning experience for everyone!

Sign-in to your account today and submit a tutorial! :)

(Blog post about our future and how we want to work with you to create the best possible learning experience.)

Don


Featured Excel Content

Name Worksheets Based on Cell Contents
Excel Tip
This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means that you can set your worksheets to be named by what is in cell A1 or F455 etc. You set what cell you want the name to come from in the vba code and whatever text or numbers are pulled from there become that sheets name. This is a ...
View Excel Tip
 
Delete a VBA Module From Excel
Excel Tip
Delete a VBA macro module from Excel with this macro. This macro allows you to fully remove a macro module from Excel. This is great when you need to quickly clean up your macros, vba, or just leftover modules in Excel. You do need to be careful not to delete a module that contains important code. This is a great macro and is very powerful. To use ...
View Excel Tip
 
Highlight the Column of the Selected Cell
Excel Tip
This macro will highlight the column of the active cell. This will fill the column of the active cell with a solid background color and remove the color when a different cell is selected within the excel spreadsheet. Anytime you select a different cell, the new column will be highlighted. This is a great macro for zeroing in on a specific column d ...
View Excel Tip
 
Filter Data in Excel to Display Records that Contain a Value Between Two Values - AutoFilter.
Excel Tip
This free Excel macro filters data to display only those records or rows that contain a value between two values. For example, you could display all of the salesmen whose sales are between $50,000 and $75,000 for the quarter. You can use any number and apply it to any data set that contains number where you need to display all of the records that a ...
View Excel Tip
 
Format Cells as a Currency in Excel Number Formatting
Excel Tip
This free Excel macro allows you to quickly and easily format a selection of cells in the Currency number format in Excel. This format allows you to display a number as a currency so that readers immediately know that a number is a currency and exactly what currency it is. This macro is made to display a number in the U.S. dollar currency format bu ...
View Excel Tip
 
Capitalize the First Letter of Every Word in a Cell
Excel Tip
This macro will make the text of any selected cell in excel proper case. This means that the first letter of any word in excel will be capitalized. This macro works on any selection of cells in columns, rows, or a combination of the two. Where to install the macro:  Module Convert Text in Cells to Proper Case - First Letter of Each Word Capitalize ...
View Excel Tip
 
Open a PowerPoint Presentation from Excel
Excel Tip
This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the file extension in the macro to point to any powerpoint file on your computer and then have it open through excel. This is a cool macro which allows you to basically call on powerpoint from the excel inteface. You can attach this macro ...
View Excel Tip
 
Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
Excel Tip
This free Excel macro filters a data set to display the bottom 10 percent of the data set in Excel. This is a great macro for data analysis in Excel because it allows you to quickly and easily filter a large amount of data in Excel in order to view the most important data. This macro is really easy to use and a great way to quickly filter your data ...
View Excel Tip
 
Sort Data that Doesn't Have Headers in Ascending Order in Excel
Excel Tip
Sort data that doesn't have headers in ascending order in Excel with this macro. This is a simple sort macro that assumes that your data does not have headers. This means that the top row of the selected range will also be sorted. Sorting in ascending order means that the macro will sort the data in alphabetical order or numerically ascending order ...
View Excel Tip
 
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Excel Tip
This free Excel macro filters data in Excel based on multiple criteria for one field in the data set. This macro uses the autofilter feature and specifically filters data based on two separate criteria. This allows you to narrow down a data set based on more than one parameter and to better display specific sets of data within Excel. The two criter ...
View Excel Tip