Jim from California is trying to organize his kid's home chores list. He was trying to mark the current weekday's chores with conditional formatting and a cell that contained =NOW(). In Episode #1269, Bill shows us a method to solve this problem.
-
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.
Excel 2007 introduced 'Page Layout View' and it has carried over to Excel 2010 - haven't seen it yet? In Episode #1268, Bill demonstrates the attributes of Page Layout View in Excel 2010. ..."Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
The MrExcel Podcast returns with a demo of how to mash up two data sets in PowerPivot. Episode #1178 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
In this week's dueling Excel podcast (Episode #1267), Mike and Bill take a look at formulas to perform a lookup that requires two key values to be found and displayed. Visit MrExcel.com - Your One Stop for Excel Tips and Solutions.
Ray asks how to use Conditional Formatting to compare two worksheets. This feature is "new" in Excel 2010 - compare two sheets using Conditional Formatting. Today, in Episode #1266, Bill shows you how to work with this new feature. Learn Excel!
With Episode #1265, Bill takes us on a tour of the Excel 2010 File Menu. In this review of the Backstage View, Bill touches on a few pros and cons of the Excel 2010 File menu. ...Get the upgrade guide: "Rev Up to Excel 2010" by Bill Jelen
Today, in Episode #1264, Bill shows us how to add Subtotals to an Excel Data Set and then copy only the Subtotal rows.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Ron asks how to count how many times each model occurs in a column. Today, in Episode #1263, use a Pivot Table to quickly solve the problem and display results.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
Rick from Alabama sends in today's question: "How can I join two date cells into a single cell?" While Excel initially won't cooperate, Episode #1262 shows the function that you can use to answer this question.
Learn Excel 97-2007 from MrExcel!
