Tag Archives: accounting
Learn Excel 2010 — “Saving Form to Database”: Podcast #1504
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 … Continue reading
Excel VBA – Demonstration of Looping Workbooks Within a Folder
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 … Continue reading
Learn Excel – Macro to Find: Podcast #1382
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 … Continue reading
Dueling Excel – Dynamic Validation VLOOKUP: #1379
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. Duration : … Continue reading
Learn Excel 2010 – “Remove Spaces with VBA”: Podcast #1465
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 … Continue reading
MS Excel VBA – Using Application.Speech
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 … Continue reading
Create Worksheets – 1072 – Learn Excel from MrExcel
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, … Continue reading
Learn Excel 2010 – “Numbers to Words in Excel”: Podcast #1431
Today, Denver asks how to convert a number in Excel to words such as “three thousand four hundred sixty five dollars and thirty two cents”. In Episode #1431, Bill shows us a cool knowledge base article with the answer to … Continue reading
Learn Excel 2010 – “Removing Duplicates”: #1433
John is looking for some VBA to find and remove duplicate records in a database of 169,000 records. Today, in Episode #1433, Bill shows us how its done. Duration : 0:1:31 Technorati Tags: accounting, business, excel, MrExcel, spreadsheets, technology, tutorial, … Continue reading
MrExcel’s Learn Excel #944 – Excel to Word
In Episode 943, I took data from Word and pasted to Excel for sorting. Now, I need to “type” that data back into Word, using the proper Style for each paragraph. Episode 944 shows you an Excel macro to automate … Continue reading