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
Posted in Learn Basic Excel
Tagged accounting, Bill Jelen, business, data entry, database, excel, Macro, MrExcel, shortcuts, spreadsheets, technology, tutorial, vba, visual basic for applications, worksheet
1 Comment
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
Posted in Learn Excel Macros
Tagged accounting, consulting, database, excel vba, finance, If function, Macro, vlookup
Leave a comment
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
Posted in Learn Excel Macros
Tagged accounting, business, Change a Recorded Macro, excel, find, Macro, MrExcel, record a macro, spreadsheets, technology, tutorial, vba
1 Comment
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
Posted in Learn Excel Formulas
Tagged accounting, business, Data Validation List, excel, MrExcel, spreadsheets, table, technology, tutorial, validation, vlookup
3 Comments
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
Posted in Learn Basic Excel
Tagged accounting, business, excel, Macro, MrExcel, Removing Spaces in a Cell, spreadsheets, technology, text, TRIM, TRIM Function, tutorial, vba, visual basic for applications
2 Comments
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
Posted in Learn Excel Macros
Tagged accounting, analysis, Basic, business, excel, finance, financial, Macro, Pivot, Quickbooks, statistic, table, tutorial, vba, Visual
Leave a comment
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
Posted in Learn Basic Excel
Tagged accounting, business, excel, MrExcel, spreadsheets, technology, tutorial, vba
1 Comment
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
Posted in Learn Basic Excel
Tagged accounting, Bill Jelen, business, dollartext, excel, formula, MrExcel, spellnumber, spreadsheets, technology, tutorial, vba, visual basic for applications
1 Comment
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
Posted in Learn Basic Excel
Tagged accounting, business, excel, MrExcel, spreadsheets, technology, tutorial, vba
Leave a comment
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
Posted in Learn Basic Excel
Tagged accounting, business, excel, MrExcel, spreadsheets, technology, tutorial, vba, Word
Leave a comment
