Excel PRODUCTIVITY Top 5 Tricks
Вставка
- Опубліковано 5 вер 2024
- Excel PRODUCTIVITY Top 5 Tricks
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#innozant#exceltricks #exceltipsandtricks
#exceltutorial #learnexcel #careermotivation
बहुत अच्छा लगा सर जी।
बहुत बढ़िया।
Thanks
Respected sir
I m from Pakistan. Your way of teaching is mind blowing. I appreciate your way of teaching and pray for your success.
May God bless you ever.
Thanks
Thanks dear
Nice sir apke video se ham sabko ek New motivation milta hai life me kuch New achieve karne ka thank you so much sir
Thanks..keep growing
Very great sir
Good to see you back
Thanks dear
Very much helpful 😍🤘
Thanks dear
Really appreciate sir ❣️aapne bhot kuch sikha diya
Thanks Lavi..God bless You dear❤️👍
Aage badhiye life me yhi wish
Thanks for Trick #3. 🙏🙏👌👌👌👌👌👌
Great.... You always rocks...
🙏 PRANAM SIR 🙏🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼🌼
Sir. Very nice top 5 tricks of excel tutorial plz upload a tutoriel upon time calculation in ms excel .
I will thankful to you .Regards
Effective Excel trick sir... ❤️🙏
Thanks Sunil.
Happy learning
Great learning
Thank you sir
Thanks
Sir power bi ka playlist pura bnayiye
Please, please
sir now, your subscribers are unhidden.
i can't believe. apke bs 69k approx subscribers hai. jabki ap to hum sbke liye kitni jyada mehnt krte ho.
sir ap jesa teacher mene ajtk nhi dekha.
you are great sir.
i hope ki apke jld hi millions me subscribers ho ❤️
Thanks Deepak ji for your love ,support and concern.
Yes underrated ,but maine kbhi bhi views pane ke liye nhi padhane ke liye video banaya hai tabhi aap mere channel par ek bhi short videoa kabhi nhi dekhe honge..Keep learning..keep exploring ❤️👍
Fantastic video sir 🙏🙏🙏🙏. Good night
Thanks Satish Ji .Good night..hope aap sahi hain aur acha kar rhe hain life me
Thanks for sharing Jha sahab
Thanks dear
I learn lot of things from you. Thanks
Thank you sir
Sir trick apki no 1 h
Thanks Hemant Ji
Sir very nice.
You work really hard to make such career oriented videos sir, thankyou so much sir.😊
Thanks Bhawna for your valuable appreciation dear..Keep learning..Keep exploring ❤️👍
gr8 sir ji👌👌👍👍
bhaiyon aur baheno ye channel me Dilip Jha ji Analytics padhate hai, fir bhi 70K hi subscribers kyun, jladi se jaldi 1lakh subscribers tak pahuchaiye is channel ko
Yahi to trashadi hai Nishant Ji😊
Thanks apke love aur support ke liiye.❤️
@@Innozant Jha Ji, Hum Mithilanchal chi, aaha ke 1Lakh Subcribers takk pahuchawe me bhar sakk koshish karab..
Thanq sir apki wjah se main ajj ek ashi job par hu bus id change hai meri Gaurav bhatia
Kya haal Bhatia ji..aap to gayab ho gye the kuch time se ..God bless you dear
Hii sir😃🔥
Thank you once again sir for sharing all effectives tricks
Informative video sir 🤓
Thanks Nirupma..Keep Learning ❤️..Keep Exploring
Amazing tricks as always.... 😀
Fantastic Sir
God bless you
Good to see u
Very useful information sir 👍👍
Sir large or table tricks best for work
You are amazing sir.❤️🙏
Sir
Thank you for the tricks.
In case of summing k values more then 3, then I make some changes to the formula you explained.
SUM(IFERROR(LARGE(IF((range as explained in the video = value to lookup), range of values to sum), ROW(INDIRECT("1:30"))),0))
Sir I am running my small business on self made excel program. I have a workbook of about 25 customers sheet and a sheet containing customer directory where I have hyperlink their names with their respective sheets. It was my long desire that by some how I can fetch the last payment date from every customer sheet on the directory. Thank you very much you solved my problem by indirect and counta combination function. Now another issue raises, the indirect and counta combination fetch the last date cell it didn't distinguish either it is last billings date or last payment date. I want only the last payment date on my customer directory sheet can you please help me solve this problem?
Is there any video regarding Store inventory management?? Opening stock, issuance, closing, balance management through Pivot data entry??
Just amg waiting for vba
Sir Please Share the File
Hi sir,
Date format became default format.
How can i set it as number format as default ????
Sir i want to sum net total of vendors coming many times in different rows, through sumif i am able to do but i need one vendors one total in last of vendors line , any suggestion....
nyc
I'm first viewer
Thanks Mohit♥️👍
@@Innozant welcome sir ji ❤️
Respected sir, we are waiting for excel vba contin....
👍❤️
Hello sir...can i make a career transition into data analyst after working in 13 years in operations and m only b.com graduate and m 34 years old...is it still possible?
Finally....Right time ..Amita,Age is not a barrier as you are not Fresher and also not pretend to be Data Analytics Fresher.
Who knows that You are Fresher?
Only one person that's YOU😊
A simple Bcom having greate communication skills and Good skills of Analytics tools.e.g. Power BI/Tableau is getting awesome 15Lac + Package.
Start your journey Now ,I assure you won't regret for this decision as Data Analytics and Data Science is Great career option Now.
Still issue and unable to prepare your self for career transition,Will guide you for the same,Conny us via whatsapp/call for career guidance.
Data ko table me convert kerne ke baad auto filter use nahi hota .jaise quick excess tool bar mein auto filter add kerte hai aur wo doosre no per hai aur main alt+2 enter kerta huun filter nahi hota. Normal data mein kerta huun to ho jata hai. Please bataye.
Range ko table me convert karte hi autofilter khud apply hoga.
Yadi nhi ho Raha hai means options -settimg se disable ho rakha hai.check it
@@Innozant option mein setting mein jaker quick acccess tool mein adker liyA hai. Table converted data mein alt+2 press kiya to header per filter aa jata hai, lekin jaise hum paticular cell pe jker alt+2 presa kerne se cell wali item sare filter ho jni chahiye but header per filter aa jata hai, cell items filter nahi hote fir header pe jaoo drop down mein filter kerna padta hai. Normal data pe alt+2 press kerta huuun to cell wali item sab filter hoti hai. Table format mein nahi. Plz aap ik baar check kare aur solution bataye sir
Please files alg alg share krin jo aaap videos bana rhy hus hisab say file aaap k master files m match nhe krte please is ko set krin
Har ek video k alg file link share krin
Haan direct link broken ho gya hai use theek karna hai free time nikalke
@@Innozant theek hai sir waiting for your response
Taakay hamay koi preshan na ker sakay.
First comment
Thanks dear
@@Innozant I have got a new job as mis officer because of you sir thank you so much
Really I have no words for you sir
Until you day by day release a new analytical skills tips which very helpful for all ..
Jai guru dev