In today’s podcast, a five line macro that will allow you to scale a selected range. This macro was inspired by engineers in one of my recent VBA seminars. They had been using a similar tool for years and we were surprised it was a five line macro to replicate the tool. Episode 695 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Duration : 0:3:18
Scott from Australia sent in what should have been a simple lotto question. However, I chose to solve the problem using an array formula. Now, as far as I know, no one has ever tried to explain an array formula in a 2 minute podcast. Episode 454 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Duration : 0:3:41
The Basics of Excel Charting: Part IV
This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously we’d set up our Data Set, Created our Chart and made adjustments to our Chart Axis. Today, in Episode #1408, Bill shows us how to Change our Chart Title, set up a comprehensive Legend and adjust the colors of our charted data.
…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010″, by Bill Jelen a.k.a. MrExcel.
For more Excel 2010 knowledge, check out “Excel 2010 In Depth”, by Bill Jelen a.k.a. MrExcel.
For all of your Microsoft Excel needs visit MrExcel.com — Your One Stop for Excel Tips and Solutions.
Duration : 0:3:17
John from New Zealand offers an improvement to Thursday’s podcast about creating a Data Entry form on a spreadsheet. Today, in Episode #1504, Bill applies the tip from John to improve the VBA code for this Database Form routine!
…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Duration : 0:1:52
Excel VBA – Demonstration of Looping Workbooks Within a Folder
You can download the files at http://www.irs.gov/taxstats/article/0,,id=219931,00.html
If you need a MS Excel Freelancer, you can reach me at ExcelFreelancerJJ@Gmail.com
(Check out some of my work at https://sites.google.com/site/excelfreelancerjj/portfolio)
Excel Consulting Buyer’s Guide
http://www.dailydoseofexcel.com/excel-consulting-buyers-guide/
Duration : 0:8:6
Gary points out that the TRIM Function in VBA isn’t working like =TRIM() Function in the worksheet; the spaces in the middle remain after running the Macro. Bill shows us, In episode #1465, how to solve this issue with the ‘Application.WorksheetFunction’ to remove those spaces in the middle.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Duration : 0:2:24
MS Excel VBA – Using Application.Speech
If you need help regarding MS Excel or need an Excel freelancer, feel free to contact me at ExcelTutorJJ@gmail.com. You can download the workbook at http://www.box.net/shared/kh3n7te2zh. Feel free to add me on LinkedIn use the the e-mail address provided in the description
Make sure to change your video quality to 720P
Duration : 0:3:13
Uma wants to create many worksheets in a new workbook that are named after values in range B2:B20. Episode 1072 shows a VBA macro that makes all of this possible.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Duration : 0:3:22
Mike is looking for a faster way to Find. He wants to enter his search term in a Named Cell and have a Macro that will search for that term. Today, in Episode #1382, Bill shows us how to Record a Macro and edit that Macro to do the job we need done.
Today’s Dueling Podcast asks: “Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?” In Episode #1379, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen look at using Table Nomenclature in Validation and in VLOOKUP.