Top 5 Excel Productivity Tricks | Excel Tips and Tricks
Вставка
- Опубліковано 13 вер 2023
- Top 5 Excel Productivity Tricks | Excel Tips and Tricks
Excel Tips & Tricks Playlist Link- • Excel Tips & Tricks
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
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/innozantinfotech
#innozant #exceltricks#exceltipsandtricks#innozantchannel
Sir, please make a video on Top 5 Google Sheets Productivity Tricks.
Very Good video sir
please make the same types of videos
Excellent teaching
Sir pls continue power BI series
Sir Advanced VBA ki series chahiye
First tym i show ur video and it's really Enlightening video sir 👌👌👌👌
Thanks..Keep learning dear
You are the best ❤
Merge wala trick 👌
Hii sir ❤️😀 i love your videos
Very good sir your teaching slide is tremendous
MIS REPORT video chahiye Sirji
Thanku sir
Amazing
The way you explain realy Amazing
beautiful tricks and motivation...! Amazing Dilip Sir....!
Sir,The best part of your video is the message you are given to us it was very motivational and inspirational
Thanks ..Keep learning
Sir value added video🎉😊✌️💯
Salute to you 🙏 Sir
custom colour number to format cells se ho jata hai koi custom colour text bhi ho skta hai format cells se please sir agar hai koi solution
Sir, I have data or blank cells in range A2:K20. Each cell may contain either data or blank. In column J, I want the last non blank data to be returned for each row. How can I achieve this. Please help.
Dilip sir. Your teaching style very awesome. I have much learnt from your good tutorial. Stay bless.
Thanks
Dear sir
I have face some difficulties in excel.
I have used formula sumprodut with indirect maked to link another workbook but when does workbook close then come out #ref! Error
Kindly make video on this error
Thanks
Sir please continue with VBA series as well
Sir python in Excel kaise install kare =py()
App abb vba ki interview crack series shuru kar do
Sir mai 12th pass hu or bcom ke first semester mai hu per mene MIS executive ka course kiya hai or mere pass MIS executive ka certificate bhi hai per meri graduation complete nhi hui hai to mujhe job mil jayegi small company mai ?
🔥❤
Sir mere ek excel ka question hai me kispe puchu
Sir, I have a customer ledger
account. I want to calculate Cash Discount. The conditions are advance received-8% under 7 days received -7%, under 15 days received - 5%, under 30 days received - 3%, under 45 days received - 2% bill wise payment received to customer.
In my Excel data fields are 1- date 2-description 3- Invoice no/Ref No 4- Dr amount 5- Cr amount 6- Closing balance. Get the data from erp software therefore some cells are merge and every rows have a nartion row. So, How to calculate?
I became master in excel because of you sir, your teaching style ❤..
Thanks.Keep learning
Sir your tips and tricks really so amazing, actually I am just watch your videos of excel, your teaching skill is so cool 👍👍
Thanks dear..Keep learning
Keep learning what about jobs
Pls make video on power bi in single video
Powrr bi seprate playlist are currently running
Sir ap sabhi formula ka proper use krte ho koi bhi data ho answer nikal dete ho,,
apke jase excel me kse expert bane , full video bana do ek hi me
Thanks dear Keep Learning
@@Innozant please sir ek video banao jisme sabhi formula likh pr explain kr do " kis use me ata hai yeh formula" data me apply karke halka sa solve krke banao time mile kabhi to Qki ap formula ko ase explain karke batate ho ki formula ka syntax samjh aa jata hai.
Another easy method : Month function laga ke pick the number of month and then sort by smallest to largest
एक फोल्डर के अंदर एक एक्सेल फाइल है। एक्सेल फाइल मैं एक वर्क शीट है। इस वर्क शीट मैं अलग अलग टेबल है। हर टेबल मैं रो कम ज्यादा होती रहती है। हमे इनमे से तीन टेबल के PDF बनाने होते है। ये तीनो PDF मैंन फोल्डर के अंदर ही बनते है। क्या इसे हैं automatic बना सकते है क्या?
Killrr
Sir Aapki videos bohat kam samajh me aati hain
Random video dekhenge to kam hi aayegi samajh dear,Playllist sequnce me learn karna hota hai jab concept clear honge to khud samjh aane lgega.
@@Innozant Aapki bat sahi hai but excel me to kahi se bhi dekho ho kuch na kuch to samajh me aata hi hai
Sir trick 4 new thi thanks for always share new tricks