8 year old Excel is Funner joins Mike and I to show us some math tricks in Excel!
Transcript of the video:
Hey here we are live at Highline Community College for another trueling excel podcast.
I'm Bill Jelen from MrExcel be joined by Excel Is Fun and Excel Is Funner.
Sup?
Sup?
Isaac what he have for us today. Oh Math in excel.
Math in Excel.
I know it doesn't look like a calculator.
No, it doesn't look like a calculator at all. There's no buttons.
And then I know but the keypad does.
Okay.
and then you just just type 12 x 12.
Then you want to put an equal sign, and then go up and then press a multiplication symbol then go up and you can bring these anywhere both the cyan what I did and this one.
You're never going to get me.
How do you jump all the way back to cell A1 without moving the way out.
If you lost over here I don't know how to get home and then you just go Ctrl + Home wow and then boom you're back to A1 and then go Enter and that's your answer.
Look at that. [ inaudible 1:21 ] And I already knew that and I really You already knew 12 times 12?
Yes.
That's amazing.
So what's 13 x 13?
Okay.
[ inaudiable 1:31-32 ] Are you home again?
Ctrl + Home I'm just going to do it here.
I'm going to do how about, how about this? I don't know what a 1000 times a 1000 is. So I'm just going to use excel. It will know the answer immediately.
All right. Let's see it.
So = and then go up and then doot doot doot It's a million.
Yes.
1000 times a 1000 is a million. All right.
Oh, and it didn't use correct.
That's not correct. Do you know why?.
Why?
Where are they?
It's missing a comma.
Escape and then use your comma button up on the Home Ribbon.
Home look at this.
I'm at Home.
And there's a comma.
Comma comma Comma Dollars Nice.
Dollars. I get that much dollars.
I'm rich Alright, hey, let me show you a trick Isaac.
Yeah.
Step aside.
So hey once you have the 12 x 12 or 12 yeah 12 times 12 up here, if we would need to see 13 x 13, we don't have to come down here and enter 13.
We can just go back to the original cells.
Once I've 13. Ctrl + Enter.
I know that.
And it gave us the 161. Then why'd you come down here and build a whole new section this first sheet. That didn't work.
Because I was lazy.
No that wasn't lazy that it was you did extra work.
I know because I like extra work. Extra work. Okay.
6 times 6. There you go. All right, Mike. Oh, yeah.
6 times 6 Okay, well, I'm super lazy, so I'm going to say 6 and then = up arrow and Bugs Bunny's favorite number, the number six with the shift and 2. ^2 means exponent 2. So now I'm super lazy. I just type 7 and I get 49.
9 81.
I didn't know how to do this.
13 169 18 289 Put a 1000 a 1000 1000 a 1000?
Look at that.
Now what's the keyboard for that? I think it's Ctrl + Shift + 1 There you go. There you go. All right. There you go.
Well that was Isaac. How old are you now seven and a half?
Yes.
Seven and a half almost.
and plus i already knew that trick.
Almost age 7.5 and before you know you'll be 8.
Let's make it 8. he's got to be, he's got to be eight right.
Well to do that we just say hey, we're gonna round this to zero decimal places. So right there decrease decimal and BAM! Excel says you're 8. Congratulations.
Sweet.
That's the way that excel rounds numbers.
Well I want to thank Isaac for being here today. Excel Is Funner.
We always have fun. This is our what third or fourth year, we've been doing these trueing excels.
All Right, we'll see you next time for another dueling or trueing excel podcast from MrExcel and Excel Is Fun and Excel Is Funner, All Right.
I'm Bill Jelen from MrExcel be joined by Excel Is Fun and Excel Is Funner.
Sup?
Sup?
Isaac what he have for us today. Oh Math in excel.
Math in Excel.
I know it doesn't look like a calculator.
No, it doesn't look like a calculator at all. There's no buttons.
And then I know but the keypad does.
Okay.
and then you just just type 12 x 12.
Then you want to put an equal sign, and then go up and then press a multiplication symbol then go up and you can bring these anywhere both the cyan what I did and this one.
You're never going to get me.
How do you jump all the way back to cell A1 without moving the way out.
If you lost over here I don't know how to get home and then you just go Ctrl + Home wow and then boom you're back to A1 and then go Enter and that's your answer.
Look at that. [ inaudible 1:21 ] And I already knew that and I really You already knew 12 times 12?
Yes.
That's amazing.
So what's 13 x 13?
Okay.
[ inaudiable 1:31-32 ] Are you home again?
Ctrl + Home I'm just going to do it here.
I'm going to do how about, how about this? I don't know what a 1000 times a 1000 is. So I'm just going to use excel. It will know the answer immediately.
All right. Let's see it.
So = and then go up and then doot doot doot It's a million.
Yes.
1000 times a 1000 is a million. All right.
Oh, and it didn't use correct.
That's not correct. Do you know why?.
Why?
Where are they?
It's missing a comma.
Escape and then use your comma button up on the Home Ribbon.
Home look at this.
I'm at Home.
And there's a comma.
Comma comma Comma Dollars Nice.
Dollars. I get that much dollars.
I'm rich Alright, hey, let me show you a trick Isaac.
Yeah.
Step aside.
So hey once you have the 12 x 12 or 12 yeah 12 times 12 up here, if we would need to see 13 x 13, we don't have to come down here and enter 13.
We can just go back to the original cells.
Once I've 13. Ctrl + Enter.
I know that.
And it gave us the 161. Then why'd you come down here and build a whole new section this first sheet. That didn't work.
Because I was lazy.
No that wasn't lazy that it was you did extra work.
I know because I like extra work. Extra work. Okay.
6 times 6. There you go. All right, Mike. Oh, yeah.
6 times 6 Okay, well, I'm super lazy, so I'm going to say 6 and then = up arrow and Bugs Bunny's favorite number, the number six with the shift and 2. ^2 means exponent 2. So now I'm super lazy. I just type 7 and I get 49.
9 81.
I didn't know how to do this.
13 169 18 289 Put a 1000 a 1000 1000 a 1000?
Look at that.
Now what's the keyboard for that? I think it's Ctrl + Shift + 1 There you go. There you go. All right. There you go.
Well that was Isaac. How old are you now seven and a half?
Yes.
Seven and a half almost.
and plus i already knew that trick.
Almost age 7.5 and before you know you'll be 8.
Let's make it 8. he's got to be, he's got to be eight right.
Well to do that we just say hey, we're gonna round this to zero decimal places. So right there decrease decimal and BAM! Excel says you're 8. Congratulations.
Sweet.
That's the way that excel rounds numbers.
Well I want to thank Isaac for being here today. Excel Is Funner.
We always have fun. This is our what third or fourth year, we've been doing these trueing excels.
All Right, we'll see you next time for another dueling or trueing excel podcast from MrExcel and Excel Is Fun and Excel Is Funner, All Right.
