Course curriculum

  • 01

    Create Excel Worksheet Tool

    • 1010 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 1

    • 1014 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 2

    • 1016 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 3

    • 1020 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 4

    • 1025 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 5

    • 1030 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 6

    • 1035 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 7

    • 1040 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 8

    • 1045 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 9

    • 1050 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 10

    • 1055 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 11

    • 1060 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 12

    • 1065 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 13

    • 1070 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 14

    • 1075 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 15

  • 02

    Open Chords Built from the C Major Scale

    • 2010 Open Chords - C Major Scale – C Major Chord Worksheet

    • 2012 Open Chords - C Major Scale – C Major Chord Fingering

    • 2016 Open Chords - C Major Scale – C Major Chord & Related Scale

    • 2020 Open Chords - C Major Scale – C Major Chord & Intervals

    • 2025 Open Chords - C Major Scale – F Major Chord Worksheet

    • 2030 Open Chords - C Major Scale – F Major Chord Fingering

    • 2035 Open Chords - C Major Scale – F Major Chord & C Scale

    • 2040 Open Chords - C Major Scale – F Major Chord & Intervals

    • 2045 Open Chords - C Major Scale - G Major Chord Worksheet

    • 2050 Open Chords - C Major Scale – G Major Chord Fingering

    • 2055 Open Chords - C Major Scale – G Major Chord on C Scale

    • 2060 Open Chords - C Major Scale – G Major Chord Intervals

    • 2065 Open Chords - C Major Scale – D Minor Two Chord Worksheet

    • 2070 Open Chords - C Major Scale – D Minor Two Chord Fingering

    • 2140 Open Chords - C Major Scale – B Diminished 7 Chord Fingering

    • 2145 Open Chords - C Major Scale – B Diminished 7 Chord Intervals

    • 2070 Open Chords - C Major Scale – D Minor Two Chord Fingering

    • 2075 Open Chords - C Major Scale – D Minor Two Chord on C Major Scale

    • 2080 Open Chords - C Major Scale – D Minor Two Chord Intervals

    • 2090 Open Chords - C Major Scale – E Minor Three Chord Worksheet

    • 2095 Open Chords - C Major Scale – E Minor Three Chord Fingering

    • 2100 Open Chords - C Major Scale – E Minor Three Chord on C Major Scale

    • 2110 Open Chords - C Major Scale – E Minor Three Chord Intervals

    • 2115 Open Chords - C Major Scale – A Minor 6 Chord Worksheet

    • 2120 Open Chords - C Major Scale – A Minor 6 Chord Fingering

    • 2125 Open Chords - C Major Scale – A Minor 6 & Scales

    • 2130 Open Chords - C Major Scale – A Minor 6 Intervals

    • 2135 Open Chords - C Major Scale – B Diminished 7 Chord Worksheet

    • 2140 Open Chords - C Major Scale – B Diminished 7 Chord Fingering

    • 2145 Open Chords - C Major Scale – B Diminished 7 Chord Intervals

  • 03

    Pentatonic & Major or Minor Scale Position Fret 5 (Position 4 or G Shape)

    • 2300 Pentatonic & Major or Minor Scale Positions Worksheet

    • 2310 Pentatonic Scale Fret 5 Fingering

    • 2315 Pentatonic Scale Fret 5 Intervals

    • 2320 C Major-A Minor Scale Fret 5 – Fingering

    • 2325 C Major-A Minor Scale Fret 5 – Intervals

    • 2330 A Minor Scale & Related Modes Fret 5 – Intervals

    • 2335 C Major-A Minor Scale Fret 5 – Target C Major Chord

    • 2340 C Major-A Minor Scale Fret 5 – Target F Major Chord

    • 2345 C Major-A Minor Scale Fret 5 – Target G Major Chord

    • 2350 C Major-A Minor Scale Fret 5 – Target D Minor Chord

    • 2355 C Major-A Minor Scale Fret 5 – Target E Minor Chord

    • 2360 C Major-A Minor Scale Fret 5 – Target A Minor Chord

  • 04

    Pentatonic & Major or Minor Scale Position Fret 7 (Position 5 or E Shape)

    • 2365 C Major - A Minor Pentatonic Scale Fret 7 Fingering

    • 2370 C Major - A Minor Pentatonic Scale Fret 7 Intervals

    • 2375 C Major - A Minor Scale Fret 7 Fingering

    • 2380 C Major - A Minor Scale Fret 7 Intervals

    • 2385 A Minor Scale Fret 7 Intervals

    • 2390 C Major - A Minor Scale Fret 7 Focusing on the C Note

  • 05

    Interval & Modes Worksheet Creation - Complement & Parallel Modes

    • 3010 Interval & Modes – Complement & Parallel Worksheet

    • 3014 Interval & Modes – Complement & Parallel Worksheet Part 2

    • 3016 Interval & Modes – Complement & Parallel Worksheet Part 3

    • 3018 Interval & Modes – Complement & Parallel Worksheet Part 4

    • 3020 Interval & Modes – Complement & Parallel Worksheet Part 5

    • 3022 Interval & Modes – Complement & Parallel Worksheet Part 6

    • 3024 Interval & Modes – Complement & Parallel Worksheet Part 7

    • 3026 Interval & Modes – Complement & Parallel Worksheet Part 8

    • 3028 Interval & Modes – Complement & Parallel Worksheet Part 9

    • 3030 Interval & Modes – Complement & Parallel Worksheet Part 10

    • 3032 Interval & Modes – Complement & Parallel Worksheet Part 11

Description

Explore an Innovative Approach to Guitar Theory:

Embark on a groundbreaking journey to master guitar music theory like never before with this unique course tailored for aspiring guitarists. By harnessing the potential of Microsoft Excel, an unexpected ally in the world of music theory, we offer you a fresh and innovative perspective that will revolutionize your understanding and mastery of the guitar.

This course is far from the traditional music theory class. We recognize that the guitar fretboard can be likened to a spreadsheet, making Excel an exceptional tool to deepen your understanding and unlock new musical potentials. From creating detailed Excel worksheets mirroring the guitar fretboard to charting out chords and scales, this course guarantees a comprehensive and hands-on learning experience.

The initial segment of the course is dedicated to constructing a robust Excel worksheet that will serve as your musical companion throughout your learning journey. Whether you are interested in enhancing your Excel skills or focusing solely on music theory, this course caters to your needs. We provide clear, step-by-step instructions for building the worksheet, ensuring you grasp the fundamentals of both Excel and music theory. For those inclined toward the theoretical aspects, a completed copy of the worksheet is available at each stage, allowing you to dive directly into the world of music exploration.

In a unique twist, the worksheet is formatted with the lowest guitar string at the top, mirroring the visual perspective most guitarists have when playing. This intuitive layout facilitates a seamless transition from theory to practice, enhancing your ability to visualize and navigate the fretboard effortlessly.

As the course progresses, we delve into the key of C in open position, unravelling its intricacies with unparalleled detail. You will learn to construct and analyze each chord within this key, mapping them onto the fretboard, identifying fingering positions, and understanding their relationship with the C Major scale. By comparing the C Major Scale with the scale of each chord, you will gain a comprehensive understanding of musical relationships and patterns, enriching your theoretical knowledge and practical skills simultaneously.

This is more than just a course; it's an innovative journey that combines the power of Excel with the beauty of guitar music theory. You will emerge with a solid foundation and a newfound appreciation for the fretboard. Join us on this unique adventure and transform your approach to guitar theory and practice!