this video will take you from excel shortcuts beginner to excel shortcuts pro
and for this we'll put the shortcuts in tiers from rookie level all the way to sensei level using
formula one themes as analogies so we don't get bored let's go starting off at the rookie level
and in f1 equivalents that would have to be williams and haas sorry if there's any fans out
there so let's take a look at the excel file which you can download in the description we've got this
large data set over here and don't worry too much about the content itself if you want to navigate
across it you can obviously use the down arrow but that's obviously going to take quite a bit of time
instead you can use the control up arrow to get all the way to the top ctrl down arrow to get
all the way to the top you press the down arrow again that takes you to the very bottom of the
excel file ctrl up arrow again and then right and left to go across similarly if you actually want
to select an area you can press the ctrl and shift and then from there go down arrow all the way to
the bottom that will take you and then ctrl shift right arrow that will take you all the way to the
end now suppose we don't really want the very last column for that you can press the shift
and then the left arrow that's gonna allow you to do that the right arrow to select it again
and same thing if you go shift up or shift down that allows you to select whatever area you want
moving on to manipulating the data so things like adding rows or adding columns
for that let's suppose we want to add a new row here to select it you can obviously just click
it here if you want but the shortcut for that is actually just going to shift space
that's going to select the row for you then to other row you can press ctrl shift plus
ctrl shift plus again to add and then ctrl minus that would be to delete some
similarly for the columns it's ctrl space instead of shift space layer and then you can press the
ctrl shift plus to add some and then ctrl minus to delete some there as well press ctrl z if you
want to go back if you deleted too many like me now suppose we do want to add a few more rows and
for this area here under northeast and new york on these we just want the same thing for all the
other ones you can obviously just press ctrl c and ctrl v to paste it but an actual faster
way to do that is just by pressing ctrl d ctrl d again so what does that does it basically pastes
anything that you had above so as you can see that's working there similarly if you want to
copy whatever you had to the left you can press control r so basically taking you to the right
and lastly under the rookie level if you want to navigate across workbooks you can press the
control page down that's going to take you to the next tab and control page up to go back up
that's a rookie level and now moving on to the amateur level so those that use excel occasionally
in f1 equivalents that would have to be alpha tauri alpha romeo and aston martin let's say we're
given this small table over here and first up we have the invoice state which as you can see is
in this odd format because it's obviously not in a date there now if you want to change that we would
first select it by ctrl shift and down arrow all the way to the bottom there and i'll press ctrl 1
that's going to open up this whole dialog box where basically you can change the type of uh
of format that you want in our case let's say we wanted a specific date and within that you
can change a ton of different formats let's say we're okay with the first one and similar
to that you do have different tabs where you can control different things about that cell
hit okay there for now now you can see it's all changed to the table format there is a quicker way
to go about this first press ctrl z that's going to take you back to how it was originally and
now you want to press the ctrl shift and number that's going to put you to a date format quickly
then looking at the other data in the table as you can see for the price per unit let's suppose we
want this one to have a dollar sign as its price after all so ctrl shift down and here you want to
press the ctrl shift dollar sign which is fairly intuitive there similarly for the unit sold we
do want to have some columns in there for that we got to make it a number so go to ctrl shift 1 and
that's going to do it for us and lastly for the operating margin we'd like it to be in percentage
so again ctrl shift down to select it and then ctrl shift percentage sign another great tool
here is a paste special feature you can see over here we've got a different table and now let's
suppose we want the same format as this one over here now were we to just copy and paste the whole
table then obviously all the numbers would change as well which isn't quite what we want instead we
can select it by pressing ctrl a then ctrl c and instead of just pasting by pressing ctrl v
what we want to do here is actually go to paste special which you can press ctrl alt v for that
and here you can see you have a ton of different paste options so for instance you can only
paste the formulas the values itself without the formatting etc etc in our case let's say we just
want the formats and then hit ok there and now you can see that everything's changed to this exact
same format but the values remained what they were originally all right now we're on to the higher
tiers and we'll put alpine and mclaren in here and here's the table that we'll be working with and
as you can see this one requires a lot more work than the previous ones and for this we'll be using
the alt key as you can see if you press the alt key once a ton of different numbers and letters
start to pop up this is basically to replace the mouse first up here let's go ahead and auto
fit these columns as you can tell they're not very consistent and you can go one by one which is very
tedious instead we're going to press the control a and then from there we're going to go to alt
go to the home page h o it's going to go under format and we want to go to the i which is the
autofit column width here press i there similarly for the rows we can go to alt h o a in this case
and that's going to autofit the rows as well and just like that using a few keystrokes it's looking
a lot more like it let's finish it up firstly let's remove the grid lines which is basically
this grayish line color that we've got go to alt w vg there so it's a lot less distracting and let's
work on this data set a bit as you can see the price per unit doesn't actually have decimals it'd
probably be useful to do so so we'll go ctrl shift down and then press the alt h 0 that's going to
add a decimal voltage 0 again if you want to add another one and then alt h9 that's going to remove
a decimal for us let's also highlight this top part over here so we'll go ctrl shift and right
arrow ctrl b is going to bold in it for us and let's add a border of sorts so we can go to alt h
from here you'll be able to select whatever border you want let's just go with a simple o which is
the bottom border now that's looking more like it and suppose we're looking through a data set
and we find a number that we find a bit suspicious like say this first one we don't think it's quite
right the price per unit if you want to leave a comment on it say for your analyst or something
you can just press the shift f2 key that's going to open up the panel and then here you can write
whatever you want like hello say now when i get out of it it'll remain as this red red dot which
you can hover over it and there's going to be a clear sign there if you're not done with this data
set and you want to add a few more beverage brands from above you can just go to towards this very
bottom one and then press the alt down arrow now you can see that you're going to get all of these
suggested ones which are basically all of the ones that we had above let's say i go with coca-cola
here same thing applies to say new york go to alt down arrow and now i can select new york from that
list lastly we've got the excel senses so those that spent years trying to master these shortcuts
you must feel the force around you and then here we're gonna put red bull mercedes ferrari
and of course fernando alonso and at this level they don't just use regular keyboard shortcuts
instead they customize them using the quick access toolbar so let me show you how to
go about that that should be on the top left hand side that you can see over here
and yours is probably going to look different to mine as mine is already customized if you want to
get inside it you can go under file go to options and from here go to the quick access toolbar so
over on the right hand side are all of the quick access toolbar tools that i currently have whilst
on the left are all of the commands available go to all commands so you can find all of them
from here feel free to copy all of these in the same order so suppose i find the camera just by
typing camera in here then i'll just go to add and i'll be able to add it if you ever want to
change the order go to up or down arrow the order is going to matter as that's gonna change the the
shortcut you have to type in it so once you're happy with what you've got press the ok key there
and now over here let's go ahead and reformat this using the quick access toolbar you can find it on
the top left hand side if you want to drag it down a bit you can just put it to show below ribbon
it's going to be down over here so first things first let's auto fit this column
so control space and now all we need to press is the old 6 that's going to do it for us before
we had to do the old hoi which is a lot more tedious obviously then let's highlight the top
row and dark blue so go to control shift right and from here we're going to go to alt 5 and let's go
ahead and with the arrow keys just go to the dark blue like so we'll also change the font color to
a white so we can see it a bit better for this go to alt 4 and now let's change that to a white
press ctrl b to bolden and just below we'll do the same thing but actually put it in light blue
so we'll go to alt 5 and we'll select the light blue kind of like so great now let's separate
the total revenue a bit more so let's go select it ctrl shift right and then we're just going
to go to alt 3 and then let's press c so it's quite clear control b to bolden that now you
can see what that's currently looking like and if you're feeling a bit lazy and even these shortcuts
aren't quite enough for you you can go ahead and select the whole table by pressing ctrl a
then you're just gonna go to alt 2 that's going to give you the auto formatted tables so basically
excel suggests a few different table formats for you let's say we go for the classic number two
hit ok and just like that that's gonna be edited to their standards and one last really cool trick
is the camera tool so let's go ahead and select this table ctrl a now we're just going to press
the alt one to take a screenshot of it let's say we paste it right over here so just click there
once now you can see we have the exact same table you might be wondering well that's just a normal
image what's what's so cool about that and the difference here is that suppose
i change this number to a5 now this one over here is also dynamically going to change
so suppose we have this say in the summary tab or something and we're able to make changes over here
and they're gonna be reflected down over here as well which is what's really cool about it so is my
formula one rating of excel shortcuts accurate let me know in the comments down below if you
want to learn more about the quick access toolbar check out this link over here and if you want to
learn more about excel specifically for a job in business or finance check out this link over here
where we teach everything we know about excel specifically applied to the workforce
hit that like and that subscribe button if you liked it and i'll catch you in the next one