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

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
Follow us on
instagram
Twitter
Facebook
MS Excel Videos
MS Excel for Beginners
Excel VBA
MS Word
MS PowerPoint
MS Access
MS Paint
MSW Logo
Notepad & HTML
CSS
JAVA
PHP
Python
Photoshop
Full Tutorial
Computer Education
Other
Tally
Internet
Computer GK
Google Sheet
Invoice in Excel
Reasoning
Airthmatics

[atulkumargaikwad]

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

[nitishsaharoy]

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

[PhaniRaj]

Super and fantastic, thank you very much dear sir

[sumeraali]

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

[bilash]

Sir how to combined multiple sheet in one sheet.

[prashanttyagi]

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.

[juleerathore]

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

[ucwehwq]

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

[sohansahu]

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

[DDX]

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

[chanderprakash]

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
.
.
.
.
Sir Plz tell me
I am waiting