Excel 2007 Natural Language Formulas Tutorial

Excel Date and Time Tutorial - "Learn Excel from MrExcel Episode 902 - Decimal Hours"Calculate time difference and show the result as a decimal number of hours. Episode 902 will show you how. This video podcast is the 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!

- Manfred from Germany has an interesting problem. Each record takes up six rows in his spreadsheet. Formulas need to point to the first row of the company. Those formulas need to be copyable. But those formulas are in conditional formatting rules.

Excel Lessons - Excel to Word - In Episode 943, I took data from Word and pasted to Excel for sorting. Now, I need to "type" that data back into Word, using the proper Style for each paragraph. Episode 944 shows you an Excel macro to automate this process.

How to Use Paste Special - Excel 2007 - In this Excel 2007 tutorial, learn how to use the paste special command to get pasted data to look exactly how you want it - showing the formulas, values, formatting or anything in between.

- It became harder to exit Excel starting in Excel 2007. Episode 1089 takes a look at how to exit Excel 2010.

Using 2003 Dialogs on 2007 Excel - As you switch to Excel 2007 and try to find things on the new Ribbon, look for the tiny dialog launcher icons to take you back to the old Excel 2003 dialogs. 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!

Excel Lessons - Icon Sets 1 - Add an icon set to a range in Excel 2007. Episode 922 shows you how.

Learn How To Use Excel in this easy to follow step by step tutorial.

- Pablo sends in a cool tip for using Spearing Formulas. Episode 1099 shows you how.