MrExcel Excel Videos

Using Google Search autocomplete, today's question... Is Excel Infinite? Does excel go on forever? What's the last row in Excel? What's the last column in Excel?

October 17 is Spreadsheet Day - marking the anniversary of the release of VisiCalc on October 17, 1979. In this short video, an actor does an amazing job of playing Sheriff Buford T. Justice, the role made famous by Jackie Gleason in the Smokey and the Bandit movies. Have a happy spreadsheet day!

October 17 is spreadsheet day. For all of you who can pivot data as quickly as Nate "Big Easy" Lofton can spin a ball on his finger, Happy Spreadsheet Day! #Globetrotters #HarlemGlobetrotters #HappySpreadsheetDay

October 17 is SPREADSHEET DAY! This marks the anniversary of the October 17, 1989 release of the first spreadsheet - VisiCalc. For any #StarTrek fans out there, we have a cool spreadsheet day message from Lt. Commander Shelby. I should have asked if #Excel was still the dominant spreadsheet in the future.

How to sum the top 5 values in excel? How to sum top 5 in excel? The question is how to sum the top 5 in Excel, but I create something here that can the top N values.

Carl Pepperseed, on assignment in the Burmese Jungle, reports that his =IMAGE() function in Excel suddenly started returning a #CONNECT! error. While we all feel bad for Carl, maybe that means that IMAGE is now Dynamic? If we could just figure out what Carl did to bring that #CONNECT! error! How about F9? No. How about Ctrl+Alt+F9? No. How about F2 / Enter? No. Replace the URL and then Undo? The image is still there. Copy the sheet within the workbook? No. How about Copy the Sheet to a new Workbook? That seems to be it. Which is bad news for the people hoping for Dynamic IMAGE function.

Shoutin' Sam has an Excel question. This video shows many ways to answer different questions. =FILTER() in Excel =XLOOKUP in Excel =TEXTJOIN in Excel =INDEX(FILTER()) in Excel

Microsoft Excel started showing an outline around the formula bar, when you are editing a formula in the formula bar. Why is there a thick dark box around the formula bar in Excel? Or, have you never noticed it? It is part of the F6 Loop.

Microsoft fill cells with numbers 1 to 100,000. YouTube viewer asks: How to generate numbers 1 to 100000? There are many ways to do this in Excel. I will show you two methods in this short video.