Convert English to Metric and more with the versatile CONVERT function.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Reaching way back to the archives, the DSUM function allows for some pretty amazing criteria. This video discusses how to build smaller criteria ranges for your DSUM function.
Excel 2010 adds a new function called AGGREGATE. This function is similar to SUBTOTAL but we several new tricks, including MEDIAN, LARGE, SMALL, and the ability to ignore error values
When you are recording a macro, never use the AutoSum button. This video will show you the workaround to summing a column in a macro.
Have a loop hit every other row instead of every row using the Step command.
An explanation of how defined constants such as XLRight make life easier in VBA
One of the best features in Office 2010 is the new Paste Options flyout menu. This episode takes a look at how to leverage the Paste Options menu.
As you start to use the Excel 2010 ribbon, you will notice that it has a different arrangement of icons depending on the resolution of your monitor. This can lead to some confusion as you try to help your coworkers over the phone.
If you are going to publish your PowerPivot report to Excel Server or to SharePoint, you want it to look good. This video gives you several tips for making the report look less like Excel.
