Excel Tutorial | 20 Tricks & Shortcuts That Can Make Anyone An Excel Expert

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.

Comments

ALL SOFTWARE FOR EVERYBODY says:

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

Ashish Kumar says:

good one 🙂

brahmam v says:

Thanks in advance provide a file what you have mentioned in your video

HowToExcel says:

Thanks. Just what I’m looking for.

Shop on says:

Here all the tricks are
http://bit.ly/2ifyPUN

Jeff Banei says:

Thanks, Qureshi!

Vijay Srivastava says:

audio volume low

The Heretic says:

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!

Rashed bonanza says:

final

Rohit Sachan says:

very useful tricks….

Azam Nemati says:

I can barely hear him. Sound quality is terrible.

Asfiya Zainab says:

hi

Accounting Tutorial says:

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

-Missy- says:

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?

Filip Janowski says:

lol

Sarika Biwalkar says:

they are good!

kajal mathur says:

Thanks a lot sir.

sankalp nagar says:

Thankyou keep makin these kinda videos very nice good work

Rick S says:

4:12
The infamous Dragon Drop.

mohammed asif says:

Very interesting, its sounds good

Laura Pantelakis says:

OMG the Ctrl+Tab shortcut has opened my eyes to a whole new world: it works with nearly every program, even internet tabs!

Sridhar Kaushik says:

If you are going to be fast, split up your tutorial into 2 parts, with 10 tricks in each.
This sucks!

I Turn says:

Nice video…

OSAMA JAVAID says:

Thank you sir. No doubt great learning video. Please keep posting these videos.

SEO says:

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.

IT Success Center says:

Audio level is low but over all a good video, informative!

RAFAEL CANELA says:

This is the worst Excel demonstration!!

mohamed abubaker says:

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

Rijul Chawla says:

Actually good

Sulaiman Muhammad says:

what a magic…….these tricks are extremely helpful, Jazakallahu bi khair

tina:D says:

so hard to follow

MISComputerNET says:

Hi,

Could you please explain how you made blue bar, which is getting larger as you go down through the cells ?

John Bonnie says:

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

Susheel Kumar says:

voice is not audible sor

Kosta Stanic says:

Thanks 🙂 🙂

akha80 says:

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)

moinuddin khan says:

Assalamoalikum
just subscribed you

vick gupta says:

thnxx it was very helpful for us

ivor worrell says:

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.

Cynthia Szczepaniak says:

Suleman, do you know how to copy or fill the column letters of a sheet into the first row of a sheet?

kraftyiam says:

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?

Velo1010 says:

Volume too low.

md ASif says:

fucking ass hole.. chutiya bana rha.. this is so basic

Mohammed Naseef says:

Excellent and very useful

ALL SOFTWARE FOR EVERYBODY says:

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

Green Health says:

its very informative thanks for shearing

 Write a comment

*

Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!