MrExcel Excel Videos

Starting in Excel 2007, you could sort by color. In today's Episode, #1317 of the "Learn Excel from MrExcel" podcast series, Bill shows us how to sort a database where the sales reps have been identified by cell color. Chapter 15 ... This episode is the video podcast companion to the book, "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" by Bill Jelen a.k.a. "MrExcel. For all of your Microsoft Excel needs visit MrExcel.com -- Your One Stop for Excel Tips and Solutions. Considering Upgrading to Excel 2010? Want some help in making an informed decision? Check out Bill Jelen's Blog Post: "Upgrade to Excel 2007 or Excel 2010?"

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!