How to Do ADM Calculation in Excel

- 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.

Excel Lessons - Using the DATE function - Rod has a formula in column B that calculates the earliest month in a data set. He then wants formulas in C, D, E, and so on that show the first of the next month. Although you can right-click the fill handle to do this, Episode 942 will show you how to solve this using the DATE function.

- In today's dueling podcast, how to turn a range upside down. Episode #1015 shows you how.

Excel Lessons - Date Format - You get a CSV file from an International branch of your company and the dates are in M/D/Y when you use D/M/Y or vice versa. There is an easy solution. Episode 947 shows you how.

- Ubuntu Linux 8.04 tutorials, this tutorial will show you how to add Startup programs.

- Excel 2010 adds some new picture tools. Episode 1088 shows off some of the cool tricks in Excel 2010.

- 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. Episode 1017 shows you how.

- Excel 2010 finally gives you an option to fill in the blank spots in the outermost row fields.

- Mike and Bill offer five different way to solve a simple bonus calculation. Episode 1085 shows you how.