 Guitar and Excel Open Chords C Major Scale G Major Chord Worksheet Get ready because it's time for our guitar skills too! 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 you 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 chords that we're focused in on If you do have access to this workbook though there's currently four tabs down below Three example tabs and one OG tab The OG tab representing the original worksheet we put together in a prior section It now acting as our starting point showing the entire fretboard giving us the entire musical alphabet in both letters and absolute numbers showing the worksheet and the key allowing us to then change between scales giving us our worksheet for the scales and chords that are constructed from it on the right Now in prior presentations we've been focusing in on the C Major Scale and looking at the chords in the C Major Scale and we started with of course the chord of C which is in this first example tab We hid all of the fretboard except for the open position which I'm defining as the first three frets We mapped out the key of C showing the one in green, the three in red and the five in yellow We talked about the fingering, we talked about the positions We talked about it on top of the pentatonic scale, it on top of the major scale and so on We then moved to the four chord in the key of C remembering that we're still in the key of C We're mapping everything out in the key of C but this time building the four chord which happens to be an F major chord We then constructed that in open position remembering that in one sense it is an open chord because it's being played in the first three frets but in another sense it's a bar chord but we constructed it here, we talked about it in relation to the pentatonic scale for the C Major Scale because we constructed it from the C Major Scale and we're mapping it out in accordance with the C Major Scale We then looked at it in alignment to the C Major Scale for the pentatonic This was the pentatonic and this is the full C Major Scale And now we're going to do a similar kind of process for the chord of a G Major So now this is what we're going to do, this time we're going to copy over the OG tab and construct this one Now we moved this time to the fifth Remember that we skipped the second and the third, we will go back to them Why are we going to the fifth? Same reason as why we went to the fourth instead of going to the second note first and that's because the one four five as you can see by the lettering here in uppercase in Greek letters or numbers are the major scale constructions So when we construct from a major scale, C Major, when we build off of the one four five we end up with a major chord and those will be related to each other so it's useful to think about them together So then we'll map out the shape, we'll map out the shape on top of the pentatonic scale Again the pentatonic scale in the key of C Major and then we'll map out the full C Major Scale and our shape within it will put the two together and then we'll contrast that to if we were going to construct this in the key of or then we'll take a look at the shape and how it could be movable and then we will contrast what we have done to us constructing the G Major shape or chord if it was the one chord and a scale of G Major instead of the scale of C Major So we'll talk about all that as we go forward This time we're just going to construct the worksheet So I'm going to go to the OG tab, here's our OG tab I'm just going to copy it over hold down control, left click on the OG and then drag it to the right and then I'm going to double click on it down here and call this, I'm going to call it blank G and then I'm going to right click down here and make it white so the one we're working on will be white Alright and then in our key up top I'm going to change it to the key of C again Now note, you might think I should have it on an 11, the key of G because we're focused on the G chord but we're not constructing the G chord from the G Major scale we're constructing it from the C scale and we're mapping out the C scale So I still want it in the key of C we're still in the C Major scale but we're going to look at the 4 chord I'm sorry the 5 chord which is going to be the G Alright, now that we have that I'm going to hold down control and scroll down a little and I'm just going to, let's first get rid of this conditional formatting I don't need that yet because we'll do our own formatting Home tab, style, dropping it down, clearing the rules and then I'll copy from 1 down to 25 so I'm just copying it down to the end of this worksheet I'm going to copy that over, paste it on top of all the ones below it because the ones below it were mapped out to show the modes I don't want the modes, I just want to redo the same thing over and over again, focusing in on the key of C over and over but from different angles so we'll just paste this on down, paste it on down, paste it on down paste it on down Okay, so now we have our framework I'm going to now look, I don't want to look at it in terms of numbers so I'm going to hide from 1 to 12 right click and hide all that stuff so now I can just see my fret board with the letters and the numbers on it and then I'll make this small and I'll say, okay, now let's hide from open position 1 to 3 frets and get rid of all the other frets so they don't confuse us at least at first and then hide and then there's our process and check it out, let's zoom in and check it out we're going in with the zoom and out with the checking so we'll zoom in and then check it out alright, so we're going to say this is going to be the 5 right there and then, okay and then let's go to the shape fill and say it's a yellow fill okay, so first what we'll do is we'll just map out this shape now just a quick note, once again we're building a G major chord I know it's a G major chord because when I constructed it, even though I constructed it from the C major scale I constructed it from here and just picked every other note which is a B and then a D and I know because I constructed it from the 5th position of a C major scale it will construct an interval that corresponds to a major chord instead of a minor in other words, the 3rd is 4 notes away as opposed to the 2 and the 3 which will be minor chords which will 3rd will be 3 notes away if I was to compare it to the G over here in the OG tab if I constructed this using an 11 a G then you can see that when I think about the notes in the chord I think about the 1, 3, 5 if it was the 1 chord, 1, 3, 5 of the key of G would be G, B, D or G here, B, D those are the same notes we got over here G, B, D but we constructed them starting from the 5th note of the key of C okay, we'll talk more about that later but I just want to point that out now here because we're focusing in you want to keep in mind that we're always focusing in on all the notes that are in and constructed from the key of C even though we're on a G major chord okay, enough, enough let's go to the home tab let's go to conditional formatting and say this is going to be equal to a G and I'm going to make that green that's our home key, that's our tonic that's our root note and we're going to hit the dropdown again and say the next one is going to be a B that's the major 3rd, 4 note away major 3rd, let's make it red it's red, possibly you can think of it because of the differential or key factor between a major and a minor so that's going to be your 3rd is the important one is it a major 3rd or minor 3rd is it 3 notes away or is it 4 notes away and then I'm going to say this is going to be our yellow 5th and it's going to be the same either way, the 5th just goes along with whatever if it's the major or minor it's like whatever I'm cool with either one so there we have it, so this is our standard shape this is a classic open G shape, big full chord having all 6 strings we'll talk about different ways you can finger it there's arguments as to what's the best fingering way to do it and you can see that we could build it with just these 3 notes which is useful to be able to see because that's a classic formatting of a major formatting which is of course movable, you can see it's kind of related to an A kind of position over here which we'll see when we get to a caged system because this kind of looks like an A kind of position here although they're all in the open thing that's what you would finger in an A but you would be doing it over here right and then these 2 you have the choice of should I finger one or both of those and how should I do that we'll talk more about that later but that's your classic G open position shape alright let's scroll down and now lay that on top of the pentatonic position so let's think about that I'm going to hide the numbered ones again going from here to here I don't want the numbered ones right click and hide those and so then I'm going to hold control and scroll back out again so this time you'll recall that if I'm looking at the key of C the pentatonic scale is 5 notes out of the 7 and they are the 1 2 3 5 and 6 and I'm going to make those home tab font group green now remember that I'm looking at the pentatonic scale this time in the key of C because that's what we constructed the G chord from you could think about switching entirely to the G chord and we'll take a look about what that would look like later that's your choice when you're moving from the 1 chord to the 5 chord like if you're noodling around within the 5 chord you could pick up notes that are outside the C scale but in the G scale making it sound more G-ish or you can add notes and noodle around with it adding notes that are in the C scale making it sound more in alignment with the key that you're in which is the key of C or you can try to make it the tonic where you're making it the tonic even though you're playing the C notes which means you're going to be playing in a different mode about that later let's go ahead and grab these I'm going to add the pentatonic scale first remember it's the C pentatonic scale not the G pentatonic scale home tab let's say equals and let's pick up the C and I'm going to make these green so pentatonic green and then I'm going to say boom this is going to be equal to a D and I'm going to make that green that's going to be green boom and then we're going to say this is going to be equal to an E we're going to make that green boom boom boom and then this is going to be equal to the G I'm going to make that green boom boom not that green wrong green this is going to be G I will make it that green but later I subconsciously went forward I'm getting ahead of myself I put the cart before the horse which I still think the horse should be able to push the cart with this big head with this giant head up the hill that might be a better I feel like that it might even be a better way to put the cart in front of the horse and tell it to push the cart with its head anyways this is this is the shape then that this is the shape that we've seen in the past and now this is the C major pentatonic now I'm going to put the G chord on top of it that we constructed from the C now note that these three notes are in the C major chord because we constructed it from C major but they're not necessarily all in the C pentatonic meaning this B in particular is not I can see it right there right I can see that clearly that is not in the pentatonic so when I if I was to kind of noodle around with this thing then I would have to note that the B here when I go if I was just doing the pentatonic is not in here there's the other one I was like where's the other one right there and see that okay in any case so let's go ahead and select these and then I'll add these on top of it so I'm going to say this is our scale that we're working it on this is going to be this one this I'm going to make the other green this is where I put up the other green now so now it's that green hopefully that's not too confusing and then I'm going to say this is going to be the this one is red red and then this one is going to be the yellow the yellow as has been our formatting and then I'll just conditional format this here green this is the red one and this is the yellow so so now you could see the pentatonic scale and then adding that B note to get the G fitting on top of it so now let's do the same thing but with the whole C major scale well hold on I need to delete the numbered ones we don't want the numbered ones I'm going to go from here to here I'll hide this worksheet right click and hide and then I'm going to go up top okay here we go let's do it again but this time with the whole scale in open position of the C major scale and then we'll put our five note on top of it so I'll select the whole thing I'm going to say alright let's do this this time I'm going to build the C major scale that and this is the scale that we constructed this chord from so all of the notes in the chord have to fit within this scale for sure right so we got the C and then we're going to say this is going to be blue I'm just going to make them all blue this time and then I'll put the chord on top of it so I'll make the D that's going to be blue blue and then I'm going to say okay and then like the E is going to be blue blue this is not the blue note by the way in the blue scale just want to differentiate to that I would like to get to the blues stuff later because it really it's actually quite confusing people try to say the blues thing is easier but if you try to figure out what they're actually doing it's like what in the world how does that work so it's a little it's definitely not easy but here we go and then we're going to say this is this one and this is going to be equal to this one this one alright so there's our our scale so you can start to see that if you want to play just the scales right and this is the C major open position scale I would call it scale position number four but some people will use that C as like the root to kind of name the scale around that position so then I'm going to put on top of that then the C or the G chord that we constructed in here so I'm going to say this is going to be the G let's put that as the green and then that's our the root or the tonic here's the red for the third and here's the D and that's going to be the yellow so there we have it and then I'll conditional format this over here just to finish this out and we'll look more deeply at this later but let's just set up our worksheet and prep this is the prep work you get to see the behind the scenes prep work for the next one alright so there we have it now next just to completely confuse ourselves let's scroll back a bit and say what if I put those three together and I try to I try to put the pentatonic on top and then so let's hide these first before we start talking about that cart before the horse cart before the horse okay okay here we go we're going to say then let's now this time we'll we'll construct the pentatonic and then we'll put the the other so I'm going to say the pentatonic are these three notes or five notes five notes penta pentatonic alright so then we're going to construct on I'm going to try to build everything on top of each other so let's say the foundation is once again the C the C major and then I'll put the pentatonic on top of it so you can see how the pentatonic fits in the C major and then I'll put the chord on top of that so I'm going to say alright let's do the same thing we did last time this equals the C let's make them all blue first blue boom boom let's copy this thing down here because I'm focused on that'll tell me where my focal point is on the five chord alright let's do that again so we'll just first put just build our C major in open position again there's the D I'll make that blue make it blue my brown eyes brown eyes are blue I don't know I'm getting tired here let's make that blue and then we're going to say this one is going to be blue and boom boom and then this one did I have a G yet no let's make that blue boom boom boom and then we'll make this one A blue and then boom boom boom and then uno vase moss one more time por favor please okay so there's our there's our major scale again and so now I'm going to put on top of it the pentatonic scale so we can see how that fits in remember we're in the key of C not the key of G even though we're then put the G chord on top of it which we constructed from the key of C so now I'm going to say this is going to be the pentatonic is going to replace some of the blue ones let's make that one green boom boom and then let's make this one this one the the D is a pentatonic type undo though because it shouldn't be red it should be green pentatonic green D boom boom boom and then we'll say this is going to be this one's in the pentatonic so we'll say okay now the four is not in the pentatonic as we saw last time when we looked at the F chord so we skipped that one but this one is in the pentatonic and so we'll say Dune the pentatonic is the cool club with all the cool notes are in it and they just leave out the four and the seven because they're just main they're main like that they're like high schoolers or something and so there we go so now you've got the pentatonic and yeah that looks right and then when I put this one on top remember that this note is in the chord but it's not in the pentatonic although it is in the major because we constructed this chord not from the G major scale in that case the chord would be inside both the pentatonic and the major but in this case we constructed it from the C so let's just keep that in mind as now I put this one on top and I go okay this is going to be this one that's going to be a G let's make it green and then boom and then this one is going to be that one is red and then boom this one is the D and it's going to be yellow yeah that's how we do it and then boom so now I can let's format that over here so it looks kind of chaotic once constructed but hopefully the construction of it maybe did something useful for understanding purposes alright so next let's do another one down here this time I'd like to see it as though we're going to map out the relative position shapes so let's just see this again I'm going to go okay let's hide from here to here and then right click and hide and so and then now what I'm going to do what I'm going to do is going to be let's see some more of the fret board so I'm going to open up the fret board I'm going to go from D to AK right click and unhide and then I want to see the fret board out to like the 13th fret so it starts over at 12 but I'm going to go out to 13 and then I'm going to hide over here right click and hide okay so now what I'd like to do is think about if I'm starting on the 5 right here and then and then I try to move that shape because that shape is movable right and I can move it up to the other to the other ones that are that are major so that would be the 1 and that would be the 4 so let's do that and just think about what that would look like I want to put this on top oh man okay so now I could say okay if I was in positions 1 through 3 then I could say that would be our normal G shape there's our G shape I can say let's go do this again insert this one is a G I'm going to make it green okay and then this one is a B it's red and then this one is going to be a D and it's going to be yellow okay and then I can't really move back to the 4 because it's a nut right I can't go backwards so if I go up around the horn going around the horn to the 1 then now I'm back to a C so you'd think I can move this up until I get to a C I'm looking at this G right here and I'm going to move it up until I see a C on that string there's a C so I'm going to say alright what if I move that position up right here then I can play the same shape or let's first make these colorful I need to have these nicely colored so let's do that first okay so then so now if I move it up to here I can say okay so then if I move this shape up I should be able to play the relative 1 position with that same shape right which are going to be these 3 notes so I'm going to say okay insert and that's going to be the C is going to be the green and then the this is equal to the E which is red and this is equal to the G which is going to be yellow so there we have it now note you have the same shape here but now instead of playing a G you would be playing a C now a lot of people will say well you can't really do that because I can't play an open G up here it's going to be difficult to play but you don't have to play all 6 strings right you could just play these strings right here and you'd be playing the same shape you could just play these 3 strings we'll talk about that later this is kind of like an A shape because the A and the G are next to each other when we talk about the cage system we'll talk about that later but you could play some combination down here these are on the same string but you could do some combination so that's useful to note and then if I was up here at the 1 I can move that up to the 4 so I could move it up to the 4 if I was here so I'm looking at the 4 starts as an F so this C when I go to an F there's an F so I thought I'd move that same shape right there then maybe I should have this aww come on come on I want to include the frets in my analysis okay alright alright alright so then we can do these ones so we can move it up here now this is going past the 12th fret so we start to start over on the 13 but then it just starts over right so we can do that if we want to so we're going to say okay this is going to be equal to the F is green and then boom then the next one is going to be an A and it's red and then the next one is going to be a C and it is yellow like old yellow the dog that died in that sad movie that they made me watch in grade school why do you do that why are you forcing me to watch the dog I had another one like where they made the dog died too sad dog dying movies when they tortured you in grade school anyways whatever this is going to be an F this is going to be the A is red the A here is red and then the C is there so you can see you can move that shape up and when you we'll talk more about that later because you could still think of the C as the tonic you could move from C to G and then move the G up to the 8th position so that you're basically playing another C there's another way to play the C and then you can move it up to the F or you can start to think of the 5th as the tonic even though you're playing all the notes in the key of C and you can play these positions and then you would basically be playing in a different mode we'll talk more about that later but you can practice moving this shape around if you wanted to we'll talk more about how to do that in future presentations we're focused on the first three frets right now but just want to introduce that idea and we'll talk more about it in the next couple of ones now the next one I wanted to do is to just say well what if I changed the key so let's hide some cells first let's hide some cells and then we'll talk about that another extremely interesting topic and important to everyone so let's go ahead and hide these and then I'm going to unhide the key up top so I'm going to go from N to AK oh man I missed it N to AK right click and unhide and then I'm going to go into my key and say well what if by contrast I constructed all the stuff in the key of G so I'm going to change my key to an 11 which now shows me my worksheet now not in the key of C but in the key of G what if we did that then alright let's check it out so then I can go back up top and let's hide from the O 13th fret to our worksheet on the right right click and hide and then I'm going to hide the numbered ones up top so I'm going to go from the here 128 down to here don't need that right click and hide okay so now let's build this as though we're looking in the key of G now so now the G is the one so I'll say copy paste the G the G is now the one and if I just if I plot it out as the one it's going to be the same it's just that now we constructed it from the one and picked every other note 1 3 5 1 3 5 and of course we get the same intervals so it's the same chord so we're going to say alright let's do that let's say but first before I plot that it'll look the same let's plot the whole major scale here this time in the key of G instead of the key of C so the notes around it will differ now because now I'm playing it because now I'm constructing it from the key of G not all the notes in the key of G are the same as the key of C but the three notes that we're building the chord from the G major chord are in both the key of G and C okay so let's do this let's select the whole thing and go to the home tab drop down this is going to be equal to I'll just make a G and I'm going to make this custom color custom color I don't like the colors that you have provided I would like a color that is not on the menu okay I hate to be picky but what you're giving on the menu is for the common folk and I happen to be special so I would like something that is not that is custom custom to my particular and more sophisticated needs excel and so I'm just going to make all of these blue and then we're going to say this is going to be here and we'll make this one blue and boom and then this one is going to be here and let's make this one blue and okay and uno base mass custom blue boom so we have different shapes that we'll see when we'll do the comparison I'll show them later when we get into the future presentations but we're still folk if we focused on this first three frets we'll still see that although the shape is different than the shape we saw before if I compare this shape for example to this shape it's not the same shape it has similar notes, some notes in common but not all of them but some of the notes in common will of course be these three notes so let's do that let's select this whole thing and then say conditional formatting put the three notes on top of it the G now constructing from the one position is green and then the B is red and the D is yellow just like old D was old yellow old yellow alright and then it could be a young yellow too that also sounds good I had a young yellow but then the young yellow got old I used to call him young yellow young yellow but then he got old and I had to change his name to old yellow old yellow so now that's going to be our starting point so now we'll talk about this more in future presentations thinking about how we can map this out and looking at the relative positions for these items