MrExcel Excel Videos

Brand new in Excel for Office 365 (currently in Insiders Fast channel only)... a LET function. Any time that you have a formula that repeats the same calculation over and over again, the LET function will let you assign that intermediate result to variables!

You are collaborating in a workbook and a co-worker filters or sorts their data and it changes your view as well. Microsoft has introduced Sheet View to Excel Online. This allows a person using Excel online to Filter to just their data without screwing up your view of the data. To read more: Sheet Views in Excel

Links to the 16 articles: Bill's "How Would You Clean This Data" Challenge Back in episode 2316, I had a clunky solution to a data shaping problem from Beth. I knew there had to be a better way and I asked you for your solutions. I learned so much from the 27 solutions and many comments. Thanks to Peter Bartholomew, brandon brimberry, Jonathan Cooper, Bohdan Duda, Geert Demulle, Fowmy, ExcelisFun, Roger Govier, Wyn Hopkins, Josh Johnson, Michael Karpfen, Hussein Korish, Kevin Lehrbass, John MacDougall, Ondřej Malinský, Rene Martin, Chris McNeil, Jason M, Christian Neuberger, Ken Puls, Jamie Rogers, Prashanth Sambaraju, Oz Du Soleil, Rico S, Bill Szysx, Frank Tonsen, Charles Williams, MF Wong, and Matthew Wykle.

For 16 years, people asked me if Excel VBA will be around forever. I always said, "Don't worry - they can't kill it until there is a viable replacement with a macro recorder." Today, in Public Preview, Office Scripts offer a macro recorder that records TypeScript. This will be the product that eventually kills Excel VBA. Listen as deal with the stages of grief as I try to figure out if I can figure out typescript. This is a first look at the Macro Recorder and trying to understand TypeScript. Microsoft Tutorial: Sample scripts for Office Scripts in Excel on the web - Office Scripts

Creating a Frequency Distribution in Office 365 Excel is easier thanks to dynamic arrays. First: make sure you have a function called UNIQUE. You don't need UNIQUE in this method, but if you don't have UNIQUE, then you don't have spillable arrays and you need to watch this instead: Included in this video: 1. Creating a frequency distribution from random data using a bins array and the FREQUENCY spilling function. 2. An odd bug with the Histogram chart. Why you could choose Pareto first and then switch back to Histogram to avoid the bug. 3. Using NORM.INV instead of RANDARRAY or RANDBETWEEN to generate data that has a standard normal distribution.

I really love this new feature from the Excel team. Do you know those big task panes that take up space on the right side of your Excel screen? You can now collapse (most of) them into a single tab strip on the far right side. Show one pane at a time, or no panes. The only pain point is getting trapped with focus on the tab strip. If you regularly use the arrow keys to navigate, you might find your keystrokes directed to the task pane instead of the grid.

Today's tip from Kristin in Cape Canaveral: a faster way to insert worksheet rows in Excel. I will show you the method that I use, other methods I know about, and Kristin's faster method using the Quick Access Toolbar. Also in this video - the easy keyboard shortcut for the first 9 icons on the Quick Access Toolbar.

Extremely tricky problem today: How can you use UNIQUE to get all unique individual cells from A1:D12? The solutions are all pretty complex. Do you have something better? Vote for a SPLIT function at https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/33712939-add-new-split-formula Vote for changing UNIQUE at Allow UNIQUE() to operate on a rectangular range, returning all unique values Follow Brad Yundt on Quora: Brad Yundt - Quora Information on Fast Excel V4 from Charles Williams: FastExcel V4 SpeedTools Cool stuff in this video: Ingeborg Hawighorst using TEXTJOIN to turn a rectangular range into a single cell. Fairwinds splitting that cell into a row of cells Charles Williams add-in with...

Insomnia in Merritt Island. How would you solve this problem in Excel? I have a solution, but it can't possibly be the best solution. We are playing for Excel Guru patches. Download the data from https://www.mrexcel.com/download-center/2020/02/Podcast2316Data.xlsx and let me know how you would solve it.