After Microsoft enhanced Excel to the 2013 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. Please note that all these functions are based on Microsoft Excel 2013.
Amazon Auto Links: No products found.
ALL SOFTWARE FOR WINDOWS (link Google Drive all):
Creat USB, HDD boot 1click ALL WIN: http://quainator.com/7K0d
Check USB boot: http://quamiller.com/1nR7
Add hirent boot to HDD 1 click: http://quainator.com/8FhF
Jion and Split all file: http://quamiller.com/4tjX
Ghost Win XPSP3 all main, fast.: http://quainator.com/7QkC
Ghost Win 7 2017 32bit all main, fast..: http://quainator.com/7RHR
Ghost Win 10 Pro 32bit all main update, fast connect: http://quainator.com/7SkL
Ghost Win 7 2017 64bit all main, fast..: http://quainator.com/8TGB
Ghost Win 10 Pro 64bit all main update, fast connect: http://quainator.com/8TJD
Ghost Win 18 Luxury x86 part 1: http://quamiller.com/5cDm http://quamiller.com/5cDm
Ghost Win 18 Luxury x86 part 2: http://quamiller.com/5cJ1 http://quamiller.com/5cJ1
Ghost Win 18 Luxury x86 part 3: http://quamiller.com/5cKF http://quamiller.com/5cKF
Ghost Win 18 Luxury x86 part 4: http://quamiller.com/5cL1 http://quamiller.com/5cL1
Ghost Win 18 Luxury x64 part 1: http://quamiller.com/5c91 http://quamiller.com/5c91
Ghost Win 18 Luxury x64 part 2: http://quamiller.com/5c9r http://quamiller.com/5c9r
Ghost Win 18 Luxury x64 part 3: http://quamiller.com/5cAb http://quamiller.com/5cAb
Ghost Win 18 Luxury x64 part 4: http://quamiller.com/5cBf http://quamiller.com/5cBf
Crack win 7 working 100%: http://quainator.com/7JOj
Crack win 8/10/18 all working 100%: http://quainator.com/7JQf
Auto find All Driver Win XPSP: http://quainator.com/7d92
Auto find All Driver Win 7/8 32bit No crack: http://quainator.com/7eGV
Auto find all Driver Win 10 32bit: http://quainator.com/7fIC
Auto find all Driver Win 7/8 64bit No crack: http://quainator.com/8ftf
Auto find all Driver Win 10 64bit: http://quainator.com/8g7H
IDM 2017 full seri no crack working: http://quainator.com/7Jcl
Microsoft Visual C_ 6.0 Standard Edition http://quainator.com/8IBT
VC_redist.x64 http://quainator.com/8IEc
vclibs_redist_packages http://quainator.com/8IHG
vcredist_x64 http://quainator.com/8IJ4
Winrar 2017 full active: http://quainator.com/8Gzc
Direct X9: http://quainator.com/8FzN
Lite codec Media full: http://quainator.com/8G5z
Microsoft Office 2003 full install: http://quainator.com/8GCb
Microsoft Office 2010 full no crack: http://quainator.com/7Wl7
Microsoft Office 2016 full crack: http://quainator.com/7YvM
Auto Cad 2007 full crack: http://quainator.com/8Fob
Nero Burn room 2017 full crack working 100%: http://quainator.com/7JpB
Tera copy full key: http://quainator.com/8GDw
Ultra Iso full key: http://quainator.com/8GGd
Cut mp3 music: http://quainator.com/8H5A
Change Mp4 to Mp3 http://quainator.com/8H4n
Format factory 2017 full crack: http://quainator.com/8B9o
Install Camera Webcam: http://quainator.com/8Fs6
Kaspersky 2017 free 365 days: http://quainator.com/7Jk5
Deep Freeze 8 full key: http://quainator.com/8FwD
http://www.taiphanmemchuan.blogspot.com
good one 🙂
Thanks in advance provide a file what you have mentioned in your video
Thanks. Just what I’m looking for.
Here all the tricks are
http://bit.ly/2ifyPUN
Thanks, Qureshi!
audio volume low
Useful tricks:
ctrl + shift + any arrow keys
This easily selects the data you want quickly ;).
ctrl + a
Selects all data on many applications, including when you type comments on youtube. Enjoy!
final
very useful tricks….
I can barely hear him. Sound quality is terrible.
hi
Advance Secret Excel Tips and Tricks for all.This video enables you to work independently and very efficiently in excel. You may be a beginner or a pro but this excel tips and tricks will save a lot of time in your workhttps://www.youtube.com/watch?v=ZC2v2PuDnew&t=18s
Thank you so, so much! Is there a way to calculate someone’s age if I put their birthday in one column, and the date at which I want to calculate their age in another column?
lol
they are good!
Thanks a lot sir.
Thankyou keep makin these kinda videos very nice good work
4:12
The infamous Dragon Drop.
Very interesting, its sounds good
OMG the Ctrl+Tab shortcut has opened my eyes to a whole new world: it works with nearly every program, even internet tabs!
If you are going to be fast, split up your tutorial into 2 parts, with 10 tricks in each.
This sucks!
Nice video…
Thank you sir. No doubt great learning video. Please keep posting these videos.
http://cogismith.com/2JVI
I can Make Spread Sheet Excel Based
The many peoples are not very aware of functionalities and formulas of Excel.Therefore, they are not able to work quickly But I have no this problem while entering data on spread sheet because I use functionalities and formulas which results as saving timing my and your as well.
Audio level is low but over all a good video, informative!
This is the worst Excel demonstration!!
Mr. Qureshi thanks for the video, very helpful, just was curious to know how did you fill the cell from 1 to 10 base on the value
Actually good
what a magic…….these tricks are extremely helpful, Jazakallahu bi khair
so hard to follow
Hi,
Could you please explain how you made blue bar, which is getting larger as you go down through the cells ?
http://www.office.com/setup
office.com/setup
Call Now For Instant Support.
Toll-Free: 1-877-840-6894
or
Toll-Free: 1-855-501-1988
voice is not audible sor
Thanks 🙂 🙂
sir. how to convert php file to excel? my costomer give me php file that containt all of the student, he want me to make id card from that php file. (it will take 2 week to copypaste if i do it manual to indesign)
Assalamoalikum
just subscribed you
thnxx it was very helpful for us
Hello:Can I thoroughly hide the heading (header) in a column as well? I notice that the header *Year* was not hidden in the above video.Thank you.
Suleman, do you know how to copy or fill the column letters of a sheet into the first row of a sheet?
Watch then tell
https://youtu.be/seC2pvetxwc
Howdy – (just learned of the 3 ;;; — that’s a new one for me!) But, my odd-ball question is at point 8:05 of video — column B show cells with a diagonal Blue coloring — how did you do that?
Volume too low.
fucking ass hole.. chutiya bana rha.. this is so basic
Excellent and very useful
FOR WINDOWS (link Google Drive all):
Creat USB, HDD boot 1click ALL WIN: http://quainator.com/7K0d
Live creat boot from HDD: http://quainator.com/8Ha9
Add hirent boot to HDD 1 click: http://quainator.com/8FhF
Ghost Win XPSP3 all main, fast.: http://quainator.com/7QkC
Ghost Win 7 2017 all main, fast..: http://quainator.com/7RHR
Ghost Win 10 Pro 32bit update, fast connect: http://quainator.com/7SkL
Crack win 7 working 100%: http://quainator.com/7JOj
Crack win 8/10 all working 100%: http://quainator.com/7JQf
All Driver Win XPSP: http://quainator.com/7d92
All Driver Win 7/8 No crack: http://quainator.com/7eGV
Auto all Driver Win 10: http://quainator.com/7fIC
IDM 2017 full seri no crack working: http://quainator.com/7Jcl
Microsoft Visual C_ 6.0 Standard Edition http://quainator.com/8IBT
VC_redist.x64 http://quainator.com/8IEc
vclibs_redist_packages http://quainator.com/8IHG
vcredist_x64 http://quainator.com/8IJ4
Winrar 2017: http://quainator.com/8Gwo
Winrar 2017 full active: http://quainator.com/8Gzc
Direct X9: http://quainator.com/8FzN
Lite codec Media full: http://quainator.com/8G5z
Microsoft Office 2003 full install: http://quainator.com/8GCb
Microsoft Office 2010 full no crack: http://quainator.com/7Wl7
Microsoft Office 2016 full crack: http://quainator.com/7YvM
Auto Cad 2007 full crack: http://quainator.com/8Fob
Nero Burn room 2017 full crack working 100%: http://quainator.com/7JpB
Tera copy full key: http://quainator.com/8GDw
Ultra Iso full key: http://quainator.com/8GGd
Cut mp3 music: http://quainator.com/8H5A
Change Mp4 to Mp3 http://quainator.com/8H4n
Format factory 2017 full crack: http://quainator.com/8B9o
Install Camera Webcam: http://quainator.com/8Fs6
Kaspersky 2017 free 365 days: http://quainator.com/7Jk5
Deep Freeze 8 full key: http://quainator.com/8FwD
its very informative thanks for shearing