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
Excel macro that allows you to select multiple workbooks and have all of their worksheets automatically combined into a single workbook.  This macro will add the worksheets to a newly created workbook and not to the currently open/visible workbook. This allows you to do whatever you want with the new workbook without having to worry about the conte ...
Added: Sep 29, 2016
 
Excel Tip
How to convert a time into minutes in Excel and also how to get minutes back into a time format. For instance, change "2:30" into 150 since there are 150 minutes in 2 hours and 30 minutes; then I'll show you how to change it back from 150 to "2:30". Sections: Time to Minutes Minutes to Time Notes Time to Minutes Change a time format into minutes li ...
Added: Sep 28, 2016
 
Excel Tip
Guide to combining and consolidating data in Excel. This includes consolidating data from multiple cells, multiple worksheets, and multiple workbooks using formulas, functions, commands, and macros in Excel. Here, I will explain what you can do in Excel and point you to tutorials that help you do those things. Sections: Combine Cell Data Combine Wo ...
Added: Sep 26, 2016
 
Excel Tip
Excel formula to delete the first or last word from a cell. You can copy and paste the formulas below for a quick fix and also learn how they work, if you're interested. Sections: Remove the First Word from a Cell Remove the Last Word from a Cell More Versatile Formulas - Prevents Errors Notes Remove the First Word from a Cell =RIGHT(A1,LEN(A1)-FIN ...
Added: Sep 19, 2016
 
Excel Tip
Add two times together to get a future date and time that falls within working hours, excluding weekends and any holidays.  I'll show you how to do this using a formula. Sections: The Formula How to use the Formula Notes The Formula =WORKDAY(A2,INT(B2/8)+IF(TIME(HOUR(A2),MINUTE(A2),SECOND(A2))+TIME(MOD(B2,8),MOD(MOD(B2,8),1)*60,0)>$E$2,1,0),$G$2 ...
Added: Sep 13, 2016
 
Excel Tip
How to add a description for a UDF (User Defined Function). This allows the user to understand what the function does. Note that this description text is only visible when you open the Function Arguments window by clicking the Insert Function (fx) button. Steps to Add a Description to a UDF Go to the VBA Editor window (Alt + F11) and make sure you ...
Added: Sep 12, 2016
 
Excel Tip
This macro allows you to have a cell automatically locked after a user enters something into it or into another specific cell, range, column, or row. This is different than just locking an entire spreadsheet because you still want to be able to edit and work with the other cells in the worksheet without having to select and unlock them individually ...
Added: Sep 2, 2016
 
Excel Tip
How to calculate the percentage amount that a value has changed in Excel. This includes quickly calculating this value for an entire list. Sections: The Formula Steps in Excel Compare Each Value to the First in a List Notes The Formula The formula to calculate the change is simple: (Value2-Value1)/Value1 Steps in Excel Enter the above formula in E ...
Added: Sep 1, 2016
 
Excel Tip
How to check if a cell is empty or is not empty in Excel; this tutorial shows you a couple different ways to do this. Sections: Check if a Cell is Empty or Not - Method 1 Check if a Cell is Empty or Not - Method 2 Notes Check if a Cell is Empty or Not - Method 1 Use the ISBLANK() function. =ISBLANK(A1) This will return TRUE if the cell is empty or ...
Added: Aug 29, 2016
 
Excel Tip
How to use a single formula to apply conditional formatting to multiple cells at once in Excel. This saves you the time of changing a formula for each cell and then individually adding the conditional formatting to it. Steps Create the formula that you want to use within the worksheet so that you can make sure that it is working. Remember that a fo ...
Added: Aug 25, 2016
 
Subscribe for Free Excel tips & more!
E-mail: