MrExcel Excel Videos

"Easy-XL", produces a fine Microsoft Excel Add-in with many, inherent, time saving features. Today, Bill looks at merging data from 2 different worksheets using "Easy-XL" and just a few mouse clicks! No VLOOKUP and no time consuming process!

Episode #1280, Bill takes a look at setting up a Pivot Table and then Calculating the 'Percent of a Parent Row' -a new feature in Excel 2010. This podcast inspired by Chapter 3 or "Pivot Table Data Crunching: Microsoft Excel 2010" by Bill Jelen

Greg is trying to get rid of a Macro Button left behind by a former co-worker. Since there are two kinds of buttons [Form Control and ActiveX buttons] this can be harder than it seems. Episode #1279 shows you all the possibilities.

In Chapter 5 of 'Rev Up To Excel 2010', Bill discusses and reviews The Big Grid in Excel 2010 and why you may not see the big grid when you open one of your favorite workbooks, in Episode #1277. "Rev Up to Excel 2010: Upgraders Guide to Excel 2010"

In this week's dueling Excel Mike and Bill take a look at ways to take an address and get just the state. Bill's Method uses a VBA and Mike takes the formula route. Visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Find yourself bored with the same old column or bar charts? Why not replace the column/bar with a shape - perhaps an Arrow? Its easy to do and in Episode #1275, Bill shows you how in Excel 2010! ...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.

Patricia asks how to mark the last record in each category. Episode #1274 shows you how to use 'old-school' Conditional Formatting formulas to solve the problem. So, what do a Database, an Absolute Column Reference and a Relative Cell Reference have in common? Find out in Episode #1274! ...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.

Today, in Episode #1273, Bill begins a series on Charts and Graphs in Excel 2010". Today: Changing the Series Order of a Chart in Excel 2010. This is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010" by Bill Jelen

Kim has designed a simple data entry spreadsheet and would like to have a way to paste the data into the next empty row of a database worksheet she has created. In Episode #1272, takes a look at how to finesse the macro recorder to solve this problem.