Your workbook started off with hidden columns...but you got it back, the columns are no longer hidden and that data has been compromised. How can you keep this from happening in the future? Follow along with Episode #1539 as Bill offers solutions to this issue.

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

From Jumping Bean on YouTube, the question: "How can I apply Conditional Formatting to Double the Diagonal Borders when the Value is a Number?" In Episode #1538, Bill offers a method to 'cross out' only Numeric Values in each cell.

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

You read correctly – 1979. In Bill’s last installment for VLOOKUP WEEK 2012, we go back to 1979…VisiCalc and the whole ’20 Functions’ available in that time! There were no IF statements and there was no VLOOKUP…but there was ‘LOOKUP’. Follow along and see where VLOOKUP began!

For more on VLOOKUP, check out "VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru” An Enhanced E-Book for iPad by Bill ‘MrExcel’ Jelen. "VLOOKUP Awesome Quick" is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots!

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

MZI1A at YouTube has a column of completed projects; she also needs to show a column of projects that are incomplete.Today in Episode #1536, Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen set out to solve the issue and show the column of incomplete projects.

Dueling Excel Podcast #103…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 in eBook / Print Edition and as a DVD Bundle]

and

“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Bill brings us another use of VLOOKUP combined with the 'Consolidate Function' in Episode #1535 of the 'Learn Excel from MrExcel' Video Podcast Series.

For more on VLOOKUP, check out "VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru” An Enhanced E-Book for iPad by Bill ‘MrExcel’ Jelen. "VLOOKUP Awesome Quick" is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots!

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

In the spirit of "VLOOKUP WEEK 2012" [march 25th - March 31st, 2012], Bill centers on VLookup again today. In theory, I sent my workbook to my manager. I have received the workbook back from my manager and now I need compare the data [the original data with the new data] to find out what was deleted, what was added and what was changed. Today, in Episode #1534, Bill 'MrExcel' Jelen shows us how to work with VLOOKUP to find the answers to our questions.

For more on VLOOKUP, check out "VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru” An Enhanced E-Book for iPad by Bill ‘MrExcel’ Jelen. "VLOOKUP Awesome Quick" is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots!

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Bill starts from the beginning; why to use a VLOOKUP, when to use a VLOOKUP and how to Use a VLOOKUP. If you are ready to unravel the mystery of VLOOKUP, follow along with Episode #1533 as Bill Starts off VLOOKUP WEEK 2012 with a comprehensive how-to.

For more on VLOOKUP, check out "VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru” An Enhanced E-Book for iPad by Bill ‘MrExcel’ Jelen. "VLOOKUP Awesome Quick" is a 134 Pages (iPad Portrait) ePub containing 5 audio clips, 8 videos and 160 full-color screenshots!

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Today, in yet another ‘Almost Live’ Dueling Excel with Mike ‘ExcelisFun’ girvin and Bill ‘MrExcel’ Jelen, Mike and Bill offer solutions to: “How can I Remove Duplicates IF the first two words -before the first two commas- are the same? Now…Bill doesn’t believe that this task can be completed with a Formula and Mike says that it can. What is your synopsis? Following along with Episode #1532 to see how to remove those dupes.

Dueling Excel Podcast #102…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 in eBook / Print Edition and as a DVD Bundle]

and

“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

MS Access MVP Crystal Long has a Random name selection workbook that was originally developed in MS Access. Today, in Episode #1531, Bill demonstrates the 'Awesome!' Random Selection workbook that Crystal has developed. Note that the very same workbook is available for download! See the Podcast for details!

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Danny wants to enter a value and have all of the like values sort to the top of the list.One way to do this is to use the Filter in Excel 2010, but there are other ways to accomplish this task - and today, in Episode #1530, Bill shows us other methods...but maybe you have an awesome method to share!? To contact Bill with your method to accomplish this task you may email MrExcel [bill "at" mrexcel.com].

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Are you familiar with Shark Week on the Discovery Channel? For the last 25 years, they have dedicated one week to shows about sharks. One of the cool things about Shark Week on the Discovery Channel is that all the shows participate. From Mythbusters to Dirty Jobs, everyone checks in with an episode related to Sharks for shark week. Well, for 2012, Microsoft Excel Beginners, Enthusiasts and Gurus alike have "VLOOKUP WEEK"! Check out The VLOOKUP WEEK Blog Here! March 25th - 31, 2012. Join us! Contribute or Learn - or both!!

VLookup Week is gaining momentum as we move into the weekend – The Microsoft Office ‘Excel Blog’ has loosed the catch: “Ride The Shark! It’s VLOOKUP Week March 25-31, 2012” and Microsoft Excel Blog will be particapting as well:

“We’re participating, too, thanks to Bill. We’ll be publishing a five-part tutorial from him, one segment for each day of the week–with videos.”

To read the entire entry at the  The Microsoft Office ‘Excel Blog’ just click the text!

Today's Learn Excel from MrExcel Podcast is Part 2 of the "Percent of Production" Podcast [Episode #1528] from yesterday. So today, in Episode #1529, Bill introduces us to Microsoft PowerPivot combined with Microsoft Excel. Watch how the process becomes more focused toward the objective of finding the percentage of production as Bill demonstrates very practical, real-world uses of the PowerPivot software

NOTE: Microsoft PowerPivot is available as a Free Download from Microsoft via: http://www.powerpivot.com/

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! And be sure to check out 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.

We are looking for the amount of scrap compared to good units - but as a percentage of production and not simply a numberical value. Using a Pivot Table in Microsoft Excel in Episode #1528, Bill produces his first solution to the query.
[Be sure to tune in for tomorrow's "Percent of Production - Part II" when Bill employs the use of Microsoft PowerPivot and Microsoft Excel to solve this challenge.]

...This episode is the video podcast companion to the book, "Pivot Table Data Crunching: Microsoft Excel 2010", by Bill Jelen and the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

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

Bill has decided that Mike is going to do all of the work today. In 'Almost Live' Episode #1527, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen work out very interesting solutions for separating numbers and text to extract values...I think...? Follow along with Mike and Bill as they produce solutions to whatever is really happening in this Episode. Enjoy!

Dueling Excel Podcast #101…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 in eBook / Print Edition and as a DVD Bundle]

and

“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Hold on to your seat… today Bill shows us how to not only view workbooks on the iPad, but also how we can make changes to those workbooks – directly on the iPad! Follow along with Bill, in Episode #1526, to see how it’s done!

Today’s Episode is brought to you by… New for 2012! “CFO EXCEL PRO“: a New, weekly e-Newsletter Publication from CFO.com featuring Bill “MrExcel” Jelen! CFO Excel Pro offers, “… clear, concise illustrated articles written by Microsoft MVP Bill “Mr. Excel” Jelen that provide readers with step-by-step solutions to nagging “real-world” Excel problems.

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!