Top 5 Excel Formatting Cool Tricks | What's hidden?
HTML-код
- Опубликовано: 5 окт 2024
- 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
Sir muze aapke sikhane se jyada aapla presentation bahut achha lagta hai.
Thanks Anil Ji...🙏❤️
Good morning sir.
Such nice trick.
Last one very nice and joyful.
Thanks Tejpal🙏❤️
Sir you are Excel Guru 🙏🙏🙏
Thanks Ashish Ji
You are an amazing teacher🤗🤗🤗😊😊😊
Thanks dear
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
Thanks Jayanta..Happy Learning 🙏
Namstai sir ji Yai tools bahut hi useful hai. Bahut achai sai batya aapnai. Thank u so much.
Namaste Sandeep Aswal sahab..acha lga apko phirse on track aate dekhke..God bless you
It's very cool features thanku 🙏🙏🙏. Good night sir
Thanks Satish ji❤️🙏
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
Thanks Rajiv Ji🙏❤️
Thank u sir... Background puzzle
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😛
Thanks Mahesh Ji..Happy Learning dear🙏❤️
Awesome creativity sir👌👌👏👏🔥🔥
Thanks Raza🙏❤️
Very very informative
Thanks Pabitra❤️🙏
Very nice techniques sir thank you
Thanks Pramod Ji❤️
Really amazing sir.
Thanks Vikas ❤️
Very unique aur majedaar
Thanks Suraj🙏❤️
सर जी, क्या Cool है आप और आपकी Bonus Trick !!! ❤️ लाजवाब ❤️ !!!
माफ कीजिये, एक सवाल = Cell formatting में अंको को Lacs में दिखाना हो तो कैसे करे ???
कृपया बताये 🙏🙏🙏🙏
Thanks Shukla ii❤️🙏
Excellent sir
Thanks ❤️🙏
Very useful video Sir g
Thanks Khalid sahab❤️🙏
Wow
Excellent
Thanks Arif sahab
Dil jeet liya sir jii aapne to.... very excellent...😍❤❤❤
Thanks Jitender jI🙏👍
Last one was soo cool and informative 🙏🙏🙏
Thanks Suvankar 🙏❤️
Very great sir
Thanks ❤️🙏
Sir your every tutorial are fantastic and more informative 👌🏻🤗
Thanks a lot for this Respected Sir 🙏🤗👌🏻
Thanks Akash Ji...Happy Learning
Sir ji tussi great ho
nice tricks sir thanks
Thanks Shruti❤️❤️❤️🙏🙏
Very useful topic....👍🙏🙏🙏❤️❤️
Thanks sir....
Thanks dear❤️🙏
❤ jabardast sir
Excellent
Thanks Saroj
जबरजस्त भाई 👌👌👌👍
Thanks Rajesh Ji🙏❤️
Nice tricks Sir
Thanks Vivek ji❤️🙏
very nice sir...
Thanks dear🙏❤️
Very good sir
Thanks Durgesh ji❤️🙏
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🙏
Hahaha..Love you dear Mahesh ji🙏❤️
Thats was amazing
Thanks Chandan ji
Awesome 👍🏻🔥
Thanks Sameer ji
Good sir
🙏👍 Great Sir
Thanks 🙏❤️
Tq.....sir
Dear Sir
All the tricks explained in tutorial are Bonus, however the last one is super bonus!!
Regard
Mehtag
Thanks Gulshan...Happy Learning 🙏❤️
Wow sir ..yhi to chahiye tha
Thanks Sonu🙏❤️
Sir apke mind me itne idias aate kaha se such me Mai to kabhi kabhi hairan ho jaati hu 😀😀😀🍫🙏🙏
Thanks Pragati..😀Acha ji ..pasand aaya video aapko🙏❤️❤️
@@Innozant ha sir apke to Sare videos pasand aate because Sare video hi helpful hote hai 😊😊😊😊😊
Just Wow...
Thanks Sajeed❤️🙏
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.
Nice👍
Thanks Nilesh Sahab..❤️🙏Nice Proquest Solution..keep it up
Super
Thanks Dev❤️🙏
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.
Superb 🙏🏾🔥
Thanks ❤️🙏
Gjb sir ❤️❤️
Thanks Bhati sahab❤️🙏
supper 😍
Thanks ❤️🙏
Sir row or column ko colour se highlights kaise kare
Conditional formatting apply kariye based on your requirement
Merge centre was cool trick… hours duration can also be changed from time format
Thanks dear Gaurav ji❤️🙏
Nyc sir
Thanks Vivek ji
sir trick 4 main LACS ki formats kaise karenge
Ex. 4567000= 45.67 Lacs
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
Add kar denge kisi tricks video me.🙏
@@Innozant Thank you so much Sir
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.
Sent query with explanation on @innozantofficial telegram id
Aap ka javab nahi sir thank you
Thanks Kishor❤️🙏
कया तारीफ़ करे साहेब
Thanks Atul ji❤️🙏
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???
What formula you are looking for
@@Innozant
IF Formula for Income tax calculation
🙏🙏🙏🙏
👍❤️🙏
Easy Source Hr Solutions Pvt Ltd.( )How Many "s" in this line ?
You want to count what? Space or word ?
@@Innozant only word
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
dd krte hajn kisi video me ye query aapki
@@Innozant Thanks sir
Tq.....sir