 Guitar and Excel open chords C major scale C major chord and related scale Get ready and don't fret remember the boards fretted. So you don't have to be 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 construct this from a blank worksheet, you may want to begin back there However, you don't necessarily need this workbook if looking at this from a music theory standpoint because we will simply be using It to map out the fretboard give us the scale and related chords that were focused in on If you do have access to this workbook, there's three tabs down below example og and the open chords C Let's go to the og tab This is the worksheet we put together in a prior section it now being our starting point We will typically copy over from this worksheet and then make adjustments to it So we don't mess up the original worksheet the example tab represents some of the adjustments that we will make to it kind of the answer key after we adjust the og and The open chords tab is the tab that we copied over from the og tab in a prior Presentation and are now continuing to work on at this time Quick recap of what we did in the prior presentation. We went to the og We have the entire fretboard over here and we want to minimize much of the fretboard So we can focus in on one component of the fretboard and then see it side by side as we can see here With our scale and the related chord that we're working on So we minimized it down to just zero to fret number three And we put it side by side with our worksheet which gives us the scale down to here Here's notes one through seven and it gives us the related chords that we're going to be working on and we're starting with the first Chord of the C major scale, which is a C major chord Which has the three notes in it to make a C major scale of C E and G We color coded those map them out on the fretboard in this open position and discussed the different ways That we can basically finger this position the primary way of course being this way But we also noted that we could grab something up here, right? And we could grab it like this so I can grab this one and then I would still say let's copy this right-click and copy and paste and Then I would still have this one I can do that or I can grab just these three if I wanted to do it that way so any Any combination where I have these three notes in it will give me that C major scale Whether or not I'm ringing out all six strings or not, right? I could just grab that one right there and just ring out these three for example So now what we want to do is map this on top of the pentatonic scale So this is the related pentatonic scale in the key of C in this position We have the same fingering like this, but now we added some green notes Which is a little confusing these these greens are different than that green I hope that's not too confusing, but these are the added notes. So we have these two This one and this one those are going to be the added notes on top Now note that you could start to look at this pentatonic scale. You can look at this and say, okay Let me just start playing you know the pentatonic scale But we'll do that more later So we'll focus in on the pentatonic scale itself at a future point What we want to do at this time is just see how this C position is Inside of the pentatonic scale and that gives us a few more options if we're just kind of noodling around So when I say noodling around we saw before that we can kind of strum this I can start picking up some fingers And see how that sounds because the open notes should always work And now we have a few other notes that we can basically pick up these two We already probably were noodling around with before Because we said that all the open notes basically works if you're holding this position down Then you can pick your fingers up and you're revealing these open notes and that's going to work Well, we'll kind of talk about why it works in future presentations But you could see all those notes are in the scale So you could see them over here and that's basically why it works So you can also pick this one up down here. So if I was playing this position I can pick up this D right here With my pinky finger and you could see that's in the scale So that should be something that works and then you can start playing this if you wanted to and focusing in on particular components, so if I was to Play the C and then let's say jump up and then focus on these two notes and try to play something in between Sometimes it's useful some simple strumming just like two downstrokes on a C And then start noodling around up here Right, I'm just adding those two I can double stop it You know taking those two notes at the same time And Just play around with adding those into your into your strumming patterns and just seeing that those are available to you And notice what I'm doing is I'm I'm focusing in on these two and I'm letting go and saying okay The open strings are fine So I should be able to play that as well You could do the same you know down here and you could you know you could focus on on these two so I can start Looking at those two strings and so I could be And I'm just kind of noodling around in between some simple strumming pattern and again You could you could obviously do this all the way through and focus in on those specific Items and then what you're learning is you're kind of picking up part of the part of the pentatonic scale That's around around this in a in a basically a more of a natural way And then we'll pick it up more technically in a future presentation now you could do the same thing with the major so if I was to copy this down and Paste it down here So now I'm just going to copy this whole thing and move it down on the major the major looks somewhat chaotic It's basically the same thing as the pentatonic But now we have all seven notes in here and note that the pentatonic scale is usually something that's a little bit safer when you're switching around from from Chords to cords or if you're playing on top of something else So it's useful for it to have the pentatonic, but obviously the major scales gives you a few more options They all fit within each other and again you can kind of do the same thing So now you have the added blue notes and you could do the same thing and start to focus and you could actually look at this I would call this you know position for I'll talk about that later of the major or pentatonic position you could call it a C a C position when you're talking about the pentatonic positions Which we'll talk about more later and you could start to memorize you could play up and down just the scale But again for right now. I'm just trying to say, okay What's available to me if I was just picking around in the C area, so now I can see you know up top I can see okay, so now I've got you know my C here I've got the G and then I've got another B that I can play around with and so I can do that I might focus in on these because I've got this nice little square here boom boom boom boom so that means I've got the open notes So you could see this little square of these two and these two that's pretty easy to kind of play with so You could That's a kind of dissonancy way to play it with this to you like that gives you a lot of more tension But you can do a whole lot of stuff just focusing in on particular points in this You know in this pattern and then start to understand each each part of the fretboard as you're kind of focusing in on one piece You know at a time So that would be the general my general strategy that I'm recommending here And then if I copy this down here Once you can kind of see this position Then you can kind of try to fit these together in terms of what is actually going on With the major and minor scales you can see this This represents the cord that we're playing and then on top of that the green notes represent the added Pentatonic notes and the blue notes Representing notes that are on top or added to the pentatonic So so if you're if you're looking at this you can actually think of the blue notes as the base They're at the bottom and then on top of that we put the pentatonic The pentatonic which are the green which are going to cover up some of the blue notes because the green notes are within or Inside of the blue notes which are the major scale and then the ones that are these colors We put on top of that which is going to cover up the green notes that already covered up some of the blue notes because the actual cord fits on top of The the pentatonic scale which fits into the major scale So we'll talk more about that later, but just conceptually that might be interesting now note Also, you might be thinking well, what happens if I move If I move this shape up to the four and the five because we talked that could be an easy thing to kind of start Playing with if you're just strumming around I can move this full shape or some part of it up to the To the one four five because those are the major chords Well, you have to kind of be a little bit careful when you're thinking about what's going to be What's going to be around it because if you if you move up to the one four five like if I move this position From the C. I use the C open C position, but now I'm up Here playing an F Then you could think about that as though you're switching entirely from the C scale to the F And that in that case all the other relative scale positions would follow you and you can play the relative scale positions After you move up the fretboard and that's fine to do or you can think of it as you're still in the key of C But now you moved up to an F Which means that you're you're going to have different Related notes around it. So let me just kind of map that out. We'll talk more about that later But let's think about it a little bit more here. I'm going to unhide D to K right-click and unhide and let's go down for example to to this one so and let's hide from The 12th fret over to our Information here right-click and hide So so now we moved up to the fifth now the fifth if I move the shape up here You could say okay. I just all I have to do is move this shape up and I see my shape right there and I can finger my shape and So that looks good now You could finger it and try to pick this up finger at different ways But if I just use that same shape and I just played these three notes or the picking this one up, too Then I could just move that exact shape up like we talked about before so I can be playing this shape and I can move it all the way up to 10 and I can play it here and I can pick it up Here and then I'd be playing this is my route now This is the C shape that would be my route going up here So you might be thinking well, what about the relative or related notes around? Around that note well if I'm thinking of myself still in the key of C But now I'm moving up here I can play the related C notes which means you're gonna have a different set of notes around it or again I can think of it as me switching completely from the C to the to the G So let's pretend we're still in the C here So let's let's select this entire thing and say okay if I select this entire thing and I'm gonna go To my formatting and say we're gonna say this is equal to and We already have a C so let's go Actually, what do we have? We don't have a C. So let's go to a C. I'm gonna make that blue custom formatting and fill and I'll make that blue and Then I'm gonna say okay, and then I'm gonna go another one this equals and then a D We already have an E. We don't have let's make an E custom formatting Making it blue. Okay, and then let's go to another one and do custom formatting F we don't have yet. So I'm gonna make that blue custom formatting blue Okay, let's drop this down a little bit more and Then let's do custom formatting The G we have the a we don't have let's do that one and say okay, and Then okay, and then the B. We already have so if I look at this one I'm gonna say copy paste. Let's make some We're if we're fingering say this Which is our normal C position that we moved up and I relate that to the C position that we that we would have back here Which would be here Here and here So you can see the shape around this one is not going to be exactly the same When you when you're looking at the full major scale because now I'm putting the chords around it that are still in the key of C I'm just playing the G the G chord which fits in The key of C so so you can't play so in other words what I'm trying to say is that you can't play the symmetrical shapes if you're thinking about moving up up here and still playing the notes around it that are kind of in The key of C however, if you think about going up here and switching entirely From the key of C to the key of G then the related shapes pentatonic and major will be the same They'll be symmetrical and that'll sound good if you if you're switching the whole thing up So and by the way these two might look similar to you So let me just map it out a little bit more clearly if we look at this first position We've got this one of this one and this one over here We still have the same relative positions mapped out But if you look down on the next string down you've got here here and here Versus here here and here so you have a difference of positions here and then here here Versus here here here so same positions, but here here you only have those two versus a different position here So they're not exactly the same To show that I'm going to adjust this worksheet on the right to be in the key of G as opposed to the key of C So we can map out this information on the fretboard in the key of G So I'm going to unhide from L to AK to do this right click and unhide I'm going to unhide from 153 to 169 Right click and unhide. I'm going to go to my key over here in number format and change the key number from a 4 Which is a C to an 11, which is a G Unfortunately, it's not mapping out over here because I have absolute references So I'm going to change them if this is too technical you can fast forward, but I'll show you what I'm doing here We're going to say this equals to the X lookup tab and I'm going to pick up this number plus This number and I want this number to be able to move down when we go down But not to the right when I copy it to the right Therefore, I'm going to put a dollar sign before the letters, but not the numbers and I'm going to say plus this Number and that one I wanted to be able to move to the right but not down therefore a dollar sign before the number but not the letter and Then comma the lookup array I wanted to look up that number which will be a one in this case and the scale In the scale relative positions And so I'm going to make that absolute because I don't want those arrays to move as I copy them Comma and then the return array. I wanted to give us this Numbers that are representing the notes and then f4 on the keyboard Closing it up and let's copy that across and see if it does what we think it should So I'll copy that down and then down here I have to change this one too because it also has the absolute reference. So this equals the X lookup tab I'm just going to pick up this note up top I want it to move as I copy it both down and to the right so no absolute lookup array I wanted to find it over here in our notes control shift down And then absolute f4 on those comma and then the return or what array I wanted to give us the one with the number and the letter control shift down f4 on the keyboard And then closing it up And hopefully I've got that correct. So now I can copy this across And copy this down Okay, hopefully that's correct. I'm not gonna we're gonna Trust it right now and then I'm gonna hide from 12 over To my scales over there or my worksheet hide that And then now you can see I have the G Uh in my in my first position. So I'm gonna say okay. So now Let's make it a little smaller so we could see everything We're gonna let's just map this out in the key of g So I'll map out these notes rather than in the key of c, right? So if I select This entire thing this entire thing from here on out And then I go into the layout and I say this is going to be equal to And I'm going to be picking up. Let's put this up here This one and I'm going to make that Uh custom fill blue Okay, okay, and then boom equal to this one. I'm going to make that custom fill blue. Okay Okay, and then equal to this one making that custom fill blue Okay, okay Equal to this one making that custom fill blue. Okay Okay equal to This one making that custom fill blue Okay, okay, and then equal to This one making that custom fill blue okay, okay equal to This one making that custom fill Blue okay, okay And then I'll put on top of it these three because now I'm going to be mapping out the one note Which is now a g instead of a c. So I'm going to say let's make this This note and I'm going to make that green. That's now our root And then I'm going to say let's make this one This note that's going to be the red the third And then this one is this note which I'll make yellow And so there we have it and then I can say let's format paint this to here format paint this To here and format paint this To here and so now you can see uh when I when I move up To this position up top That the relative position Will move up right so this this whole relative position should be the same as uh the relative position We had here right this information here. Let's let's hide from here to Here Right click and hide Scrolling down a bit So now we've got this whole piece When I was in the open position And I'm going to put this over here And then here's we were fingering this this And that that would be in the key of c. Let's take this out entirely And then if I finger this Down here, we would be in the key of g now And we would be fingering like these And you can see the relative the whole relative position is the same So the point is that if you're noodling around And you're saying okay, I'm going to be moving this c position up to this c position And then the next thing is well, can I can I then noodle around in the same relative shape? You can but just realize that when you do that you you're not you all the notes may not then be in the key of c You've basically switched you want to switch in your mind that now you're in You've actually switched all the way to the key of the next key in this case the key of g So now I was playing all the notes and you can do that in the in the song But just know that you switch the other way you can do it It would still sound good Is that you can move up here and you can play all the notes that are still in The key of c around these three notes Which happened also to fit in the key of c which means that the whole relative shape Around it will not fit. It's just those notes will fit But but then when you noodle around it You'll be playing the notes that are still in the key of c As opposed to the notes which are in the key of g which will have some different notes So that so that's just a point now that we can practice when you're kind of noodling around and you're thinking Okay, I can I can noodle around here I can use all the open chords and then I can move this thing up I'm still in the key of c although I'm playing a g because the whole g chord fits in the key of c What about those other notes? You can again you can use the symmetrical position, but then you're kind of switching The scale so but it's you know, you could totally do that Just it's useful to keep in your mind that now you've switched the scale All right, so we'll play with that We'll play more technically next time and start looking at the at the numbers and the intervals