MrExcel Excel Videos

How can you find the most recent record for each customer? The method I proposed in Episode 614 is not the fastest way. Richard from Jaguar Cars Ltd sends in a faster method. Episode 639 shows you how. The podcast will take off a couple of days for the U.S. Thanksgiving holiday and will resume on Monday. 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!

Joe Marten sends in todays tip; how to quickly navigate through the AutoFilter list when there are far too many entries in the list. Episode 638 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!

Ben asks todays question: Can I set up Validation Dropdowns where the list of items requires a unique entry? For example, once I choose ABC in a column, it should no longer be offered in that column. Episode 637 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!

James asks how he can combine data from all rows of all worksheets into a single worksheet. 11 Lines of VBA code will do the trick. Episode 636 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!

Todays question deals with conditional formatting. How can you have four rules? How can you have the color of column A be based on values in Column D? Episode 635 answers all. 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!

Did you know that you can change numbers in the underlying worksheet by dragging points on a chart? This might be an interesting trick to allow someone to adjust their forecast projections. Episode 634 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!

Vincent from Montreal shares a tip today to print all Excel keyboard shortcuts at once. Episode 633 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!

Back in podcast 621, I wondered why the function arguments box wont work with an array formula. It turns out that it works fine unless you switch applications while the dialog box is shown! In Episode 632, we take a look at why the function did not work, when it does work, and a cool workaround. 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!

Excel can allegedly handle 4096 characters in a cell, but in todays podcast nothing past character 1130 is displaying in the cell. In Episode 631, a convoluted solution with a textbox solves the problem, but there must be a better way. 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!