MrExcel Excel Videos

Saying good bye to 2010 and welcoming in 2011, Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen present you with "Red Over 140". In todays Dueling Excel Podcast [Episode #1316] Mike and Bill use a variety of methods to track values that exceed a predetermined threshold. Maybe you'll also need information in cells adjacent to the exceeded value - they'll show you how to get that too!

"If you've seen one of my seminars, you know that my favorite trick is to Double Click the Fill Handle to copy a formula down the the Data Set. Excel 2010 handles blank cells in the adjacent column much better than in previous versions." - Bill Jelen

Dueling Podcast #59 deals with Sorting Summary Data - collected results of a survey. Counting the responses is easy while keeping the results in the original order. Mike and Bill show us how to accomplish the task with Episode #1313.

In Excel 2003, they were referred to as 'Lists'. In Excel 2010 they are referred to as 'Tables'. In Episode #1312, Bill takes a look at Tables and how the use of this feature allows Charts, Pivot Tables and Formulas to grow as the Data Set grows!

In Episode #1311, Bill shows us how to create a Pivot Table in Excel 2010, upload it and then [using the Excel Web Application] create a nice looking Dashboard on the web..."Pivot Table Data Crunching: Microsoft Excel 2010", by Bill Jelen

Bob writes with a question about using AutoFilters when the headings are not in row 1. With Episode #1310 Bill looks at a solution, as well as a method for totaling the visible cells... "Learn Excel 97-2007 from MrExcel" - by Bill Jelen

Create a visual representation of your values without using a Chart. In Episode #1309, Bill shows us how to use the "Pipe" Character ( | ) with the 'REPT' Function to show the variances in a data set - even when the values are very large.

Today's Dueling Podcast [ Episode #1308 ] looks at sorting data with a Formula. Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen look at the uses of the RANK, VLOOKUP, COUNTIF, LARGE, ROWS, INDEX, MATCH and SMALL Functions - plus a few shortcuts you may find useful!

Excel 2010 now contains 400 Functions. Amongst those new Functions is a new Function called 'AGGREGATE'. AGGREGATE is similar to SUBTOTAL, but with several new tricks, including the ability to ignore Error Values. "Rev Up to Excel 2010" by Bill Jelen