No, we're not coining new words at 'The Learn Excel from MrExcel Podcast Blog, but someone somewhere is... Truel is truly a word [Truel - Wikipedia]. But enough about that, lets look at this podcast! In a Three-way Duel between Mike 'ExcelisFun' Girvin, Bill 'MrExcel' Jelen and - 'ExcelisFunner'. In this 'Almost Live' podcast, Bill and Mike get schooled - in the rain, in an empty parking lot in Seattle... by a 5 year old Excel Wizard! Follow along with Episode #1540 to learn some basic Charting technique.
Dueling Excel Podcast #103...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] Slaying Excel Dragons
and
"Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Dueling Excel Podcast #103...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] Slaying Excel Dragons
and
"Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Transcript of the video:
Hey, welcome back it's another trueling Excel podcast.
It's episode 104, Create a Chart.
Hey welcome back it's another dueling Excel podcast live here from the streets of Seattle.
I'm Bill Jelen from MrExcel will be joined by Excel is Funner this is going to be wild.
All right, here we go, Isaac it's all you man show us something.
So, you're going tell us show us how many hits you got in a game, right?
Isaac: Yeah.
Bill: Game, you know, how to put a 1 and copy it down.
Isaac: Okay, Oh! yeah, I know saw you all the times.
Bill: Well, that was an F1, that's okay that happens to all of us.
Only we're older we get to then say bad words what happens and how do you enter that, what do you use the, what keyboard shortcuts to use.
Isaac: The Angry Rabbit, sometimes you call it sometime's mouse.
Bill: What's the angry rabbit?
Isaac: Angry rabbit is like this big square over here.
Bill: Okay angry rabbit.
Isaac: You can call it like the angry ****roach or something.
Bill: I call it Dr. Fill.
Isaac: Dr. Fill.
Bill: Dr. Fill handle all right now put your wits in for your games this is your baseball game right yeah there's no number pad you gotta use the numbers on top enter or immature so how many games it hits to get in Game one I got five hits and then now you want to visually portray this with the chart right so do you know how to highlight with this laptop I I think you you have to click there yeah and you remember the keyboard shortcut for a chart our high all the default chart is a line playing around with the default charts all right hey I excel is funner that's Isaac how does Isaac haha hey Isaac is the only kid with three excel videos at YouTube now ice through Isaac at curvier because I in a class taught people how to change their default charts and so Isaac was probably expecting one of these cool charts have you do you like the blue blue blue or do you wanted to be different colors all of them the colors that's the gravel buried cuff I thought like that look so see you think you're mine I'm gonna control Z to go back you want one of these up here huh yeah I'm gonna go with purple oh that's really really dark undo how about if we come in here and go to format and then shake Ville and then bring it and we will open that James says to that one that's bad and now it's raining it's raining on the streets of Seattle we've got to wrap this up I got a trick yeah go ahead all right there's Excel is fun all right let's see it it is it is starting to rain if I can figure out I think we're going to go if we can go equals arrow arrow so I'm going to do change these labels down at the bottom and I think shift seven gives me an percent and then character ten yeah character ten it's a hard return lap the dreaded laptop and then I'm gonna go ampersand arrow so now I'm going to get these labels control enter and copy shift arrow arrow control V on learn that from mr. excel now I'm gonna I know how to use a laptop go click the chart and go up to design and select data and edit these and now instead of those over there I'm going to select these click OK and what what happens is the label says game 1 and then below it's his 5 now I don't like that I'm gonna put boy am i slow on laptop here I'm going to add one more thing here in double quotes space hits and double blow it I think that's a double quote right-side space all right so this is hilarious control-enter and then I copy it down ctrl C shift arrow arrow again I learned that from mr. so now the chart looks better alright snow Isaac Isaac who gets the point who gets the point who wins who won this one this big dueling podcast today you me we'll leave it up to the people and they'll put their comments on YouTube alright so is it Excel Excel is funner mr. Excel or Excel is fun Excel is funner hey oh hey I want to thank everyone for some quality next time for a dueling excel podcast from mr. Excel Excel is fun who are you
It's episode 104, Create a Chart.
Hey welcome back it's another dueling Excel podcast live here from the streets of Seattle.
I'm Bill Jelen from MrExcel will be joined by Excel is Funner this is going to be wild.
All right, here we go, Isaac it's all you man show us something.
So, you're going tell us show us how many hits you got in a game, right?
Isaac: Yeah.
Bill: Game, you know, how to put a 1 and copy it down.
Isaac: Okay, Oh! yeah, I know saw you all the times.
Bill: Well, that was an F1, that's okay that happens to all of us.
Only we're older we get to then say bad words what happens and how do you enter that, what do you use the, what keyboard shortcuts to use.
Isaac: The Angry Rabbit, sometimes you call it sometime's mouse.
Bill: What's the angry rabbit?
Isaac: Angry rabbit is like this big square over here.
Bill: Okay angry rabbit.
Isaac: You can call it like the angry ****roach or something.
Bill: I call it Dr. Fill.
Isaac: Dr. Fill.
Bill: Dr. Fill handle all right now put your wits in for your games this is your baseball game right yeah there's no number pad you gotta use the numbers on top enter or immature so how many games it hits to get in Game one I got five hits and then now you want to visually portray this with the chart right so do you know how to highlight with this laptop I I think you you have to click there yeah and you remember the keyboard shortcut for a chart our high all the default chart is a line playing around with the default charts all right hey I excel is funner that's Isaac how does Isaac haha hey Isaac is the only kid with three excel videos at YouTube now ice through Isaac at curvier because I in a class taught people how to change their default charts and so Isaac was probably expecting one of these cool charts have you do you like the blue blue blue or do you wanted to be different colors all of them the colors that's the gravel buried cuff I thought like that look so see you think you're mine I'm gonna control Z to go back you want one of these up here huh yeah I'm gonna go with purple oh that's really really dark undo how about if we come in here and go to format and then shake Ville and then bring it and we will open that James says to that one that's bad and now it's raining it's raining on the streets of Seattle we've got to wrap this up I got a trick yeah go ahead all right there's Excel is fun all right let's see it it is it is starting to rain if I can figure out I think we're going to go if we can go equals arrow arrow so I'm going to do change these labels down at the bottom and I think shift seven gives me an percent and then character ten yeah character ten it's a hard return lap the dreaded laptop and then I'm gonna go ampersand arrow so now I'm going to get these labels control enter and copy shift arrow arrow control V on learn that from mr. excel now I'm gonna I know how to use a laptop go click the chart and go up to design and select data and edit these and now instead of those over there I'm going to select these click OK and what what happens is the label says game 1 and then below it's his 5 now I don't like that I'm gonna put boy am i slow on laptop here I'm going to add one more thing here in double quotes space hits and double blow it I think that's a double quote right-side space all right so this is hilarious control-enter and then I copy it down ctrl C shift arrow arrow again I learned that from mr. so now the chart looks better alright snow Isaac Isaac who gets the point who gets the point who wins who won this one this big dueling podcast today you me we'll leave it up to the people and they'll put their comments on YouTube alright so is it Excel Excel is funner mr. Excel or Excel is fun Excel is funner hey oh hey I want to thank everyone for some quality next time for a dueling excel podcast from mr. Excel Excel is fun who are you
