MrExcel Excel Videos

Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Learn Excel 2010 - "Named Range and Implicit Intersection": Podcast #1579
Name Box Expand is a great way to actually be able to see your Ranges - as you've named them - in the Named Range Box, without trying to guess what you are looking at. But did you know that you can find that name showing in lists when using other Functions of Excel? Bill shows us an interesting discovery and the uses of that discovery in Episode #1579 - this may make your Excel tasks just that much easier and more logical to follow. Today begins a week-long Series on Named Ranges: This is Part I of IV 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...
"Don't Fear The Spreadsheet" - The Dollars and Cents of It: Podcast #1578
The earliest Spreadsheets were designed for accountants. To this day, some of Excel's annoying behavior is to make the accountants happy [but it may not be making you very happy]. How can I set up Excel so that it always shows Dollars and Cents? Excel has a "Accounting" Format, but perhaps you're not interested in the look and feel of that Format. To have your Data present the way you'd like it to, take a look at the "Currency" Formatting options today with Bill, in Episode #1578. Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked...
Learn Excel 2010 - "Cluster Stack Charts II": Podcast #1577
Update: Jon Peltier sells an add-in that replaces all of these steps: Peltier Tech Charts for Excel 3.0 Today's episode is a continuation from Episode #1091 [ Stacked & Clustered – 1091 – Learn Excel from MrExcel Podcast ] that shows how to create a chart with Two (2) Series Stacked and a Third as a Cluster. But in Episode #1577, Bill is going to show us how to stack Two (2) Series of 2, side by side. Follow along to see how it's done.
Learn Excel 2010 - "Are They Customers?": Podcast #1576
Sheri has two Spreadsheets: One Sheet contains all of the company's current customers and the other contains a generic list of all the top warehouse customers. What Sheri's employer wants is to find out how many customers on the generic warehouse list match current customers of the company. So, how do we set out to accomplish the task? Follow along as Bill shows us the way in Episode #1576. ...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...
"Don't Fear The Spreadsheet" - All Of My Numbers Are Corrupt!: Podcast #1574
Are all of your Numbers in your Spreadsheet appearing as 'Pound Signs' [Hash or Number signs]? Learn why this happens - why it happens with Numbers and not Text - and what you can do to restore the look of your Spreadsheet, as your Numbers are probably not corrupt at all. Following along with Bill in Episode #1574 to learn more about the issue and how to solve it. Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and...
Learn Excel 2010 - "Lock Formula in All Directions": Podcast #1573
[This Podcast Rendered at an Altitude of 33K Feet] A tip from Patricia today! Several ways to get those " $ " signs where you want them when working out your Forumula! Follow along with Bill in Episode #1573 to see how it's done! ...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!
Learn Excel 2010 - "Two-Way Table to Linear": Podcast #1572
Today's podcast takes a solution found in "Pivot Table Data Crunching: Microsoft Excel 2010" by Michael Alexander and Bill Jelen. Taking a table that is currently set up as a Two-Way Table, Bill uses the 'Old Pivot Table Dialogue' in Excel to set up a Pivot Table to transform the current Table to a Linear Table. Follow along with Episode #1572 to learn how to access that 'Old Dialogue' and transform the Two-Way Table. For more information on 'Pivot Table Tricks', Usage and general 'Pivot Table How-To', check out: ""Pivot Table Data Crunching: Microsoft Excel 2010" by Bill Jelen and Michael Alexander Pivot Table Data Crunching: Microsoft Excel 2010 ...This blog is the video podcast companion to the book, Learn Excel 2007 through...
Dueling Excel - "The Electoral College": Podcast #1571
Today, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen look at working with the Electoral College. Using the State by State Electoral Vote Count, Mike and Bill will sort out which States had the highest number of votes collecting the required 270 votes and which States had the lowest number of votes which added up to 270 votes. Learn a little about the Electoral College, why the numbers matter, see why simple Filters will not do the complete job, why Bill chooses to use a Pivot Table and Mike goes with Functions such as =LARGE, =INDEX, =SMALL and more. A real Information-Packed Dueling Podcast! Check out Episode #1571. Dueling Excel Podcast #109...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A...
Learn Excel 2010 - "VLOOKUP Range:" Podcast #1570
Todays question involves doing a Range Lookup using a VLOOKUP Formula. Bill shows us how to set this up based on the Data Range provided and explains why today's VLOOKUP will be ending with a 'TRUE' statement instead of the usual 'False'. See how and why its done in Episode #1570. ...This a 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!

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top