MrExcel Excel Videos

Calculating workdays between two dates for a farmers market that is open 4 days a week. This dueling podcast shows how to use a new feature introduced in Excel 2010 to calculate dates for any non-standard work week.

"... Not A Custom List." Justin is back today. His pivot table filter list is still sorted in the wrong order. Yesterday, in episode 1784, I theorized it was due to a custom list, but that was not the problem. Today, another reason that the filter list could be out of sequence and how to fix it.

Justin on Twitter asked what determines the order of the drop down for a selection list in a pivot table. In Episode 1784, Bill shows a pivot table that ends up in a seemingly random sequence - three large cities at the top, followed by alpha after that. This episode is full of accidental discoveries - things that can help Justin solve the problem, but also plenty of useful tricks that can let you control the order of items in a pivot table.

Someone asked if I could create a macro that would print faster than Ctrl+P. I am guessing they are upset about the extra click required after pressing Ctrl+P starting in Excel 2010. In today's episode, how to add QuickPrint to your Quick Access Toolbar and how to record a macro to your personal macro workbook to print in one keystroke.

Bob has a two-row data set with sales from different countries arranged across the columns. He wants the country with the largest sales to appear first. Episode 1782 shows you how to sort data left-to-right.

Grab some data from the web, paste to Excel, and you get all sorts of things that you did not expect. Today, there were tiny icons, hyperlinks, columns of the wrong width. Today's episode shows Remove All Hyperlinks and a great way to get rid of the pasted icons in a single command.

How to calculate pay by month where the contractor worked part of the first and last months. Mike and Bill offer competing formulas but hope you can come up with something better.

How can you calculate work days between two dates when your business is closed on Sunday and Wednesday? WORKDAYS.INTL does not offer a Sunday and Wednesday option. Today, @ExcelWriter from Twitter checks in with a great solution to this question.

Matt asks about making VBA code created with the macro recorder more reliable. In today's long episode, a discussion about adding variables to your recorded code and then using those variables to replace the hard-coded bits in the recorded code.