MrExcel Excel Videos

Pivot tables are great when the source data is formatting correctly. But today, our data set has the Quarter field stretching across the columns instead of down the rows. This creates an awkward pivot table. The old solutions (see episodes 1787 and 705) took a lot of manual effort. Today, I show how the Power Query tool for Excel 2010 and Excel 2013 make this incredibly easy.

Ugh - you import data that has Row 1 headings and title repeated every 40 rows throughout the data. We've all been there. Today, a cool macro from Jim Simons called The Sequencer to quickly add the "original sequence" numbers so you can sort, and then sort back. Also in today's episode: An ad for LiveLessons Excel VBA & Macros at http://tinyurl.com/l9z2yp4 Plus, a tip from Bob Umlas on using EVALUATE to shorten the macro from Episode 1907, and an event handler from Brian Crosby to improve episode 1907.

Rafiqul wants to enter 10 in A1 and then have the numbers 1:10 appear starting in A2, A3, and so on. This podcast offers three solutions: a formula, a macro, and then, as a bonus, a cool trick with the fill handle and the Series dialog box.

Ross has a data set in Excel. He wants to highlight the entire row if the date is more than 60 days old. Today's episode shows how easy it would be to highlight the date cell and the formula necessary to highlight the entire row using Conditional Formatting.

How to get the expense totals by month in Excel, using a pivot table with slicers or a formula.

I used to believe that every Excel macro would clear the undo stack. But, as you will see today, sometimes a macro can run and the Undo stack remains in place.

When you mark a record as Paid, can you automatically copy that record to another worksheet? Today's episode shows an event handler macro that will move records after they have been marked as Paid.

Excel for iPad 1.1 came out last week and everyone is reporting on the pivot table interactivity. Don't get excited; it is not the interactivity that you think would come with a pivot table. The truly exciting new feature here is the new Flick to Select gesture that mirrors the Ctrl+Shift+Arrow keyboard shortcut in Excel.

Dee-Dee has a column in Excel with Date-of-Birth. She wants to sort this column to assist her with sending out birthday cards. Podcast 1901 shows two formulas, one short that requires some scrolling and one insanely long that will always sort the next birthdays to the top.