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.

...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.

Tweet

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.

Tweet

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. Learn to use EOMONTH(~), LOOKUP(~), SUMPRODUCT(~) Double Negatives and more plus a few shortcuts!

Dueling Excel Podcast #68…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available as an eBook / Print Edition due soon!!]

AND

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

Dealing with Pivot Tables can be frustrating. Today, Linda asks how to fix some Pivot Table formatting. Linda would like to get rid of "Sum of" and "Count of"; she also wants to format all of the numeric fields with currency instead of general formatting. In today's  Episode [#1347], Bill shows several ways to achieve the desired results.

...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.

Tweet

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 question by setting up a Dashboard Sheet with multiple, scaleable Pivot Charts. Follow along with Episode #1346 and Learn Excel from MrExcel!

...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.

Tweet

Today's Learn Excel from MrExcel Podcast, Episode #1345, features a 'First' for Bill "MrExcel" Jelen!

A Three-Level Side-to-Side Sort in Excel. Bill says: "This is the first time that I've ever tried this, and it works!"

...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.

Tweet

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.

Dueling Excel Podcast #67…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available as an eBook / Print Edition due soon!!]

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

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 to the Data Set and the use of a VLOOKUP, comparing our data becomes a bit more permanent and efficient.

...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.

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. Stay tuned to The Learn Excel from MrExcel Podcast Series for Part 2 of "Comparing Side by Side" airing tomorrow.

...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.

Tweet

Today, in Episode #1341, Bill takes a look at final formatting with PowerPivot and Excel 2010. If you are going to publish your finished report to Excel Server or to SharePoint, you'll certainly want it to look good! Episode #1341 offers you several tips for creating a great result, making the report look less like Excel.

Chapter 13…This episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

Excel 2010 adds new features to Pivot Tables. Today, in Episode #1340, Bill looks at Pivot Tables in Excel 2010. While reviwing new features and dialogs in Excel 2010, learn how to fill in blanks in the row area, change a calculation to reflect the % of parent row, create Rank results from your data, and learn a bit about Slicers.

Chapter 20 … This episode is the video podcast companion to the book, “Rev Up to Excel 2010: Upgraders Guide to Excel 2010” by Bill Jelen a.k.a. “MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Considering Upgrading to Excel 2010? Want some help in making an informed decision? Check out Bill Jelen's Blog Post: "Upgrade to Excel 2007 or Excel 2010?"

Today, with Dueling Podcast #1339, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen take a look their Newly released book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun". Included in this episode are a few 'How-Tos' straight from the book! Learn a few tricks in Excel and take a look at Mike & Bill's new book!

Dueling Excel Podcast #66…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available as an eBook / Print Edition due soon!!]

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

Today's 'Learn Excel from MrExcel Podcast' looks at Future Zeros in a Data Set. If your chart shows future months as a line at zero, replace the line with blanks. With Episode #1338, Bill shows us how to use a simple formula to remove future zeros in order to produce a clean, sharp looking Chart Graphic for presenting our future Data.

From Chapter 14…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

Today, in Episode #1337, Bill talks about Time Intelligence Functions using PowerPivot and Excel 2010. Following up on Podcast #1327 [DAX Measures: Podcast #1327], Bill makes a few modifications to his file to calculate MTD Revenue for today's Learn Excel from MrExcel Podcast.

PowerPivot Chapter 11 …This episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Tweet

Bill likes 'New and Cool'. Today, in Episode #1336, Bill discusses the new color themes in Excel 2010. The new themes come with six (6) accent colors - but today, Bill shows us how to take those six theme colors and turn them into 1200 colors using Tint and Shade. Learn this simple technique and color your Excel World anew!

From Chapter 17…This episode is the video podcast companion to the book, "VBA And Macros: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet