Practical Excel for Accounting: Pivot Tables, Drop-down Lists, and VLOOKUP
Hector Garcia CPA Hector Garcia CPA
266K subscribers
156,483 views
0

 Published On Premiered Nov 17, 2020

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]

show more

Share/Embed