31 Excel Tricks that everyone should know!
ฝัง
- เผยแพร่เมื่อ 26 ม.ค. 2025
- 31 Excel Tricks that everyone should know!
Boost your Excel skills with these 31 must-know tricks! From shortcuts to advanced tips, this guide will make your workflow faster and smarter. Perfect for beginners and pros alike. 📊✨
Practice File Link:drive.google.c...
Timestamp
0:53 :- CREATE CUSTOM LIST
4:16 :- AUTOCORRECT
6:34 :- ADD TO QUICK ACCESS TOOLBAR
7:42 :- PRESS ALT + TO ACCESS OF QUICK ACCESS
9:29 :- OPEN A COPY
10:21 :-NAME BOX - JUMP TO CELL
11:59 :- COPY SEPRATE - CLIPBOARD
14:25 :- PIN FILES
15:08 :- ENABLE DARK MODE
15:48 :- FROMAT PAINTER
17:24 :- FLASH FILL
20:48 :- REMOVE DUPLICATE
21:49 :- TOP 5
22:51 :- CUSTOM SORT
24:25 :- ANALYZE DATA
26:22 :- HIDE NUMBERS - CUSTOM CELLS - ;;;
27:42 :- GOTO SPECIAL
28:28 :- PASTE SPECIAL - REMOVE FORMULA
29:44 :- ALT + ENTER
30:26 :- CTRL + F -FIND ALL
31:58 :- VIEW -NAVIGATION
32:51 :- INSERT PICTURE
34:29 :- CTRL + T -TABLE
35:50 :- INCREASE RANGE OF FORMULA
36:45 :-GOAL SEEK
39:28 :-FORMULA TEXT
41:09 :-F9 - IN FORMULA
41:51 :-PIVOT TABLE TRICKS
42:34 :-RECOMANDED PIVOT TABLES
43:38 :-SHOW REPORT FILTER PAGES
Learn Free AI Masterclass : • A.I. Masterclass for D...
Subscribe to Satish Dhawale: / @satish_dhawale
👉 LinkedIn : / satish-dhawale
Follow me on LinkedIn for daily updates and lessons
Get Free Notification for Upcoming Videos = forms.gle/9G2x...
A.I. Masterclass for Data analyst learn to create dashboard using ChatGPT
: • A.I. Masterclass for D...
#ExcelTips
#LearnExcel
#exceltricks
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_c...
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia...
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/le...
------------------------------------------------------------------------------------------------------------------------------
For Short tips : / @skill-course
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more_pro
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My TH-cam Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu
The best thing in your videos is that you providing the practice file link. Thanks...
Sir aap bahut sare videos daalte hai utub per 5 se 6 hours tak ke sir aapko ek excel ke sabhi tabs ka details video daalna chahiye please sir 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉 sir meri request ko seriously liya jaye main bhi aapke students main se ek hoon
Always favourite teacher.
Congratulations. One of the best presentation I have seen on Excel. Most fail by quickly showing how to move from one step to next without showing what commands are in use. In this video, I like that I can follow what menu/commands are in use. Keep the good work. I will look out for your videos.
Well Explanation👏👏
I learn a lot from here.
Thankful🙏
You are Life Saver Sir..All Respect to you
Interesting video
Very nice 👍
Very nice class
Ayse hi video banate rahe thanku sir🎉🎉😊
Dear, you did a good job, it will help to enhance productivity, waiting for more chapters of Power BI, Python
Maja aa gaya sir ❤❤
Thanks for you dear Satish Sir good information and Explaination video for Excel tricks 🎉🎉🎉
Very nice video
very nice sir
Very useful video
Very nice videos sir.
🙏🙏🙏 thanks sir
Thanks for you dear Satish Sir good information and Explaination video for Excel 31formulas🎉🎉🎉
Yes Sir Create a video of detail Excel All Tabs With Full Detail 😊😊😊😊😊
Aap ki Mehnat ko salam sir
Thanks 😊
Very powerful video sir
Thank you Satish sir as always your one single video is very informative I learn a lot from here ...niceeeee vedio sir A big salute 🫡 respected 🎉🎉
Legend Computer Teacher
Custom formating par video banaiye 😊
Good morning sir ji
Good
2019 or bellow me chalege kya sab formula?
Best
Sir ap Excel konsa use krte ho please reply
Thank you sir but to save your video to my playlist is missing😊
Dear Satish Sir plz ek video excel ke all tab ke shortcut pr video banao home tab ke all functions, insert,view,page layout,all plz
Sir i'm from pakistan how to enroll you're excel course
❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤ very very most important video thanks sir
Questions/query - when I download GL from tally it gives amount with custom DR and CR sign instead of - minus sign for credit. How can I replace amount with custom CR with minus. I do not want to use filter.
Sir skill course application iPhone ke liye bhi hai kya Kaha se download hoga
Sir I From Pakistan And I Learn Ms Office From Your TH-cam channel Sir You Are Great 😃😃👍👍 Amazing 😍😍😍 Teacher.
Sir I Request You Please Create a Full Detail Excel All Tabs With Practice Full Explanation Video. Because I lot of search TH-cam video About Excel All Tabs But No proper guide video I find in TH-cam so please you create all Excel tab detail video.
sir alright video post on youtube ,watch excel tutorial channel 😊
Kya sir advance Excel course mil sakta hai
Dear sir ...
Please upload a detailed vedio of all features and tab with excel worksheet whose display same time when we working.
Pc me deep ki volume aa Rahi ha to koi tips
Excel Ka new version de dijiye sir
Sir ms word me A0 our A1 size ka paper kaise set karen
Sir app se sikna starts se step by step
Sir mera excel mein salary sheet banata waqt basic salary mein five digits number type
karke enter baad uska last two digits invisible ho jata hai. Ise thik kaise kare sir?
Flesh fill 2010 me apply kaisy kry
Kya video hai.
Sir Mera se flash fill work nhi kam kwr rha hai Mera pass excel 2021 hai plz sir solve kar digea ap jaysa bola waha hi Kiya hu tab v nhi ho rha hai
FLASH FILL KA USE KARNE KE LIYE. APKO *JO DATA HAI* USKE RIGHT SIDE PE EK EXAMPLE DENA PADEGA. EXAMPLE DENA JARURI HAI. PHIR APP KEYBOARD SE CTRL+E PRESS KAR SAKTE HAIN. WORK KAREGA.
🎉🎉🎉🎉
Sir How earn money online...
Practice file
Given in the description. Kindly check it
A B C D
Date Sales Month Total Nos of Order
2-Mar-24Ordered Mar-24 1
15-Mar-25 Mar-25 0
28-Feb-24Ordered Feb-24 1
20-Mar-25 Jan-25 0
5-Mar-23 Mar-25 0
=COUNTIFS(A:A,">=" & DATEVALUE("01-" & C2), A:A, "
Pls talk in English Sir,
Try some new
You waste my time
You don't come direct to point