MrExcel Excel Videos

Heather has Sales Rep assignments stored next to a range of Zip Codes. For example, John is responsible for the territory that includes zip codes 41000-44699. "How can I use a VLOOKUP that pulls Data that is stored in Ranges like this?" Today, in Episode #1676, Bill shows us how to get the Zip Code and offers a few tips on Data Setup as well. "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! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

If you've tried out - or are using - Office 15, you will notice that there has been a change to Office Theme Colors and they are different than those we became accustom to seeing. Can we get back to those Theme Colors that we've been familiar with? Yes! Follow along with Episode #1675 as Bill shows us how to get those colors back for Office 15. Today's Podcast is sponsored by "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all...

FlightStats.com is a great resource for a demonstration of Microsoft GeoFlow. Yesterday's Airtran Flight 435 from CAK to MCO was a little delayed, but otherwise went fine. Using data from Flightstats.com and GeoFlow in Excel 2013, we take a look at the flight path and Altitude of the Journey. UTC Time, Time At Departure, Time At Arrival, Time, Air speed, Altitude, Latitude and Longitude. Add a 'Category' column for the Under/Over 10K Feet segments to know when you can or cannot use your computer... Now create a Table, pull the Data to PowerPivot and get into actually flight path mapping in GeoFlow for the Visualization in Graphic style. Follow along with Bill as he shows us a few tricks in this demonstration of GeoFlow's capabilities...

On one Worksheet we have Item Number, Date and Quantity; on another Worksheet - our LOOKUP Table - we have Item Descriptions. The idea is to set up a VLOOKUP to pull that Description Data to the rest of our Data on the same Worksheet. Today, in Episode #1673, Bill shows us how to quickly and easily accomplish this task in Excel. Today's Podcast is sponsored by "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of...

Mike and Bill have a question from Dandy: "Is there a Formula that would pull values over 500,000 to a New Range?" Bill addresses the solution using VBA with a few modifications and Mike takes the Formula route. Follow along with Mike and Bill to see how to get the Range in Episode #1672. Dueling Excel Podcast #110...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] Slaying Excel Dragons 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...

We know that we can 'Insert Shapes' for use in Microsoft Excel... but how can we edit our shapes to the visual that we would like to show? Today in Episode #1671, Bill shows us how to use Microsoft Power Point to Edit our shapes for use in Excel. Today's Podcast is sponsored by "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. Amazon.com: Excel 2013 In Depth (9780789748577): Jelen, Bill...

***We had a slight mix up of Podcast Versions: This is the corrected version of Podcast #1669, showing a slide as to where you may download the Sample Files for both Podcast #1668 and #1669.*** First, save your file as a Macro-Enabled Workbook - " .xlsm " - and now you need to following along with Episode #1669 as Bill shows us the VBA Macro Solution to showing Subtotals in the Footer of our Printed Page. [If you would like a Formula-based solution to this question, see Podcast #1668 - Learn Excel 2013 – “Subtotal in Footer” Podcast #1668 Part 1 - to achieve the result without the use of VBA [Visual Basic for applications]. The Sample Files for these Podcasts #1668 and #1669 may be downloaded Here from the MrExcel Website...

Creating a chart fast used to be a few steps. Excel 2013 shows no apparent way to Set a Default Chart - the button is actually hidden, but Bill shows us where it is. Follow along with Episode #1670 to learn the quick way to have a Chart in just a few clicks using Excel 2013. Where Is It Wednesday is sponsored by "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. Amazon.com: Excel 2013 In...

MRAM asks if there is a way to Total All Pages so far...at the bottom of each Printed Page. MRAM is struggling with the situation where someone Inserts or Deletes Rows and then the Subtotal needs to move to a new location. In Episode #1668 today, Bill shows us a Formula-based solution [Tomorrow, Bill will show us a VBA Macro solution]. ...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! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and...