MrExcel.com

Episode 1048 will show you a cool way to speed data entry using a combination of the tab and enter keys. While I have discussed this before on the podcast, using shift-tab makes the trick a bit cooler. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...

If you have to round 0.5, do you think it should round to 0 or 1? I bet that you learned in school that it should round to 1. However, this will introduce errors. Episode 1046 talks about the errors introduced by this rounding...

Isabel asks how to use Ctrl+F to find a row where three criteria are true. Rather than use Ctrl+F, Episode 1044 suggests using a Filter.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...

Dawn's file has name in A and address in B. Except: the address field in column B contains the name again. Episode 1043 shows how to parse the variable-length name out from column B.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...

Mario has built a great nested IF formula for assigning points to soccer games. However, the formula is calculating 1 point for both teams for all unplayed games...

In this dueling Excel podcast, Bill and Mike look at ways to do a frequency distribution. Episode 1040 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!

If you need to find the smallest value in a range, you would use MIN. Episode 1037 will show you how to find the second smallest value, third largest value and so on. Also in this episode, sort with a formula.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...

Tom and Thor send in better ways to force the area chart under a portion of a line chart to drop to zero. Episode 1036 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...

If your fiscal year does not end on December 31, then all of the cool date grouping functions available in pivot tables will not work for you...

Question from YouTube is how to average all the non-zero values in a range. In Episode 1030, Bill and Mike show several methods for solving the problem.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...

Yes - a podcast of use to 10,000 British Cattle Farmers but of no use to anyone else. Actually...it is a fun challenge. Play this one to see the problem then see if you can come up with a formula to extend the fine numbering system used for British Cattle...

While yesterday's podcast was created with the macro recorder, you can switch over to the VBA editor to change 4 lines of the macro. This will create a macro that will work without requiring you to rename the pivot table...

Cheryl asks how to format all new pivot tables that she creates. The macro recorder can handle this, if you change the name of the pivot table before recording the macro. Episode 1027 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...

Mario sends in an UGLY solution to episode 1016. Episode 1026 will show you how to highlight one segment of a line chart in Excel 2003. This episode wins an award for the ugliest workaround.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...

A dueling Excel podcast where Mike and Bill take a look at how to sort using a formula. While most people would use RANK and COUNTIF, Episode 1025 shows you how to use LARGE and ROW or ROWS.This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel...

Todd has lottery data in a single column and needs to break the data into various columns. Episode 1024 shows you how.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!

Add a background picture to a worksheet that is printable and semi-transparent. Episode 1023 will show you how.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!

Episode 1021 required that the survey data be set up vertically. Most survey tools like Survey Monkey would provide the data in a table format with questions going across the columns...

Patricia asks how to replicate a frequency distribution for many questions in a survey. If your data is set up correctly, this is a snap using the Show Report Filter Pages feature in a pivot table...

Dave wants to know how to choose a random name, but he does not want the complete list of names in the cells in the worksheet! Episode 1020 shows you how.This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel...

You can solve the MWF problem from episode 1018 using an incredible array formula from the book Excel Gurus Gone Wild. Episode 1019 takes a look at how to coerce an array of dates from a start date and end date cell.This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel...

Figure out the number of billable days between two dates. Episode 1018 looks at ways to count the number of days, number of workdays, or number of Monday-Wednesday-Friday dates between two dates.This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel...

Shawn sends in today's question. The spreadsheet has billing data to audit. For each record, there is a location, a start date, and an end date. Shawn wants to find any records where the same date and location is double-billed. A quick two-loop macro solves this problem...

How to highlight part of a line chart using a second area chart series. This trick works in Excel 2007, but not 2003. Episode 1016 shows you how.This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel...