Steven Lawrence
Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions
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!
Improved problem-solving skills
92% of students report faster problem-solving after lessons.
Project-based learning for real-world skills
90% of students complete relevant coding projects.
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
Data visualization
Deep Learning
Business intelligence
To protect your payment, never transfer money or communicate outside the Wiingy website or app.
Data Science concept taught by Steven
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
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
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
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
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
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
Your data science tutor also teaches
Data Analysis
Excel
Free lesson slots
1 / 1
Teaching tools used by data science tutor
Google Colab
Student types for data science class
School
College
Adult/Professionals
All levels
Interactive data science classes
Record lessons
Note taking
Pets are welcomed
Parent feedback
Open Q&A
Data Science tutor on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.