MrExcel Excel Videos

Wyn's book for shipment to USA: https://mrexcel.e-junkie.com/product/1750249/Power-BI-for-the-Excel-Data-Analyst-Print-Book-to-USA-Only This video covers six exciting things: 1) The Show Changes feature which had been in Excel Online is now in Desktop Excel 2) Data Validation partial matching is working again 3) There is a new look for Excel Options 4) A new IMAGE function comes to Excel to display an image 5) Wyn Hopkin's new Power BI for the Excel Analyst book... it drops on November 1, but I have 3 cases to ship now.... US only. 6) The 14 functions for text and array manipulation are coming to general availability. Table of Contents (0:00) Four new features today (0:54) Show Changes made in last 60 days (1:30) Validation List...

TKH is using the new STOCKHISTORY function in Excel. He is looking for stock prices from 7, 14, 30, and 60 days ago. When you are asking for a single day, the STOCKHISTORY function returns a #VALUE error if the market is closed on the desired day. This video shows how to use the old WORKDAY function to make sure your date never ends on a holiday or weekend.

Jeremy asks Is there a way to select multiple headings and change all of their "Summarize value field by" at once? I have hundreds of headings, each time I want to change their value by Max, Min, Average, I have to select one heading at a time, it is extremely labor intensive. Is there a way to change field calculation for multiple headings at once? This episode shows some simple VBA to do this quickly. How to create a personal macro workbook: Table of Contents (0:00) Welcome (0:41) VBA (1:55) Looping each field (2:35) Copying for Sum, Max, Min (3:10) Other calculations (3:42) Easier way to run (4:30) Running all 4 macros (5:25) Upcoming Webinar

This actually applies to any character that you want to display in Excel that is in the Unicode character set. Microsoft gave us functions for UNICODE and UNICHAR. It is not intuitive, but you have to use UNICHAR to solve this. However, the websites showing the unicode are often showing the number in Hex, so you have to use HEX2DEC before passing the value into UNICODE. Table of Contents (0:00) What is gamma and beta (0:13) Results of googling (0:32) History of CODE and CHAR (0:54) UNICODE isn't it (1:22) UNICHAR of HEX2DEC (1:51) Displaying Beta in Excel (2:21) ESPN Wrap up (2:59) Retrieve Webinar (3:30) Episode 2500 ideas?

Microsoft Excel Tutorial: Special ESPN Pricing: https://www.mrexcel.com/news/special-ocho-deals-on-training-books-to-celebrate-excel-being-on-espn/ The Excel All Star Battle will air on ESPN2 at: Friday August 5, 2022 at 5 AM Eastern. (2 AM Pacific. 10 AM in London.) Sunday August 7, 2022 at 9AM Eastern. (6 AM Pacific, Noon in London.) Monday August 8 (8/8!), 2022 at 11:30 PM Eastern. (8:30 PM Pacific - Prime Time, Baby! And 4:30 AM Tuesday in London). Bill's favorite Excel trick: Fast Formula Copy, as well as a lot of other items. Table of Contents (0:00) Historical re-enactment (0:20) Data description (1:00) Begins typing (1:38) Adding text is #VALUE error (1:57) & to Concatenate (2:10) FORMULATEXT function (2:36) Adding a space...

Reid would like to list all 6-number combinations of the numbers 1 to 44. For example, 1-2-3-4-5-6, 1-2-3-4-5-7, and so on up to 39-40-41-42-43-44. The first thing to realize is that all lottery combinations are a lot of numbers. Over 7 million possibilities according to the COMBIN function in Excel. (For Power Ball, there are 292 million combinations!). Listing all combinations will be difficult because Excel only includes 1,048,576 rows. In this video, I show how to enable Macros in your version of Excel and then the macro code to list all possible combinations. Here is the code you can copy into your project. Sub ListThemAll() TC = 1 TR = 1 Ctr = 1 MaxRows = Rows.Count EndCell = 7059052...

ExcelFormulaBot.com is a free A.I. bot that generates the Excel formula for any problem. You type a sentence. It suggests a formula. Free from David Bressler. Table of Contents (0:00) This is cool (0:36) Formula for last word (1:15) Formula for Prime Numbers (2:23) Excel All Star Battle on ESPN8 The Ocho

I love this feature so much, I turned it off! For decades, Excel has been performing default data conversions: Remove leading zeroes Keep first 15 digits of long numbers and convert to scientific notation Convert digits surrounding an E to scientific notation. New in Insiders beta, Excel will ask if you want to do all three of those things. The first time, I was happy to click Don't Convert. But I think the real solution is to embrace all three options and turn all three of them off! They have been annoying us for so long. Why would you want Microsoft to ask, "Hey, should we keep annoying you?". For me, I am turning all three of these off. Table of Contents (0:00) I love this so much, I am turning it off (1:10) Numbers longer than 15...

Episode 2493 Why is the drop-down arrow not showing up when I create the Excel validation with VBA? It appears after I click Save. But I don't want to save since these numbers are a temporary scenario and I plan on closing without saving. Also: Using the Selection Pane in Excel to see all shape names How Excel names shapes. Why Excel renames Shapes during workbook copy How to use VBA to detect which shape was selected. Table of Contents (0:00) Bug with Shapes in VBA (0:31) Excel Validation drop-down arrow missing (3:05) VBA code to delete shapes (4:07) How Excel Names Shapes (4:44) Selection Pane in Excel (5:47) First Validation arrow is named (7:01) Shapes names restart with new sheet (7:48) Shapes renamed after Sheet Copy (9:26) VBA...