How to get the expense totals by month in Excel, using a pivot table with slicers or a formula.
-
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.
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.
A cineplex has 18 theatres that show movies. Given the schedule of when each movies begins and ends, how many movies are being shown at any given moment? Bill and Mike offer competing formulas.
Due to a strange accounting error, I had to reduce 7 invoices by 80%. I had filtered to those 7 invoices. Copied 0.2 to the clipboard. I was about to Paste Special Multiply, when I wondered if it would work correctly. Episode 1900 shows you the result.
All week, I've been testing a Responsive Web Design (RWD) for a new section of MrExcel.com called the Excel Mall. It is Friday afternoon, and I am looking for some people with a variety of phones (Android, Windows, iPhone) or tablets to give the new site a spin and let me know if the site is rendering OK on your device?
http://www.mrexcel.com/Excel_Utilities.html
You have a main table and two lookup tables. You need to use all three tables in a pivot table. Bill shows Power Pivot and Mike shows VLOOKUP in Dueling Excel episode 161
