Learn Excel from Bill Jelen with this daily 2 minute video podcast.
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.
posted by Bill at 9:00 AM
Excel 2010 introduces some new icon sets and data bars functionality. Episode 1069 will show you these features.
posted by Bill at 9:00 AM
Improvements to Excel 2010's SmartArt functionality. In Episode 1068, I show how to make your SmartArt text dynamically generate from cells in the worksheet.
posted by Bill at 9:00 AM
One of the great new features in Excel 2010 is the Slicer functionality. Slicers are a great visual way to filter your pivot table. Episode 1067 shows you how.
Labels: 2010, Pivot Table, slicers
posted by Bill at 9:00 AM
A preview of new features coming in Excel 2010: Episode 1066 shows you the Paste Options shortcuts in Excel 2010.
Labels: 2010, Paste Special
posted by Bill at 9:00 AM
How to use COUNTIF to count survey answers for a subset of rows. Bill and Mike show many methods in Episode 1065.
Labels: COUNTIF, COUNTIFS, formula, Pivot Table
posted by Bill at 9:00 AM
In yesterday's netcast, I talked about using four zones in custom number formats for positive, negative, zero, and text. In Episode 1064, you will learn how to create your own zones for formatting.
Labels: custom format, Formatting, Number Formats
posted by Bill at 9:00 AM
LearnAccessByCrystal at YouTube asked for a podcast with information about the zones in a custom number format. In Episode 1063, an explanation of the four zones in a custom number format.
Labels: Formatting, Number Formats
posted by Bill at 9:00 AM
Xiao asks how to have a picture appear when you hover over a cell. Episode 1062 shows how to solve this problem.
Labels: Pictures
posted by Bill at 9:00 AM
Julian wants to point to the row above the current row. This formula works fine until he deletes a row then those formulas change to #REF! errors. Julian asks how to point to "the row above" without specifying a row number. Episode 1061 shows you how.
posted by Bill at 9:00 AM
In today's dueling Excel podcast, how to do a VLOOKUP left. In Episode 1060 Bill and Mike show differing methods, from INDEX and MATCH to LOOKUP.
posted by Bill at 9:00 AM
Lisa from Chicago sends in today's question. Why can't you sort the page field in a pivot table? Episode 1059 talks about several ways to sort the row fields in a pivot table and then a method for sorting the filter field.
Labels: Filter, Pivot Table, Sorting
posted by Bill at 9:00 AM
Michael sends in a great tip today about pivot tables. While Excel 2007 replaced the drag and drop feature with drop zones, there is an obscure setting in Excel 2007 that will let you go back to the old drag and drop method. Episode 1058 shows you how.
Labels: Pivot Table, WIIW
posted by Bill at 9:00 AM
Carrie from yesterday's podcast called in to say that the links are not working. It turns out that Carrie and Mike wanted to copy the cell shading of the linked cell and regular links don't do that. For Episode 1057, I go back to Excel 2003 to show where the Paste Picture Link is hidden.
Labels: Formatting
posted by Bill at 9:00 AM
Carrie from NYC asks how to set up links between worksheets. Episode 1056 shows you how.
posted by Bill at 9:00 AM
Faizee from Youtube posts a question about looking for certain words in a cell in order to create a category. While this sounds simple, Bill and Mike manage to come up with a number of possible formulae in Episode 1055!
posted by Bill at 9:00 AM
Erik Spiekerman has designed a font that is ideal for use in Excel. The Axel font is designed to be narrow yet highly readable both on screen and on paper. In Episode 1054, we will take a look at the Axel font.
Labels: Font
posted by Bill at 9:00 AM
If Jerry from podcast 1052 had been using cell styles to mark his input cells, he could have used advanced options in the Find dialog to clear all of the input cells. Episode 1053 shows you how.
Labels: Formatting
posted by Bill at 9:00 AM
Jerry has a model with input cells and formula cells. He wants to copy the model for next month and clear out all the input cells. Episode 1052 will show you how to clear out the numeric input cells.
Labels: Excel 2007, Formatting, Go To Special
posted by Bill at 9:00 AM
Jeffrey wonders why the top row of his data won’t sort. He has a blank row between the data and the headers, which looks great, but is fooling the Intellisense. Episode 1051 shows you how.
posted by Bill at 9:00 AM
Today's dueling Excel podcast question is how to count all cells with times greater than five minutes. Episode 1050 shows you how.
Labels: Time
posted by Bill at 9:00 AM
You have a large formula which is generating an error. To find which reference in the formula is causing the problem, use the Evaluate Formula tool to step through the formula. Episode 1049 will show you how.
Labels: formulas
posted by Bill at 9:00 AM
Episode 1048 will show you a cool way to speed data entry using a combination of the tab and enter keys. While I have discussed this before on the podcast, using shift-tab makes the trick a bit cooler.
Labels: keyboard shortcuts
posted by Bill at 9:00 AM
