 Guitar and Excel open chords C major scale C major chord worksheet get ready because it's time for our guitar skills 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, you may want to begin back there However, you don't necessarily need the workbook if looking at this from a music theory perspective because we will simply be using it as a tool to map out the fretboard and related Scale and chords if you do have access to the workbook There's two tabs down below example and the og tab the og tab Representing the worksheet we put together in the prior section that now being our starting point So we're going to copy over from the og tab So we don't mess up our og worksheet and then we will change it to Fit our current needs, which is represented in the example tab So let's go to the example tab to get an idea of what we will do from this og worksheet To get into this example tab and why so on the example tab We're going to take our fretboard and we're going to try to trim it down to just where our focal point is in this case We're looking at the open positions and this is going to be a common technique that is very very helpful when trying to learn the fretboard When looking at the fretboard you might say hey, there's not too much going on here. I can take that I can see the whole fretboard pretty clearly in my field of sight. It's not that big But when you try to analyze what's actually going on within it, it gets very overwhelming very quickly So the technique typically that needs to be used here is breaking the fretboard down into smaller components and looking at Specific areas of it and then building your understanding of it from there So what we're going to do is we can trim it down to just the open positions of the fretboard and then we're going to be Making it so we can see the worksheet over here which represents the major scale and C major and we're going to be focusing in on the one cord Which is going to be the C major chord and then we will map that out on our worksheet And we'll use these little tools here to be able to see How we can finger finger our positions and what's the different ways that we are Looking at this and then we'll kind of analyze what this looks like And then so we'll do that up top here so we can just see the cords We'll also have another worksheet down here so that we can see the cords on top of the major scale So we can see how this fits in the major scale We'll do the same thing with the pentatonic scale So we can see how the cord fits in the pentatonic scale and then we'll do another one fitting the pentatonic Major and the cords which have a lot of colors going on so that we can kind of go through each of these things and analyze Them how they fit together. Okay, so let's go to the og tab First thing I'm going to do is take my og tab and I'm going to copy it over so I don't mess up the og So I'm going to I'm going to hold down control Left click on this tab and then drag to the right and that'll just copy the tab over So now we've got the second og tab. I'm going to double click on it and and say this is going to be let's say open cord C and I'll make it white. This is gonna. I'm going to make the color white because the og is dressed in the og orange And this will be the one we're working in which is the white tab Okay, so then what we did last time is we we mapped out our fretboard in terms of numbers We mapped out our fretboard in terms of numbers and letters Which I think is a useful tool to look at the intervals. We numbered our scales So we built this by by having the musical alphabet a a sharp or b flat I'm representing that with a lowercase a and a b B C C sharp D and so on and then we numbered them these being absolute numbers here And that's going to help us with our intervals. So now that we have that What I'd like to do is have my major I want to focus in on the major scale now the way we constructed our worksheet is we're looking at C major here with the key on C So here's our C major and then and then underneath it. We've got the minor And and the Dorian related to C and so on but and then on to the right of it We've got all the modes related to C what I really want to do is focus in on Multiple layers of C because I want to I want to have a fretboard that I can map out in multiple different ways So what I'm gonna do is I'm gonna first remove everything on this fretboard I got a bunch of stuff in here. You may not have stuff in the fretboard, but I'm gonna remove the conditional formatting by going to the home tab Styles conditional formatting and clear them and Then I'm just gonna copy down The these the major the major one here so that I can focus so that I have it Repeating over and over again because that's where my focus will be so I'm gonna put my cursor on the one and scroll down and copy it down to to The 19 so as far as I want to go. Let's make it a little smaller so I could see exactly how far down I want to go Let's go from one down to Down to here 25 so I pick up everything Let's copy that and I'm gonna paste it right here Control V. So now I'm just pasting it on top. So I'm overriding what we did before so I can just repeat I'm just gonna paste it all the way down paste control V and Then right here. I'm gonna paste control V and Then here I'm gonna paste control V. We may not need all of these paste control V But I'll just have this one thing Repeated multiple times so I can look at multiple fretboards. That should be enough So then I'm gonna assume that we don't want to look at just the numbers only so I'm gonna hide all of the numbers Only ones at this time So I'll put my cursor up here and we'll go down to To here and right click and hide So I can hide all of that and then if I go to the right I really want to go down to this point. So to see that I'm gonna also hide Everything from I don't need to see all of this stuff. I just want to see The the this worksheet next to my fretboard and the fretboard I really only need to go out To like the third the third position here and just look at those three or maybe four would be Good, but let's just keep it. Let's just keep it at Let's keep it at four. Let's go to four. So I'm gonna then Now I'll go to three. Let's go to three. So I'm gonna put my cursor on the e and I'm gonna drag on over to go next to This one and then right-click and hide all of that So now I've got this little bit of the fretboard that I'm that I'm gonna be looking at and focusing in on So then I'm gonna hide all of the numbers down here So I'm gonna go from I really can go from right here to get everything as close and tight as possible So I'm gonna hide from 24 down to 38 right-click and hide and so now I've got the two fretboards on top of each other and then I can hide from here down To here right-click and hide. I'm not deleting. I'm just hiding them and then I'm gonna go from here If you delete them, you're gonna mess things up because it'll all the formulas will get messed up So I'm gonna right-click and hide this and Then I'll do the same thing here from here to here right-click and hide that Oh, I did the wrong thing. What is that right-click and hide That and then from here To here Right-click and hide that Okay, and then I've got one more. So I probably don't need all of these But I'll do this one right-click and hide that and So and I'm not worried about messing it up because I still have my og down here So I can always go back there and Fix things if I need to so now I'm gonna scroll in because I really just need this part right here The the wheel might be useful, but that's not where our focus is gonna be so I'm gonna hold down control and scroll in You know as far as we can So that it kind of fits on a screen so now we can we can zoom way in and focus on this little bit now I don't really need this right now. So I'm gonna make this small This will help me to kind of focus in on a certain area So now what I'd like to do is I'm gonna map this first one out So so what I have on the right here is the C major scale So you've got these are relative positions what I call relative position one two three four five six and seven They're relative because they're not absolute numbers whereas this number nine when we numbered the cells that's Note number nine which this this is a relative position one Relative to the C scale relative position one is a C relative to the C scale So then we then we have our notes These are the notes in the scale one through seven and then we can map out our chords And we're looking really just at These three because we're mapping out just the major The major chords. So let's map that out over here a couple different ways I'm gonna do this with my conditional formatting So I'm gonna select all of this stuff and we'll use our conditional formatting to map out the notes in the key of C Which is going to be the C E and the G So I'll do that by going to the to the home tab Styles conditional formatting and I'm gonna say if it's equal to and I like to make different colors because I want to really focus in on Which is which meaning what's the one note? What's the two? What's the you know the the second note in the cord and third note of the cord? What's the one three five? So I'm gonna say this is gonna be equal to the C I like to make the root green So that's where we want to be you want to always be kind of hovering around that one That's gonna be the the the major central central point and then I'm gonna say let's do it again and This is gonna be the E I'll make it red and some in the red almost stands out more than the green But that's the other major format that they have here and then we're gonna say let's do it again and then the Last one is a G and that G. I'm gonna make it the yellow So there we have it and so now when I start to do my finger in I can see my fretboard this is the open strings and And so this is where I start putting my fingers on it and you can see here's your C position This is where your fingers go. I can use this down here to start to map out Where I put my fingers. I'm gonna copy this and paste another one here I put a finger there and I put a finger down here and Then I would this would be an open Position no finger there and no finger there and notice you have other options here You could finger this one you could mute this string all together This is the low E string by the way the string that's on the top of the guitar when you're holding it closest to the ceiling and And so so that's how we'll start to map that out And so we'll use this next time to really kind of analyze What is happening here in the open position the open position is deceptively simple because people just learn This shape as a C shape, but it's actually a little confusing because you because you only need three notes to create a C And you could play all of the six notes here in this open position That would be fine because you have repetitive notes the more you're able to see what's happening here the more you're gonna be able to Both learn the open notes, but also be able to move these things up the fretboard and be able to see these relationships And and so it's a good thing to do both of those things because it's fun to play the open Chords and just strum away at it But it's also useful to take some time sometimes to really analyze it because that allows you to kind of move it around more So then next so I'm also gonna format this let's format paint this one I'm gonna go to the home tab Format painter and just paint that formatting here so I can see format painter I'll paint it here and then format paint this one here So that's where our focus on I'll copy one more of these and then just and then I'll put this on where I'm really looking Which note I'm kind of looking at in this scale when I start when we start to analyze this Okay, and then I'm gonna do it again down here, but this time I want to note The minor the minor scale and see how the chords fit into the minor scale So first I'm gonna indicate the minor the minor notes are the one The two the three the five and the six I'm gonna indicate I mean these aren't the minor notes. These are the pentatonic notes These are the pentatonic excuse me pentatonic scale. We're looking at and these These the major chord will fit all of these chords will fit into The pentatonic scale generally so that's gonna be the idea. So let's map out the pentatonic scale So home tab I'm gonna go to the font group drop down I'm gonna make these green to indicate that's these are the notes in the pentatonic notice there's five notes in it instead of the seven and It's useful to map out the pentatonic because it's usually a safer scale to use And it and when you're switching from modes to modes the pentatonic is often the the go-to Safe safer place to go So that and then but then we'll also add these other two notes and do the major scale as well Which is often also really useful to memorize and understand Because then you can count out the actual notes in the scale a lot more easily It's hard to count off the notes in the scale when you're skipping, you know Some of the notes when we're used to the major see okay, so let's map this one out So I'll do the same thing this time I'm gonna make all of All of the notes that are in this scale a different color. Let's make them Let's make them like a green Hopefully it doesn't stand out too much with our with our seat with a green But anyway, let's go to the home tab Format painter and I'm gonna say if it equals and I'm just gonna pick all of the ones that are green And then I'll add my notes on top of it. So I'll show you how that works. I'll pick this one here I'm gonna make it an additional formatting custom formatting and then I'm gonna go to the fill and We can make it some kind of green. Maybe we do like that green. Maybe let's see what that looks like So there that is that's gonna clash a little bit when we do that other formatting, but we'll keep it there for now So I'm gonna say okay, and then I'm gonna do this again. I'm gonna go to the format Equals and I'm going down to all the notes in the scale now So there's the second note that's in it's in the pentatonic and major scale Customizing it. I'm gonna make it green and then we're gonna say, okay. I made it the wrong green Let's undo that undo Redo, okay, let's do it again dropping it down and this is gonna be this one and Then I wanted to customize it and make it this green Okay, there it is. Okay, so there's that one and then I'm gonna say next one It's gonna be this E Dropping it down Making it that green Okay, and then I'm going to this one the G skipping the the F Because I'm looking pentatonic this time equals to We're looking at the G Drop down and I want to make that this green. Okay, and okay, and then dropping it down again and Equal to and let's go to this one Make it green custom green make it that green again and Okay, okay, and then on top of that I'm gonna put my C the C with the same color coding we had up top which hopefully doesn't clash too much with our green We'll see what it will see here. So I should have test this out a bit more But we're gonna say this is gonna be equal to and now I'm gonna pick up this C Notice I already had a C in here, but now I'm gonna put this formatting kind of on top of it Hold on a second cancel. I have to select the select what I'm looking at and then do it So now I'm picking up this C. I want to make it the green one. So now it's a different green. So hopefully hopefully that's not too Like looks too similar because I use two greens there But we'll go with it and then this one we're gonna insert and say this is gonna be equal to it's hard to get all the colors There's so many That one and then I'm gonna say okay, and then we're gonna say this is gonna be equal to This one and that's gonna be the yellow So we'll say yellow and Okay, and then I'll format paint this stuff here again format paint this here And then I'll format paint this here and then I'll format paint this here So now you can see the pentatonic Scale we'll talk about the pentatonic scale later It's a little bit difficult to see the pentatonic scale sometimes in the open position because you lose some of the some of the paint the full pentatonic shapes format in the open positions And you have and you can do a lot different fingering, you know with the open positions But obviously the open position is also There's a reason it's more complicated because you have more things you could do because you have those open strings Available to you. We'll talk about more about the pentatonic scale later But just note that once we start messing around just with the C We can then say it well I can I can kind of noodle around as they say with any of these notes in the pentatonic scale and kind of always go Back to home playing some kind of C. So we'll practice kind of noodling around with that And here and try it in a future presentation So then let's do this time will do the same thing except we'll use the whole major Scale so this time I'm going to put everything in the major scale So I'm going to select this whole thing and I'm this time I'm going to say the major scale is going to be blue So I'm going to say this is going to be equal to the C and I'm going to say this is going to be a custom formatting blue. I'm just going to make all of them blue So I'm going to say this next one is going to be this one and I'm going to make it custom formatting blue And then I'm going to say okay next one is going to be equal to this one custom formatting blue and Then we'll say next one. Hold on a sec next one equals the F It's going to be custom formatting and blue and then okay next one equals the G custom formatting and blue and then okay and then equals to a custom formatting blue and Then okay and one more time equals Hold on equals The B custom formatting and blue Okay, so now this is the major scale and This end this position and so now I'll put I'll put the C on top of it Which it fits in the major scale. So I'm going to say this is going to be equal to equals to The C and I'll make it green And then I'm going to say this equals to the E and I'll make it red Hold on a second. It was red by default red and Then we'll say this is going to be the Equal to the G and we'll make it the yellow Okay, and then I'll custom format this format paint it to here format paint this to here So now same thing except now we've added a couple notes from the pentatonic So now we can see the the colored notes are still our C position our our C position here Right, we'll be fingering this this and this open positions But when you're noodling around you can play the C and then you can start to Play some of these other notes and it should all sound good because you're playing in the key Of C that would be like playing all the white notes on the piano It should sound good because you're in the same key So and notice this is getting a little bit messy because you might think about how am I going to do that because now There's a lot going on even in this little section. So that's what we'll start to map out. We'll start to say, okay Well, what if if if I was to try to noodle around on this then Maybe I would let's copy this down here Maybe I would let's copy this down here Maybe I would Then focus in on a certain area, right? I would I would play the C chord and then maybe focus in like the open strings are always good because you can always do the Open strings That's what's great about playing like the key of C on a guitar Because the open strings can wring out if you're pretty safe that they're not going to clash too much with anything And then I can start playing just these in between and then go back to the C I don't really know what I'm doing up here at first. I just know I'm playing some stuff That's in The scale, you know, and then I could start to then I can start to understand We're what I'm doing in relation to the C and you can actually get some pretty fun Stuff if you mix if you mix together just playing the C in multiple formats in this one position and rhythm playing different rhythmically Then you have like an infinite number of things you can do just with like playing in the key of C Right, you could do things, you know infinitely any case. Let's do it one more time this time I want to map out the The major and the minor so I'm gonna list the minor I mean the the major scale and the pentatonic So I'm gonna list out the pentatonic notes again by going home tab and Let's make these green And so this time I'm gonna list out the pentatonics So let's do the same and then I'll add the two notes that are the major in blue And then we'll add the the other notes on top of that for the for the cord we're playing So this time I'm gonna say let's start with the green ones. This is gonna be equal to this one. Let's make that green I'll make it this green. That's what we did before Okay, and then we're gonna say next I'm gonna say equal to this one and it's gonna be green Custom green, okay Okay, and then equal to this one and it's gonna be custom green Okay, okay, and then equal to This one and it's gonna be custom green Okay, okay, and then equal to This one and it's gonna be custom green Custom green and then the other two I'm gonna make that blue So then I'm gonna say the other two that make up The major is gonna be this one from from the pentatonic to the major It's gonna be that blue note. It's not a blue scale I just the blue it's it's not the blue note in the blue scale Don't get that mixed up and then I'm gonna say this is gonna be equal. It's just a major scale and Then we're gonna say this is gonna be the blue note So now we've got now we've got the pentatonic in green the and the added two notes Right in blue and now let's put our cord on top of that So now I'm gonna say our cord it's gonna be equal to The C it's gonna be the green one which clashes a little bit with the other one but we're gonna deal with it and then we've got the E and it's going to be let's make that one the red one and then we've got equal to the the G The G and it's gonna be The yellow Okay, so then I'll format these I'm gonna say this is gonna be format paint that format paint that and Format paint that so now and this one looks like if we didn't do this one by one And I just gave you this to look at it would be quite overwhelming But now that we've built these other three it might look a little less overwhelming So even though we're on this one little piece So if I just to recap it we're looking at this one little piece of the fretboard We started out just mapping out the three notes that create the C The C major then we said let's map that on top of the pentatonic scale So now we have the three notes that still represent the C major But have the added notes in the pentatonic scale so that we can noodle around we can finger pick or whatever We want to do for you know You don't need whatever style you're using and then always go back to the C notes as your home base And then we said let's add the blue that the major notes on top of that So this is all of the major notes which are seven notes So and then we put the the C on top of the seven notes You can do the same thing you can noodle around and then go back to that C Chord and then we we mapped out the green notes in the pentatonic The blue notes being the added two notes and then these three notes mapped on top of them Which are going to fit over all the green notes right because because Because the this chord will fit in the pentatonic scale Which is larger than the chord and both the chord and the pentatonic scale will fit in the major Scale we'll talk more about that in the future But they'll kind of blend together so we'll kind of point them out now and then we'll talk about The pentatonic and major scales and more detail later so what we'll do from this next time is that we'll we'll pull out the actual guitar and Start to start to finger this position see the multiple ways we can play it and then also look at the The relative positions in terms of the intervals