Tired of feeling overwhelmed by Google Sheets?

Bachelor Data Academy is a program designed to help you establish a solid foundation in Google Sheets while learning to tell powerful stories using design and color. The bonus? You get to learn using fun data from BachelorData! 🌹
ENROLL NOW
Hi, I'm Suzana Somers, and I teach reality TV show lovers like you the power of Google Sheets that you need to be successful in your daily work. If you've been hesitant to learn or found that the videos out there on Google Sheets or Excel are boring and unrelatable, Bachelor Data Academy gives you the skills and confidence to harness the power of data.

In this program, I take the guesswork out of understanding spreadsheets so you can navigate and use them with ease, efficiency and confidence in knowing what they can do for you.

👉 The result? You get time back in your life to focus on other important projects at work and the potential of growing your career.

Bachelor Data Academy is the right fit if you:

  • You're tired of wasting time Googling how to use Google Sheets

  • Find YouTube videos on Google Sheets boring, dull and completely unrelatable 😴

  • You know that learning how to use them will make you more marketable for a promotion but don't feel supported or know how to get started

  • You would actually like to be "Proficient in Excel" like your resume says you are 😏

"I was a complete beginner with spreadsheets but with the knowledge from the course I feel comfortable with the program and applying for jobs that require a knowledge of spreadsheets. Lessons were entertaining and incorporated information about contestants from the show I am already familiar with, made learning tools and formulas easy to understand."

 - Laura H, Bachelor Data Academy Student

Here's what you'll get

  • 10 modules with over 70 self-paced lessons walking you through the foundations of Google Sheets to intermediate and advanced skills

  • Access to a private Facebook community to troubleshoot, ask questions, and continue learning with Suzana

  • Access to the Bachelor Data Academy Workbooks featured throughout the course, using data from Season 15 of The Bachelorette (Instagram follower counts, episode 1 featured screen time, and more!)

Check out the Course Curriculum!

Your roadmap to Google Sheets confidence 🌹

  • 1

    Module 1 - Google Sheets Fundamentals

    • Welcome to Bachelor Data Academy 🎉

    • How to get support during the course

    • Module 1 Workbook

    • 1.1 Get to Know the Data

    • 1.2 Intro to Spreadsheets

    • 1.3 Your Keyboard gets the First Impression Rose 🌹

    • 1.4 Get Started in Spreadsheets

    • 1.5 Intro to Functions

    • 1.6 Your Toolbar

    • 1.7 Printing
  • 2

    Module 2 - Formatting

    • Module 2 Workbook

    • 2.1 Formatting Basics

    • 2.2 Building a Color Palette

    • 2.3 Freezing Panes

    • 2.4 Drop Down Menu

    • 2.5 Relative & Absolute Referencing

    • 2.6 Copy & Pasting

    • 2.7 Alternating Colors
  • 3

    Module 3 - Conditional Formatting

    • Module 3 Workbook

    • 3.1 Intro to Conditional Formatting

    • 3.2 Format Cell Rules

    • 3.3 Google: Color Scales

    • 3.4 Clear Conditional Formatting

    • 3.5 Add Conditional Formatting to Entire Row

    • 3.6 Highlight Duplicate Values & Remove

    • 3.7 Sparklines (Bonus Lesson)
  • 4

    Module 4 - Working with Data

    • Module 4 Workbook

    • 4.1 Types of Data

    • 4.2 Splitting Data

    • 4.3 Combining Data

    • 4.4 Find & Replace

    • 4.5 Case Functions

    • 4.6 Beginner Functions

    • 4.7 IF Functions

    • 4.8 Share your Data
  • 5

    Module 5 - Creating Visualizations in Google

    • Module 5 Workbook

    • 5.1 Intro to Data Visualization

    • 5.2 Bar and Column Charts

    • 5.3 Line Charts

    • 5.4 Pie Charts

    • 5.5 Combo Charts

    • 5.6 Customize your Charts

    • 5.7 Moving Charts

    • 5.8 Deciding on the Best Visualization
  • 6

    Module 6 - Creating Visualizations in Canva/Color & Design

    • Module 6 Workbook

    • 6.1 Intro to Canva

    • 6.2 Bar Charts

    • 6.3 Line Charts

    • 6.4 Icon Charts

    • 6.5 Design & Color 🎨

    • 6.6 Bring in Google Charts

    • 6.7 Taking Canva Data Viz to Infographics & Presentations
  • 7

    Module 7 - Cleaning your Data

    • Module 7 Workbook

    • 7.1 Clean Up Whitespaces

    • 7.2 Filtering Data

    • 7.3 Sorting Data

    • 7.4 Grouping Data

    • 7.5 Find & Replace
  • 8

    Module 8 - Lookup & Query Functions

    • Module 8 Workbook

    • 8.1 Working Across Worksheets

    • 8.2 Data Validation Across Multiple Sheets

    • 8.3 VLOOKUP

    • 8.4 VLOOKUP Troubleshooting

    • 8.5 HLOOKUP

    • 8.6 Index & Combo Formulas

    • 8.7 Intro to Queries

    • 8.8 IFERROR
  • 9

    Module 9 - Google Power Tools

    • Module 9 Workbook

    • 9.1 Pivot Table

    • 9.2 Add a Slicer

    • 9.3 Collecting Clean Data

    • 9.4 Adding Comments

    • 9.5 Explore Tool

    • 9.6 Protect your Spreadsheets

    • 9.7 Version History

    • 9.8 Filtered Views

    • 9.9 Named Ranges
  • 10

    Module 10 - PivotTables

    • Module 10 Workbook

    • 10.1 Prepping Data for PivotTables

    • 10.2 Making your First PivotTable

    • 10.3 Show Value as a Percentage

    • 10.4 Formatting PivotTables

    • 10.5 Sorting and Filtering PivotTables

    • 10.6 Refreshing & Updating PivotTables

    • 10.7 Copy & Move PivotTables

    • 10.8 Calculated Fields (Coming July 2022)
  • 11

    Module 11 - Library of Resources

    • Course Workbooks & Cheat Sheets

    • Favorite Graphic Design & Data Resources

    • Data Viz Inspiration
"I can't believe how many new things I'm learning in a short amount of time and in such an enjoyable way. If you hated data or math in school, this course will give you a new found appreciation for all of those things -- and don't be surprised if you find yourself starting to love it. If you already enjoy working with data, this course will only add to the joy of discovering the stories in your data and creating spreadsheets that are beautifully formatted and curated to your needs."

- Summer H, Bachelor Data Academy Student

Bachelor Data Academy

Give yourself that spreadsheets rose!

ENROLL NOW

FAQ

  • Is this course for beginners? 🤔

    Bachelor Data Academy is a foundational program.

    👉It's for anyone who is just getting started with Google Sheets AS WELL as people who feel like they understand a bit about Google Sheets but knows there's a better way to use them.

    This course is not for seasoned experts in Google Sheets or data visualization.

  • ⏰ Do I have a limited amount of time to access this program?

    Bachelor Data Academy is fully self-paced, allowing you to take the course whenever it is convenient for you! You will have lifetime access. 🎉

    You can revisit lessons at any time, even after completing the course.

  • Do I have to join the Private Facebook group to participate in the course?

    No - We've created the private Facebook community as a way for you to troubleshoot your problems with Google Sheets and get bonus content after you're done with the course.

  • How many hours does this course take?

    The course will take about 7-8 hours to complete. Time will vary based on your experience and the time you spend practicing each lesson in your Bachelor Data Workbook.

    With lifetime access, you can go at whatever pace you'd like and revisit videos and lessons in the future.

  • 🌹 Will we get to use the real data from BachelorData?

    YES! This course uses data from Bachelorette Season 15 including (but not limited to):

    ✅    Instagram follower for all contestants
    ✅    Episode 1 Featured Screen Time
    ✅    Contestant Bios

  • What if I use Google Sheets AND Excel?

    We have a bundle available here.

  • Do you offer bulk pricing?

    Yes we do! Please email databachelor@gmail.com for more information.

  • Do you have a payment plan available?

    Yes we do! You can find it here.