Okebiz Video Search



Title:Top 20 Microsoft Excel Tips & Tricks
Duration:25:38
Viewed:82,562
Published:23-10-2020
Source:Youtube

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: 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...

🚩 Connect with me on social:
- LinkedIn: https://www.linkedin.com/in/kevinstra...
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratv...

🔔 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

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Microsoft Excel Tutorial for Beginners Microsoft Excel Tutorial for Beginners
31:13 | 67,119
☑️ Top 30 Advanced Excel Tips and Tricks ☑️ Top 30 Advanced Excel Tips and Tricks
10:56 | 480,103
Top 20 Microsoft Outlook Tips & Tricks Top 20 Microsoft Outlook Tips & Tricks
21:18 | 243,432
Top 15 Microsoft Word Tips & Tricks Top 15 Microsoft Word Tips & Tricks
20:34 | 108,262
Top 50 Microsoft Excel Shortcut Keys Top 50 Microsoft Excel Shortcut Keys
15:39 | 56,351
How to use Microsoft OneDrive How to use Microsoft OneDrive
24:27 | 369,489
Top 20 Windows 10 Tips & Tricks Top 20 Windows 10 Tips & Tricks
21:03 | 176,488
5 Excel Functions YOU NEED in 2021 5 Excel Functions YOU NEED in 2021
12:15 | 171,303


coinpayu