Tired of feeling overwhelmed by Excel?

The Data Academy is a program designed to help you establish a solid foundation in Excel while learning to tell powerful stories using design and color. The bonus? You get to learn using fun data from BachelorData! 🌹
Hi, I'm Suzana Somers, and I teach reality TV show lovers like you the power of Excel 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 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 Excel

  • Find YouTube videos on Excel 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 😏

Check out the course curriculum

Your roadmap to Excel confidence 🌹

  • 1

    Module 1: Excel Foundations

    • Welcome to Bachelor Data Academy!

    • How to get support during the course

    • Module 1 Workbook

    • 1.1 Get to know the Data & Course

    • 1.2 Welcome to Excel (PC Specific)

    • 1.2 Welcome to Excel (Mac Specific)

    • 1.3 Your Keyboard & Shortcuts

    • 1.4 Your Ribbon (PC Specific)

    • 1.4 Your Ribbon (Mac Specific)

    • 1.6 Intro to Functions

    • 1.5 Fill Series

    • 1.7 Printing (PC Specific)

    • 1.7 Printing (Mac Specific)

    • 1.8 Saving, Exporting and Sharing Safely (PC Specific)

    • 1.8 Saving, Exporting and Sharing Safely (Mac Specific)

  • 2

    Module 2: Formatting

    • Module 2 Workbook

    • 2.1 Formatting Basics

    • 2.2 Building a Color Palette

    • 2.3 Freezing Panes

    • 2.4 Data Validation (PC)

    • 2.4 Data Validation (Mac)

    • 2.5 Relative & Absolute Referencing

    • 2.6 Move, Copy, Cut & Paste

    • 2.7 Alternating Colors

    • 2.8 Merging Cells

  • 3

    Module 3: Conditional Formatting

    • Module 3 Workbook

    • 3.1 Intro to Condition Formatting

    • 3.2 Exploring Rules and Formatting

    • 3.3 Color Scales

    • 3.4 Data Bars

    • 3.5 Icon Sets

    • 3.6 Add Conditional Formatting to Entire Row

    • 3.7 Highlight & Remove Duplicates

  • 4

    Module 4: Working with Data

    • Module 4 Workbook

    • 4.1 Types of Data

    • 4.2 Splitting Text

    • 4.3 Combining Data

    • 4.4 Find & Replace Text

    • 4.5 Find & Replace Formatting (PC ONLY)

    • 4.6 Capitalization Functions

    • 4.7 Beginner Functions

    • 4.8 IF Functions

    • 4.9 Multiple Conditions

  • 5

    Module 5: Creating Charts in Excel

    • 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 Moving Charts between Worksheets

    • 5.7 Deciding on the Best Visualization

  • 6

    Module 6: Creating Charts in Canva

    • Module 6 Workbook

    • 6.1 Intro to Canva

    • 6.2 Bar Charts in Canva

    • 6.3 Line Charts in Canva

    • 6.4 Icon Charts in Canva

    • 6.5 Color Theory & Design Principals 🎨

    • 6.6 Bring in Excel Charts to Canva

    • 6.7 Taking Canva's 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

    • BONUS Sort + Filter Combo Function!

    • 7.4 Grouping & Subtotaling Data

    • 7.5 IFERROR

    • 7.6 Tables

  • 8

    Module 8: PivotTable Analysis

    • Module 8 Workbook

    • 8.1 Prepping Data for PivotTables

    • 8.2 Making your First PivotTable

    • Dealing with Growing Source Data

    • 8.3 Formatting PivotTables

    • 8.4 Sorting, Filtering, & Grouping PivotTables

    • 8.5 Refreshing & Updating PivotTables

    • 8.6 Copy & Move PivotTables

    • 8.7 Calculated Fields

    • 8.8 PivotCharts

  • 9

    Module 9: Lookup Functions

    • Module 9 Workbook

    • 9.1 Working Across Worksheets & Workbooks

    • 9.2 Data Validation Across Worksheets

    • 9.3 VLOOKUP

    • 9.4 VLOOKUP Troubleshooting

    • 9.5 HLOOKUP

    • 9.6 XLOOKUP

    • 9.7 Index & Combo Functions

    • Bonus: Finishing the Dashboard

  • 10

    Module 10: Excel Power Tools

    • Module 10 Workbook

    • 10.1 View Panes & Custom Views

    • 10.2 Copy Visible Cells Only

    • 10.3 Create Custom Table Styles

    • 10.4 Naming Cells

    • 10.5 Left & Find Combo Formula

    • 10.6 Templates

    • 10.7 Scatter Plots in Excel

    • 10.8 Flash Fill

  • 11

    Resources

    • Shortcuts & Formulas Cheat Sheets

    • Favorite Graphic Design & Data Resources

    • Data Viz Inspiration

Here's what you'll get

  • 10 modules with over 80 self-paced lessons walk you through everything from the basics to skills like advanced formulas and data visualization, plus tools like PivotTables and more!

  • Access to a private 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 24 of The Bachelor (Instagram follower counts, episode 1 featured screen time, and more!)

Bachelor Data Academy

Give yourself that Excel rose!

FAQ

  • Is this course for beginners?

    The Data Academy is a foundational program.

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

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

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

    The 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.

  • 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 Bachelor Season 24 including (but not limited to):

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

  • What if I use Excel and Google Sheets?

    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.