Practical Excel for Accounting: Pivot Tables, Drop-down Lists, and VLOOKUP

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 hector@garciacpa.com

To setup a 30-day free trial of QuickBooks Online and then a 50% http://www.quickbooksoffer.com/?cid=irp-4337#pricing

Видео Practical Excel for Accounting: Pivot Tables, Drop-down Lists, and VLOOKUP канала Hector Garcia CPA