MrExcel Excel Videos

Fariedx asks if there is a way to paste 100 single cells into 100 Merged Cells of varying sizes from 2 to 6 Merged Cells. After reviewing several possible options that just won't work, Bill then uses a Circular Reference Formula to pull the Data from the Range of Single Cells. Follow along with Episode #1558 to learn this method and to learn why the others just won't work.

Auto-SUM is pretty straight foward - it resides on the Ribbon of Excel. But what about 'Auto-Average'? Today, the student enlightens the teacher when Bill finds out that 'Auto-Average' will reside on the Ribbon as a one-click function. Follow along with Episode #1557 to find out how to add Auto-Average, Min, Max and others to the Ribbon of Excel for one-click functionality. ...This episode is the video podcast companion to the book, "Don't Fear The Spreadsheet" by Tyler Nash and Bill Jelen. The Soon To Be Released Excel Book, "Don't Fear The Spreadsheet" [Due Late May, 2012] is for beginners, by a beginner. Nothing is assumed and all of the basics are explained in "Don't Fear The Spreadsheet" "The Learn Excel from MrExcel Podcast...

The Learn Excel from MrExcel Podcast Series is currently covering 'The Most Popular Functions in Microsoft Excel'. Today Bill chose to look at #6 in the series, " =AVERAGE ". Use the "=AVERAGE" Function to get the Arithmetic Mean. Simple yet effective to use; follow along with Bill in Episode #1556 to see the =AVERAGE Function in use.

No...it's not a Learn Excel Podcast about Excel - it's about the Calculator Utility! Have you ever looked at the Toolbar selections? Did you ever wonder why Microsoft has included a 'Help' button for the Calculator? Check out Episode #1555 to learn a little bit more about Calculator from Microsoft. ...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! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Today's Duel comes from a YouTube viewer who - depending on the original configuration of digits - would like to add "0"s and " - "s based on the first digit of the Number that has been recorded. Follow along with Episode #1554 as Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen offer their means to the solution. Dueling Excel Podcast #106...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...

You asked for it and here it is: a Learn Excel from MrExcel Podcast Series covering the Most Popular Functions in Microsoft Excel. Bill will be covering the Most Popular Functions in Excel in the series starting with "=SUM". Follow along with Bill today in Episode #1553 to learn a few tips - including how you can win a free copy of "Microsoft Excel 2010 In Depth" by Bill Jelen. ...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. Microsoft Excel 2010 In Depth by Bill Jelen "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Today, Bill encourages you to upgrade your SkyDrive account with Windows Live. It's FREE to upgrade - but you need to do it now. Existing Accounts are eligable for an upgrade from 7GB to 25GB, free of charge! Check out Episode #1552 to get your 25GB SkyDrive account! ...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! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Mike has a price sheet in Excel. Column A is Product Name, Column B is Current Price and Column C is the Percentage of Increase for Column B. Bill Sets up Column D to reflect the adjusted New Price and then demonstrates how we can carry the New Prices to Column B as the New Current Price. Follow along with Bill in Episode #1551 to learn how to set this project up and how easy it is to do! ...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! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series"...

Going back to "VLOOKUP WEEK 2012" VLOOKUP WEEK Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen look at the 'LOOKUP' Function. Taking cues from an email Bill received from Dan Bricklin [co-founder/inventor of VisiCalc] Bill argues the point that "=LOOKUP" is ambiguous in Microsoft Excel when the Data Set Table is 'square'. Mike, on the other hand, thinks that "=LOOKUP" is not an ambiguous Function; that it is intuitive and dynamic. Follow along with Episode #1550 to hear the debate and decide for yourself. Dueling Excel Podcast #106...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...