Top 6 Excel Questions Asked in Job Interviews part 17

[@AVTechandTravel]

1:14 VLOOKUP
1:50 VLOOKUP Definition
3:10 VLOOKUP Syntax
5:19 Limitations of VLOOKUP
6:38 Absolute and relative reference
7:00 Relative Reference
8:45 Absolute Reference
10:10 Removing Duplicates
11:30 Password protection to Documents
12:22 Giving pwd to workbook
13:00 Giving pwd to worksheet
13:41 Locking cells
15:07 How to create Charts
16:22 Pivot table definition
17:05 Creating Pivot table
Click here for Microsoft Outlook Tutorial part1
th-cam.com/video/s64OxK2_4NM/w-d-xo.html
Microsoft Excel 2019 Basic to Advanced in Malayalam Full : th-cam.com/play/PLgeIgRaZLnlV3Hcsu1DVUx2Lq0bssjHt5.html
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 1 : th-cam.com/video/x-DYe1CEdDg/w-d-xo.html
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 2 : th-cam.com/video/lOAELAMZVU8/w-d-xo.html
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 3 : th-cam.com/video/lIXs1upMsjM/w-d-xo.html
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 4 : th-cam.com/video/ZOdwOSAqfCk/w-d-xo.html
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 5 : th-cam.com/video/QOrA6wnp56k/w-d-xo.html
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 6 : th-cam.com/video/H6m0XFO3RgA/w-d-xo.html
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 7 :th-cam.com/video/D5Wwek7JD3k/w-d-xo.html
Microsoft Excel 2019 Basic to Advanced in Malayalam : Part 8 : th-cam.com/video/-PQtRtMWKak/w-d-xo.html
part 14 sumifs th-cam.com/video/IyHUwL4r4Fg/w-d-xo.html
part 15 th-cam.com/video/JpKu6lNVQgc/w-d-xo.html
part 16 th-cam.com/video/36vG8BuwYAw/w-d-xo.html

[@shenza.fathima6484]

You tubel koodi ithokke padichal namuk joli kittumo certificte chodikkille

[@tonyoffical007]

Thank you

[@fanyaschrist]

Thank you Mam,
Love and respect from Pakistan 🇵🇰

[@AVTechandTravel]

Most welcome🥰

[@prejuobin7916]

Thanks chechi once again for presenting about VLOOKUP & PIVOT TABLE in a simple manner.

[@AVTechandTravel]

Most welcome

[@nisheethaprakash9765]

I became a great fan of you 🙏

[@AVTechandTravel]

Thanks dear🥰

[@aiswaryan3070]

Thanku for the explanation🙏❤️very useful video❤️❤️❤️❤️

[@AVTechandTravel]

Most welcome

[@tmdasan]

Valare useful annu ketto...Thank you

[@AVTechandTravel]

Most welcome

[@cutiepiecreations2328]

Thank you❤️very informative

[@AVTechandTravel]

Most welcome 💕

[@lofi_Mallu]

Miss., scenario managerne pati oru video chaiyavo.

[@ganeshkg4688]

Thanks a lot, very good presentation

[@AVTechandTravel]

Most welcome

[@samueljohnson7989]

Very Informative 👍

[@AVTechandTravel]

Thank u

[@umavenkatraman5408]

Sooper renditions mam. Best wishes

[@AVTechandTravel]

Thank you

[@princygeorge4590]

Wonderful tips and easy to understand.Thank you so much for bringing improtant tips in single Video.

[@AVTechandTravel]

Thanks dear🥰❤

[@sachisnest2242]

Thankq. Super class

[@AVTechandTravel]

U r welcome 😍

[@Sharon-1240]

👍🌹🌹
🌹🌹🌹🌹👍👍Dear ടീച്ചർ, your ടീച്ചിങ് സ്റ്റൈൽ amazing, amazing because easily can understand. സ്റ്റെപ് by സ്റ്റെപ്. My opinion എല്ലാ എക്സൽ formulasum ഒരു 5 എണ്ണം വച്ചു short വീഡിയോ ചെയ്യുമോ with എഗ്സാമ്പ്ൾസ്, സ്ലോവേലി ചെയ്യണം 👍👍👍👍
🌹🌹👍🌹👍👍👍

[@AVTechandTravel]

I ll try dear💕

[@rameshbala2000]

Good information sister thanku

[@AVTechandTravel]

My pleasure 🥰❤

[@umavenkatraman5408]

Super rendition mam

[@AVTechandTravel]

Thank u

[@rejeeshkumar7923]

ഞാൻ ഒരു Excel ഫയൽ electronic document management system (EDMS) നു പകരം ഹൈപ്പർ ലിങ്ക് അറ്റാച്ച് ചെയ്ത വർക് ചെയ്യുവാണ്...
ഇന്നലെ അബദ്ധവശാൽ ഞാൻ അതിൽ ഒരു ഫയൽ റെയ്ഡ് ഒൺലി ആയിരുന്നത് കാരണം ഡെസ്ക്ടോപ്പിലേക് കോപ്പി ചെയ്ത സേവ് ചെയ്തതിനെ ശേഷം റിട്ടേൺ ഫയൽ റീപ്ലേസ് ചെയ്തു ഇപ്പൊ എനിക്ക് ഹൈപ്പർലിങ്ക് ആയിറ്റി കൊടുത്തിരുന്ന files ലിങ്ക് വഴി ഓപ്പൺ ആക്കാൻ പറ്റുന്നില്ല
എന്തേലും ചെയത് return എടുക്കാൻ പറ്റുമോ?

[@fulla4023]

Thank u for chart short key #F11🌹

[@AVTechandTravel]

Always welcome

[@rohithraghavan363]

It was very easy and simple to understand 😄😊 tq ❤️

[@AbdulAzeez-lh1jg]

Video quality resolution could not be changed?

[@vipin.ppalakkal378]

Exellil sheets kureyundu all sheetinum vere vere perukal koduthittundu athil namukku venda sheet find cheyyan pattumo

[@AVTechandTravel]

Pattum..

[@abhilashmani1587]

Good video 💕

[@new99460]

Usefull information good

[@jijeeshpadmanabhan350]

Very informative

[@AVTechandTravel]

Thank u

[@nithyanair749]

Beautiful presentation ❣

[@AVTechandTravel]

Thank u

[@sobinsaj12]

Informative ❤️

[@AVTechandTravel]

Thank u

[@jeffingeo1634]

its really helpful and i like your way of teaching.. but can you please slow down .. i repeated like 20x already to grab info....

[@AVTechandTravel]

🥰👍

[@Revathy60]

Cell protect chayyumpo filter work akumo??

[@vaishakdamodar1351]

Good teaching mam, its very easy to understand😊👍

[@AVTechandTravel]

Thank you 🥰

[@harispunnakkal305]

Very Informative dear

[@AVTechandTravel]

Thank u🥰

[@rekhadevan7971]

Thank you mam

[@vigneshb7034]

Thank you ma'am

[@AVTechandTravel]

My pleasure 🥰

[@rakeshvk5042]

Thank you

[@AVTechandTravel]

Welcome

[@anaskt5751]

one simple summary report video please

[@harshadbinhameed2682]

Thank you teacher 🥰

[@AVTechandTravel]

Welcome dear

[@wizardop92]

Enikk outlook kurichu onnu paranju tharumo

[@AVTechandTravel]

Outlook video already cheythitund

[@kmanoj392]

👌👌👍✌

[@MaheshM-ll7nc]

Can you start Paint 3D classes....

[@praveenpraveen-et5ob]

Thank you teacher

[@AVTechandTravel]

Most welcome

[@dheenadhayalan1445]

Part 2 koodi cheyyumo

[@AVTechandTravel]

Cheyyam

[@ashfathukkinadka3541]

Thnk you

[@AVTechandTravel]

Welcome

[@shilpathomas3805]

Nice teaching.. I like your vedios very much.. But ad is intolerable😅

[@sreenivasnair3926]

njan padichathum upyogikunnathum aya karyangallanu ithil kooduthalum ,but oru interview theorytically nadannirunnenkil njan failed aakumayirunnu ningalude video kandillel,malayalam video sathythil kuravaanu youtubeil,njan kooduthalum hindi yil aayirunnu kandittullathu

[@AVTechandTravel]

Thank u so much😍💗

[@sajisnair9354]

Part 🕵️

[@saad-ns1oo]

Mam can you please make this video in English language or hindi?

[@shamnus8052]

Bahrain l undo ipo

[@favasfarhanm2322]

part 18 undo?

[@msateesh2814]

How Does absolute reference differ from relative cell reference . 70 20 =90. No coming .
70 20 =70 Anne answer varunathu. Enthanu karanum. reply tharamo.

[@AVTechandTravel]

Reference mattikoduthal sheriyavum..

[@muhammedansar47]

👍👍👍👍😍😍😍👌👌👌

[@AVTechandTravel]

🥰❤

[@renjithbaburaj9731]

Hi madam,
One doubt
Recently i went for an interview in abudhabi vegetable exporting company, and interviewil avar ennod excel sheet thannit ath copy cheyth next sheet il paste cheyyan paranju, 1. As usual copy paste cheyyan nokki nadannilla, 2. Mothamaayit sheet copy cheyth special paste koduthu ennittm paste aayilla.
Aaro parayunnath kettu aa cell and row nokki paste cheyyanam yenn.. Ath manasilaayilla. Is it possible to explain why i cant paste to next sheet.???

[@jayanvelappan2391]

Hi mam

[@binoychelat6037]

cell 8 adu agineyanu kittiyathu manasilayilla

[@aakashkr5519]

Mam apo kavitha name 2 perundengilo

[@AVTechandTravel]

Only return 1st match nd that s d main limitation...

[@അവിയൽ-ഥ3ഫ]

Synthax means formula ano🙂

[@AVTechandTravel]

Syntax means structure of that formula..

[@bavanucutz543]

എന്നെ plus two യിൽ പഠിപ്പിച്ച ശൈലജ ടീച്ചറെ പോലെ ഉണ്ട് ടീച്ചറെ കാണാൻ

[@anuragjohn87]

Excel sheet blurred ആണ്

[@AVTechandTravel]

Increase quality

[@harishkandathil7434]

മാഡത്തിന്റെ പേരെന്താ?

[@AVTechandTravel]

Asitha

[@naseeba.a5312]

sound kurav

[@aswinrajkv7206]

Hello, my I have you email address for AV Tech and Travel? I have need solutions for a problem in excel. As I am beginner to exam this doubt seems very complicated to me. If you could provide me the email for this channel I could prepare a doc and send you. Thanks.

[@shamsudheenpv3732]

Thank you teacher 😊

[@AVTechandTravel]

U r welcome