Top 5 Ultimate Advanced Excel Tips and Tricks
HTML-код
- Опубликовано: 9 июн 2020
- The Top 5 tips and tricks for Excel. Use these ultimate advanced excel interview question tips and tricks to improve your efficiency using Excel.Our aim at innozant is to make you expert in Excel and related technologies.
1. Move Column and rows
2. Status bar total
3. Insert multiple lines
4.Find occurrence /duplicate
5. Compare List
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
#Exceltips #exceltricks #innozant #exceltipsandtricks
Mind-blowing not only this I watched 4 lectures regarding advance tricks....
Thanks dear
heartly thanks
It was nice to clear that last tak video dekho and second thing sath sath excel pr try kro tabhi kuch fayda h 👍👍 Again amazing 😃
This is the best approach for solving the all problems in few seconds , I love it sir ❤❤
No words.. Extraordinary
Ur videos are truly amazing.....very helpful for working professionals
Thanks Ram
Bahut sundar sir
The video are superb sir
Amazing video
Very great trick
Excellent sir
Thank you..
Thanks dear❤️🙏
I am a real big fan of your sir.... Your all videos helps me.... Many ways.... I love your teaching style.... And also follows it.... When I am with my students.... I just remember your teaching style... And follow it... In my... Class... All my students... Are felling happy 🥰🥰🥰🥰🥰
Thanks Sarita..Really means a lot to me..Wow is it true ?❤🙏Hope these video are helpful and adds some values in your life..
Very good
you know you have a amazing talent
Sir, you are great teacher
Thanks dear..Keep learning ❤️
The way you explain the formula is amazing thank you so much and yes I've subscribed your channel☺
Thanks Vanisha , Really means a lot to me.Keep Learning And Keep Exploring👍❤️
দারুন দারুন দারুন
From Bangladesh
You are My BOSS in excel learning
Thanks Rasel ❤️🙏Happy learning❤️🙏
Sir day by day u just increase your video clarity and this video is really helping me out enhance my skills too..
Good👍
Great Sir❤❤
Thanks Jay
Thanks i was looking for this duplicate formula I need it . I tried myself before but don't have solution now I do. So happy. Usually I was selecting all range .
Thanks dear
Thinks sir
Excellent 👌
Thanks ❤️👍
Thank u sir
I have lern lot of excel formula
from u
Thanks dear..Happy Learning 👍🙏
Excellent
Good Morning Priyanka..Have a wonderful career ahead ❤️
it's too good video sir
please make a videos like that sir
Thanks dear..Sure will make more videos
Amazing sir..
Thanks dear
Thanks sir❤🌹😊
Thanks ❤️🙏
Kya baat h sir meri problem solve kar di apne last me
Thanks dear❤️
I do not have word to praise you Sir
Thanks Mahima .Really means a lot to me dear.❤❤🙏🙏
lajwab sir from gujranwala pakistan
Thanks dear Bilal
Thnq sir
Boss you really champ....
Really means a lot to me dear
Superb
Thy👍❤️❤️🙏
hi, I am frm Tamilnadu. Your videos are very useful . Have been learning both excel formulas, tricks, difficult tasks and Hindi Language. Your way of explaining step by step is exemplary. Thank-a- lot. Ravichandran. H
Thanks Ravichandran for your trust ,love and support.Have a wonderful career ahead.
Amazing
Thanks Pradeep ji
Nice sir
Nice teaching sir
Thanks Madhuri..Recommend you to start your learning journey from Playlist Basic Excel onwards..step by step
Sir Good after noon.
I m your subscriber and I want to know a complete tutorial on time calculation in ms excel. Plz share and upload a tutorial video. I will be thankful and greatful to u. Regards.
👍👍👍
Super bro
Thanks Swarna..God bless You..Happy learning ❤️👍
Dear sir,
May i know, demand forecast training videos, please suggest if possible.i want to take demand forecast training
💞
Thanks ❤️
Your lecture is good, but plz also provide sheets as well.
Sheet are already there.
Kindly see the link in video description
Please give a lecture on adding watermark and page layout
Ok .Aditya..👍🙏❤️
🌟🌟🌟🌟🌟
Awesome video, my question is related to this duplicate which I had mailed you plz help me
Bht saare mail aate hain dear..miss ho gya hoga..Ok will check it again
@@Innozant I understand sir...plz chk..not an issue
This video is unrated, it should be on toppppppp
♥️♥️♥️
Can i get ur website sir and how get yr online classes. So, i can have duscussion for projects.
Search Innozant on Google ,You may find Innozant website for more information
Pl make regarding mailmerging.
Mail merge video available under ms word playlist
@@Innozant pl send link.
Pl guide make wages slip of 1000 people by help Mail merging.
sir can you please provide excel sheet link again because when i click on that link G drive show empty.
Dear direct mis master link is working fine..m working on video broken link..
Still issue shre your mail id or you may mail us for the same
Find duplicate wale formulae me aapne formula ko freez kaise kiya sir ?
10:21
sir i think apka ye conditional formatting ka formula always shi nhi hoga kyoki agr 1 se jyada duplicate hue to countif formula use highlight nhi krega
you should use= countif(range,criteria)>=1
isse agr 1 se jyada bhi repetition h tb bhi highlight hoga
Ishu phir SE ek Baar dekhiye aap wo Question kya pucha gya tha..occurance 1 time ho to hi color krna hai na ..ek se jyada Hoga to wo to duplicate hi hai use kyu krna format..🙂M Happy ki aap analise karte Hain Questions ko aur different krne ki koshish krte hain..Good 👍❤️.
@@Innozant
sir your question and solution was right according to your situation but agr range me vhi number 1 se jyada bar repeat hua ( like 3 times repeat,4 times repeat) then countif formula to sirf 1 time repeat ane pe hi cells ko colour krega na according to your condition.
agr 2 ,3 4 ,i mean 1 se jyada bar repeat hora h number to mera wala formula shi hoga.kyoki apki condition ke according 1 se jyada bar repeat hone me countif formula 2,3,4 and so on answers dega aur apne apne =1 lgaya h condition me to colour hoga nhi us situation me.
ab kya pta ki koi number range me kitni bar repeat hora h.mera solution meri condition ke according tha.
ye mere kehne ka mtlb tha.🙏😊
Yes Ishu you are right in case of multiple duplicate value aur uspe formatting apply karna hai to,Jab bhi main interview cracker series me Questions Ka solution attempt krta hu aap koshish Kiya kro ki usse alag solution try Kiya kro aur mujhe btao ki iska solution Aise bhi ho skta hai jisse main ye Jan sakun ki aap logic Apne tareeke se laga pa re ho aur concept clear h apke jaisa ki aapne is Question me socha .👍❤️
Good morning.hv a nice day ahead. Happy Learning 🙏
hi
ak sheet make kar ni ha . ms execl par kuch is taraha say ha
mujsay nai ho rahi ha
S No particular 200gm /400 gm quty rate amount
problems ya ha k items zida han
jab invoice make karna hota ha to items list 70 ha
or gm mai bhot dar ho jati ha koi asan sa trik ho
Custom formatting se gm suffix kar skte hain
Sir jo bhi word likhe uska first letter automatic uppercase mein ho jaye....iska setting kaha milega sir plz reply 🙏
File-options me sayd advanced ke andar hoga .
As u replied inzannt team. Wesite sir???
Hi Shweta ,Unable to provide link in RUclips comments due to RUclips policy ,You may find our contact details in our any any latest video intro or RUclips channel introduction.
Sir how to add number with text......like...12pcs,10pcs,13psc,24pcs
Will make video for the same
IE $ SIGHN KAISE A RAHA HAI ??
Sir 4th question m agr mutiple invoice no same h to ye kaam nahi kr raha kaise kiya jaaye sir
Duplicate vlookup use kren ..kya output chahte h
Sir if we have 2group of numbers and both have dulipicate values and we want to know where tha duplicate values and also we want to match and romeve duplicate no from both of number groups
sir...आपको email करके, questions पुछ शकते है...??
@innozantofficial telegram id
Sir, ये विडियो delet कर दें तो अच्छा है। क्यूं की इसमें आप कुछ खास करते हुए नही लगे
Excel ka ABCD sikha rahe ho bhaiya.
Ye safar Abcd se Z tak ka hai..keep learning
Sir meny 1300 logo ki list bnaye par glati say name or father's name 1 sath likh leya ab wo alag colom m kesy jaye ..?😭
Split kar lein ya to power query se yabusing formula
@@Innozant pls video bnaa k dkhaye.
Sir have u any WhatsApp group???
No dear...telegram id is there