Practical Excel for Accounting Pivot Tables Dropdown Lists and VLOOKUP

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=hX9uic6L6y4

QuickBooks 30-day free trial + 30% off for 12 months: • https://quickbooks.intuit.com/partner... • • • Check out all my Advanced Courses: • http://hectorgarcia.teachable.com • Timestamps: • 00:00 Introduction • 00:42 Create a TABLE for transactions data entry • 10:15 Create a report with a Pivot Table • 13:30 Using Vlookup for pulling account name / account number (or vice versa) • 18:10 Using Data Validation Lists to pull chart of accounts • 25:20 Pulling it all together to create a Pivot Table for a Financial Report • Check out all my Advanced Courses: • http://hectorgarcia.teachable.com • Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (rates vary from $275 to $650) for first consultation depending on length and consultant required. E-mail Hector your questions [email protected]

#############################

New on site