Steven Lawrence
Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions
Private tutor - Steven Lawrence
Bachelors degree
$31
$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
Business intelligence
Data visualization
Assignment help
Deep Learning
To protect your payment, never transfer money or communicate outside the Wiingy website or app.
Data Science concept taught by Steven
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.
Excel Sheet Protection
VLOOKUP Function
Linking Cells Between Worksheets
Data Validation in Excel
3D Formulas in Excel
SUMIF Function
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.
Data Validation
Action Variables
Local vs. Global Variables
VBA User Forms
Order of Operations
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.
VLOOKUP Function
Concatenation
Trim Function
Substitute Function
Left and Right Functions
Length 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.
Attributes of Relationships
Junction Tables
Many-to-Many Relationships
One-to-Many Relationships
ER Diagram Breakdown
Database Design Flexibility
Importance of Constraints
Distinguishing Primary and Foreign Keys
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.
Exponential Smoothing
Simple Linear Regression
Mean Squared Error (MSE)
Moving Average
Time Series Analysis
Steven taught Breana advanced Excel skills, including data formatting, using functions like VLOOKUP and PMT, creating pivot tables and charts, and applying conditional formatting. Breana practiced these skills through a series of assignments focused on condo sales and loan data. They scheduled their next session for the following Monday to continue working on the material.
Pivot Tables
Data Tables
Conditional Formatting
Subtotals
Absolute References
PMT Function
VLOOKUP Function
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.