Hey guys, welcome to this session, brought to you by Financial Edge Training.

My name's Ger Kelly, and I'm gonna be working you through today some Excel shortcuts.

I'm not gonna be doing loads of slides with you, I'm not gonna be lecturing at you.

We're going to be doing, I want to do as much Excel as I can with you.

Cool. Okay, cool. Guys, I'm here in Excel and I want to start moving around in Excel.

I want to move to the next two tabs. I could grab my mouse.

I could grab my mouse and I could start zooming around.

But instead, I'd love to be using my Excel shortcuts if I can.

Now, I should say all of the shortcuts I'm gonna use today are for Windows.

Some of them can be used on Mac as well.

So to change through our tabs, you press the control button and then page down, it takes you up and down.

So page down, page up, page down, control page up, control page down.

Cool. Next up, I wanna start moving around in Excel.

And of course, if you wanna start moving around a little bit, little bit quicker, the arrows are the best place to start.

So I'm looking at cell C four.

I want to jump to I four, and I'm gonna press control.

And then the arrow, watch what happens on my screen as I do it.

So control and right arrow and it jumps me to I four.

And I can press control down, arrow control left arrow.

And what it does is it jumps me around the edges of a block of data.

Now where we particularly use that is in column A.

You can see column A doesn't have many words written in it.

We've got this workout one.

I want to jump down to workout two. I press Ctrl down arrow.

I've just jumped 93 rows.

Oh my God, I'm saving so much time already in Excel.

Let's go back up to workout one.

So control and the arrows to start jumping around.

Next up I want to use a couple of shortcuts that you may know already.

I'm looking at the home ribbon in XL, and I can see this capsule B, some of you may know the shortcut already.

It's control B. And then to make italics, I can make control I.

And then to make it underlined, it's control U. Cool. If you knew that one already, fantastic.

You were probably born and your mother took you in her arm and she went, oh my god.

I would teach you about Excel control B, control I control U.

But I'd love to do more than just those three.

I wanna get access to everything in the ribbon in particular.

To start off with, I want to hit this yellow painting.

Now how do I go to that yellow painting tin without using my mouse? I'm gonna tap the out or alt button. Just once, just tap it.

And these letters appear across the top.

I can see that I want to go to the home ribbon.

And the home ribbon has an H above it.

So I'm gonna press H And new letters appear.

These are called accelerator keys, but you don't need to know that another H appears above the painting.

So I press H again and I'd like to make this particular cell yellow.

I'm not gonna use my mouse.

Instead, I'm gonna use the my arrows to get me down to the yellow.

Amazing. If you thought that was slow, don't worry, I've gotta wait to make it a lot quicker. Promise. So let's try it again on the word name, I'm gonna go alt hh and then hit the down arrow and then the right arrow.

Cool. Now there's a couple more I'd like to do using the same idea.

So using that alts button, I'm going back to sell C four.

I'd like to make my font color red and my font size 24 guys, see if you can work out what the shortcuts all by yourselves.

I'll give you a quick 10 seconds, time's up, time's up.

So the shortcut to make the font color red again, I'll do alts and I need the H for the home ribbon.

And then I've got FC for font color. Ah, that makes sense.

So fc, use those arrows.

I promise I'm gonna make that a little bit quicker in a minute because using the arrow feels very slow.

That's cool. Lastly, I want to make my font size from 11 to 24.

So I go alt, hit that H button again.

And then above the font size, I've got Fs.

How close this guys font sizes, Fs, font, color, it's ft.

This is so cool. If your first language is English.

Anyway, let's move on.

So FS type 24, Press enter.

Guys, look at this beautiful cell that is absolutely amazing that has got best practice written all over it.

Yellow, the red. Oh my gosh.

Now I did promise there'd be a way to do these things a little bit quicker.

So let's do the yellow one more time.

We'll do it nice and slowly.

Let's go down to the cell below.

So alt H and then H again, use the arrows to make it yellow.

So old HH arrows to yellow.

Now I said there was a way to make it quicker.

This is gonna make it so much quicker.

This is now getting into my top 10 favorite shortcuts. And we're only gonna have time to go through like half of the my top 10, but I'll get through as many as I can.

What you want is the shortcut to repeat the last thing you did like this.

So watch my screen. I'm pressing one button and it's making things yellow again.

It repeats the last thing you did and you can do it so quick.

That shortcut, I'm using F four. F four repeats. The last thing you did.

If your F four doesn't work for any reason, you can also use control y press and hold control, then press the y Repeats the last thing you did. That is so cool, health and safety warning.

If the last thing you did was to delete a sheet, so come down here.

If the last thing you did was to delete a sheet, it will now start deleting sheets.

So be careful, be careful. Health and safety warning required. Okay, so that's awesome.

That's really cool. I want to go back to this C four again.

Okay, I'd like to make my column autofit this enormous word.

We've got this lovely red and attacks word.

I just can't see it. So it's autofit, it's gonna be alt, and then H again for home.

So alt H. And then in the middle-ish of my screen, I've got the word format with an O on top of it.

So let's hit O. And there's a humongous menu of goodness in here.

So hit the O inside there we've got I, which is autofit column width.

So let's hit I.

Oh, That's amazing guys. That was my ninth favorite shortcut.

And a way to get it in your heads is called the sailor shortcuts.

It's called the sailor shortcut because if you say it really quickly, it makes you sound like a sailor, a hoy alt hoy.

I promise I'll get these in your heads if it's the last thing I do.

So alt hoy, that's my ninth favorite shortcut and it autofit common width.

I still can't see row heights.

I'd love to autofit row heights.

Do you guys wanna see if you can find it? It's in the same menu.

Gimme a quick five seconds.

Let's have a go. So I hit the ALS button And It's H for home.

Then O for format.

And it wasn't I, 'cause that was Autofit common width.

I wanted to autofit row height.

And if we have a quick look, it's a, that's not in my top 10.

It's probably about number 54 I think.

But it's still pretty good. It's still pretty good. We're not, we're not, we're not. We're not gonna be be ho.

We're not gonna bully Alt Hoa.

Now we can do some pretty cool stuff with this cell here.

I could copy it.

So copy see if we know that shortcut is control C.

If I go to the cell above, I can paste it with control V.

So you might know that one already.

And control V is awesome 'cause you can do it again and again and again and again and again.

So Control V is repeat paste, however, I'd like to go a little bit quicker.

Control V is a good shortcut. I wanna go even quicker.

So I'm gonna undo the last thing I did to undo shortcuts. Control Z or depending where you are in the world, control Z.

So I'm gonna hit control Z. Let's go back through all that.

And I'd like to copy and paste this one more time.

So I'm going to go back to cell C four, Copy control ZI Now go up to the cell above.

And what I want to do in the cell above is I want to paste it once and once only with one button.

It's the most satisfying shortcut that there is.

Press enter.

No Gerard, this is insane. Yep.

So just press enter and it copies the item really quickly.

Try again. Control C, go to the right, enter control C, go to the right Enter if you want to copy to something once really quick, really easily.

Cool. I want to show you one more thing with this, with this particular cell here.

Let's go back to it. Let's copy it again.

But I want to change what I'm gonna paste.

I don't want to paste the word transaction, I want to paste the formatting.

And some of you will have used format painter before.

Now format painter up in the RI ribbon. There it is.

But going up to that, using the alt key, it's not great.

It's a li, it's a little bit rubbish. You gonna do it once at a time. So instead, I'm gonna copy this, I'm gonna go to the right and I'm gonna use Paste special.

Now there's lots of shortcuts to get to paste Special.

I'm used Control Alt V.

But if you like this one up here, that's a really good one up there.

I could, instead of going alt and then H, and then V Gets me into all of my pastes here and then S at the bottom.

But there are some others as well that we could use here.

So pay special, really cool.

And now that I'm here, I want to use formats.

Now I could use my arrows to go up and down to formats, but instead, this is really difficult to see.

Can you see that the word formats has the letter T underlined the underlined letter.

That's your shortcut letter.

So if I just tap a T now jumps to formats, press enter.

Ooh, That word name is looking a lot better.

Now I've had a great question in the chats.

Hey guys, thanks for asking me this Gerod, how do you personally decide which shortcuts are worth memorizing and which ones are not worth the brain space? Yeah, absolutely guys, you don't want stuff living rent free in your brain and it's taking up space that should be used for other things.

What I do is, well what happened to me is that my boss told me, you're not allowed to touch the mouse for the next two days.

And the only time I was allowed to use the mouse was to Google what's the shortcut to not use the mouse for this.

And so what I, what I decided eventually after that was that the things I was using most often, such as alt hoy, AutoFi, that one was gonna go in.

And what I tried to do was do at least half of all my keyboards stuff using shortcuts.

And then every day I try to do a bit more and a bit more and a bit more and a bit more.

Does that make sense? So basically try and start with half of everything you do being shortcuts and then every day just add a couple more shortcuts on.

And I guarantee within a week, two weeks at the top you'll be using the mouse 10% of the time.

Great question. Now back to this guys.

Let's copy, I want to do the same thing again.

Alta paste format. So a pay special format.

So I hit control alt VT enter, Hang on. There was a shortcut we just learned so I could repeat all of that again.

What was that shortcut that we learned? It was one of my top 10. It was F four, F four, F four, F four.

And you now apply that formatting again and again and again and again.

So good save you so much time. F four.

Uh, amazing. One more with pay special, I promise. Just one more with pay special. Super, super useful guys.

Imagine your boss says to you, Gerard, I didn't want 83, I wanted 83,000 or 250.3, I wanted 250,000 Gerard, what have you done? And I say to the boss, boss, it's okay, I can just go into the formula bar using my mouse naughty.

I can just delete that decimal point and I could just move it.

Boss, what's the big deal? And the boss says to me, no, Jared, all the numbers, my heart starts to sink.

Oh my god. So what I'm gonna do is I'm gonna put a 1000 off into an empty cell somewhere.

Yeah. So just, oh pardon me, let's make sure we're in the right place.

So just a random cell somewhere, type of 1000.

What I'm gonna do, you might want to just watch, you might just want to watch this one.

Let your brain soak it up and I'll do it a second time.

I copy it and I'm now going to paste and multiply.

I'm gonna paste and multiply.

So I now select all of the cells that I want to copy and paste, uh, that I want to paste onto.

And I did that by pressing shift and then the down arrow.

And now I need pay special control Alt V.

And I need to do two things here. Not one.

Everyone thinks it's one, it's two.

I want to multiply and the underlined letters M.

But a second thing I want to do this is propagating you into advanced level stuff. Here I want to multiply by the value and I basically won't lose your formatting. Your formatting will stay perfect everywhere. Press enter.

Yes, Winning at Excel guys, I look to my boss, the boss I'm expecting to see happy. The boss is still unhappy.

The boss says the positive numbers need to be negatives.

The negative numbers need to be positives.

Ah guys, let's do it.

Let's do the same thing with a minus one.

So let's do it together guys. If you had pause, let's do this one together.

Type of minus one, copy control C.

Now let's select the cells we want to paste onto.

So shift down, down, down arrow, down arrow, down arrow, down arrow.

Now pay special control alt V.

And there were two keys, two keys that we had to use here.

It was the M for multiply and V for values.

Awesome, awesome. Press enter.

Amazing guys.

I was thinking I was gonna have to cancel my wife's birthday tonight because I was gonna have to clean up all these numbers, but now I'm in the club.

No cancellation of the potty guys, these numbers are looking good.

And the best thing about those is that you can now delete the 1000.

You can delete the minus one and you've kept everything nice and clean.

Amazing. Now, quick little thing for you.

Imagine I'm over here and I've just done some work and I now save my file.

What's the shortcut to save? Shortcut to save is control S.

That makes sense. S to save If I save my file here, but now I send it to my boss, the boss sends my file to the clients, the client in Germany, the client opens up my file.

What's the client gonna see? They're gonna see exactly this screen where I've saved my file and it looks really amateurish and the client's gonna be like fu stars.

Okay, they're not gonna be happy at all.

Okay, I teach in Germany all the time, got love, lot love for Germans.

So how should we be saving our file? We're gonna use something called a beauty save.

And again this is top 10 favorite shortcuts here to beauty save will take us back to the top left hand corner and it looks much better.

Now the shortcut is control home.

So I'm gonna press the control button and then the home button.

You might have to go looking on your laptop.

I've got a great big keyboard so it's a little bit easy for me.

There's my home button there.

But if I had a laptop keyboard on my laptop keyboard, it's just that little guy there and you might have to press function, fn and then home to get that to work.

Now I've gone up to a one, I can save control s send it to the boss.

Boss sends it to the client.

The client say, yeah, dust, it's good.

Okay, the client's really happy, cool. And we stay happy.

They stay happy. Great relationship with the client.

Cool guys, we're getting some really good shortcuts going on here.

Now a couple more for you, a couple more.

I let, let's create a little, let's, let's create a little formula, shall we? I'm just gonna say equals I'm in B eight and I'm just gonna maybe add two cells together. Alright, so I'm just gonna add that one and that one.

Okay. And all I did there, which is equals, and I pressed the right arrow, then I did add, and then I pressed the down arrow and the right arrow.

So I've got myself a little formula that's really nice, I press enter.

But now I realize accidentally I linked to the wrong cell.

How do I fix this? And this gives me another amazing shortcut.

I want to go up into the formula bar.

And the question, the question from Nishi, how do you decide which shortcuts are worth remembering? If you can get this shortcut, this one is the one that will keep you using shortcuts.

'cause I find if I, if I don't memorize this one, this is the one that takes me back to the mouse.

Instead of using my mouse to click into the formula bar, I'm gonna press F two.

And now I'm in the formula bar.

But, but, but, but, but, but, um, your, your cursor might be blinking in the cell, so it might be blinking down there. So that's okay. I, I'm gonna get rid of this C nine.

So I'm gonna press backspace, backspace.

I now want to go to C 10.

That's the number I actually wanted to C 10.

But if I try and press the down arrow or the left arrow, now I'm in the formula bar.

Can you see how I'm moving around in the formula bar? I don't want to be moving around the formula bar.

I want to be moving around outside.

So make sure your cursor is blinking just after the plus sign.

It might be down here so you might be blinking down here.

To get outta the formula bar again, press F two again, just watch my screen F two and now I'm outside.

I'm happy with that. Press enter. You fixed it.

Let's try it again. I press F two to go into the formula.

I'm going to delete out C eight.

So I get that C eight reference.

I'm gonna press backspace instead I want to go to G five.

So I press F two, press the F two button again, go to the right hand side and now I've gone outta the formula bar F two to go into the formula bar F two to come outta the formula bar.

That one, if you can use that one all the time, it'll stop you grabbing the mouse every five seconds.

Great, great, really good there.

Now I would really like the formula that I've created here to copy down to the cell below and down to the cell below and down to the cell below.

I'd really like this 120, uh, 1,224.

I'd like that to stay put.

But I'd like this 83 to move down, move down, move down, move down.

So let's try and do this.

I'm gonna try and copy this down to the cells below.

If you were using your mouse, you'd grab this little handle in the bottom right hand corner.

You just drag it like that And You see how the formula goes down to the cells below.

But gerod, we didn't come here for using the mouse and clicking the handle. It came here for shortcuts.

So I'm gonna select this cell, I'm gonna press shift and the down arrow, down arrow, down arrow, down arrow to copy to the cells below.

I want to press control DD for down.

That is fantastic.

And to go to the right, we won't, we won't do it, but to go to the right is control RR for right.

The question I always get at this stage is, Gerald, what's it to go to the left? And there isn't one. Unfortunately there isn't a control l, it doesn't exist.

Um, there are other things you can do.

So just watch what's happened to my formula here.

I was linking to the 1,224 and the 83.

As I go down to the cell below, both of those references went down and the cell below went down, down, down.

So those references go up and down as the formulas go up and down. So that's really cool.

But I want to stay locked on that 1,224.

I do want the 83 to go down and up.

I don't want 1,224 to go down and up.

So I need to go into my formula bar and I've just clicked with my mouse on my life.

Oh no cardinal in. So I'll press F two.

So I'm in the formula bar and now I'm going to make sure that my mouse or cursor where it's blinking is somewhere around the G uh, somewhere around the C 10.

I want to lock onto that.

And dollar signs, dollar signs are your friends, but is there a shortcut to get the dollar signs? And there is the dollar signs is F four.

So I make sure the mouse is just kind of blinking somewhere.

I press in C 10 press F four.

Ooh. And I get a dollar sign before the C and a dollar sign before the 10.

That's awesome. Let's see if I copy it down.

Let's see what happens. So to copy down, I'll press shift down, arrow, down arrow, down arrow, down arrow.

I'll then use control D again, another top 10 for me there. And F four is another top 10 for me.

So control D, all of those formulas. Look at the formulas in the formula. RG six plus C 10, G seven plus C 10, G eight plus G 10, G nine plus C 10.

This is fantastic. I've managed a lock using those dollar signs and F four was my friend to help me do that.

Uh, amazing zing guys. I've only got three minutes left.

Oh my god. LinkedIn live time flies when you're having fun.

So let's go down to workout two.

Let's go there as quick as we can.

I'm gonna go to column eight and now to jump down to the next one. Below is control down arrow.

So hit control, hold the control, hit the down arrow as well.

And now we're looking at work out two. Here we are.

Cool. Now we're getting towards the end. Oh my god, I've got less than two minutes.

I want to sum up these numbers.

We've got some units of some products that have been sold.

I want to sum them up so I could, I could use just keyboards to equals SUM open.

Then I could use my arrows and then press the shift down arrow.

You don't do this, you don't do this guys, I'll do this one.

So shift then down arrow and down arrow and down arrow.

And that's cool. That's worked out for me.

I've got my number I awesome.

But I'd like to do that with shortcuts.

So my shortcut for auto sum, and this is my number one favorite shortcut.

I'm so glad that we had time to do this is alt equals.

Now depending where you are in the world, it might be alt plus or it might be alt shift equals.

So you might have have to have a little play around with that.

If you are on a Mac, it's command shift T, command shift T.

So let's do it again. How good is that to alt equal? So good. So good Guys, let's go down to the bottom out three, which is absolutely enormous.

I'm right down the bottom here in that orange cell row 135.

I need to sum all of the items above Gerard. It's gonna take me ages. No way guys, let's use alt equals.

And that's how quickly it selects numbers.

Oh, it's so good, so good.

I then press enter.

But an alternative you can use instead of that is just alt equals equals and it does it super quickly.

Oh, Gerald, I blinked. I missed it. Can you do it again? Yeah, alt equals equals.

It's that quick to get that shortcut done.

Cool guys, let's just do one more. Let's scroll down really quickly. Let's go to work out six.

Let me zoom it in. Oh geez, my mouths so well, so, so naughty.

I should say guys, using the mouse is okay.

The mouse is actually quicker for many things.

But where we can use shortcuts, let's use shortcuts. They're gonna save you so much time.

And what's another benefit of using shortcuts? It makes you look cool. Okay, right, last one.

Then last one. I've got some sales that have been made in January.

I'd like to sum them up.

So let's use alt equals amazing.

So I've summed all those with alt and then equals press enter.

And now to copy to the right, which is my second favorite shortcut.

Upper shift, right arrow, right arrow.

And then to copy to the right is control, R Control. And then the letter R, often known as the pirate shortcut because it makes it sound like a pirate.

What was the shortcut again? Control R Guys.

Can you imagine what it's like spending a day in the classroom with me? It's all the dad jokes.

I am definitely of the age of dad jokes being amazing.

Guys, that was half an hour. I'm so sorry.

I feel like I've left you guys shortchanged.

But really quickly, just a quick reminder.

You can of course go to our website.

There's loads of money off, 40% off at the moment.

The short, the ugh, the code you use there it is on screen Excel 40.

You can book single courses, you can do the boost plan of Felix, 40% off that.

And it gives you unlimited access to our website.

Every single certificate, every single micro degree, whatever you want.

But there's loads of free stuff. We've got free blogs there.

If, oh, hang on, if you go through into the View courses and you want to do a free course, just scroll down, scroll down, scroll down until you get to the word free.

There's loads of free stuff here as well guys.

I hope you found that useful.

Hope I see you on another course soon.

Lovely to meet you guys. Goodbye.

Bye.