Excel Analysis ToolPak Replacement: XLMiner is Better - Episode 2409

Microsoft Excel Tutorial: Walkthrough of a better alternative to the Analysis ToolPak in Excel Welcome to episode 2409 of the MrExcel Podcast, where we dive into the world of Excel and all its amazing features. In today's episode, we will be discussing an incredible replacement for the Analysis ToolPak that will blow your mind. I am Bill Jelen, and I am excited to share this discovery with you. The story of this discovery is quite interesting, with many connections and a bit of luck. It all started when someone reported a bug with our XL2BB add-in, which allows users to post Excel workbooks on the MrExcel message board. Upon further investigation, we found that the bug was caused by Application.GoTo not working in VBA. This bug was also reported by some Insiders Beta users, and we discovered that Microsoft was aware of it and working on a fix. But that's not all, as a friend of mine was going through George Mount's new book, "Advancing Into Analytics," and found that the Analysis ToolPak Descriptive Statistics tool was not working. After some testing, we realized that it was also affected by the Application.GoTo bug. This led me to reach out to Dan Fylstra, a spreadsheet legend and author of Solver, to see if the Analysis ToolPak was also using this function. And that's when we discovered the XLMiner Analysis ToolPak. XLMiner is a free, cleaner, and more efficient version of the Analysis ToolPak, created by Dan Fylstra and his team at Frontline Solvers. It offers the same 19 tools as the old ToolPak, but with a modern interface and the ability to work with Excel and Excel Online. To access it, simply go to the Insert tab, click on Get Addons, and search for XLMiner. Once installed, you can find the 19 tools on the right-hand side, just like the old ToolPak. And the best part? It actually works! So, for those of you who have been struggling with the old Analysis ToolPak, whether it's because it doesn't work in Excel Online or is affected by the Application.GoTo bug, or if you're just looking for a better version, XLMiner is the solution you've been waiting for. And while you're at it, make sure to check out George Mount's book, "Advancing Into Analytics - from Excel to Python And R," for more amazing Excel tips and tricks. If you enjoy our videos, don't forget to like, subscribe, and ring the bell for notifications. And feel free to leave any questions or comments in the YouTube comments section below. Thank you for tuning in, and we'll see you next time for another exciting episode of the MrExcel Podcast. Oh, and let me know what you think of my new green circle lighting hack. I may look like a dork, but at least you can see me clearly now! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-... #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial Are you trying to use the Analysis ToolPak dialog box? It's dialog boxes are ancient. The Analysis ToolPak won't work in Excel Online. There is a better version, for free, from Frontline Systems called XLMiner. XLMiner runs in Windows, Mac, and Excel Online! Running into a bug with Application.Goto in an add-in? Microsoft knows about the problem. At the end of the video, there is an outtake where I talk about the portable green screen that attaches to a chair. Buy this at Amazon: https://bit.ly/3RA7DP0 George Mount's book: https://amzn.to/3ygyK5z Dan Fylstra's XLMiner info: https://appsource.microsoft.com/en-us... Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ Why clicking Like below this video helps the algorithm: https://www.mrexcel.com/like-mrexcel-... This video answers these common search terms: how to add xl miner on excel how to add xl miner to excel how to add xlminer analysis toolpak excel how to add xlminer analysis toolpak excel how to add xlminer in excel how to add xlminer on excel how to do miner on excel Table of Contents (0:00) Walkthrough: XLMiner improves Analysis ToolPak (0:10) 19 old tools in Data Analysis dialog box (0:40) Bug in XL2BB add-in with Application.GoTo (1:10) George Mount Advancing into Analytics (1:31) Dan Fylstra at Frontline offers XLMiner (2:21) Installing XLMiner (2:45) Descriptive Statistics in Excel (3:37) Premium versions of Solver (4:00) Buy George Mount's book (4:14) Like, Subscribe, Ring the Bell (4:37) Portable Green Screen Background Chair Attachment Improves Lighting (4:57) Clicking Like really helps the algorithm Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...