馃攳
Excel shortcut keys you SHOULD know! - YouTube
Channel: Leila Gharani
[0]
I'm really excited about today's video.
[2]
It's a highly requested
video on Excel shortcuts
[5]
that you should know. Your
colleagues should know.
[7]
Anyone who works with Excel should know.
[10]
Let's get started.
[11]
(upbeat music)
[16]
Click anywhere inside your
data set, use Ctrl+Shift+L
[20]
to add a filter to this, and then you can
[23]
go about using the usual filter options,
[26]
filter for names, press
enter, that's my list.
[29]
To deactivate the filter,
click inside the data set,
[32]
Ctrl+Shift+L takes it away.
[35]
It's a toggle Ctrl+Shift+L puts it back
[38]
Ctrl+Shift+L takes it away.
[41]
Click anywhere inside the
data set and press Ctrl+T.
[46]
The table has headers, click on OK.
[48]
Design tab is activated, you
have a lot more table options.
[53]
You can decide on the style you want,
[55]
you can add a total row to this,
[58]
summarize with a pivot
table or remove duplicates.
[61]
Now there are many more
advantages to tables.
[64]
If for some reason you want to
convert this back to a range,
[67]
just click on convert to range.
[70]
To jump from one side of
your data set to the bottom,
[74]
use Ctrl+Down arrow.
[77]
To jump to the right, Ctrl+Right arrow
[79]
To jump to the left, Ctrl+Left arrow
[81]
Jump back up, Ctrl+Up arrow.
[83]
This is much faster than
using the scroll bar.
[87]
Now if you wanna jump to the bottom
[89]
but highlight everything in
between, use Ctrl+Shift+Down.
[94]
Ctrl+Shift+Right arrow, highlights
everything on the right side.
[99]
I can click on the home tab to take me
[101]
to the top of the data set
so if I had some text here
[104]
and I used Ctrl+Shift+Right arrow,
[107]
it highlights everything there,
[109]
it doesn't jump to D,
because D is in fact empty,
[113]
this information is sitting in E.
[117]
If I wanted to format all of these,
[119]
I'm gonna use Ctrl+Shift+Down arrow
to highlight them,
[122]
Ctrl+1 which takes me to
the format cells options,
[126]
I can decide on my
formatting and press enter.
[130]
If I'm not using an Excel table
[132]
and I wanna add a sum to this,
[135]
just click on the cell below
or above your data set,
[138]
use Alt+Equals sign,
that automatically inputs
[142]
the sum function for you
and it tries to figure out
[145]
the range that you probably want to sum,
[147]
so in this case it has
correctly figured it out.
[150]
If I had a number here,
and I use auto sum here,
[153]
it think that I want to
add these two values,
[156]
and press enter.
[157]
So it's quite smart in trying to figure
[159]
out what you want to sum.
[162]
If you want copy and paste your formula,
[164]
but you wanna have your
numbers as hard-coded,
[166]
so you wanna paste it as values
[168]
without the formula behind this,
[171]
you need this shortcut,
so first Ctrl+C to copy,
[174]
and then Alt+E+S+V to bring up
the paste special dialog box,
[178]
all you have to do now is press enter,
[180]
and you've pasted it as values.
[182]
Now you notice it's a
difficult one to remember,
[184]
the way I remember it is
Eat Some Vitamins, ESV,
[188]
you just have to figure out
something that works for you.
[192]
To add a new line inside
a cell, use Alt+Enter,
[197]
so you have to be in edit mode
[199]
because if you press enter here
it just moves down one cell,
[203]
to move down a line inside a cell,
[206]
press Alt+Enter and now
you can input your text,
[208]
and you can adjust the
formatting as you like.
[213]
To select the entire data
in the current region,
[216]
click anywhere inside your
dataset and press Ctrl+A.
[221]
Once your dataset is highlighted,
[223]
to insert a default chart, click Alt+F1.
[228]
The next one is a great one,
[230]
let's say you wanna add
email addresses to this,
[233]
and you wanna repeat this
pattern for the next ones
[235]
It should be James.Willard and so on,
[238]
I'm gonna hold down the Shift
key, and the down arrow key
[241]
to highlight this area,
[242]
and then I'm gonna press
Ctrl+E, that's flash fill magic.
[248]
It tries to figure out the correct pattern
[250]
based on the pattern that I gave it first.
[253]
In this case I just gave it one option
[255]
and it figured it out correctly,
[257]
sometimes for flash fill to work properly
[260]
you might need to give
it more sample data.
[265]
To highlight an entire
row, use Shift+Space,
[269]
to highlight an entire
column use Ctrl+Space.
[273]
To insert a new row or
column, use Ctrl+Plus,
[278]
this brings up the insert dialog box,
[281]
you can select insert an
entire row, entire column,
[284]
but because we already
learned a shortcut before this
[287]
we're gonna use that first.
[289]
So let's say I wanna
insert an entire column,
[292]
I'm gonna highlight the whole column,
[293]
what was the shortcut key?
[295]
Ctrl+Space, Ctrl+Plus,
[297]
that automatically is gonna add a column,
[300]
it's not gonna ask you if
you want a row or a column.
[303]
Now let's repeat for the row, Shift+Space,
[306]
insert a new row, Ctrl+Plus.
[310]
To remove an entire row, Ctrl+Minus.
[313]
To remove an entire column, Ctrl+Minus,
[316]
but if you wanna avoid the dialog box,
[318]
we're gonna highlight
the entire column first,
[321]
and then we're gonna do Ctrl+Minus.
[325]
If you wanna drag an entire
row and drop it somewhere else,
[330]
so let's say I wanna move Richard Elliot,
[332]
in between Robert and Paul,
[334]
what I'm gonna do is
highlight the entire row,
[336]
now if I drag this and let it go,
[339]
it's gonna try to replace this data
[341]
but I don't want it to replace it,
[343]
I wanna actually put it
in between those two.
[345]
So here you drag it, but
while you're dragging it,
[349]
you're gonna hold down the Shift key,
[350]
and that's gonna insert
it between those two.
[357]
To hide a column use Ctrl+0,
[359]
to hide an entire row, use Ctrl+9.
[364]
When I first receive a new
workbook from someone else,
[367]
I wanna check if anything has
been hidden in there or not.
[370]
The shortcut key I use is Alt+;.
[373]
That highlights the visible cells only,
[376]
and this way I get a visual indication
[379]
that some rows and
columns have been hidden.
[382]
If nothing comes up, nothing is highlight,
[384]
it means that no rows or
columns have been hidden.
[388]
Now let's say I've updated
this information here,
[390]
I wanna add a timestamp to this,
[393]
I'm gonna use the shortcut key Ctrl+;,
[396]
and if I wanna add the time to it
[398]
I'm gonna add a space and
use Ctrl+: and press enter.
[403]
One bonus tip: when I receive a new file,
[405]
and I wanna highlight all
the constants in that file,
[409]
I press F5, Alt+S, O, X, Enter.
[412]
This highlights all the numbers
[414]
that don't have formulas behind them,
[417]
so here I can see this
has a formula behind it.
[421]
What I recommend you do
is to pick three shortcuts
[424]
that you didn't know before,
[426]
and you think you're
gonna need in the future,
[428]
and practice them a few times.
[430]
If there's any other Excel shortcut
[432]
that you consistently use,
[434]
please share it with us
in the comments below.
[436]
But if you wanna learn more tips
[438]
to help you design
reports faster in Excel,
[440]
it's your lucky day, because
I cover nine more tips
[443]
in my Excel advanced course on Skillshare,
[446]
but because this class is on Skillshare,
[448]
which is an online learning platform,
[451]
once you register you get
access to over 25,000 classes
[455]
in business, programming,
[457]
Office applications, and a lot more.
[460]
So you don't just learn from me,
[461]
but from thousands of other instructors.
[464]
Their premium membership
gives you unlimited access
[467]
so you can join the classes
that are right for you,
[470]
and for your career goals.
[471]
So let's say if this weekend you wanted
[474]
to get started learning about
data science, and Python,
[477]
there's nothing holding you back.
[478]
Skillshare is also very affordable,
[480]
and annual subscription
is less than $10 a month.
[484]
And here's the best part,
[485]
the first 500 of my subscribers
[488]
who use the link in the description below
[491]
are gonna get a two month free trial
[493]
that's gonna give you unlimited access.
[496]
Click that link, sign
up, and start learning.
[499]
Thank you so much to Skillshare
for sponsoring this video,
[501]
and supporting my channel.
[504]
I'm not sure what the
shortcut for thumbs up is,
[506]
but if you know it please use it,
[509]
otherwise just click that thumbs up.
[511]
The list of all the shortcuts
[513]
is provided below this video,
[515]
print it out, keep it handy,
[516]
and share it with your colleagues.
[518]
See you in the next video.
[520]
(relaxing music)
Most Recent Videos:
You can go back to the homepage right here: Homepage