Take 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 & Absolute References
00:08:32 Named Ranges and Tables
00:12:22 AutoFill & FlashFill
00:15:16 Go To Special (Select Blanks)
00:17:18 Find and Replace

Part 2 (Coming Soon – End of August):
#8 Trim(), Upper(), Lower()
#9 Paste Special (Values)
#10 Remove Duplicates
#11 Text To Columns
#12 Concatenate(), Textjoin(), and Ampersand (&)
#13 Autofit Width and Height
#14 Formula Operators Order (PEMDAS)