Paul from Las Vegas offers a great workaround to underlining your headings! Some managers resort to adding tiny little columns between their columns to avoid this problem. Using the trick in Episode #1259, create better looking headings in Excel.
-
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.
Creating a frequency distribution is one of the hardest things to do in Excel, because the function returns an array of values. Episode #1258 will help you group your data into 'Bins' and create a 'Bins Array' using the Frequency Function - Excel 2010
Diane from Alabama asks how to make a copy of a pivot table report for every region in a database. Episode #1257 shows you how, as well as a few other pivot table tricks such as rolling daily dates up to years and showing the top 5 customers.
In today's Dueling Excel Podcast [Episode #1256], Mike and Bill work on a formula that adds up all of the non #N/A values in a range. Traditional Excel meets Excel 2010 - and a few new menu items!
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
AND
"Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen.
For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.
One of the great things to return to Excel 2010 is the ability to customize the ribbon - without knowing XML and without being a programmer! Customize the Ribbon in Excel 2010 to make the interface more efficient for your needs. Episode #1255 and Chapter 2 of "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" by Bill Jelen show you how.
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.
As a follow-up to Episode #1252, "Once you've used the HLOOKUP to return the last value in the row, can you find the date associated with that entry?" Yes, you can! Today, in Episode #1254, Bill shows us how to locate the last value in a row of data and return that value to our designated cell using the INDEX and MATCH Functions.
...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!
A 3-D Reference (also known as a 'Spearing Formula') is when you need to shoot through a series of worksheets to add up the same cell on many worksheets. Episode #1253 shows you how to create these references in just a few clicks!
...This episode is the video podcast companion to the book, "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.
A question from my seminar at the NAESA conference in New Orleans (September 2010): "How can I return the last value entered in a particular row?" Episode #1252 will show you how. "Learn Excel 97 - 2007 from MrExcel"
Podcast #1251 introduces my newest book, "Rev Up to Excel 2010 - Upgraders Guide to Excel 2010". In Chapter 1, Today I take a look at how to get the elusive mini toolbar to appear.
"Rev Up To Excel 2010: Upgraders Guide to Excel 2010" Bill Jelen
