Excel Tips & Tricks | Best Excel Tips & Tricks for Beginners (Part 2)

Опубликовано: 07 Октябрь 2024
на канале: Tech with Azam
240
10

My Talend Course on Udemy:
https://www.udemy.com/course/talend-d...

--------------------- FREE COUPONS OF MY UDEMY COURSE -------------------------------------
I am giving away 3 Discounted Coupons for my Udemy Course every Month.
If you are interested to get them, you need to drop a comment in the Comments Section and my Algorithm will randomly pickup 3 students with whom I will share the discounted Coupons via email.
Comment Should Include: "UDEMY COUPON: I AM IN"
Once I pickup your names, I will ask you to share your email address with me.
The results will be announced soon!
--------------------------------------------------------------------------------------------------------------------------------


This video discusses some of the most important tips and trick of using Microsoft Excel that everybody should know and practice in their regular excel usage. This is part 2 of my excel tips and tricks series. Link of part 1 is as under:
MS Excel Tips & Trick Part - 1:    • Excel Tips & Tricks |  Best Excel Tip...  

If you want to jump to a specific part of video, simply click the below mentioned timestamps next to desired headings. Following 10 tips and tricks have been discussed in this video:

0:00 Introduction
0:34 Office Remote
1:34 Input data Validation
3:53 Parsing delimited data
5:46 Duplicates Removal
7:05 Filtering data
7:59 Column width adjustment
9:15 Import tables from web
10:33 vlookup
11:34 hlookup
13:07 Pivot tables

Don't forget to subscribe & Enjoy the Video!
Cheers!
Azam