Guitar & Microsoft Excel

Name: Guitar & Microsoft Excel
Rating: 4.6 (90 reviews)

Unleashing the Synergy of Spreadsheets and Strings: A Novel Approach to Guitar Theory and Practice

Created byRobert (Bob) Steele

Last updated 4/2024

English

What you'll learn

Grasp the Fundamentals of Music Theory: Acquire a solid understanding of essential music theory concepts as they relate to the guitar.
Master Excel for Musical Applications: Learn to utilize Microsoft Excel as a unique and effective tool for mapping and analyzing guitar fretboard patterns.
Construct and Navigate Guitar Fretboard Spreadsheets: Develop the skills to create detailed Excel worksheets that represent the guitar fretboard.
Understand Open Position in the Key of C: Dive deep into the key of C in open position, gaining insights into chord constructions & scale relationships
Analyze Chords and Scales: Explore and understand the relationship between chords and scales, enhancing your ability to analyze and interpret music.
Improve Fretboard Visualization: Enhance your mental representation of the guitar fretboard, allowing for quicker navigation and more fluent play.
Apply Theory to Practical Play: Translate theoretical knowledge into practical skills, improving your guitar playing and musical comprehension.
Enhance Musical Creativity: Use your newfound knowledge and skills to experiment with and create your own musical compositions and arrangements.
Build a Comprehensive Musical Toolbox: Equip yourself with a versatile set of skills and knowledge that can be applied across various musical genres.
Develop a Unique Approach to Guitar Learning: Experience a novel and engaging method of learning guitar theory, setting a strong foundation.
Navigate and Customize the Provided Excel Worksheet: Learn to effectively use and modify the provided Excel worksheet for your own musical practice.

Course content

7 sections • 88 lectures • 49h 46m total length

1010 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 127:25
1014 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 224:37
Learn to build a guitar fretboard in Excel from a sheet, mapping notes with numbers and letters and wrapping after 12, with open strings E A D G B E.
1016 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 313:56
Learn to map the fretboard in Excel by building a number and letter based grid, and use XLOOKUP and VLOOKUP to pull notes from a prepared table.
1020 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 424:44
1025 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 526:31
1030 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 627:11
1035 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 718:17
1040 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 839:13
1045 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 919:41
1050 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 1019:33
Explore how to map the guitar fretboard with Excel, building major and minor scales, and introduce modes like Dorian using relative major concepts and the circle format.
1055 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 1117:16
1060 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 1213:05
1065 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 1315:43
1070 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 1431:27
1075 Spreadsheet Creation Mapping the Path to Fretboard Enlightenment Part 1527:12

2010 Open Chords - C Major Scale – C Major Chord Worksheet28:06
2012 Open Chords - C Major Scale – C Major Chord Fingering29:55
2016 Open Chords - C Major Scale – C Major Chord & Related Scale24:39
2020 Open Chords - C Major Scale – C Major Chord & Intervals24:47
2025 Open Chords - C Major Scale – F Major Chord Worksheet28:30
2030 Open Chords - C Major Scale – F Major Chord Fingering27:11
2035 Open Chords - C Major Scale – F Major Chord & C Scale28:48
2040 Open Chords - C Major Scale – F Major Chord & Intervals31:41
2045 Open Chords - C Major Scale - G Major Chord Worksheet34:32
Explore open chords and the C major scale using guitar and Excel to map the fretboard, build G major and other chords, and understand movable shapes and the Caged system.
2050 Open Chords - C Major Scale – G Major Chord Fingering30:16
Map open chord fingering on the fretboard with an Excel workbook, focusing on the C major scale and G major chords, including 1-3-5 and open position.
2055 Open Chords - C Major Scale – G Major Chord on C Scale26:03
2060 Open Chords - C Major Scale – G Major Chord Intervals33:30
2065 Open Chords - C Major Scale – D Minor Two Chord Worksheet47:58
Map the fretboard with open chords in C major and the D minor two chord using a guitar–excel worksheet, exploring major/minor shapes and pentatonic scale.
2070 Open Chords - C Major Scale – D Minor Two Chord Fingering35:47
Explore open chords in the key of c and the d minor two-chord fingering, using a mapped fretboard in excel to visualize notes, intervals, and movable shapes in open positions.
2075 Open Chords - C Major Scale – D Minor Two Chord on C Major Scale35:25
2080 Open Chords - C Major Scale – D Minor Two Chord Intervals38:56
2095 Open Chords - C Major Scale – E Minor Three Chord Fingering32:25
2100 Open Chords - C Major Scale – E Minor Three Chord on C Major Scale38:49
2110 Open Chords - C Major Scale – E Minor Three Chord Intervals37:18
2115 Open Chords - C Major Scale – A Minor 6 Chord Worksheet38:47
Explore open chords and fretboard mapping within the C major scale, leading to A minor, with an Excel-based worksheet for constructing 1–4–5 major and 2–3–6 minor chords and pentatonic relationships.
2120 Open Chords - C Major Scale – A Minor 6 Chord Fingering28:07
Explore guitar open chords and the C major scale, master a minor fingering, and map the fretboard using an Excel workbook, linking major and minor modes.
2125 Open Chords - C Major Scale – A Minor 6 & Scales28:13
2130 Open Chords - C Major Scale – A Minor 6 Intervals35:47
Explore open chords in the C major scale, map the fretboard with absolute letter-number and relative interval systems, and analyze A minor six, major/minor chord intervals, and related pentatonic context.
2135 Open Chords - C Major Scale – B Diminished 7 Chord Worksheet35:28
2140 Open Chords - C Major Scale – B Diminished 7 Chord Fingering32:28
2145 Open Chords - C Major Scale – B Diminished 7 Chord Intervals33:00
Explore chords in the key of C, map the fretboard with a workbook, and analyze C major, F, G, D minor, E minor, A minor, and B diminished seventh intervals.

2300 Pentatonic & Major or Minor Scale Positions Worksheet40:35
2310 Pentatonic Scale Fret 5 Fingering32:46
2315 Pentatonic Scale Fret 5 Intervals36:43
2320 C Major-A Minor Scale Fret 5 – Fingering37:07
Master fret five fingering for C major and A minor scales, map the fretboard from open-position chords to the major scale, and connect pentatonic patterns to Aeolian and Dorian modes.
2325 C Major-A Minor Scale Fret 5 – Intervals44:10
2330 A Minor Scale & Related Modes Fret 5 – Intervals37:52
2335 C Major-A Minor Scale Fret 5 – Target C Major Chord30:09
2340 C Major-A Minor Scale Fret 5 – Target F Major Chord41:45
Map the guitar fretboard in Excel to visualize the C major and A minor scales, build chords including the F major, and connect pentatonic shapes to the major scale.
2345 C Major-A Minor Scale Fret 5 – Target G Major Chord42:22
2350 C Major-A Minor Scale Fret 5 – Target D Minor Chord43:51
Map the guitar fretboard in Excel from C major and A minor scale shapes up to fret five, targeting the D minor chord, and explore the major and pentatonic relationships.
2355 C Major-A Minor Scale Fret 5 – Target E Minor Chord44:40
Map the guitar fretboard with Excel to illuminate C major scale and chords, target E minor at fret five, explore pentatonic patterns, and connect open-position shapes across related modes.
2360 C Major-A Minor Scale Fret 5 – Target A Minor Chord35:10

2365 C Major - A Minor Pentatonic Scale Fret 7 Fingering35:47
2370 C Major - A Minor Pentatonic Scale Fret 7 Intervals38:59
2375 C Major - A Minor Scale Fret 7 Fingering29:33
2380 C Major - A Minor Scale Fret 7 Intervals47:19
2385 A Minor Scale Fret 7 Intervals36:07
Map a minor scale and intervals from fret seven using Excel, linking notes to chords and positions, and compare major and minor interval concepts in absolute and relative terms.
2390 C Major - A Minor Scale Fret 7 Focusing on the C Note31:50
Map the C major and A minor scales across the guitar fretboard, focusing on fret seven and the C note, with open positions, pentatonic and major shapes, and chord voicings.
2395 C Major - A Minor Scale Fret 7 Focusing on the F Note40:50
2400 C Major - A Minor Scale Fret 7 Focusing on the G Note42:01
2405 C Major - A Minor Scale Fret 7 Focusing on the D Note42:05
2410 C Major - A Minor Scale Fret 7 Focusing on the E Note40:59
2415 C Major - A Minor Scale Fret 7 Focusing on the A Note45:53

2420 C Major - A Minor Pentatonic Scale Fret 9 Fingering32:42
Master C major and A minor pentatonic fingering at fret 9, map pentatonic shapes across the fretboard, and connect them to open chords and barre or power chords.
2425 C Major - A Minor Pentatonic Scale Fret 9 Intervals46:40
Discover how to navigate the C major scale and the A minor pentatonic across guitar positions, with interval naming, chord constructions, and fret 9 insights.
2430 C Major - A Minor 7 Note Scale Fret 9 Fingering29:33
2435 C Major - A Minor 7 Note Scale Fret 9 Intervals45:51
2440 C Major - A Minor Scale Fret 9 Focusing on the C Note36:04
Explore the c major scale and a minor scale at fret 9, focusing on the c note, mapping open-position chords and caged shapes (g-shaped, e-shaped, d-shaped), and mastering neck transitions.
2445 C Major - A Minor Scale Fret 9 Focusing on the F Note42:15
2450 C Major - A Minor Scale Fret 9 Focusing on the G Note45:26
2455 C Major - A Minor Scale Fret 9 Focusing on the D Note51:51
2460 C Major - A Minor Scale Fret 9 Focusing on the E Note56:50
2465 C Major - A Minor Scale Fret 9 Focusing on the A Note54:02

3010 Interval & Modes – Complement & Parallel Worksheet26:04
3014 Interval & Modes – Complement & Parallel Worksheet Part 223:38
3016 Interval & Modes – Complement & Parallel Worksheet Part 330:43
Learn to map the musical alphabet and fretboard in excel, then create a complementary parallel interval worksheet that visualizes intervals relative to a root using formulas like if and xlookup.
3018 Interval & Modes – Complement & Parallel Worksheet Part 433:11
3020 Interval & Modes – Complement & Parallel Worksheet Part 530:27
3022 Interval & Modes – Complement & Parallel Worksheet Part 637:07
3024 Interval & Modes – Complement & Parallel Worksheet Part 719:51
3026 Interval & Modes – Complement & Parallel Worksheet Part 834:36
3028 Interval & Modes – Complement & Parallel Worksheet Part 925:03
3030 Interval & Modes – Complement & Parallel Worksheet Part 1029:38
3032 Interval & Modes – Complement & Parallel Worksheet Part 1139:36
Explore guitar interval and mode concepts using an Excel-based complement and parallel worksheet, building a 12-note major scale circle to map whole and half steps across keys.

Requirements

Familiarity with Excel: While advanced Excel skills are not required, a basic understanding of how to navigate and use Microsoft Excel will be helpful. Participants should know how to open and save files, enter data into cells, and navigate between different parts of the worksheet.
Access to a Guitar: Participants need to have a guitar available for practice and application of the concepts taught in the course.
Access to Microsoft Excel: A computer with Microsoft Excel installed is required to participate in the course and complete the exercises.
Openness to Learning: A willingness to learn and an open mind are crucial, as this course takes a unique approach to guitar theory.
Commitment to Practice: As with any musical endeavor, regular practice is key to understanding and mastering the concepts taught in the course.
Internet Connection: If the course is taken online, a stable internet connection is required to access course materials and participate in any live sessions.
Desire to Explore Music Creatively: A passion for exploring music and a desire to understand the guitar on a deeper level will enhance the learning experience.
Patience and Persistence: Learning music theory and Excel simultaneously can be challenging, so patience and persistence are essential.

Description

Discover a groundbreaking approach to mastering guitar music theory with a course designed for aspiring guitarists ready to explore the fretboard like never before. By leveraging the untapped potential of Microsoft Excel, a tool rarely associated with music theory, this course offers a fresh and innovative perspective that will change the way you perceive and play the guitar.

This course is not your typical music theory class. We understand that the guitar fretboard can be viewed as a spreadsheet, making Excel an exceptional tool to deepen your understanding and unlock new potentials. From constructing detailed Excel worksheets that mirror the guitar fretboard, to mapping out chords and scales, this course ensures a comprehensive and hands-on learning experience.

The first section of the course is dedicated to building a robust Excel worksheet that will serve as your guide and companion throughout your musical journey. Whether you're keen on enhancing your Excel skills or solely focused on the music theory aspect, this course caters to you. We provide step-by-step guidance for constructing the worksheet, ensuring you grasp the fundamentals of both Excel and music theory. For those more inclined towards the theory, a completed copy of the worksheet is provided at each stage, allowing you to dive straight into the musical exploration.

In a unique twist, the worksheet is formatted with the lowest guitar string at the top, mirroring the way most guitarists visually perceive the fretboard while playing. This intuitive layout ensures a seamless transition from theory to practice, enhancing your ability to visualize and navigate the fretboard with ease.

As the course progresses, we delve into the key of C in open position, unraveling its mysteries with unparalleled detail. You will learn to construct and analyze each chord within this key, mapping them onto the fretboard, fingering the positions, and understanding their relationship with the C Major scale. By contrasting the C Major Scale with the scale of each chord, you gain a holistic 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 blends the power of Excel with the beauty of guitar music theory, ensuring you emerge with a solid foundation and a new-found appreciation for the fretboard. Join us on this unique adventure and transform your approach to guitar theory and practice!

Who this course is for:

Guitarists Seeking a Deeper Understanding: Guitar players who have mastered the basics but want to delve deeper into the theory behind the music, gaining a more comprehensive understanding of scales, chords, and progressions.
Music Theory Enthusiasts: Individuals with an interest in music theory who are looking for innovative and practical ways to apply theoretical concepts directly to the guitar.
Excel Users Interested in Music: Those proficient in Excel who are interested in exploring its applications beyond the traditional office setting, particularly in creative and musical domains.
Self-Learners: Individuals who prefer a hands-on, interactive learning style, and are looking for a course that provides practical skills and knowledge that can be applied immediately to their guitar playing.
Music Educators: Teachers and instructors looking for new and engaging methods to introduce or reinforce music theory concepts to their students.
Songwriters and Composers: Musicians involved in songwriting or composition who want to enhance their understanding of how different chords and scales can be used effectively in their work.
Technology Enthusiasts: Those who have an interest in exploring unconventional uses of software like Excel, particularly in artistic and musical contexts.
Beginner Excel Users: Individuals with basic Excel skills who are looking to improve their proficiency while also learning about music theory.
Creatives Looking for a New Approach: Artists, musicians, and creatives who are always on the lookout for innovative approaches to enhance their skills and understanding of their craft.
Lifelong Learners: Anyone with a curiosity about music and technology, and a desire to learn something new and unconventional.

Guitar & Microsoft Excel

What you'll learn

Explore related topics

Course content

Create Excel Worksheet Tool15 lectures • 5hr 46min

Open Chords Built from the C Major Scale26 lectures • 14hr 6min

Pentatonic & Major or Minor Scale Position Fret 5 (Position 1 or G Shape)12 lectures • 7hr 47min

Pentatonic & Major or Minor Scale Fret 7 (Position 2 or E Shape)11 lectures • 7hr 11min

Pentatonic & Major or Minor Scale - Fret 9 (Position 3 or D Shape)10 lectures • 7hr 21min

Pentatonic & Major or Minor Scale - Frets 0 & 12 (Position 4 or C Shape)3 lectures • 2hr 4min

Interval & Modes Worksheet Creation - Complement & Parallel Modes11 lectures • 5hr 30min

Requirements

Description

Who this course is for: