In Today's Dueling Podcast Mike 'ExcelIsFun' Girvin and Bill 'MrExcel' Jelen look at Counting The Number of Days Between Two Dates - not including Saturdays. The Duel becomes a Team Effort today as Mike and Bill work with a variety of Functions.
-
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.
The Question Ed asks is: "How can I add new months to an existing XY Chart?" Today, in Episode #1353, Bill shows us the answer.
...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
In today's "Learn Excel from MrExcel Podcast" David needs a formula that will set up live formulas that turn Data sideways. Episode #1352 provides the solution as Bill shows us a more efficient method for achieving the desired results. Learn Excel!
Ricardo has a Spreadsheet where active projects include live Formulas. Once a project is complete, he converts the Formulas to Values. He wants a way to mark all of the Cells which are still live Formulas by changing the color of the Cell's Data. Today, in Episode #1351, Bill shows us how to use a UDF [User Defined Function] to accomplish the task - using one (1) line of VBA [Visual Basic for Applications] to keep the process dynamic and reflect future changes in the Data Set.
...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!
For all of your Microsoft Excel needs visit MrExcel.com -- Your One Stop for...
Today, in Episode #1350, Bill examines an Excel VBA [Visual Basic for Applications] loop is supposed to step by 1% increments (0.01) - but it isn't working. Bill shows us the solution to get the result intended. Learn Excel 97-2007 from MrExcel.
The Question: James asks how to add a decimal before all of the numbers in a range; i.e. how to convert 42 to 0.42
Today, in Episode #1348, Bill shows us how to get the proper value.
...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!
For all of your Microsoft Excel needs visit MrExcel.com -- Your One Stop for Excel Tips and Solutions.
In Today's Dueling Podcast Mike 'ExcelIsFun' Girvin and Bill 'MrExcel' Jelen look at counting all of the records that fall in a certain year and month. Episode #1349 offers two formula methods to get the answers.
Linda asks how to fix some Pivot Table formatting. She would like to get rid of "Sum of" and "Count of" as well as format all of the numeric fields with currency instead of general. In Episode #1347, Bill shows several ways to get the results.
Today's Question, from Joe: "How can I arrange many Pivot Charts on a worksheet - without the underlying Pivot Tables getting in the way of my Charts?" Bill answers this by setting up a Dashboard Sheet within Episode #1346. Learn Excel from MrExcel!
