How to Convert Percentages to Letter Grades With Excel VLookup

- 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 Episode 1041, I take a look at how to modify the original formula to calculate nothing until a score has been entered.

- Brett from Australia asks how to format a date to include the words Opening Balance so that he can do a VLOOKUP into a report. The format is easy, the VLOOKUP is tougher. Episode 1115 shows you how.

Excel Lessons - Ctrl+N Compatibility Mode - A question from Gary: Why does Excel 2007 open with only 65,536 rows? Wouldn't Microsoft want to show off the cool functionality available in Excel 2007 without forcing you to up convert each worksheet? Episode 953 discusses the unfortunate setting causing this problem.

Excel Lessons - Grouping Ages - Steve asks how to group records into age ranges. In Episode 949, I show how to use the range version of VLOOKUP to solve this problem.

Learn how to adjust flesh tones by setting the gray point in this Adobe Photoshop CS2 Advanced training video.

- Gopal asks how to round a number up to the next whole number. Episode 1039 takes a look at several different functions available for rounding numbers in Excel.

Excel Lessons: Dynamic Validation - I've talked about making the list for your data validation automatically grow with the list. In the past, I've used a macro or the OFFSET formula, but today Morne sends in a beautiful solution for either Excel 2003 or Excel 2007 to build a dynamic validation list. Episode 937 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!

How to Use the formula bar in Excel - In this Windows tutorial you will learn how to use the formula bar in excel.

Excel Lesson - Keyboard Shortcuts - Dave from San Francisco suggests you should use Excel without the mouse and challenges you to convert a formula to values in three keystrokes. Episode 958 shows various attempts to solve the problem without using the mouse. Keyboard Shortcuts