Тёмный
No video :(

Top 5 Excel Formatting Cool Tricks | What's hidden? 

Innozant
Подписаться 151 тыс.
Просмотров 13 тыс.
50% 1

Top 5 Excel Formatting Cool Tricks | What's hidden?
1.Merging without merging
2.Merge multiple cells
3. No Decimals
4. Showing numbers in Thousands or millions with Custom cell formatting
5. Total Hours
Bonus Tricks-Whats Hidden?
Excel Tips & Tricks Playlist Link- • Excel Tips & Tricks
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========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...
#exceltipsandtricks #cooltricksexcel#innozant #top5formattingtricks

Опубликовано:

 

19 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 120   
@anilbagul1046
@anilbagul1046 3 года назад
Sir muze aapke sikhane se jyada aapla presentation bahut achha lagta hai.
@Innozant
@Innozant 3 года назад
Thanks Anil Ji...🙏❤️
@sandeepaswal8944
@sandeepaswal8944 3 года назад
Namstai sir ji Yai tools bahut hi useful hai. Bahut achai sai batya aapnai. Thank u so much.
@Innozant
@Innozant 3 года назад
Namaste Sandeep Aswal sahab..acha lga apko phirse on track aate dekhke..God bless you
@ashishshiriskar123
@ashishshiriskar123 3 года назад
Sir you are Excel Guru 🙏🙏🙏
@Innozant
@Innozant 3 года назад
Thanks Ashish Ji
@tejpalsain1507
@tejpalsain1507 3 года назад
Good morning sir. Such nice trick. Last one very nice and joyful.
@Innozant
@Innozant 3 года назад
Thanks Tejpal🙏❤️
@maheshswami2064
@maheshswami2064 3 года назад
Sir pahala wala trick..Without merge to merge .. shandaar tha .. bahot useful bhi h daily work me Thanks for it:) Baaki aage ke video dekh rha hu😛
@Innozant
@Innozant 3 года назад
Thanks Mahesh Ji..Happy Learning dear🙏❤️
@satishojha6240
@satishojha6240 3 года назад
It's very cool features thanku 🙏🙏🙏. Good night sir
@Innozant
@Innozant 3 года назад
Thanks Satish ji❤️🙏
@surajtiwari872
@surajtiwari872 3 года назад
Very unique aur majedaar
@Innozant
@Innozant 3 года назад
Thanks Suraj🙏❤️
@jayantabhattacharyya628
@jayantabhattacharyya628 3 года назад
Dear Sir Excellent excel formatting cool tricks which I don't know. It will help me to know excel better. But the last trick is really very useful & interesting which I enjoy very much. Thanks & Regards Jayanta Bhattacharyya
@Innozant
@Innozant 3 года назад
Thanks Jayanta..Happy Learning 🙏
@mdshahnawazahmad6070
@mdshahnawazahmad6070 2 года назад
You are an amazing teacher🤗🤗🤗😊😊😊
@Innozant
@Innozant 2 года назад
Thanks dear
@atiqrehman1223
@atiqrehman1223 Год назад
Sir ji tussi great ho
@amanyadav0812
@amanyadav0812 3 года назад
Thank u sir... Background puzzle
@rajeshgadge8595
@rajeshgadge8595 3 года назад
जबरजस्त भाई 👌👌👌👍
@Innozant
@Innozant 3 года назад
Thanks Rajesh Ji🙏❤️
@pradeepnegi7523
@pradeepnegi7523 Год назад
❤ jabardast sir
@nitinshukla914
@nitinshukla914 3 года назад
सर जी, क्या Cool है आप और आपकी Bonus Trick !!! ❤️ लाजवाब ❤️ !!! माफ कीजिये, एक सवाल = Cell formatting में अंको को Lacs में दिखाना हो तो कैसे करे ??? कृपया बताये 🙏🙏🙏🙏
@Innozant
@Innozant 3 года назад
Thanks Shukla ii❤️🙏
@pramodbhavsar4488
@pramodbhavsar4488 3 года назад
Very nice techniques sir thank you
@Innozant
@Innozant 3 года назад
Thanks Pramod Ji❤️
@pabitrapaul2908
@pabitrapaul2908 3 года назад
Very very informative
@Innozant
@Innozant 3 года назад
Thanks Pabitra❤️🙏
@rajivranjan-mf6zu
@rajivranjan-mf6zu 3 года назад
Sir your u hv a great concept to teach all the tricks this type of skill level not found on any youtube channel.... hats off sir.... Thank u so much
@Innozant
@Innozant 3 года назад
Thanks Rajiv Ji🙏❤️
@Jitenderkumar-yp1rn
@Jitenderkumar-yp1rn 3 года назад
Dil jeet liya sir jii aapne to.... very excellent...😍❤❤❤
@Innozant
@Innozant 3 года назад
Thanks Jitender jI🙏👍
@vikaskumar-wr3bz
@vikaskumar-wr3bz 2 года назад
Really amazing sir.
@Innozant
@Innozant 2 года назад
Thanks Vikas ❤️
@razamoulvi8801
@razamoulvi8801 3 года назад
Awesome creativity sir👌👌👏👏🔥🔥
@Innozant
@Innozant 3 года назад
Thanks Raza🙏❤️
@khalidalisubhanallah2947
@khalidalisubhanallah2947 3 года назад
Very useful video Sir g
@Innozant
@Innozant 3 года назад
Thanks Khalid sahab❤️🙏
@pradeepjangid490
@pradeepjangid490 3 года назад
Excellent sir
@Innozant
@Innozant 3 года назад
Thanks ❤️🙏
@The-Fronted
@The-Fronted 3 года назад
Wow Excellent
@Innozant
@Innozant 3 года назад
Thanks Arif sahab
@createyour6681
@createyour6681 3 года назад
Very great sir
@Innozant
@Innozant 3 года назад
Thanks ❤️🙏
@TheSuvankarKundu
@TheSuvankarKundu 3 года назад
Last one was soo cool and informative 🙏🙏🙏
@Innozant
@Innozant 3 года назад
Thanks Suvankar 🙏❤️
@pragatirai9512
@pragatirai9512 3 года назад
Sir apke mind me itne idias aate kaha se such me Mai to kabhi kabhi hairan ho jaati hu 😀😀😀🍫🙏🙏
@Innozant
@Innozant 3 года назад
Thanks Pragati..😀Acha ji ..pasand aaya video aapko🙏❤️❤️
@pragatirai9512
@pragatirai9512 3 года назад
@@Innozant ha sir apke to Sare videos pasand aate because Sare video hi helpful hote hai 😊😊😊😊😊
@sonukumarskp6933
@sonukumarskp6933 3 года назад
Wow sir ..yhi to chahiye tha
@Innozant
@Innozant 3 года назад
Thanks Sonu🙏❤️
@sarojkumarsahu2858
@sarojkumarsahu2858 2 года назад
Excellent
@Innozant
@Innozant 2 года назад
Thanks Saroj
@prochallengers8920
@prochallengers8920 3 года назад
nice tricks sir thanks
@Innozant
@Innozant 3 года назад
Thanks Shruti❤️❤️❤️🙏🙏
@durgeshrai8938
@durgeshrai8938 3 года назад
Very good sir
@Innozant
@Innozant 3 года назад
Thanks Durgesh ji❤️🙏
@vivekthakur2334
@vivekthakur2334 3 года назад
Nice tricks Sir
@Innozant
@Innozant 3 года назад
Thanks Vivek ji❤️🙏
@chandannekesh
@chandannekesh 3 года назад
Thats was amazing
@Innozant
@Innozant 3 года назад
Thanks Chandan ji
@abusiddik8265
@abusiddik8265 3 года назад
Very useful topic....👍🙏🙏🙏❤️❤️ Thanks sir....
@Innozant
@Innozant 3 года назад
Thanks dear❤️🙏
@adnanshoukat807
@adnanshoukat807 3 года назад
very nice sir...
@Innozant
@Innozant 3 года назад
Thanks dear🙏❤️
@akashindian8436
@akashindian8436 3 года назад
Sir your every tutorial are fantastic and more informative 👌🏻🤗 Thanks a lot for this Respected Sir 🙏🤗👌🏻
@Innozant
@Innozant 3 года назад
Thanks Akash Ji...Happy Learning
@nagarajalingayath
@nagarajalingayath 3 года назад
🙏👍 Great Sir
@Innozant
@Innozant 3 года назад
Thanks 🙏❤️
@sajeedahmed7837
@sajeedahmed7837 3 года назад
Just Wow...
@Innozant
@Innozant 3 года назад
Thanks Sajeed❤️🙏
@theoffsideartist
@theoffsideartist 3 года назад
Awesome 👍🏻🔥
@Innozant
@Innozant 3 года назад
Thanks Sameer ji
@harishbhati3651
@harishbhati3651 3 года назад
Gjb sir ❤️❤️
@Innozant
@Innozant 3 года назад
Thanks Bhati sahab❤️🙏
@sadashivkage3133
@sadashivkage3133 Год назад
Tq.....sir
@maheshswami2064
@maheshswami2064 3 года назад
Sir rashtrapati se award milna chahiye aapko to😃 Each trick is very useful You able to catch the problematic things which is in the mind of data analyst and u resolve that problems here like a pro🙏
@Innozant
@Innozant 3 года назад
Hahaha..Love you dear Mahesh ji🙏❤️
@nileshchavan742
@nileshchavan742 3 года назад
Nice👍
@Innozant
@Innozant 3 года назад
Thanks Nilesh Sahab..❤️🙏Nice Proquest Solution..keep it up
@PopatMomu
@PopatMomu 3 года назад
Super
@Innozant
@Innozant 3 года назад
Thanks Dev❤️🙏
@gulshanmehta6997
@gulshanmehta6997 3 года назад
Dear Sir All the tricks explained in tutorial are Bonus, however the last one is super bonus!! Regard Mehtag
@Innozant
@Innozant 3 года назад
Thanks Gulshan...Happy Learning 🙏❤️
@ramuluvarkala9656
@ramuluvarkala9656 2 года назад
Sir, how can I formatting the following conditions My shift scheduled from 16th of this month to next month 15th in that every sunday ,1st & 3rd Saturdays cells to be format or hilighted dynamically when I change the month Thankyou sir.
@amitpyasi2819
@amitpyasi2819 2 года назад
Sir row or column ko colour se highlights kaise kare
@Innozant
@Innozant 2 года назад
Conditional formatting apply kariye based on your requirement
@fortunatelythescene8205
@fortunatelythescene8205 3 года назад
Superb 🙏🏾🔥
@Innozant
@Innozant 3 года назад
Thanks ❤️🙏
@muhammadbilal1947
@muhammadbilal1947 3 года назад
supper 😍
@Innozant
@Innozant 3 года назад
Thanks ❤️🙏
@jyotikumari-rl3er
@jyotikumari-rl3er 2 года назад
Sir, can you help on below formatting requirement Positive Values greater than 0.5 (apper in positive) Negative value greater than -0.5 like -0.6 or more (apper under bracket in red) Any number apart from that (0,0.4, -0.4) should apper as "-". All numbers should be in thousands without decimal points and alignment should be equal.
@vivekkalshan3589
@vivekkalshan3589 2 года назад
Nyc sir
@Innozant
@Innozant 2 года назад
Thanks Vivek ji
@kishorpanara4191
@kishorpanara4191 3 года назад
Aap ka javab nahi sir thank you
@Innozant
@Innozant 3 года назад
Thanks Kishor❤️🙏
@pksirknowledge
@pksirknowledge 2 года назад
sir trick 4 main LACS ki formats kaise karenge Ex. 4567000= 45.67 Lacs
@gauravrai30
@gauravrai30 3 года назад
Merge centre was cool trick… hours duration can also be changed from time format
@Innozant
@Innozant 3 года назад
Thanks dear Gaurav ji❤️🙏
@atulshukal4072
@atulshukal4072 3 года назад
कया तारीफ़ करे साहेब
@Innozant
@Innozant 3 года назад
Thanks Atul ji❤️🙏
@ghumansaab2314
@ghumansaab2314 3 года назад
Sir agar me value decimal me enter karu to hi decimal number show kare agar whole number enter karu to whole number show kare aise possible ho sakta hai kisi formatting se
@Innozant
@Innozant 3 года назад
Add kar denge kisi tricks video me.🙏
@ghumansaab2314
@ghumansaab2314 3 года назад
@@Innozant Thank you so much Sir
@KayDee2021
@KayDee2021 3 года назад
I want a help in excel. The problem is as below. 1. Vir Chakra 2. Maha Vir Chakra 3. Advanced 4. Advanced Arithmetic 5. Advanced Arithmetic Algebra I want to highlight or Find or Search the repetition of one word within another phrase or multiple word format. Like i want to see where all Vir Chakra has been also included in Other sentences like it is repeated in Maha Vir Chakra, but after the word Maha. In the same table there is Advanced which is repeated in two more rows below it. I have thousands of words like this in my database and i want to highlight them or atleast find them. Please help me.
@Innozant
@Innozant 3 года назад
Sent query with explanation on @innozantofficial telegram id
@manojkumarsingh3385
@manojkumarsingh3385 3 года назад
🙏🙏🙏🙏
@Innozant
@Innozant 3 года назад
👍❤️🙏
@desu.usharani9904
@desu.usharani9904 2 года назад
Hi sir I want formula on Tax calculation for income tax limits . Upto 2.5 lakh - exempt 2.5 lakh to 5 lakh - 5% 5lakh to 10lakh -20% >= 10 lakh - 30% If income is 545678 how to calculate tax payable amt ,how to apply the formula sir???
@Innozant
@Innozant 2 года назад
What formula you are looking for
@desu.usharani9904
@desu.usharani9904 2 года назад
@@Innozant IF Formula for Income tax calculation
@thegardener_mk8150
@thegardener_mk8150 3 года назад
Easy Source Hr Solutions Pvt Ltd.( )How Many "s" in this line ?
@Innozant
@Innozant 3 года назад
You want to count what? Space or word ?
@thegardener_mk8150
@thegardener_mk8150 3 года назад
@@Innozant only word
@manojkumarsingh3385
@manojkumarsingh3385 3 года назад
Sir Humari ek problem hai Jo main aap ke sath share Kar Raha hoon "B I M J K S U P X Y " '1234567890' SIR AGAR HUM 12,565 Likhe to O convert ho Jaye BIKSK KE ROOP ME please help me sir
@Innozant
@Innozant 3 года назад
dd krte hajn kisi video me ye query aapki
@manojkumarsingh3385
@manojkumarsingh3385 3 года назад
@@Innozant Thanks sir
@gauravbhatia7987
@gauravbhatia7987 3 года назад
Good sir
@sadashivkage3133
@sadashivkage3133 Год назад
Tq.....sir