Excel Lesson - Index:Index

Learn Excel - How to Delete Names - Mike from OK City asks how to delete all names in a workbook. In Episode 904, I will show you a way to delete all names or to delete only the invalid names. This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel.

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

How to Enter Data - Excel 2007 - In this Excel 2007 tutorial, learn how to enter data with ease and quickly move around the Excel workspace as you enter data.

- Word 2007 tutorial: this tutorial will show you how to build an index in Word 2007.

- Michael asks why when you add up three cells with 1/3, you don't get 0.99? Episode 1116 takes a look at how to solve this.

- A dueling Excel podcast where Mike and Bill take a look at how to sort using a formula. While most people would use RANK and COUNTIF, Episode 1025 shows you how to use LARGE and ROW or ROWS.

- DRG asks how to use COUNTIF to find records that match a range. Unfortunately, it can not be done with COUNTIF. In Episode 1100, Bill and Mike compare six solutions.

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

- Mike Girven pointed me to an excellent whitepaper by Charles Williams about calculation speed. In Episode 1011, an example contrasting different ways of entering running totals. One calculates 100 times faster than the other!