 Guitar and Excel open chords C major scale D minor two 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 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 five tabs down below We've got three example tabs or four example tabs at this point and an og tab We'll be creating a new tab to the right, which is what we'll be working on this time The og tab Representing the original worksheet we put together in a prior section it now acting as our starting point Going forward mapping out the entire fretboard giving us our entire musical alphabet both in terms of letters Numbers and combining them to have the letters and the numbers giving us a key Allowing us to change the scales that we are in by changing this green cell Providing the worksheets on the right-hand side, which gives us the scales and chords we're working in We then wanted to focus on the C major scale the positions on the guitar in open position And then put together the chords that we can construct from the C major scale starting with the course the one cord Which is the C chord so that's going to be this first tab We then minimized our worksheet or hit a bunch of cells so we can see just the open positions I'm defining that as frets zero through three mapped out the shape of the chord We were mapping on C in this case and then we went in depth Describing that chord on the fretboard. We did a similar type of process for the F chord Skipping not to the two chord, but then moving to the five chord Why because the one I'm sorry moving to the four chord because the one four five are going to all be Major chords constructed from the C major scale. We did a similar process then moving to the five chord Which is the G? Again doing so because that's also going to be a Major chord that will be constructed now. We're going to go back to the two chord Which is a minor chord so we went we started at the one we then went to the four We went to the five because they're going to be similar in nature because they're going to all be Majors now we're going to go back to the two and we're going to look at the two the three and the six Which will all be similar in nature because they're going to be minor constructions and the major Well the the big difference that you'll see between the major and the minor is going to be the interval Will not be four on this three chord. It will be three So and so that's what we want to start to recognize and once you recognize that it'll be a lot easier to To kind of construct these chords and and make these movable shapes up and down the guitar So what we're going to do is we're going to copy over the og tab And then we're just going to set up our worksheet this time if you don't if you're not really into excel You could just watch this to see the music theory component of it as we constructed and then we'll use this worksheet to then Think about the the two chord and more depth in the future So we're going to copy this the og tab over we're going to hide a bunch of cells So we can see the open positions which are going to be defined. I'm defining as Zero through three on the fretboard remembering that the low or heavy string is the string that we're going to say is The top string here That's how we're visualizing this because I think that's the easiest way to visualize in our mind And then we'll map out the pentatonic scale on top of it and then we'll map out the major scale the key of c by the way Scales so we could see its relation to the key of c and then we'll map it out a few different ways down below So let's get to it. We got a lot to do here. We're going to go to the og tab I'm going to copy it over so I'm going to hold down control Left click on the og tab and drag it to the right And so then I'm going to change the name. I'm going to double click down here I changed the names to be a little bit more detailed now down below. So I'm going to say this is going to be practice I'm going to say this time d Minor and I'm putting a small m because sometimes people rep represent majors with a large m and a minor with a small m As a convention I'm going to call it a two chord Because it's the two chord of the key of c that we're working on I'm also going to make it blue down here if you don't have this blue down there I like to make it that blue you can make it any blue you want But that's the blue you know how you know how I've gotten into the habit of using that blue And that blue sticks with me man. So that's what I use So then we have this so now what I'd like to do is copy over the first part of the worksheet All the way down because you'll recall that this worksheet gives us The the major and then the minors are going to be to the right or the relative modes are to the right And we also have the relative modes that are in the same key That are starting on the same note down below But what I want to have is a repetition of just the major stuff Over and over so I can look at the fretboard multiple times In relation to the major scale So i'm going to remove this conditional formatting and just copy over this major bit So i'm going to go up top home tab Styles and remove the conditional formatting rules Clear the rules There are no rules here no rules And then i'm going to copy this i'm just going to put this on the side because I would like to have that Somewhere over here Okay, and then i'm just going to copy i'm going to put my cursor on the one copy of the rows all the way down until I get to Number 25 i'm just copying it down to the bottom of this table Control c or right click and copy and i'm just going to paste it right on top of all these other worksheets control v Or paste control v Or paste control v Or paste control v And I think one more time control v and that oh there's one more control v And there we have it. Okay. So now i'm going to go back up top. So now we have a repetition Of just this first This first bit which will keep on repeating the major scale which has been constructed in the key of c Noted by the four here which represents the c chord So now i'm going to go back in and say, okay, I just want to first start off by just looking at frets One to three. So i'm going to hide frets four So i'm going to put my cursor on f and i'm going to hide the frets from four all the way out to my worksheet over here And then right click and hide that stuff So now we've got our worksheet right next to our fretboard I could scroll in a little bit holding down control scrolling in I don't need the number ones even though if I could see it just by the numbers I hope you can see How much nicer that would be to look at that than this if I can interpret the fretboard with just numbers Then in some cases that will be a lot easier to envision in my mind And do little math calculations then with with the letters here This gets a lot messy even if I didn't have the numbers and I only had the letters the sharps and flats get really ugly They get really ugly. Okay. I'm not trying to put down the whole musical system, but Like it's still it's kind of messy Still sharps and flats are kind of messy sometimes if you just had a number You know, you can kind of visualize it. It might be worth doing just from time. There's pros and cons Okay pros and cons, but i'm going to hide from one down to 12 right click and hide And then i'm going to hide all of the ones that are that are like so i'm going to go to the bottom of this blue Right here and i'm going to hide from here Down to here And well, let's just go all the way down to here right click and hide And then i'm going to do that again. I'll say let's hide from Actually, well, yeah, let's keep that system. I'll go from the bottom of this blue right there and I'll hide from here Ah, it's too fast Down to here And then right click and hide. I'm going to scroll out a little bit so I can see a little bit more easily Holding control scrolling out. I'm going to go from this cell and I'm going to hide from here Down to here right click and hide And then scrolling down again from here Down to here right click and hide And then we're not deleting them. Of course, don't delete them That'll mess up the whole thing the whole thing will be messed up right click and hide And then I think one more time uno vase moss poor fava Right click and hide And I think that's it scrolling back up to the top back to the top. Okay, so now I'm going to Put one of these boxes around and let let me grab one from the og tab. I thought I would Have one here. I thought I let's copy it like this bracket thing And put it over here And we're focused on the two chords. So I'll put it here grabbing all the way over To the greek number so we can see that it's a minor chord And then I'm going to map out the one three five just as we did Before so I'll start off but just mapping it out so we can have that and we can analyze it in future presentation So I'm going to select This is the nut with the black here and then this is all of the of the frets from zero to three And let's map it out by going to the home tab styles And I'm going to say if what is on that fretboard if it is equal to The one in this case the one of this d minor chord if it's equal to that I want to make it green because that's going to be the root And then if it's equal to Conditional formatting if it's equal to the f make it red which is the default And then if it's equal to conditional formatting the A Make it yellow make it yellow por favor and there we have our Shape this is going to be the d minor shape So this is our d minor shape. You're usually going to look at it like Here So we have that open note right there And then you're going to be holding you're probably not going to play you're not going to be holding down that f right It's going to be there this one this one this one this one Right, so we'll talk about that later. So your fingers are going to go boom boom And boom and then you ring this one out open And then you could play that a and the f if you wanted to ring them out or you can mute them So you have more d on the low on the low end of the d All right, so then let's conditional format these back I'm going to go to the home tab format paint brush to that d And then I'm going to go back here to The f and format paint brush to the f and I'm going to go back here to the a and format paint brush that to the a a All right, anyway, let's go down and now I'm going to do the same thing this time But now I'm going to Put it on top of the pentatonic scale in the key of c So remembering that when we look at this two chord When I name it the one three five as we did here the one three five We're naming it in relation to it as though it was the The root note. Let me just give a quick note on that. We'll talk more about that later But if I go to the og tab over here and I say now I want to look at a minor just to compare it How can I do that on my worksheet? Well, I could change this Four to a six, which is the d That gives me the major up top But I want to look at the minor and I put all the but I put all the minors that have the same root note below So underneath it. We have the minor. So here's the minor Uh, so now we have d minor or aoleum And you can see that now it's the one chord In and if this was a if this was the d minor and the one Three five of that chord is a d f a if I go back on over here D f a so that's but we're also defining it as the third Being an interval from the one of not four but three Because it's a it's a whole and a half step if you want to think about it that way And that differentiates it. That's just how it happened to be when we constructed it from from the c But we think about it as as the third being Uh, a minor third away three notes instead of a major. Okay, so now I'm but now I'm going to think about it on top of the c Uh, the c pentatonic Remember that the pentatonic only has three out of the seven notes So I'm going to select my notes over here. It has one two three and then it has the five and the six I'm going to make those green home tab font group letters make those green And then so I'm going to make these green to show us the pentatonic and then I'll put on top of it These notes and you'll note that they won't all fit Inside the pentatonic scale For the key of c they would fit inside the pentatonic scale if we constructed it related to you know the d minor But no we're looking at we're looking at constructing it from the key of c Here they will fit when we get into the major because we'll we'll add the notes that are missing So this f in particular is going to be sticking out from Uh, this pentatonic So if you're playing in terms of a pentatonic scale You can noodle around and then you can think about it as I'm playing the pentatonic and adding the f Right in there Because I'm on the two chord right if the if you wanted to think about it that way But let's first just map out all the pentatonics home tab Uh that style drop down. We're going to make them all green. I'm going to say pentatonic This is the part of the pentatonic that c let's make it green. I'm going to make a custom green And I'm going to make it fill color Green let's make it the dark green boom And then I'm going to keep doing that all the way down another one equal to that d Dropping it down custom color dark green okay And okay dropping it down again equal to that e Drop down custom color dark green okay now this time i'm skipping the f and i'm going to go to the g Because there is no f we're talking pentatonic which Takes out the four and the seven because they're just not cool enough to hang with the crowd They're not or maybe they're too cool to be with the crowd. I don't know I don't know who did the pentatonic kick them out or were they like I don't want to be part of your group because you guys are lame I don't know how it worked But in any case they're not included So there we have it. So there's our pentatonic that we have been seeing because we're mapping it out in the key of c every time So boom boom boom boom boom you can start to learn to play that shape if you wanted And then if you're saying i'm going to the two chord then you're going to be like okay I'm going to add The f on top of it if i'm thinking pentatonic because i'm playing the two chord which has the note in The the major scale, but it's outside of the pentatonic scale if i'm thinking about the pentatonic scale in the key of c Rather than thinking about it in the key of the d minor Okay, so then let's add that one and so this is going to be uh equal to Let's put our our d on top of this making that the root which is going to be green And then the f this is the one that's going to be the odd ball out is odd The ball is odd Let's do that You have an odd ball. What is it a football because it is shaped weird. It's an odd ball Footballs are odd balls The golf balls are odd balls because they have Little divots in them for some reason which is kind of strange They're really small. It's an odd ball I'm gonna put the let's go to the home tab and format paint this over here And then format paint this over here And then format paint this over here and then we'll just show With a bracket that that f is sticking outside Of my normal pentatonic shape. Let's make it a different color Make it not a fill color. Let's make it yellow. So the fs Are you got the pentatonic and the key of c and then the f Hanging on hanging out there that you can pick up if you want to if you want to look at it that way Then we can bring it on down and say let's do the whole major scale in the key of c And then the pennant then the chord will fit inside the major scale So i'm going to make the major scale all blue this time Make it at all blue because that's what we've been doing before hometown style I'm going to make the whole thing blue so we can see the whole shape now not just the five notes But all the notes all the notes are going to be in this one This time i'm not leaving anyone out you have to come but the But the four and the seven are too cool. They don't want to show up You have to show up this time four and seven Where did the thing go? Uh What is going on here? Let's undo that Undo All right, let's do it again. So conditional formatting boom and then This is going to be green. Oh, no, let's make it blue this whole thing blue first. I got distracted And then i'm going to hit the drop down And we're going to say the d also blue everything's blue Everything's blue. We're wearing the same uniforms this time. We have the team jersey on team jersey for the entire c Major scale Everyone's on everyone's got to be looking the same because we're on the team together f is going to be Here and then okay And then g is going to be blue as well And then okay, and then we're going to say a is going to be blue two And then okay, and then we've got the B is going to be blue and then oh, no, that's not blue. That's not blue b It's not red. You're not special You're not special b. Okay, you're blue just like everyone else But I don't why I don't like blue it doesn't go with my eyes Whatever whatever No one cares Okay So now you can start to memorize that shape If you if you so choose right you can see the pentatonic shape is kind of inside of that shape And then if we were to put If we were to put these on top of that it'll fit the f is in there now, right? So you got boom boom boom boom boom boom boom boom boom boom boom boom boom boom boom boom boom Okay, let's put the the chord on top of it Styles We're going to say The d let's make that green as has been our custom And then we'll say that we have the f is going to be red And then we've got the a is going to be yellow Yellow bellied a It's not yellow bellied There's nothing wrong with having a yellow belly I had I had a friend's dog that had a yellow belly and it was A very brave dog Okay Stop making fun of people with yellow bellies Anyways So there we have it So now you can see again the d this d fits in there Boom boom, you know boom boom boom boom Beautifully and these are they going to be the fingers that we would hold down ringing out that d up top and it fits inside The c major because of course we constructed it by starting at the two note and taking every other note from the c two to four To six, but we don't call it a two four six in the key of c You could but we call it a one four five as though the d is the starting point and the the the I'm sorry. We call it the one three five And then the three is now A minor a minor distance away, which is instead of four notes away It's three notes away or a whole step and a half step. All right. Let's do the same thing this time But we're going to build the the the base of the Majors and then we'll put the pentatonic on top of it and then we'll put the The scale on top of that that'll be a good exercise so we can really see How this stuff kind of sits on top of each other and fits together like a puzzle It's like sadoku All right, it's so let's do the whole thing again I'm going to do the whole major thing again And then I'll put the pentatonic on top of it so we can see that So the ground floor pentatonic bottom bass line. I'm sorry bass line is going to be the major the major scale on the bass focus So we're going to do the whole blue thing again. Everyone's got the same jersey to start out with And then we're going to differentiate because everybody's got their own special positions That they need to play so then we're going to After we get everybody on the same team We're going to change the jersey colors to represent the different the different positions that people are going to do When they're when they're in the game So this is going to be equal to uh So we have have the d did I pick up the e we're on no we're on the f yes f and then Okay, and then g Picking up the g and okay Okay, and then we'll pick up the a Okay Okay Okay, and then we'll pick up The b And so that's the whole team up but the b tried to be special again. We're not switching your jersey yet be Your blue You're not even going to switch your jersey It is but I don't like blue Whatever that's that's what it's not your choice You're part of the team now we're going to make the Now so that's our normal shape again for the whole thing now Let's put the pentatonic on top of it changing the colors to green for the pentatonic So we can see how it overlays and it'll fit perfectly on top because this is the c major And we're going to just going to remove we're just going to take all of them except for these two and lay on top of it The pentatonic so the pentatonic will just be the c let's make it green now And we're going to make it green And then we're going to say okay And then we'll say that the d Is going to be green The d is going to be green And then we'll say that the e Is going to be green It's going to be green And then skipping four skipping the f going to the g Which is going to be green It's going to be green And then finally the a Not ub not u the a It's going to be green. Why does the a get to be green when I have to stay blue? It's not this is how it works. You're good at that position You have to be there even though you don't want to Okay, so then we're going to then we're going to put on top of that these Three so now you can see the pentatonic the added two Notes in the major are now blue And then on top of that we'll put this here noting that the f is going to stick out It's in it's in the major scale, but it's not in the pentatonic because the pentatonic scale is being made from the c Rather than being made from the related pentatonic scale for a d minor, right? Okay, so let's do that. We're going to say, okay Let's say this is going to be equal to the d and That's going to be green Okay, and then this is going to be equal to the f And then this is going to be equal to the a and it's going to be yellow All right, and then I'll put those colors over here Format paint it back on over format paint this back on over And format paint this back on over a a all right And then we can note that these F's are sticking out as kind of outside Of the pentatonic I'll make them yellow Old yellow All right, we had a dog named young yellow We tried to tell him to stop yelling, but he never did. I was hoping to change his name to not yellow But then he just got old he kept yelling so I had to change his name to old yellow My neighbors hated that dog Anyways, no one cares. Let's get back in the swing of things got to get back in the swing of things I hate when things aren't swinging right those things Start to feel uncomfortable So you got to get the things No one likes when their things aren't are uncomfortable due to the lack of swing So let's get back into it. We're going to say Let's unhide this now. I'm going to go from d to ak right click and unhide And so so now what I'd like to do is map out and say well, what if I moved this position? So let's hide from columns 12 On the fretboard so we could see a bit more of the fretboard and then go back on over here and right click and hide and then Let's then so now we're going to say okay If I wanted to move this position up, which we'll talk more about later But just note that the ones that are similar here Are the the miners now, which is the two the three and The six and then you've got the diminished which is still lowercase because it's kind of like a minor And that it's got like a minor third, but then it has a diminished or it has a a flat Fifth so we'll talk about it separately. It's its own kind of thing So then so let's say then that if we do that Then uh, we can say the one is still going to be over here So let's map that out over here just like we did before just looking at the notes Uh d f and a so i'm going to say all right Let's just map this piece of the fretboard right there and map it out and i'm going to say uh home tab conditional formatting and we'll say this is going to be equal to And we'll say this is equal to the d which is green And then this is going to be equal to The f which is red and then this is going to be equal to the a Which is yellow So there's that bit of the fretboard and then this bit i'm going to make a different color And say if i move that up, let's make it yellow and Copy that i can think of the root of this As being that D right there. Oh I'm going to say the root Is going to be this d. So if I look for the next one up, which is an e It's it's right there. It's two notes up because we're going from the two to the three So it's two notes up. So it actually starts right there. So you have some overlap So if you're playing this on the guitar You could move this shape up, which is a little bit Kind of difficult because because this is an open string So you'd have to adjust your finger in or you just play these three notes down here Noting that then you might be looking at this You know, you'd be looking at this as the root that you're moving up to here, right? So let's i'm going to make this just blue so we could see a different color in here So i'm going to make them blue just so we don't overlap these colors So i'm going to say this is just going to be blue And we'll say that's going to be the e. I'll just make all of them blue. So i'll say blue and then okay And then boom, this is going to be blue and then boom And then this is going to be uh blue and then Hold on hold on a second. It's that b again I don't want to be blue Just for crying out loud. It doesn't even matter All right So now you can see these shapes On top of each other here And so you can move this shape up. We'll talk more about it in a future presentation We're not really getting into too much the movingness of the shapes But I just want to show you that You know if you wanted to play with that you can you can move those up and then of course We can move it up to the six So if i'm looking at this as my leading note, I now want to find an a on that string So i'm going to go boom boom boom boom boom. There's the a Or if i'm looking at this e as my leading note because that's what i'm fingering I'm going to move up till I find the a and then i'm going to make my shape Around the a so there we go, uh right here So let me let me see it this way The e to the a So there we have it. So now let's I'll I'll map this out And we'll say let's map this one out if we moved it up here We would be playing the same shape which would be being an a as the root making it green I'm going to make it green that would be the root here And then we would be playing equal to the c it's going to be red and then equal to the e Which is going to be yellow So you can so you can play this shape if you get good at the shape you can kind of noodle around with it But if you're just noodling around and you can move it up from the two to the three to the six So you can play the one four five together you could play the two The the three and the six together now note when you play the two the three and the six together It's your it's almost useful to play in the in the related minor scale So you might want to think about it as the a Is your root and then if you so for example this d e and a if I looked at the related minor Uh, which is an a Then if you saw it this way And you say that a is the related minor now you're in a one four five Which are all minors Which is a good way to think about it when you're playing You practice on the majors by playing the one four five in the key of c And when you play the minors you can think about it as playing the two three six But you probably want to think about the six as the root because that means you're playing in the related minor And if you have flipped the related minor scale So you look at it in its mode of the aolean or related minor you will once again be playing Uh, you'll be playing the one four five The same one four five, but now they'll all be minor because you flipped it you flipped it that way in other words You could you could play it so that this too is your Is your center point, but then you're playing uh in like a dorian which is cool But it's probably not as common as to be thinking of this as the root Which would be playing in the related minor which is in this case would be the a minor So we might talk about that more later, but you can then so then you can move these up and do it like that So let's go ahead and make this format paint this to green and then format paint this to uh That color the color that it is that which is red I know that color. I know the name of that color and let's make all of these blue These are the blue ones and then this one. Let's make that green and Why is it not grabbing the format painted green? I'm running long on time here You're running long on time. You're breaking your own rules, man You're breaking your own rules. You got to get out of here. Okay I have plenty of time Let's do this. All right, then the next thing is that we might want to see it What if I was trying to compare it to to making this A d minor like so instead of me looking at the related minor which is going to be the a Let's think about this as the d minor because when I look at it from One three five of it of of the home. I end up with a minor Uh A minor chord which I can think constructed around the minor scale So the question is well, how do I get to a d minor? If let's go to the og tab and think about that for a second because if I if I'm on the four which is a c I can I can see the c worksheet over here has the related modes on the right hand side And and then down below I could see the related modes that are going to have the same starting note So underneath it you could see here that I have now a c Uh a c minor Down down below what I'd like to do then is to create a worksheet where Where I'm going to I want to find the related major to a d minor So I could think about it this way. I could say, okay Well, here's my c as my major the related minor is the a right I could I could tell that by going to the right and saying, okay, the minor is over here. Here's the minor And there's the a it's related to the major because it's the sixth note and I start it as the mode So so what so I would I would think of a a similar relationship if I said this was the six Then now I've got the the Uh Chords that are in the key of d. Here's the major and down below it. I've got the minor So here's the minor starting with a d And the related major to that then it's going to be the f It's going to be the f let me and if I double check that I can say, okay Well, what if I was in the key of f, which is the nine If I was in the key of f There's the nine then the related minor Is this d which is on the sixth it should the relation should be the six, right? So so okay, so looks like what I need to do is construct it in the key of f because what I so let me show you what I mean I'm going to go back on over here and I'm going to say all right. Let's Unhide from l to ak right click and unhide and I'm going to make my worksheet In the key of f So I have to unhide some cells Above it so I can see my numbering to find that green key unhide And I'm going to make that green key on f Which is a nine So now it's in the key of f. So now I've got my majors up top. So here's my major But to the right of it I have The related minor which is now in the key of d Now the reason I want it to the right is because now I can construct my fretboard on top of each other and kind of compare This minor to its related major. So now I'm going to hide from bh Over to my fretboard hiding over to column 12 or fret 12 right click and hide Okay, so then I'm going to go okay So now I can look at this Let's hide this stuff too So I'm going to hide From here down to here because I don't need the number stuff And so we'll hide that right click and hide that Okay So now I'm going to Let's copy one of these And bring it down And so if you were to look at this Uh As though it's in the minor the d minor just so you can show it as a movable shape As though it's the 145 in a minor. So now I can say, okay Now I've got the the minor the d minor Okay, I see a problem with my worksheet here. So just note these These notes these are coming from up top and these Are are there's So let me unhide. I'm going to fix my worksheet. I got a bit of an issue With the worksheet. So let's go ahead and Unhide, I'm going to go from here to here right click and unhide And I'm going to say, okay, what is going on here? K stop pass on dough And so these Are pulling from The wrong place and they're using this crazy formula. I want to pull so I'm going to unhide these unhide and then major And the minor these should be pulling from the related minor. So I'm going to say equals If this is a little tedious, I'll try to fix the worksheet so you could don't have to do this But the related minor Is here. So I'll just pull it from this one boom and this should be The copy of that down And so so now you've got the one four five are all minor. So down here the one The one four five should be minor. So I'll try to fix that on My master worksheet as well. So when we copy it over in the future, we don't have to do that again So now let's hide from here over to The minors So here to the minor right click and hide and then Uh, hold on a second undo Let's do that again. I'm going to go from here To the minor right click and hide All right, and then I'm going to hide these ones up above. I've been skipping two cells. I'm going to hide from here To here right click and hide So I think everything Is good now. So I'm going to say, okay So now we've got the point is we've got the one four five That you can look at this way as well if you saw it in the key Of the minor. So if I was to say, okay, let's copy this and put it over here And on this position I'm going to I'm going to select the entire fretboard and construct it Uh for the major scale. I mean the whole scale that's in the key of now D minor. So I'm going to say, okay, let's conditional format Boom I'm going to make the whole thing blue dropping it down make it blue Okay, and then dropping it down making the e blue and then okay And then okay and then dropping it down And making the f blue Boom, okay, okay, okay Dropping it down and then making the g blue boom Okay, okay, okay, and then dropping it down making the a blue Boom, okay, okay, okay, and then dropping it down making the uh a sharp blue Oh, that's not blue Okay, okay, okay and then uno vase moss with the c And so now you can see you have a different a different array of shapes But this will still fit in that shape So so now I'm just going to select this area for my first position And say this is going to be equal to the one which I'm going to make green And then I'm going to say boom conditional formatting the four which is going to be Uh red which is there by default And then conditional formatting the five which I'm going to make Uh yellow yellow And so then it fits into that shape now if I was to I won't compare it right now We'll do that later But if I compare this shape to the shape we had up top when we constructed it in the key of c Uh, then you can see the blue notes will not all be the same, but this shape still fits inside of it Uh, and so I just want to point that out and then you can move this shape up. So let's let's do this is going to be green This is going to be red And this is going to be yellow a and then If I move this up Looking at this note the d moving it up to like I get to the g Which is going to be the four That would be the four chord if I'm thinking about it in the key of d minor now So let's select these and make the four chord. So I'm going to say this will be uh boom This one is going to be This note that's going to be the green that'll be the root And then we're going to say this is going to be equal to this note That'll be red and this will be equal to This note and that will be yellow And then I'll make this border. Let's make that a different color. Let's make it yellow And let's make this one yellow and then let's conditional format back over boom and then boom and then And then if I moved it up to the five We're going to say I'm just going to look for that g and move it up a whole step to an a now To get to the one four five if I was thinking of it in The key of d. Let's make that green red yellow green. It's rost of far eye colors I Rost I far I don't know anyway Let's just put some green brackets around that one So if I was in here Let's put just like a green bracket around here It would be there And then we've got the c It would be an a And then we have a c here And then we have an e Ah, there's too many things an e Happening right there and then we have another a So you can see how you can move it up from there just to show the movement of the shape Okay, we got the whole thing worked out now So i'm going to use this as a baseline to talk about it a little bit more in depth later Hopefully I didn't mess it up too much. I should change the og worksheet to change that uh that numbering system in the greek. I'm going to Hide some cells from Uh, well, let's unhide so I can see the majors again So I'm going to put my cursor from l to bi right click unhide and then I'm going to hide from four To the majors so I don't have the minor Because I want to focus on the majors first when I get into the next talk So there's our starting point. We'll zoom it in a bit so we can focus in that's going to be our point to focus next time We'll talk about finger in it. We'll talk about how it's related to the Scales and how we can move it and stuff using this super cool worksheet That we put together