MrExcel Excel Videos

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.

Why is the text in the formula bar so small? If you are on a Zoom call or doing a presentation, it is impossible for the audience to see. There is an amazing trick for making the text in the Excel formula bar HUGE. Try this out. Microsoft Excel Formula Bar Font Size

Microsoft Excel Favorite Tip. Today, October 17, 2022 is International Spreadsheet Day. Microsoft has asked a lot of creators to post their favorite Excel tips. Here is mine: Double-click the Fill Handle to copy a formula to the bottom of the data. How to copy Excel formula to the bottom of the data set by double-clicking the Fill Handle.