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]
Пікірлер
Hi
Sir i have to attach file by defining the path in "D column in Master sheet" In this code. Plz help
Nice....
Thank you
Thank You brother!!
You're welcome bro
Power BI - End to End Reports and Dashboard: kzread.info/head/PLId2Zr4hAG7al9kWdXZEQx0FD6LU40A3Z
@kallanai - Can you share me the Code?
Sir plz share excel sheet
It is working in browser outlook
hi bro i need a help from you i have a set of excel questios please help me to solve those problems
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
excal multiple sheet filter data only copy without header delivery sheet paste mt data sheet go to next sheet loop vba code
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
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
Bro enaku emp I'd ka against emp I'd venum na epdi pannanum
EXCEL DASHBOARDS: kzread.info/head/PLId2Zr4hAG7bttip9EuIk9-xUeOQWO_BN
Hi sir . Nega online la vba and power bi course adukurengalla sir .
Hrllo Bro.....how to create organization chart in excel pls.upload a videro
I'll make it soon bro
❤ .... 🥰👌
Thank you Santhosh
Very useful video
Thank you
EXCEL CHARTS: kzread.info/head/PLId2Zr4hAG7ZVnGvR90r9ijPIykCcJPvJ
sri kindly teach in dynamic way using this three functions
Sure bro I will make it soon
thanks for teaching this concept sir.
Thanks for your comment
hi sri. intha three function combinations la oru video make pandringala
Super sir Wonderful information tq
Thank you so much for your valuable comment
😊
❤
I want to contact u brother
Hi bro, new outlook format of table came plain text in body of email, plz check resolve this
Nice explanation bro. I was confused why these locals window and watch window are present. Now I have some idea.
Thanks for your comments bro
VBA USERFORMS: kzread.info/head/PLId2Zr4hAG7bdACBJF8Wx0nkBwVZKmaib
EXCEL FORMULAS & FUNCTIONS: kzread.info/head/PLId2Zr4hAG7aaCk7-FB4hnW5GF72ttTGi
VBA AUTOMATIONS - TAMIL: kzread.info/head/PLId2Zr4hAG7b9IPyjWQmL4NOA3o8Xs0Nf
"Promo sm"
Thank you
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
Currently I have stopped the live courses. I'll restart it few months later
@@KallanaiYT please inform me before sir like just post a video
Sure
Thank you
You're welcome
Please make vedios on ATS resume builder free websites
I'll try to make a video for this
Hi sir, please start uploading a video for powerbi
Sure
Free Excel VBA Full Course - kzread.info/head/PLId2Zr4hAG7Z9vSgIKC3oVwxcm3qO27p9&si=kOYzBUE5VCpSwLEL
Excellent. Very helpful. Can you help in doing this on excel query?
Yes
Hi Sir Please Share the File for practicing purpose
Pls send your email
Python means pandas is enough or django is must tell me
Pandas enough for Data Analysis. if you want to do web application development then learn the django framework as well.
@@KallanaiYT No i am looking data analyst only Thank u
You're welcome
@@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🙏🙏
How do you make the first command...
I'm not getting your point
Name , place as integer nu kudutha work aaguthu
Ok enna value assign panuninga string or numberic ?
Variable not defined nu varudhu
Code ah share Pannunga
Sir programming notes iruka sir
kindly send me the formula
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
What is the error you are facing ?
@@KallanaiYT end of statement error
@@KallanaiYT in that range("v"&i) v is showing error
Can you share your file to my email?
Hello sir I have one doubt. How to write vba code for if(isnumber(search("chrome", a2)), "Google chrome", " No") Using for loop function
Hi Bro, i need to attach Graph along with this auto email..... Need your support pls
I'll check and make separate video bro
contact number please?