Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

https://youtube.com/watch?v=kNaxTNSAtLkDirect links to file: START FILE: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/E%20W%20T%20M%20Accounting%20Excel%20Seminar-StartFileSoYouCanFollowAlong.xlsx FINISHED FILE: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/E%20W%20T%20M%20Accounting%20Excel%20SeminarAllFinishedExamplesAfterVideoDone.xlsm Keyboards 0:01:47 Jump: Ctrl + Arrow 0:02:20 Go To Cell A1: Ctrl + Home 0:02:36 Format Cells dialog box or…

Continue Reading

Top 14 Excel 2019 Tips & Shortcuts

https://youtube.com/watch?v=rdQr8NLu6CQTake my $100 live webinar/course on September 20th: Advanced Excel Tricks for Accounting: https://hectorgarcia.teachable.com/p/dataimport/?product_id=1296697&coupon_code=SEPT20 Part 1- Table of Contents: 00:01:07 Select Data Range & Filter 00:02:31Autosum & Subtotal() 00:05:17 Relative…

Continue Reading
Close Menu