Tag Archives: accounting
MrExcel’s Learn Excel #695 – Scale Selection
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 … Continue reading
Posted in Learn Basic Excel
Tagged accounting, business, excel, Macro, MrExcel, Scale Numbers, spreadsheets, technology, tutorial, vba
Leave a comment
Lotto Probability – 454 – Learn Excel from MrExcel Podcast
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 … Continue reading
Posted in Learn Basic Excel
Tagged accounting, Array Formula, business, excel, MrExcel, spreadsheets, technology, tutorial
2 Comments
Learn Excel – Chart Title, Legend, Colors: Podcast #1408
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 … Continue reading
Posted in Learn Basic Excel
Tagged accounting, Bill Jelen, business, charting, charts, excel, Excel2010, Learn Excel, MrExcel, spreadsheet, technology, tutorial, workbook
2 Comments
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
