Todays Dueling Excel Podcast, Episode #1286, addresses a teacher's question of how to calculate the % score for a student, ignoring any assignments where the student had an excused absence. SUMPRODUCT, ISNUMBER and More in today's episode!
-
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.
Chapter 7 of "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" is all about the 'Page Layout View' introduced in Excel 2007. Today, in Episode #1285, Bill is going to focus on Excel 2010's ability to remember the 'Last Custom Margins' used.
In Episode #1284, Bill looks at Charting Dated Data and how to get a more realistic distance between dates. Included in Podcast Episode #1284: Using =DATEVALUE(). "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen
In today's Dueling Excel Podcast [Episode #1283] Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen look at a data set and then attempt to find all of the records that contain the word "Car". Using Excel VBA [Macro] and Formula methods, Mike and Bill produce the desired results - see how they do it in Episode #1283!
Episode #1282 takes a look at the new Paste Options menu in Excel 2010. Specifically, Bill reviews a variety of time methods to convert Excel Formulas to Values in Excel 2010. "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" by Bill Jelen
"Easy-XL", produces a fine Microsoft Excel Add-in with many, inherent, time saving features. Today, Bill looks at merging data from 2 different worksheets using "Easy-XL" and just a few mouse clicks! No VLOOKUP and no time consuming process!
Episode #1280, Bill takes a look at setting up a Pivot Table and then Calculating the 'Percent of a Parent Row' -a new feature in Excel 2010. This podcast inspired by Chapter 3 or "Pivot Table Data Crunching: Microsoft Excel 2010" by Bill Jelen
Greg is trying to get rid of a Macro Button left behind by a former co-worker. Since there are two kinds of buttons [Form Control and ActiveX buttons] this can be harder than it seems. Episode #1279 shows you all the possibilities.
In Chapter 5 of 'Rev Up To Excel 2010', Bill discusses and reviews The Big Grid in Excel 2010 and why you may not see the big grid when you open one of your favorite workbooks, in Episode #1277. "Rev Up to Excel 2010: Upgraders Guide to Excel 2010"
