Steven Lawrence
Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions
Data Science tutor - Steven Lawrence
Bachelors degree
$15
/ 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
Steven assisted Jean in organizing her property expense data using Excel. They focused on importing information from a disorganized spreadsheet into a new template, employing copying, pasting, and sorting techniques to identify missing details. Steven will send Jean the completed Excel template for her to begin using and entering her 2025 data.
Data Sorting & Filtering
Separating Data Types
Autofill & Pattern Correction
Quick Data Selection (Ctrl+Shift+Arrow)
Paste Values vs. Paste Formula
Steven assisted Bol with a Python assignment focused on calculating and plotting V2 max levels for cyclists based on training hours. During their lesson, they defined a function, created a plot with labeled axes and a legend, and discussed the application of for loops and conditional statements within the programming language. Bol will send Steven a different file for their next lesson, where they will continue working on Python problems.
For Loops
NumPy Arrays (Vectors)
Matplotlib Plotting
Python Functions
Steven and Bol collaborated on a Python coding problem, focusing on temperature data. They developed a function to calculate and plot daily temperatures for Melbourne and New York, utilizing Matplotlib to visualize the information and identify minimum temperatures. Bol was encouraged to review the code and make notes on any unclear sections for a future discussion, with another lesson scheduled for the following day to tackle tasks four and five.
Python Function Definition
List Append Method
Matplotlib Plotting
List Indexing
Steven and E T collaborated on structuring VBA code for data import, cleaning, and analysis in Excel. Their lesson covered array manipulation, variable passing, and debugging techniques for this Excel VBA utility. Steven tasked E T with running the code to test its functionality and will send the updated file.
ByRef vs. ByVal
Redim Preserve
Code Structure/Hierarchy
Subscript Out of Range Error
Subroutine vs. Function
Steven and a learner from Cosumnes River College in Elk Grove worked on creating flowcharts for code snippets and tracing code execution. They analyzed a menu-driven program and a program that checks for even numbers, focusing on conditional statements, error handling, and code readability. The learner practiced tracing code execution with specific inputs and numbering the executed lines.
Python Try-Except Blocks
Flowchart Divergence
Integer vs. Float
While Loop Execution
Function Call & Return
Steven and Bol reviewed Python code execution, focusing on creating flowcharts and numbering lines of execution. They analyzed code snippets with loops, conditional statements, and function calls, tracing the order of execution based on inputs and console outputs. They plan to continue their work on these types of Python exercises in the next lesson.
Python Range Function
Code Execution Order
Modulo Operator & Remainder
Infinite Loops
Learner types for data science class
All levels
College
School
Adult/Professionals
Interactive data science classes
Weekend lessons
Parent feedback
Note taking
Record lessons
Pets are welcomed
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.