Tag Archives: accounting
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
MrExcel’s Learn Excel #871 – Finding Dates
Someone tried to record a macro to find the records from a certain date. Since finding dates requires the date format to match exactly, a better way to go would be using Advanced Filter. In Episode 871, I show how … Continue reading
Posted in Learn Basic Excel
Tagged accounting, Advanced Filter, business, excel, MrExcel, spreadsheets, technology, tutorial, vba
Leave a comment
MrExcel’s Learn Excel #839 – Filter by Selection
Shawn sends in a great tip for today’s podcast. Access has a Filter by Selection icon. Using a few lines of VBA code, you can add this functionality to your personal macro workbook. Episode 839 shows you how. Here is … Continue reading
Posted in Learn Basic Excel
Tagged accounting, business, excel, Filter by Selection, MrExcel, spreadsheets, technology, tutorial, vba
Leave a comment
Learn Excel – VLOOKUP Total: Podcast #1396
The question: “Why won’t VLOOKUP add up all the matching results?” Today, Episode #1396 will show us how to use the SUMIF function instead of VLOOKUP. Included in today’s episode… “Why it is important to lock the rows in your … Continue reading
Posted in Learn Excel Formulas
Tagged accounting, business, excel, MrExcel, spreadsheets, SumIF, technology, tutorial, vlookup
Leave a comment
Excel VBA – How to bypass 30,000 limit when using Scrollbar Tool
Using Excel Active X Control to bypass 30,000 limit when insert scroll bar Currently studying for my CPA and hopefully I will be done in May, 2011. If you need assistance regarding MS Excel, feel free to contact me at … Continue reading
Posted in Learn Excel Macros
Tagged accounting, Basic, business, excel, Macro, Pivot, Public, table, vba, Visual, vlookup
Leave a comment
Excel Finance Class 11: Finance Cash Flow From Accounting Information
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to calculate Cash Flow From Assets, Cash Flow To Creditors and Cash Flow To Shareholders using accounting Financial Statements. Highline Community College Busn 233 Financial Management with Excel taught by Michael Girvin. Duration : … Continue reading
Posted in Learn Basic Excel
Tagged 2007, 2010, 233, accounting, assets, Busn, calculate, cash, College, Community, Creditors, excel, excelisfun, finance, financial, flow, From, Gel, Girvin, Highline, how, learn, Mike, Shareholders, statements, to, using
9 Comments
Excel VBA – User Defined Function to Extract Numeric Value Only
Excel VBA – User Defined Function to Extract Numeric Value Only 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 … 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
Work Sample Excel VBA – Custom Function To Sum Visible Cells Only
Work Sample Excel VBA – Custom Function To Sum Visible Cells Only Duration : 0:2:21 Technorati Tags: accounting, excel, vba
