 Guitar and Excel open chords C major scale G major chord on a C scale get ready because it's time for our guitar scales to Excel Here we are in Excel if you don't have access to this workbook That's okay because we basically built this from a blank worksheet, but we started in a prior presentation So if you want to build this from a blank worksheet that may want to begin back there However, you don't necessarily need access to this workbook if looking at this from a music theory standpoint because we will simply use It as a tool to map out the fretboard Give us the scale and related chords that we are focused in on if you do have access to this workbook though There's currently five tabs down below. We've got three example tabs and an og tab and a blank g tab The og tab representing the original worksheet we put together in a prior section it now acting as our starting point Going forward. We've got the entire fretboard here We've got the entire musical alphabet mapped out in both letters numbers as well as both letters and numbers We have our key which is adjustable by this green note We can change it from a c or 4 to an 11 or g back to a 4 for example Which will help us to construct our worksheets on the right hand side Providing us the scale and chords that we are focused in on we then copied over the og tab To focus where we want to focus this time which is in the key of c major and then Breaking down the c major into its components looking at each note in the c major scale And then building chords from the c major scale on them Starting of course with the one which is a c major chord in the c major scale That is represented in example c tab. We then minimized or hid many of the columns So we just see the open position We mapped out the c on our fretboard noting that this string represents the low string or heavy string The one closest to the ceiling and there is our c shape We mapped it on top of the pentatonic scale on the key of c and the major scale and so on and we analyzed it from there We did a similar process for the f chord which is built off of the 4 Note in the key of c so we're still thinking of ourselves in the key of c But then we jumped to the 4 we jumped to the 4 instead of the 2 or the 3 first Because the 1 4 5 will construct major chords and the 2 3 6 will construct minor chords And we want to put those two types of chords together So we will see similarities when we start mapping out the shapes So we're still in the key of c, but now we're looking at the 4 which is an f chord We saw it on top of the c major pentatonic scale as well as the c major Scale and then we talked about that now We're doing a similar process for the chord of g and let's go to the blank tab because this is where we're going to start Going forward so we did a similar process here We're still thinking of ourselves in the key of c That's important because when you're kind of strumming around with this stuff You want to be thinking all the notes that I'm playing are the notes in the key of c It just so happens that I'm focused around three notes that construct a g major chord But I constructing it from the c major scale in this case We then minimize the fretboard looking at just the first three frets We mapped out the g chord So this is the shape of the g chord that you want to have kind of in your mind because that's another shape that you can kind of ground yourself with as We think about moving the shapes up for example and we're on the five chord We're on the five chord instead of going to the two or three Just like we did with the four chord because the five chord here when we construct it will be a Major chord we construct it from the c major scale You could start here on the five and then take every other note in the c scale Which would be a b and then a d now remember that when we number these notes We're going to number it a 1 3 5 of The g those numbers are relative to the g as if we constructed this from a g So if I go back on over here to the og tab I change this to a g which is an 11 Now I have this worksheet in the key of g I get the same notes now in the one position g b d which I can see here g b d as the 1 3 5 So if I go back to my blank tab g b d, I'm calling it 1 3 5 instead of calling it a a 5 7 2 Which is what we actually constructed it from in the c scale because that's the tradition that we do But remember we kind of think about it in intervals so I'm basically saying this is the one because I'm thinking about that as my route and then The three is a major third away or four notes away, and then the five is seven notes away That's another way you could think of what does it mean to say it's a one three five? Okay, we'll talk more about that later though. We then took that position and we were now want to map it on top of The pentatonic scale so that's going to be our process here And then we'll map it on top of the major scale now as we do this We want to keep in mind that when we look at it in terms of the pentatonic scale we're looking at it in terms of the c pentatonic scale and We could think of it as though we're switching when I'm going from the one the one note To the five notes switching entirely to the g which means you can visualize the g scale on top of it But that's not what we're doing right now We're visualizing the g that we can play inside of the c The c major scale now It doesn't exactly fit in the pentatonic scale because we had to remove two notes here So what we what we have here in green is the pentatonic scale for the c major pentatonic scale in the open position I would call it position number four, but we'll get to pentatonic numbering later You could start to just visualize that scale and start fingering it, you know up and down But that's not really our objective here our objective here is to see that the the g would fit in The c major scale now it doesn't quite fit in this pentatonic scale So you'll note that this note right here is actually not in the pentatonic scale the pentatonic scale is made of these Five notes and that b is the seven. That's one of the notes that we remove So when you're kind of noodling around with this if you picked up that g if you think about the pentatonic scale You could play the pentatonic scale and still pick up that b if you're playing kind of like the five because the b will be Related to the chord that you're that you're basically playing in so from a practical standpoint then you might How could you use this you might be saying let's make this So so remember we're kind of thinking about this as though it's in the The key of C so one way you can do this is you can start you can start noodling around with what we've done thus far a C an f and a g remember that we want to think of the C as the tonic It's what we're G is what we would normally start with meaning I'm playing around the C most of the time And then I can shift to a G to an f And then a G And then back to a C and see how C kind of feels like home right there And so and then as you're as you're kind of doing that you can reveal anything you want because I'm Imagining all of this being inside of basically the G major scale more Specifically in this case the pentatonic scale. So as I'm playing any of those Chords I can always lift up a finger Because I'm always thinking of them as being built from the C major scale and all of these open notes are in In that in that scale. So if I so if I copy this G down, let's copy this G And I'm gonna say copy put that here and put that here and put that here and Then put that here So we have that and then I'll make these ones read just so you can see that's the one that's outside of The pentatonic scale So so then So then anything that we're playing here I can always lift up a finger And then when I get to here, I can play it this way. That's the G one way to play Or you can play it this way And remember you have some options with this finger down here I could lift up my finger and reveal the E the E's not in this chord But it's in the shape so that would be revealing a 13 if you wring it out Or I can I can mute it and I can play the D So you can kind of lift that finger up As well now if you if you look at this shape You'll note that I have like these strings up top that I could I couldn't play around with so if I was Right and you can start to like noodle around in this position and I would say that I Would actually imagine it as though I'm kind of noodling with just these notes Because then because the open notes always fit so So no matter which I'm playing right I can be switching from a from a C To an F To a G right and I can kind of noodle within those notes And do whatever I want to do, you know within those notes you'll also note that these three are Are Something that you can noodle around with and now I'm saying I'm gonna add that B Even though it's outside of the pentatonic scale I can imagine it as the pentatonic scale with that added B when I'm on the key of G Right because that should fit you can also imagine this remember that I can say if I don't want to keep on going back To the C as the tonic and I just want to practice in this G position I can start to see these notes as basically So so that means I'm gonna change this to the tonic. I'm not gonna switch to the key of G I'm still gonna be playing in the key of C, but this is like my tonic, right? Which is gonna be a mode remember that if I go to the right and look at the modes I can look for the mode with a G in it. So let's do that over here if I go, okay The one that starts with a G in the mode is gonna be Do-do-do-do-do-do-do-do here mixolydian and if I hide this mixolydian I'm gonna put it next to then the major this time So we'll say to do let's try to keep my circle and then I hide all that stuff So now I've got The mixolydian let's make this a little bit smaller and You can see you basically have the same thing here, right? So now you're playing this is the one You still have the the the notes that are going to be The one four five as the capital Representing that they're constructed a major chord and here's over here. It's the one Four seven you still get the G you get the You get the C and then you get the F so you can see it either way I think when people are starting out, it's easier to just say, okay, I'm just gonna play this this G Same notes, but act like it's the root and then again and then if you're doing that you can start to noodle in here I could start All I'm doing is noodling these three notes in the middle between playing G You could double stop you can put double stop with one open and one not open you can play all three together Hammer on hammer off and then and then you could do the same thing with any other Positions you can add this one in there and then you could play it within there now You could do the same let's do the same thing down here if I add the full The full position here. Let's see if I can Let's see if I can copy these I'm gonna say Copy those and put them like down here. Oh, no, I didn't copy it Copy the I'm holding down control and selecting these and then I'm gonna paste control V paste down here And then I'm gonna drag these on top So now They look like that. Now if I look at this, this is the full C major scale So now I'm in the C major scale so now of course all three of these notes fit inside because I constructed this from the C major scale so again you could do the same kind of thing here and and pick out Some areas where you'd want to focus So there's that little box again that we keep focusing in on which is kind of a fun little area to play in so I could say Right and if you're just doing if you're just starting from a G then So now I'm going to a C and I'm just still playing that little box because I know that box is good No matter what I play I can play anything in here when I'm switching between these three notes. So if I start with a C So and then you could do the same with any of these Any box that you want right down here's a the other kind of little position we were playing with before So if I was just playing a G And this might be an easier one to play it this way right because if you play it this way I'm using this finger as my pivot So I could then play my G like that And now I have my finger is right on here because I'm using that as my pivot even though I'm actually playing this string to a C to a G to an F back to a G In the same little thing down down on this overall three of them because I'm imagining myself basically in the key of C and sometimes you might if you don't play that full G Because you could you could noodle just down here and say well, you know, I'm kind of playing a G right here by just holding down You know, I could just play these these note these open notes Basically, and I'm playing like a G because this is like the open G string right here So if I just keep on hand like playing that that open string You can have kind of some fun just down here And your home bass is that is that G string Be closing it out I'm just grabbing this a now. I'm adding that into my My little pattern, right? So if I grab that a So I'm kind of resolving to that G Which is kind of just these open strings the G right here D G B But I'm sometimes I'm not picking up that D and I'm just picking up the G and the B So it resolves really not just play those two open So anyways, you can you can noodle around with different things like that and And then use all of these notes in the throat as you're kind of going between These three notes and again at this point now You can think about any of them as the tonic Because now you would just simply be switching modes if you want to focus on any of these one particular chords and just kind of noodle around That chord while picking up other chords in between it or picking up other notes kind of in between as you're hitting that chord What you're doing then is basically just playing in a different mode or you're just playing the same C major scale You think of it as but you're focusing in on whichever chord That you want to focus in on which means that you're you're going back to it the most It's your home base. So people's ears will naturally just see that as home So then down here say this is the same thing where we have the Minor chords on top of so this is the the pentatonic scale Is is in green and then we map what we mapped first the whole major so everything that's colored is in The major scale and then we mapped on the green notes on top of it So that you can see that the green notes will fit in that's the pentatonic scale Which is the green notes here that will fit inside of the major scale because that's the Pentatonic scale of C on top of the major C scale However, this one chord when we map on this chord Although it fits in the major scale because of course we constructed this chord boom boom boom from the major scale It does not fit in the pentatonic because that B is the seven Which is one of the notes that we pull out So when you're thinking about playing the pentatonic scale in the key of C over the five note The G then you might add that B into your pentatonic You could still think about it as pentatonic with an added B Or you can think about it as basically you're playing the major scale in the key of C right and then We we could also say well, what if we were to to Think of ourselves in the key of G just to see the the difference here if you were to switch this and say what if I want to be in the key of G well then I can change my Worksheet so the key of G is the one note in a G major scale in that case You can still play this this shape of course Because the shape of these three notes will be the same But the scale around it will be different and I just want to show you that by hiding Some cells up top. I'm gonna go from here up to this one That one and right-click and hide So if we do that then You can see that this shape is in both of them like I can copy Let's try to copy this again. I didn't do it very well last time Let's copy and paste that and You can paste that down here and you could see that that shape is in both of them But when you look at it in terms of the full A Major shape. This is the C major shape pentatonic shape in open positions in the first three frets This is the G major pentatonic shape in open position And you can see just from those first three that it's different now We can learn we'll talk about learning those shapes later But right now you're kind of learning the shape of the C as you as you play all this stuff because everything you play Is within the C major? Scale and then and then we can do a similar thing and just augment what we're doing To another scale once we and every all the shapes will just shift basically all the stuff will be the same But you'll shift the shape which is still hard to do in your mind You can't just you can't just say I'm just gonna shift the shape and everything will just shift in your head It won't you're gonna have to think about it But it'll be easier because you already know kind of the shape built out in the C Major scale so when you start like when we think about moving this shape up like we said with the one four five Just remember that you can't necessarily Move you cannot move up all of the all of the shapes around it I can move up this shape that is that it's actually the the cord up according to like According to if it was the one the one four five or if I'm in the If I'm in the sea I can move it from the five to the one To the four right I can move that shape up like we talked about in the prior presentation, but the related Notes around it will will not necessarily be the same So you can't pick around the that shape if I move that shape up I can't like pick around it and think that I'm still gonna be picking up the notes that I want to pick up which in this case would be in the key of C major because the shape around it Will be different so that we'll talk more about why that is and what we can do with that later But for now just note that I would practice with these Notes and say now I can practice the note of a G and I can do so I can do so playing it multiple different ways I can pick up my finger as I play the key of G and Reveal all of the open strings as I still think of it in Playing the notes in the key of C. I can play the key of G in As if it's the five note using the C as the tonic because I'm gonna be hovering around the C or I can Pretend that this that the five note is the tonic even though I'm playing all the notes in the key of C Which allows me still to play the same shape around it and be Feeling safe that all the open notes will work and then of course I can also do that for the three notes that we've done out the three chords I can make the F the tonic Or the G the tonic or the C the tonic right any of those can be my Central point and I can noodle around or off of them right I could say I'm always going to go back to that as my home base and In between that I'm going to go to another chord or a piece of a chord or two notes Or I'll just noodle around in a specific little area back to that particular chord and And that'll give you that gives you like an infinite number of ways to play around Just with what we've done thus far, right? you could you could do basically infinite things if you add rhythm on top of that and whatnot and You know picking styles and fingering styles and whatnot that would be like an infinite number of things So and so that next time we'll continue on with this But we'll go we'll do we'll think about this more technically in terms of the intervals and whatnot And then we'll get into the minors after that