logo

Steven Lawrence

Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions

4.8(32)

Free trial lesson

Profile photo of Steven, Data Science tutor at Wiingy
Data Science learning materials by Steven
Data Science learning materials by Steven
Data Science learning materials by Steven
tutor-image
tutor-image

Private tutor - Steven Lawrence

Bachelors degree

$32

$30

/ hour

About your data science tutor

Hello! I’m Steven, a tutor specializing in Microsoft Excel and VBA coding. With over 10 years of Excel expertise and 3+ years of solving real-world problems with VBA, I’ve automated workflows that boosted productivity by over 300%. I offer personalized coaching, project guidance, and a structured six-lesson series designed to prepare you for a professional career using Excel and VBA. Whether you're a student or a working professional, my step-by-step approach will help you master essential techniques, optimize workflows, and automate tasks effectively. My lessons foster confidence, creativity, and problem-solving skills in a relaxed learning environment. By working on projects that challenge and inspire you, you'll gain the expertise needed to apply Excel and VBA in real-world scenarios. Let’s elevate your skills together looking forward to helping you succeed!

icon

Improved problem-solving skills

92% of students report faster problem-solving after lessons.

icon

Project-based learning for real-world skills

90% of students complete relevant coding projects.

icon

Focused on real-world coding applications

Build real projects, from apps to websites.

Data sciece class overview

My tutoring approach is rooted in solving real-world problems. Traditional Excel and VBA lessons often rely on basic examples that don’t translate effectively into practical scenarios. My goal is to bridge that gap, helping students develop the flexibility, creativity, and problem-solving skills needed to tackle complex challenges. I structure problem-solving into three key steps: WHAT, WHY, and HOW. First, we define WHAT—identifying the business rules shaping the project. Next, we explore WHY—understanding the purpose behind the task. Finally, we determine HOW—the implementation strategy. Many rush into execution without considering the what or why, leading to ineffective solutions. My approach ensures you design robust, scalable tools. A key part of my tutoring is a six-lesson series designed to prepare students for a professional role in tech. This structured program equips you with essential skills to efficiently manage data, automate workflows, and build solutions that withstand real-world demands. I prioritize building tools that are efficient and sustainable. Simple solutions are often the best, but they must hold up under real-world pressures. Through my training, you’ll gain expertise in Excel and VBA, making you a valuable asset in any professional setting. If you're ready to take the next step in mastering Excel and VBA for a career in tech, let's get started!

Data Science tutor specialities

Assignment help icon

Assignment help

Data visualization icon

Data visualization

Deep Learning icon

Deep Learning

Business intelligence icon

Business intelligence

keyLearning

Data Science concept taught by Steven

Saira learned about 7 hours ago

Lesson date:

Steven and S A collaborated on translating an ER diagram for a law firm database into a relational model, discussing key concepts such as strong/weak entities, multivalued attributes, and different relationship types. They analyzed the diagram's limitations and the logic behind creating relational tables. S A will apply these concepts to the assignment, and they will compare their results on Friday.

Multivalued Attributes

Many-to-Many Relationships

Recursive Relationships

Weak Entities

Disjoint vs. Non-Disjoint

Mandatory vs. Optional

Superclass/Subclass

Relational Model Assignment

Show more

Briana learned 2 days ago

Lesson date:

Steven assisted Breana with an Excel assignment, guiding her through formatting, 3D formulas, data validation, chart creation, and building a dynamic X Games ticket calculator. They worked on consolidating data, creating a documentation sheet, and adding recommendations based on their analysis. They scheduled another session for the following Monday to continue working on the remaining assignments.

VLOOKUP Function

Excel Sheet Protection

Data Validation in Excel

3D Formulas in Excel

SUMIF Function

Linking Cells Between Worksheets

Show more

Edward learned 6 days ago

Lesson date:

Steven Lawrence tutored E.T. on building a calculator in Excel using VBA, covering interface design, VBA coding practices, and user input. They built a functional two-input calculator. Steven assigned E.T. homework to expand the calculator's functionality and scheduled another session for the following week.

Order of Operations

Action Variables

Data Validation

Local vs. Global Variables

VBA User Forms

Show more

Alyne learned 7 days ago

Lesson date:

Steven tutored Alyne on Excel, reviewing her completed test and covering functions including SUM, AVERAGE, COUNT, IF, AND, OR, CONCATENATE, TRIM, SUBSTITUTE, LEFT, RIGHT, LEN, and VLOOKUP. Steven emphasized practical applications and offered project-based consulting. Alyne will bring a real-world data problem to the next session, and Steven will create a cheat sheet of reviewed functions; he will be unavailable from July 16-23.

Concatenation

VLOOKUP Function

Length Function

Left and Right Functions

Substitute Function

Trim Function

Show more

Saira learned 8 days ago

Lesson date:

Steven is helping S A design a school database for a project. They discuss and refine the relationships between teachers, students, schools, subjects, and qualifications, focusing on handling many-to-many relationships with intermediary tables and efficiently tracking data like hours taught and management roles. Steven provides guidance on database design principles, UML notation, and offers to review S A's work. They also plan their next meeting, considering Steven's vacation.

Avoiding Assumptions

Distinguishing Primary and Foreign Keys

Importance of Constraints

Database Design Flexibility

Attributes of Relationships

Junction Tables

Many-to-Many Relationships

One-to-Many Relationships

Show more

Courtney learned 8 days ago

Lesson date:

Steven Lawrence tutored Courtney Rainwater on time series forecasting methods, including moving averages, exponential smoothing, and simple linear regression. Courtney worked on an assignment involving these concepts but struggled with the grading software's feedback. Steven offered to review the material and attempt the assignment himself using Courtney's login credentials for a follow-up.

Simple Linear Regression

Time Series Analysis

Moving Average

Mean Squared Error (MSE)

Exponential Smoothing

Show more

Your data science tutor also teaches

Data Analysis

Data Analysis

Excel

Excel

Free lesson slots

1 / 1

Teaching tools used by data science tutor

Google Colab image

Google Colab

Student types for data science class

School icon

School

College icon

College

Adult/Professionals icon

Adult/Professionals

All levels icon

All levels

Interactive data science classes

Record lessons icon

Record lessons

Note taking icon

Note taking

Pets are welcomed icon

Pets are welcomed

Parent feedback icon

Parent feedback

Open Q&A icon

Open Q&A

tutorFooter

Data Science tutor on Wiingy are vetted for quality

Every tutor is interviewed and selected for subject expertise and teaching skill.

Report this listing