More...
Explore Spreadsheets
How To Enter Formulas in Excel 2003- 3 Easy Ways
Lesson 61 from Power Excel 2003 with MrExcel Livelessons- Video training from technology experts Over 6 hrs of Excel 2003 training. ISBN: 978-0-7897-3824-0 http://www.informit.com/store/product.aspx?isbn=0789738244
Episode 851 - Filter By Selection II
Wiebe points out a better solution for Episode #838 - Excel already has an icon for Filter by Selection. It is hard to find and poorly labeled, but it is in there. <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast851.mp4">Episode 851</a> shows you how.&l
How To Sort By Color, Filter By Color Using Microsoft Office Excel 2007
Lesson 15 from Power Excel 2007 with MrExcel Livelessons-Video training from technology experts ISBN: 978-0-7897-3825-7 http://www.informit.com/store/product.aspx?isbn=0789738252
Quick and Easy Forms With Google Docs
Demonstrates a quick and super easy way to make web forms using GoogleDocs. Not HTML or complicated scripts required.
Episode 854 - VLOOKUP Below
Can the VLOOKUP return a value one row below the matched value? <a href="http://mrexcel.libsyn.com/media/mrexcel/podcast854.mp4">Episode 854</a> shows you how to achieve this result using two other functions.<br/><br/>This blog is the video podcast co
How To Create a 3D Graph in iWork Keynote
Why present your data in a boring spreadsheet like manner when you can represent it using a 3D graph in iWork Keynote. We'll show you how easy it is to do it!
How To Create a Chart With One Keystroke in Microsoft Office Excel 2003
Lesson 2 from Power Excel 2003 with MrExcel Livelessons- Video training from technology experts ISBN: 978-0-7897-3824-0 http://www.informit.com/store/product.aspx?isbn=0789738244
Episode 853 - Preventing #N/a
You love VLOOKUPs, but you hate the #N/A error that results. In our Where is it Wednesday edition of the MrExcel podcast, I will show you two ways to prevent #N/A as the result of your VLOOKUP formulas. One harder method in Excel 2003 and an easier method in Excel 2007. &
How To Create a Simple Macro in Microsoft Excel 2003
Learn how to create a macro in Microsoft Excel and then how to run the macro. If you would like to learn more about Microsoft Excel 2003 visit our website - www.NQTraining.com/learnexcel.asp or learn your shortcuts at - www.NQTraining.com/microsoftofficecheatsheets.asp
Episode 859 - Two Mysteries
Its two-for-the-price-of-one-Thursday (sounds like we need a new theme...). Question 1: When editing a long formula, the formula covers up adjacent cells, making it difficult to point to those cells with the mouse. Question 2: When you use Shift+Ctrl+Right+Ctrl+Down to se
