Top 20 Microsoft Excel Tips amp Tricks

YOUR LINK HERE:

http://youtube.com/watch?v=AOPa7ORJj4Y

In this step-by-step tutorial, learn the top 20 best Microsoft Excel tips and tricks. • 👋 Resources called out in this video: • Excel sheet that I used if you want to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whKMxY... • In-depth Pivot Table tutorial: • Pivot Table Excel Tutorial • Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com • ⌚ Timestamps • 0:00 Introduction • 0:17 Convert image to table in Excel using phone • 1:29 Use Excel for free on the web • 2:08 Use Ideas to generate insights on your data • 3:19 Define names for cells • 4:42 Absolute relative cell references • 6:35 Macros • 8:35 Data types • 9:38 Xlookup function • 11:47 Sum function • 12:43 Concatenate and flash fill • 13:48 Sumif function • 14:45 Countif function • 15:35 IF function • 16:48 Calculate difference between dates convert function • 18:11 Adjust column width row height automatically • 18:56 Freeze panes • 19:33 Pivot Tables • 21:14 Drop down lists • 22:16 Import data from web • 23:54 Collaborate with others comment • 24:45 Wrap up • 📃 Watch related playlists and videos • Excel: • ❎ How to use Excel • 🚩 Connect with me on social: • LinkedIn: / kevinstratvert • Twitter: / kevstrat • Facebook: / kevin-stratvert-101912218227818 • 🔔 Subscribe to my YouTube channel • https://www.youtube.com/user/kevlers?... • 🎬 Want to watch again? Navigate back to my YouTube channel quickly • http://www.kevinstratvert.com

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

New on site