Top 20 Microsoft Excel Tips & Tricks
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-whKMxYi3HuSk1aLx-PA?e=BIFDPp
- In-depth Pivot Table tutorial: https://youtu.be/m0wI61ahfLc
⌚ 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: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
Видео Top 20 Microsoft Excel Tips & Tricks канала Kevin Stratvert
👋 Resources called out in this video:
- Excel sheet that I used if you want to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whKMxYi3HuSk1aLx-PA?e=BIFDPp
- In-depth Pivot Table tutorial: https://youtu.be/m0wI61ahfLc
⌚ 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: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
Видео Top 20 Microsoft Excel Tips & Tricks канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Top 20 Microsoft Outlook Tips & Tricks☑️ Top 30 Advanced Excel Tips and TricksVLOOKUP & HLOOKUP in Excel TutorialHow to Highlight Mouse Pointer Windows 10How to make Electronic SignatureExcel shortcut keys you SHOULD know!How to easily automate boring Excel tasks with Power Query!Top 15 Microsoft Word Tips & Tricks50 Ultimate Excel Tips and Tricks for 2020How to Become a MillionaireMicrosoft Excel Tutorial for BeginnersTop 20 Microsoft Teams Tips & TricksExcel Formulas and Functions Tutorial30 Ultimate Outlook Tips and Tricks for 2020How to use Microsoft Power BI19 Advanced Excel Shortcuts (do you know them all?)How to Make a YouTube ChannelPivot Table Excel TutorialHow to use Free Windows 10 Video EditorTop 15 Microsoft PowerPoint Tips & Tricks