Steven Lawrence
Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions
Data Science tutor - Steven Lawrence
Bachelors degree
/ 30 min
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 Science tutor skills
Assignment help
Data visualization
Business intelligence
Deep Learning
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!
To protect your payment, never transfer money or communicate outside the Wiingy website or app.
Your data science tutor also teaches
Data Analysis
Excel
Data Science concept taught by Steven
During a recent lesson, Steven guided a learner, a resident of Jacksonville, through loading data into MySQL and MongoDB databases. The primary focus was on resolving foreign key constraints and data formatting issues. They utilized AI to generate datasets for tables such as 'teacher', 'class', 'parent contact', and 'student', and practiced SQL queries for data validation. The learner then exported the MongoDB collections to CSV files and plans to compile the work into a presentation.
GUIDs (Globally Unique Identifiers)
CSV Data Format
JSON Data Format
MongoDB Collections
SELECT MAX()
Foreign Key Constraint
MySQL AUTO_INCREMENT
Steven helped Ashley troubleshoot and improve her Excel costing template by fixing data validation issues, implementing error handling for dropdown lists, and discussing spreadsheet design for multiple users. They converted data to tables, used named ranges, and implemented the `IFERROR` function. Ashley plans to tidy up the spreadsheet, implement shaded areas for user clarity, and create a summary sheet by Monday.
Excel Tables
IFERROR Function
VLOOKUP vs. XLOOKUP
Named Range
Data Validation
Steven guided an individual on setting up and troubleshooting an Excel property management tool. The learner, who resides in High Point, received assistance with macros, adding a new property, logging an expense, and customizing the default save path. They will practice using the tool and schedule another lesson if further issues arise.
Expense Logging
Excel File Unblocking
Property Addition in Excel Tool
Default Save Path
Steven and Bol collaborated on a Python assignment focused on data analysis. During their work, they successfully imported data from a text file using the NumPy library and proceeded to extract specific columns. They also initiated the visualization process with Matplotlib and began segmenting the data for deeper insights, intending to pick up where they left off in their upcoming lesson.
numpy.genfromtxt
Tab-Delimited Files
Column Indexing (0-based)
matplotlib.pyplot
Steven and Ashley collaborated on refining Ashley's Excel costing template, focusing on correcting SUM formulas, implementing conditional formatting for variance display, and using data validation for dropdown lists. Steven introduced VBA to create an auto-save macro and they saved the file as an XLSM. Ashley was assigned homework to apply the learned formatting and formula corrections throughout the rest of the spreadsheet, and they scheduled another session for the next day.
Relative Referencing
Conditional Formatting
VBA (Visual Basic for Applications)
IF Statement Logic
SUM Function
Steven and J. Walter Urey delved into MySQL database operations, practicing counting, inserting, updating, and deleting records. Following this, they transitioned to MongoDB, where they focused on designing a database schema, executing CRUD operations, and exporting data. They also explored the schemaless characteristic of MongoDB and its inherent flexibility for data handling. Their upcoming lesson is set for Tuesday, with the goal of importing a data set into the database.
MongoDB Schemaless Design
CRUD Operations
SQL INSERT Statement
SQL COUNT() Function
Learner types for data science class
College
All levels
Adult/Professionals
School
Interactive data science classes
Note taking
Parent feedback
Record lessons
Chat for quick help
Open Q&A
Teaching tools used by data science tutor
Google Colab
Free lesson slots
1 / 1
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.