MrExcel Excel Videos

Jeff from MA writes with todays question; creating a conditional sum array formula that uses OR functions instead of AND functions. Episode 661 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Paul from Ontario asks how to create a timesheet dropdown showing all of the weeks ending on Sunday. Episode 660 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Greg from Indiana sends in a great mystery today. He removed some borders and somehow the gridlines were removed as well. Well take a look at the pain someone must have went through, when the solution is right in the paint bucket dropdown. Episode 659 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Andy wonders why the COUNT function doesn't count text entries. Episode 955 will show you how to overcome this with COUNTA. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Dan asks another Excel 2007 question. How can you re-specify the source data for a pivot table in Excel? It used to be simple to do this in the pivot table wizard, but it is not obvious how to find the pivot table wizard in Excel 2007. In Episode 679, I will show you how to solve the problem in Excel 2007. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Dan asks how to find Page Break Preview in Excel 2007. In Episode 678, I will show you how to find Page Break Preview, but also the improved Page Layout View. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

David from Spain sends in today's question. When you have a long text cell, it will tend to spill and show up in adjacent blank cells. David notes that you can add an apostrophe to the blank cell to prevent this. In Episode 677, we take a look at a faster way to solve this problem. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Paul uses the macro recorder to record the action of naming the current region. The macro recorder never gets this correct. There is a far simpler version of code to create named ranges. Episode 676 will show you how to replace the recorded code. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Today we revisit Episode 672. Rather than using the difficult syntax from that episode, Paul from Darby suggests using a named range. Episode 675 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!