Excel 2010 introduces the ability to put your worksheets on the web and introduced PowerPivot. You could never get your PowerPivot worksheets on the web, but Rob Collie the HostedPowerPivot.com team have solved the issue. Win a PowerPivot t-shirt!
-
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.
Today, Denver asks how to convert a number in Excel to words such as "three thousand four hundred sixty five dollars and thirty two cents". In Episode #1431, Bill shows us a cool knowledge base article with the answer to solve this issue. This blog 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!
A write-in to Bill today to ask about methods to create a Waterfall Chart in Excel, without the aid of an Excel Add-in. In Episode #1430, Bill shows us how to accomplish the task. "The Learn Excel from MrExcel Podcast Series" Learn Excel 2010!
Today's Dueling Excel looks at what the I.T. Department is sending down. It's an ugly report, each day, and we want to collapse multiple lines - for each person - into a single line. But it is more complicated than that; we have to Concatenate First Name and Last Name, plus a Lookup to figure out which Column should be reported. Follow along with Episode #1429 as Bill 'MrExcel' Jelen employs a PowerPivot Solution and Mike 'ExcelisFun' Girvin employs a Formula to solve this week's challenge.
Today's 'Learn Excel from MrExcel' Podcast is focused on some work provided by 'Dave' from Boca Raton Fire Dept. Dave sends us this tip: "Use a Formula to create a Rolling Date Data Validation." The Date Data Validation Dropdown offers 'Now', '15 Minutes from Now', '15 Minutes Ago' and so on. Follow along in Episode #1428 to learn how its done! Thank you Dave!
Today, in Episode #1427, Bill shares an interesting way to find totals in Excel ... the Read Aloud Method! This episode is another in our series for Don't Fear the Spreadsheet. Send in your best Excel Newbie stories! Learn Excel from MrExcel!
Today we will learn how to replace Numeric Chart Labels with a Formula using the method Bill gives in Episode #1426. Also learn to vary Colors by Point AND "Making Excel Columns Wider" using Gap Width. Learn Excel 2007 through Excel 2010 from MrExcel
Today, in Episode #1425, Bill takes another look at Chart Titles, how to make them Dynamic and using the TODAY() and TEXT() Functions in order to add a date to a Dynamic Chart Title. "Learn Excel 2007 through Excel 2010 from MrExcel" - by Bill Jelen.
Today, a viewer from YouTube asks how to make sure that a price entered is less than the upper limit in a lookup table. Mike and Bill compare two different ways, one using Data Validation and one using Conditional Formatting. Learn Excel from MrExcel
