5 Excel Tricks for Day to Day Work

5 Excel Tricks for Day to Day Work
===========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 #exceltipsandtricks #exceltricks #excelinterviewquestionsandanswers

[@manojkumarsingh3385]

👍👍 Sir bahut Sundar 🙏🙏🙏

[@sharemarket200]

Thanks. Last line is true. kayi baar Difficulty aane pe giveup krne ka mann hota hai.

[@createyour6681]

first class video sir

[@shrikantbadge3978]

Dilip sir not only teaches computer programming but he also programs mind for success. Hats off sir. Real Teacher.

[@Innozant]

Thanks dear...God bless You dear

[@AnkitSingh-yl3ny]

Content ka comparison Nhi Guru Ji ❤❤

[@Innozant]

Thanks

[@ankitmehta9996]

Sir aapka video ka hamesha intazaar rahata hai kab aayega dil se sir aap bahut aacha padhate hai

[@Innozant]

Thanks

[@syedaliriaz3326]

Sir apki videos bhot informative or asani se samjh any wali hoti hen. Therefore i m your subscriber from Pakistan.❤

[@Innozant]

Thanks dear

[@vasimshaikh5833]

Sir value added video 🎉✌️👍

[@subhasisbhattacharjee9187]

1st Trick is really very useful

[@vijaykumarjain3222]

Nice sir u are genius

[@shara369]

Thank you sir😊

[@excel_master_habib]

Gajjab ...bhai

[@RK45937]

You are best trainer.

[@Innozant]

Thanks

[@Afghan_Tech]

Thanks sir

[@virajraj935]

Sir, Excel me ek problem h mere pass. Customer manlo ek complaint karta h service se related aur engineer us problem ko resolve karke us complaint to close kar deta. Ab Complaint close time aur opened time ke difference se bucket bnana h. But Engineer jo h wo sirf 9:00:00 se saam 7:00:00 baje tak hi kam karta. Tu manlo agar Complaint rat ko 6:00:00 hue aur close subha 10:00:00 tu wo 4hours ki bucket me jayega. Agar rat ko hui(7baje ke bad) aur close bhi rat ko hui(9 baje se phele) tu 4hrs ke bucket me.
Rest are as follows
Opening Time : 10:00:00 PM, Closing Time: 10:10:00 PM then time difference 00:00:00
Opening Time : 10:00:00 PM, Closing Time :
NEXT DAY 9:10:00 AM then 00:10:00
Opening Time : 10:00:00 PM, Closing Time :
NEXT DAY 10:10:00 AM then 01:10:00
Opening Time : 9:00:00 AM, Closing Time :
10:10:00 AM
then 01:10:00
Opening Time : 5:00:00 PM, Closing Time :
NEXT DAY 10:10:00 AM then 03:10:00
Opening : 5:00:00 PM, Closing Time :
NEXT DAY 11:10:00 then 04:10:00. Kese karo sir???

[@VIKASHKumar-ey5ir]

you rocked this video sir ☺

[@arunkumarsinghark3024]

आप Excel के जादूगर है, और उतना ही Cute भी, अपनी कोर्सेज थोड़ा कम बजट वालो कै लिए भी बनाए l

[@Innozant]

Thanks dear

[@dipak5651]

You are a unique teacher for Ms Excel. Accept my salute to you especially for the shayari in the end.😊

[@Innozant]

Thanks dear

[@Altaf_Alam]

Absolutely right bro🙂

[@KaranSaim]

Sir your last trick so amazing 🙏🙏

[@Innozant]

Thanks

[@dharmendrachauhan4700]

You are great teacher sir

[@Altaf_Alam]

Good evening sir ❤

[@shrikantbadge3978]

Thank you sir. As always, very useful.

[@Altaf_Alam]

1. Sir all data ko select kar custom format mein 3 time ;;; dena h 😊👍

[@rajivranjan-mf6zu]

Great sir as always❤👍👍👍

[@mukeshprasad7266]

Best excel learning channel in a very simple words. Keep it up sir.

[@roniteraj4201]

Sir pehli trick was too amazing, Pasand aagayi .... Or waqai iska real life scenario me bohat acha istemal hosakta hai...

[@Innozant]

Thanks

[@hassanshahzad4964]

Best teacher ❤

[@situsahoo2482]

This one really helpful in day to day work Time saver .All tips tadka laga diya❤Thanks to Innozant Thanks Dilip sir❤

[@Innozant]

Thanks Sahooji

[@Team-gq2ee]

really great stuff sir

[@narayanbhave3020]

नमस्ते सर.

[@Rahul.parmar8439]

Hello sir
I am big fan
my office in WPS excel hai please advance shortcut batao please
Ex
alt h h se jese color option hota hai excel me vese WPS me nhi hota hota hoga to muje pata nhi please aap batao

[@akashindian8436]

Aap superb hain Sir ♥️👌🏻

[@excelDivesh]

You are awesome 😎 Sir ❤

[@MuhammadAhmed-rd7ud]

Hi Dilip Sir,
It is a Amazing video, my request to make the tricks on Google sheets as well
Thanks ❤

[@Innozant]

Sure Dear..Keep learning

[@SandeepSharma-yk7zm]

Sir
Please share video to create labels ( which will be pasted on the envelops) through Excel say 100 labels at a time , face lot of problems in setting their format.

[@goutamnayak5011]

Sir please clear my doubt
Copilot 365 soon available in Excel & other ai tools are there
So is it still important to learn ms Excel deeply all functions and advance formulas??

[@user-uk9eo6gk1h]

Sir, muje , me ek trader hu, muje ek cell me 10 baje tak jo high value hai, vo value bad me kitni bar aayi hai, usko count karvana hai uska formula hai ? Range nahi lena hai sirf ek cell ka value count ho

[@vasimshaikh5833]

Sir, need help show report filter page not enable what can I do?

[@RahulRoy-po9ct]

Sir Press F2 then F9

[@RahulRoy-po9ct]

🙏

[@prajwalshetty2047]

❤

[@babbooprasadbabbooprasad4091]

Sir mere laptop me filter =filter ke jagha filterxml aata hai Kya Kare our Aabhi formula bhi nahi aata hai

[@laisonkc]

Sir,
I was an excel 2013 professional plus user and recently upgraded my excel versions to 2016 professional plus. I am facing the following problems.
1. I am unable to save the workbooks, if I am trying to vlookup from other worksheets and not applying as paste special then trying to save with formula. When I press it save , showing save and excel get close it automatically and next time we open excel , we get a reply to excel was not save correctly. Which version you need to recover this.
2. Unable to save default font and size. File will save successfully. Next time, we open excel , nothing will happen changes will not take effect.
Requesting your help to address this.

[@SandeepSharma-yk7zm]

Sir,
How to send multiple emails having different salutations but text will remain same and also had attached file in Outlook and if there need to mention another email addresses in CC. If I have four accounts in Outlook then how to select the one so that emails do not go from other un desired email addresses. Need to send at least 100 email letters at a time. Pl reply

[@prashanttyagi1156]

Formula ko edit mode mein select kerke f9 press kerna hai, aa se hi seekh Chuka huun pehle

[@ShankarKumar-po3jb]

Sir , apne excel me , Time ke upar koi video nhi banaya ,
Sir aap please time ke upar 1 detail video bana do ,

[@Innozant]

👍

[@Prakash-fe8xy]

Hi Bro,
I need a help from you I got a mail from my trainer. It's an excel sheet its confidential mail that excel will not possible to download copy forward print save only option just view only it will expire soon. Please give me a solution for how to download.

[@lutfishaban9077]

Learn and teach

[@radhanathsikder1921]

B11:B300=Date F11:F300=company G11:G300=product name M11:M300=quantity. Multiple sheets 1 October 2023 किस कंपनी के कितना पेंसिल Sale किया, 2 October कितने बुक Sale किया है Excel formula (example: total 250 sheets)

[@vijaykumarjain3222]

Sir what is the main criteria of fixing formula or function in Excel, it's make very confusing sometimes ,what is array

[@Innozant]

Kindly lesrn step by step course frol basic excel playlist onwards .koi doubt nhi aayega aapko

[@Team-gq2ee]

I really need the missing handle trick

[@shrikantbadge3978]

छोटी छोटी मगर मोटी बाते

[@Innozant]

Thanks

[@vikaskohli1375]

Sir Mis executive ke interview me technical round me konse questions Jada puche jate hai..please reply

[@Innozant]

Sumifs ,countifs,lookup series aur pivot prepare kar lein

[@vikaskohli1375]

Nhi Sir Mera matlab hai theory round mai jese ki what is vlookup and all...

[@jigneshgandhi3195]

I want to learn VBA, can you reply me

[@Innozant]

Kindly connect with team innozant for more information

[@shivii88]

Intro mein maja a jata h sir

[@tejpalsain1507]

❤