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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
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
PowerPivot 2010 offers the opportunity to create up to 4 Charts from your data . . . but what if you need to move beyond that to 5 or more Charts? In Episode #1306, Bill shows us how to move into the "More Than Four" dimension.
"Go Zips!" The University of Akron mens soccer team wins a National Championship- the First University of Akron sports team to win a National Championship! In Episode #1305, Bill uses the new Excel 2010 Sparkline tool to analyze this season and last.
