Kallanai YT

Kallanai YT

Hello Everyone!

Welcome to my channel. Let me introduce myself...
I am a Data Engineer by profession. I worked in different profile starting with reporting using Excel & VBA Automation. Later I learned Power BI, MS SQL Server & SSIS and started building applications to automate manual process along with reporting tasks. After working for a couple of years in reporting and automation, I moved to Data Analyst profile by learning Power BI, SQL & SSIS. Now I am working as a Data analyst role.

This channel has Microsoft Excel tips & tricks, Excel formulas & functions, Excel pivot tables & slicers, Excel pivot charts, Excel advanced level charts, VBA Automations, Excel & VBA interview videos for job seekers, Excel Office 365, MIS report generations, Excel dashboard, Excel data analysis & analytics, Power query, Power point, MS word, MS access, Power BI, DAX functions, Power Apps, Power Automate, Power Flows & Power BI dashboard.

If any queries please send an email - [email protected]

Пікірлер

  • @sameerwagh409
    @sameerwagh409Күн бұрын

    Hi

  • @ujjwalkumar2087
    @ujjwalkumar20876 күн бұрын

    Sir i have to attach file by defining the path in "D column in Master sheet" In this code. Plz help

  • @natarajanvignesh5641
    @natarajanvignesh56419 күн бұрын

    Nice....

  • @KallanaiYT
    @KallanaiYT9 күн бұрын

    Thank you

  • @praburaj578
    @praburaj5789 күн бұрын

    Thank You brother!!

  • @KallanaiYT
    @KallanaiYT9 күн бұрын

    You're welcome bro

  • @KallanaiYT
    @KallanaiYT9 күн бұрын

    Power BI - End to End Reports and Dashboard: kzread.info/head/PLId2Zr4hAG7al9kWdXZEQx0FD6LU40A3Z

  • @brindhaaramesh
    @brindhaaramesh9 күн бұрын

    @kallanai - Can you share me the Code?

  • @ujjwalkumar2087
    @ujjwalkumar208712 күн бұрын

    Sir plz share excel sheet

  • @sakthivels4799
    @sakthivels479919 күн бұрын

    It is working in browser outlook

  • @rameshn4824
    @rameshn482421 күн бұрын

    hi bro i need a help from you i have a set of excel questios please help me to solve those problems

  • @nagaraj.k7525
    @nagaraj.k7525Ай бұрын

    excal multiple sheet filter data only copy without header delivery sheet paste mt data sheet go to next sheet loop vba code please upload this video sir

  • @nagaraj.k7525
    @nagaraj.k7525Ай бұрын

    excal multiple sheet filter data only copy without header delivery sheet paste mt data sheet go to next sheet loop vba code

  • @BHARATHEEYUDU.
    @BHARATHEEYUDU.Ай бұрын

    Sir i triying election results total votes for each candidate 1,2,3 position using dropdown vlookup max function but i didnot get please give example

  • @nagaraj.k7525
    @nagaraj.k7525Ай бұрын

    excal multiple sheet filter data only copy without header delivery sheet paste mt data sheet go to next sheet loop vba code please is vidoes uplode sir thk u

  • @jonvesteenselvan1798
    @jonvesteenselvan1798Ай бұрын

    Bro enaku emp I'd ka against emp I'd venum na epdi pannanum

  • @KallanaiYT
    @KallanaiYTАй бұрын

    EXCEL DASHBOARDS: kzread.info/head/PLId2Zr4hAG7bttip9EuIk9-xUeOQWO_BN

  • @a.s.dharanidharan3625
    @a.s.dharanidharan3625Ай бұрын

    Hi sir . Nega online la vba and power bi course adukurengalla sir .

  • @natarajanvignesh5641
    @natarajanvignesh5641Ай бұрын

    Hrllo Bro.....how to create organization chart in excel pls.upload a videro

  • @KallanaiYT
    @KallanaiYTАй бұрын

    I'll make it soon bro

  • @psantoshkumar5699
    @psantoshkumar5699Ай бұрын

    ❤ .... 🥰👌

  • @KallanaiYT
    @KallanaiYTАй бұрын

    Thank you Santhosh

  • @ramyaarthanarisamy7031
    @ramyaarthanarisamy7031Ай бұрын

    Very useful video

  • @KallanaiYT
    @KallanaiYTАй бұрын

    Thank you

  • @KallanaiYT
    @KallanaiYTАй бұрын

    EXCEL CHARTS: kzread.info/head/PLId2Zr4hAG7ZVnGvR90r9ijPIykCcJPvJ

  • @krishnarajr5731
    @krishnarajr57312 ай бұрын

    sri kindly teach in dynamic way using this three functions

  • @KallanaiYT
    @KallanaiYTАй бұрын

    Sure bro I will make it soon

  • @krishnarajr5731
    @krishnarajr57312 ай бұрын

    thanks for teaching this concept sir.

  • @KallanaiYT
    @KallanaiYTАй бұрын

    Thanks for your comment

  • @krishnarajr5731
    @krishnarajr57312 ай бұрын

    hi sri. intha three function combinations la oru video make pandringala

  • @srinivasanv9237
    @srinivasanv92372 ай бұрын

    Super sir Wonderful information tq

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Thank you so much for your valuable comment

  • @anandk6231
    @anandk62312 ай бұрын

    😊

  • @AxonPool
    @AxonPool2 ай бұрын

  • @shivuD-bz7iz
    @shivuD-bz7iz2 ай бұрын

    I want to contact u brother

  • @Sai_Jackie
    @Sai_Jackie2 ай бұрын

    Hi bro, new outlook format of table came plain text in body of email, plz check resolve this

  • @manigandann1434
    @manigandann14342 ай бұрын

    Nice explanation bro. I was confused why these locals window and watch window are present. Now I have some idea.

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Thanks for your comments bro

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    VBA USERFORMS: kzread.info/head/PLId2Zr4hAG7bdACBJF8Wx0nkBwVZKmaib

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    EXCEL FORMULAS & FUNCTIONS: kzread.info/head/PLId2Zr4hAG7aaCk7-FB4hnW5GF72ttTGi

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    VBA AUTOMATIONS - TAMIL: kzread.info/head/PLId2Zr4hAG7b9IPyjWQmL4NOA3o8Xs0Nf

  • @tymalone1937
    @tymalone19372 ай бұрын

    "Promo sm"

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Thank you

  • @rameshn4824
    @rameshn48242 ай бұрын

    ama sir nega sonnadhu correct nanum institute pona but no use indha videos patha podhuma illana if you take live class please inform sir i would like join please help me

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Currently I have stopped the live courses. I'll restart it few months later

  • @rameshn4824
    @rameshn48242 ай бұрын

    @@KallanaiYT please inform me before sir like just post a video

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Sure

  • @SathishKumar-py1el
    @SathishKumar-py1el2 ай бұрын

    Thank you

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    You're welcome

  • @BHARATHEEYUDU.
    @BHARATHEEYUDU.2 ай бұрын

    Please make vedios on ATS resume builder free websites

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    I'll try to make a video for this

  • @venkatrooney9912
    @venkatrooney99122 ай бұрын

    Hi sir, please start uploading a video for powerbi

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Sure

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Free Excel VBA Full Course - kzread.info/head/PLId2Zr4hAG7Z9vSgIKC3oVwxcm3qO27p9&si=kOYzBUE5VCpSwLEL

  • @arnabsinha1783
    @arnabsinha17832 ай бұрын

    Excellent. Very helpful. Can you help in doing this on excel query?

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Yes

  • @anishrobert5056
    @anishrobert50562 ай бұрын

    Hi Sir Please Share the File for practicing purpose

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Pls send your email

  • @BHARATHEEYUDU.
    @BHARATHEEYUDU.2 ай бұрын

    Python means pandas is enough or django is must tell me

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Pandas enough for Data Analysis. if you want to do web application development then learn the django framework as well.

  • @BHARATHEEYUDU.
    @BHARATHEEYUDU.2 ай бұрын

    @@KallanaiYT No i am looking data analyst only Thank u

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    You're welcome

  • @BHARATHEEYUDU.
    @BHARATHEEYUDU.2 ай бұрын

    @@KallanaiYT Sir i applying company career portal relavent job but my candidature not moving forward Companies are using ATS software how to prepare resume using ATS any free ATS resume builders are there please make vedio for short listed our Resumes🙏🙏

  • @mrponnambalam5121
    @mrponnambalam51212 ай бұрын

    How do you make the first command...

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    I'm not getting your point

  • @dbzgokutamil4646
    @dbzgokutamil46462 ай бұрын

    Name , place as integer nu kudutha work aaguthu

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Ok enna value assign panuninga string or numberic ?

  • @dbzgokutamil4646
    @dbzgokutamil46462 ай бұрын

    Variable not defined nu varudhu

  • @KallanaiYT
    @KallanaiYT2 ай бұрын

    Code ah share Pannunga

  • @AkshayKumar-tp4pg
    @AkshayKumar-tp4pg2 ай бұрын

    Sir programming notes iruka sir

  • @juliaanantan2232
    @juliaanantan22323 ай бұрын

    kindly send me the formula

  • @sangeethasundaram8394
    @sangeethasundaram83943 ай бұрын

    Sub macro() Dim lastrow as long Lastrow = thisworkbook.sheets("sheet"). Range("a"&rows.count). End(xlup). Row For i=2 to lastrow Range("b"&i). Formula="=if(isnumber(search(""adobe"", range("v"&i))), "" Adobe reader"", "" Others"") " Next i End sub This code is not working for me. Can you please help me to resolve this

  • @KallanaiYT
    @KallanaiYT3 ай бұрын

    What is the error you are facing ?

  • @sangeethasundaram8394
    @sangeethasundaram83943 ай бұрын

    @@KallanaiYT end of statement error

  • @sangeethasundaram8394
    @sangeethasundaram83943 ай бұрын

    @@KallanaiYT in that range("v"&i) v is showing error

  • @KallanaiYT
    @KallanaiYT3 ай бұрын

    Can you share your file to my email?

  • @sangeethasundaram8394
    @sangeethasundaram83943 ай бұрын

    Hello sir I have one doubt. How to write vba code for if(isnumber(search("chrome", a2)), "Google chrome", " No") Using for loop function

  • @patersonpravin
    @patersonpravin3 ай бұрын

    Hi Bro, i need to attach Graph along with this auto email..... Need your support pls

  • @KallanaiYT
    @KallanaiYT3 ай бұрын

    I'll check and make separate video bro

  • @flairezone9327
    @flairezone93273 ай бұрын

    contact number please?