Top 25+ Excel Tips and tricks | Top Advanced excel Tips to make you awesome

Рет қаралды 37,581

Күн бұрын

Top 25+ Excel Tips and tricks | Top Advanced excel Tips to make you awesome
#msexcel #exceltips #computergyanguruji
Our second channel
‪@ComputerGurujiTechnical‬
‪@GurujiComputerCourse‬
Topic in This video
00:00 intro
00:42 Across worksheet
03:03 Insert blank row trick 1
03:54 Insert blank row trick 2
04:45 Freeze header row | table format
06:28 Freeze last row
07:49 Intro
08:37 set print area
09:37 Repeat header row
10:42 Hide data
11:52 Hide Zeero
12:49 Copy and paste
13:58 Change upper case without formula
15:08 Highlight blank cell
15:40 Fill blank cell
16:20 Transpose Data
17:13 Office clipboard
18:32 massage box in data validation
13:01 picture comment
21:58 align center in selection
22:49 Delete blank
23:35 Remove Duplicate
24:14 Highlight Duplicates
25:08 Move sheet in new workbook
26:03 Insert worksheet in bulk
28:03 filter by selected cell
28:47 move columns
29:35 copy visible cells only
30:49 custom formatting custom numbers
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
Excel VBA
• Excel VBA
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
CSS
• Introduction to CSS | ...
JAVA
• JAVA Script
PHP
• PHP
Python
• Python
Photoshop
• Photoshop
Full Tutorial
• Full Tutorial
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Google Sheet
• google sheet
Invoice in Excel
• Invoice In excel
Reasoning
• Reasoning
Airthmatics
• Airthmetic

Пікірлер: 25

@atulkumargaikwad9368 Жыл бұрын

आपका सिखानेका तरीका बहुत बेहतरीन है. हमे तो बहुत पसंद आया.

@sirajmaseed5599 10 ай бұрын

سر بہت خوب زبردست

@krishnatate4765 3 ай бұрын

Useful tricks 😊

@nitishsaharoy2917 Жыл бұрын

Thank you Gyan Furuji. Keep giving us value. We are always with your channel.

@sachinkale4544 Жыл бұрын

Most usefull...

@parasvora8134 Жыл бұрын

Thanks 👍 guruji

@MdShamim-fv2kx 11 ай бұрын

thanks for tricks

@bittu25 10 ай бұрын

Thanks

@PhaniRaj1970 Жыл бұрын

Super and fantastic, thank you very much dear sir

@syedikramullah1114 Жыл бұрын

Nice

@goutamgolui866 Жыл бұрын

Nice tricks 👌

@user-kc1um9tp8v 10 ай бұрын

🙏🙏🙏🙏

@pinakiwb Жыл бұрын

👍

@sumeraali9040 11 ай бұрын

Plz let me know how to create slides on PowerPoint???

@bilash76 11 ай бұрын

Sir how to combined multiple sheet in one sheet.

@prashanttyagi1156 Жыл бұрын

Sir mujhe aap ki help chahiye excel mein, mujhe ik stock managment sheet banani hai. Jise maine ik hi sheet mein 3 part mein divide kiya hai like, stock in, us mein coloum hai a mein date, b mein rack no ( rack no 1-a,1-b) aise hai ik rack mein ,e tak coloum hai total 500tak hai , c coloum mein item code hai, d mein total qty hai, ik item code ki item kaeen rack mein hoti hai, second coloum mein stock outward hai, same coloum hai item code aur rack no manualy dalne hote hai, 3 coloum hai stock in hand, jismein jo item code hai wo aaye jo outward hovraha hai . Ab main kon sa formulavuse karun ki mujhe mujhe rack wise bhi balance stock mile aur jitne item code oyt ward huaae un kavtotal balance mile , jaise mere pass a-001 ik item hai aur mere pass ik rack a-1 mein 100 pcs hai ye hi item code c-2 mein bhi hai 100 pcs ,, outward huaa hai 50 pcs rack a-1 se tovtotal item aty balace bhi show kare aur rack wise bhi a-1 se 50 huaa wo show kare, koi formula ho to bataye , sumif use kiya hai lekin us mein rack se qty less karke total qty bata hai us item ki , rack wise nahi batata samjh nahi aavrahabkya karu .agar koi formula hai to reply mein kare ya apnavemail de to main aap ko sheet send karun.

@juleerathore1559 6 ай бұрын

Sir mere pas exam ke roll or subject online uthati hu to jo subjects code hote he unko me copy karti hu to Excel me subject code mix ho jate he to aap bataiye ki me kese subject wise set karu

@AnkitSingh-ib7up 2 ай бұрын

Job kese milega

@user-uc3we7hw1q 11 ай бұрын

MUJHE 20 DIGIT NUMBER USE KARNA BUT 15 DIGIT KE BAAD AUTO 00000 AA JATI HAI KAISE KARE

@sohansahu84 3 ай бұрын

आपके द्वारा नंबर टू हिंदी का add ins काम नही कर रहा है #NAME एरर आ रहा है

@ComputerGyanGuruji 3 ай бұрын

Check macro name

@DDX01 9 ай бұрын

Sir fill across worksheets me b to column width nhi barha ap data samet fill across worksheet krte. Is ka 1 aur tariqa b hai k ap data wale columns select kr k copy kre aur next sheet me insert column kre to b ap k same to same data with formating with column width aye ga. Thanks

@chanderprakash3418 11 ай бұрын

hlo sir my big problem in excel mein Mera question h , Ek folder me Mane 1-100 Tak numbering foto rakhi Hui h Mane un foto ka path Excel me leker gya For example D/chander/foto/1.jpeg . . . . Sari foto ka path niche drag krta hu to same. Path copy hota h Photo ka number change nhi hota h Example D/chander/foto/1.jpeg D/chander/foto/1.jpeg D/chander/foto/1.jpeg D/chander/foto/1.jpeg . . sir koi esa trika batio Foto path Excel me drag karne sath sath uski numbering bhi change ho mein Manualy karta hu to bhut time vest hota h ji Example D/chander/foto/1.jpeg D/chander/foto/2.jpeg D/chander/foto/3.jpeg D/chander/foto/4.jpeg . . . . prnt.sc/e_S-8WA7VIaP Sir Plz tell me I am waiting

@tatyasokale8402 11 ай бұрын

Sir, have their online class

@BGarvitAgrawal 10 ай бұрын

Use left function, sequence, right and concatenate