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.
-
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: 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!
Today's Learn Excel Podcast features a First for MrExcel! A Three-Level Side-to-Side Sort in Excel..."This is the first time that I've ever tried this, and it works!"
...This is the podcast companion to the book, Learn Excel 97-2007 from MrExcel.
The Question: "Can you extract a person's initials from their name?" Today, in Episode #1344, Mike 'ExcelIsFun' Girvin and Bill 'MrExcel' Jelen offer two (2) methods [one using a formula and another using a VBA function] to solve this problem and answer the question.
Today, with Episode #1343, Bill continues to show us how to Compare our worksheets - side by side - using a more involved technique. With a few minor modifications and the use of a VLOOKUP, comparing data becomes a bit more permanent and efficient.
James asks if it is possible to compare two worksheets from the same workbook side by side. Today, in Episode #1342, Bill shows us a low-tech way to do this comparison. Tune in to The Learn Excel from MrExcel Podcast for Part 2, airing tomorrow.
