MrExcel Excel Videos

Another question from Gopal. New India Pay Commission guidelines suggests that pay should be rounded to increments of 10. If the amount over the last 10 is less than or equal to 0.99, then round down. Otherwise round up. While Excel’s built-in functions don’t handle this, Episode 1042 shows you how to handle this using three functions in Excel. This is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new video every workday to learn one of 377 tips from the book!

Bill from Addison TX sent in a great tip to allow you to open Excel with Ctrl Alt X, Notepad with Ctrl Alt N. Nominally, this makes the technique in Episode 578 faster, but in reality it will make everything you do in Windows much faster. Episode 589 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

When you use the New command, you have access to hundreds of free sample spreadsheets from Office Online. In Episode 588, we take a look at this feature in both Excel 2003 and Excel 2007. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Back in Episode 578, I used an incredibly complex method using NotePad for joining cells together. Today, Jonathan from the UK points out that a few lines of VBA code would have made the solution incredibly simple. Episode 587 shows you how. Function ConcatenateRange(rCells As Range) Dim vTemp As Variant Application.Volatile For Each vTemp In rCells ConcatenateRange = ConcatenateRange & vTemp & " " Next vTemp End Function This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Here is another solution to Episode 585: Instead of trying to limit how much data the person can type into a field, you can use the Shrink to Fit setting to reduce the font size to allow all of your information to appear. Episode 586 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Ron from Dallas asks how he can limit the number of characters that will fit in a certain cell. Episode 585 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Store your validation lists on a separate worksheet and have the dropdown boxes automatically expand when you add new items to the list. Episode 584 shows you how. If you'd like to try this out, download the sample workbook. Monday in the USA is our Labor Day holiday and I'll be back Tuesday, September 4th. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Brent asks how you can set up validation lists on another worksheet. This is generally considered invalid, but Episode 583 shows you how to pull it off. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Brent asks if it is possible to make the data validation dropdown arrow appear on the left side of the cell. In Episode 582, I show you a horrible way to accomplish this, that will be entirely unacceptable to 99.9% of the audience. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!