Bht bht zukriya bhai yar kabse mujhe ye answer nahi mil pa raha tha ki filter lagane k bad kis trah se copy kiya jaye sirf usi name ko jo hum chahte hen but now i got it on your channel thank you so much bhai thak you so much .....
Very useful.... Please upload a video on the topic :- There are 6 or 7 sheets in a workbook Each sheet has some 0 value rows. How to hide 0 value rows of all the sheets at a time using a command button/button. Button will be placed at sheet 1.
Hi Nazim , I need to know a small short cut key in excel for eg to sum a range we use alt+ but I want the same sum as negative what short cut key I can use.
Very Nice Sir Thanks Mera Ek Problem Ya Qtn. Hai Mere System Par M. S. Word ya Excel ki Password Protected File Hai, Jab Is file Ko Kisi Other System Me Open Karte H Tab Word Ya Excel Password Feed Karne Ke Liye Dialogue Box Hi Nahi Show Karta. Mtlb, Password Feed Karne Ke Liye Prompt Nahi Karta. Why? Kripaya Solution Bataiye.
Sir two dates ke beach ka month ka difference k lye jaise 1-05-2015 to 30-06-2015 par hm jab datedif farmula use krte hai to ans 1 aata jab ke real may 1-05-2015 to 30-06-2015 ke beach may 2 month ka difference hota j prblm solve krdo sir
Sir jab kisi data me filter lagate hai to uske total ke liye subtotal function ka use karte hai aur yahi function uske serial no ke liye karte hai par agar date pe filter lagate hai to serial no wala function sahi se work nhi karta hai
Would like to learn how to split a master sheet data into several sheets in the same workbook. And if master is updated then those related sheets gets updated. Thanks!
Sir g , hm jab excel may number ko words may likhte hai spellnumber farmulas se to vo english may covert krta hindi ja other font may kyu nehi krta change
Sir ek data table me Sunday wake cell ka colour red hai aur hm kaise change kare bina conditional formatting kiye formula se colour kaise change kare plzzzzzz sir
Sir How to use min function if there is a column of gst, rate, amount, tax& amount+Tax only I have to take all column amount+tax (For min function on column table includes amount+tax)
👉 Download Practice File: www.techguruplus.com/excel-hidden-tricks/
👉 Buy Excel Course: TechGuruPlus.com/Excel-Course
👉 My Instagram: instagram.com/TechGuruPlus
👉 Facebook Group: facebook.com/groups/ExcelExpertGroup
Very useful method, for data sorting
Wow.... great sir...
Sir jii very nice vedio and very helpfull
Thanks Sir, mere ko same problems aaye the excel me aaj solutions mil.gaya
Very nice formula sir jiii
Very nice video and trick
You are amazing sir
Bht bht zukriya bhai yar kabse mujhe ye answer nahi mil pa raha tha ki filter lagane k bad kis trah se copy kiya jaye sirf usi name ko jo hum chahte hen but now i got it on your channel thank you so much bhai thak you so much .....
Great
Thenks Sir very good
Sir video late mat kijiyega.... Continues post karte rahiye.... "useful information"
Very nice solution sir. Invoice no. K liye formula ki jarurat nhi thi.
Wow..This is very helpful sir thanks
SIR, AS AN EXCEL IS A MAGIC.... YOU ARE THE MAGICIAN OF EXCEL😘 🥰😘
Thanks
V..Good
Bundle of thanks 👍
Allah Bless you
VERY VERY GOOD VIDEO SIR AAP EXCEL ME TO AMERICA WALE GIRVIN KE BAAP HO
hahaha Thanks bhai
Very useful....
Please upload a video on the topic :-
There are 6 or 7 sheets in a workbook
Each sheet has some 0 value rows.
How to hide 0 value rows of all the sheets at a time using a command button/button.
Button will be placed at sheet 1.
Sir provide the MIS report with dash board on maintenance expenses of automotive machines & equipment s
Hi Nazim , I need to know a small short cut key in excel for eg to sum a range we use alt+ but I want the same sum as negative what short cut key I can use.
Great trick Sir,
Sir is it possible to hide rows and columns based on text in a cell
Stock maintan ke liye ak vedio bnayege sir jiiij
Very well explained.. However I am already using it
Thanks
kuch financial analyst s related video upload kijiye...please
Very Nice Sir
Thanks
Mera Ek Problem Ya Qtn. Hai
Mere System Par M. S. Word ya Excel ki Password Protected File Hai, Jab Is file Ko Kisi Other System Me Open Karte H Tab Word Ya Excel Password Feed Karne Ke Liye Dialogue Box Hi Nahi Show Karta. Mtlb, Password Feed Karne Ke Liye Prompt Nahi Karta.
Why?
Kripaya Solution Bataiye.
Sir two dates ke beach ka month ka difference k lye jaise 1-05-2015 to 30-06-2015 par hm jab datedif farmula use krte hai to ans 1 aata jab ke real may 1-05-2015 to 30-06-2015 ke beach may 2 month ka difference hota j prblm solve krdo sir
Sir Apke Chanel per v lookup or h lookup ki vedio h. Pls bataye
Sir kindly make video on how to file gst return from pivot table in excel please sir
sir payroll process par video ban du
Sir, ekdum gajab. Would like to know your location in India. Where are you from?
Excel expert kaise Bante hai?
You can join my excel course to learn properly.
Sir jab kisi data me filter lagate hai to uske total ke liye subtotal function ka use karte hai aur yahi function uske serial no ke liye karte hai par agar date pe filter lagate hai to serial no wala function sahi se work nhi karta hai
As salam alaikum
Sir mujhe excel to tally ka formula pls bataye
Would like to learn how to split a master sheet data into several sheets in the same workbook. And if master is updated then those related sheets gets updated. Thanks!
use advance filter the data will be saved in new sheet
@@dhiru7171 how it will happen please explain
I want to know New IT slabs for fy- 2020-21 calculator and how to fill itr1 for retired persons and salary person.thanks
Sir g , hm jab excel may number ko words may likhte hai spellnumber farmulas se to vo english may covert krta hindi ja other font may kyu nehi krta change
How can Filter box resize without mouse use
Sir ek data table me Sunday wake cell ka colour red hai aur hm kaise change kare bina conditional formatting kiye formula se colour kaise change kare plzzzzzz sir
How print last page different in excel
Sales man ka report kaise kare pur amount receipt closing blance party name
Sir
How can I arrange different excel files into a single spreadsheet in the pattern of e.g. Sheet1 Sheet2 and so on? I think you can get my point.
use power query method
If in this excel sheet, we want to generate report of each company in a separate sheet automatically, how this will can be happen please explain?
Sheet delete krne ki short cut key kya y sir
Sir
How to use min function if there is a column of gst, rate, amount, tax& amount+Tax only I have to take all column amount+tax (For min function on column table includes amount+tax)
I want to buy excel course but .but payment cash on delivery nahi ho sakti?
Sir mai advance Excel ka course Karna chahta hoo
you can contact me on 9536 250020
सिर्फ नाम टाइप करें और संबंधित कर्मचारी की पूरी डिटेल आ जाए एक्सेल में ऐसा हो सकता है क्या प्लीज बताएं
Fantastic