How to Build Excel Nested IF Formula

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!

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

- In our second look at Formula Recalc, a 750x improvement in formula recalc times by using some helper cells. Episode 1014 shows you how.

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.

- Daniel from Quebec sends in a wild formula to solve the Last Match problem from Episode 1073. We'll look at using Evaluate Formula to study how the LOOKUP value actually works. Episode 1083 shows you how.

Learn the importance of the formula bar in Microsoft Excel.

- Sparklines are tiny, word-sized charts that can appear in a cell. Excel 2010 makes it easy to create sparklines. In Episode 1070, Mike & Bill show you several examples in Excel 2010. 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!

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

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