Steven Lawrence
Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions
Private tutor - Steven Lawrence
Bachelors degree
$18
$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 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
Data visualization
Business intelligence
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 and S A reviewed a database design for a dance studio, identifying issues related to normalization, data integrity, and relationships within the tables. Steven provided recommendations for improving the database structure, including creating new tables, using auto-numbered primary keys, and implementing lookup wizards. S A will discuss the feedback with her group and potentially schedule another session to address any remaining questions.
Event Date and Time
Primary Key Auto Number
Foreign Keys and Lookup Wizard
Data Types and Validation
Database Normalization
Active/Inactive Indicators
Customized Forms in Access
Contact Information Storage
Zach is analyzing changes between initial and final school funding and staffing allocations in Excel, focusing on the Division of Specialized Instruction. Steven is guiding him to improve his analysis by using VLOOKUP for data integration, calculating percentage changes to highlight significant impacts, and presenting findings clearly and simply for executives. While a deeper dive into school-level data is suggested for future analysis, Zach is prioritizing a concise presentation of the current findings, particularly the significant reduction in behavioral technician positions, for immediate submission.
VLOOKUP Function
Data Analysis Perspective
Simplifying Complexity
Percentage of Change
Inferences and Patterns
Steven assisted Breana in completing her final Excel assignments for her associates degree in small business management. They worked through formatting, formulas, charts, pivot tables, data consolidation, and "what-if" analysis across multiple worksheets. Breana used the completed worksheets to create a sales report and no follow-up was mentioned.
3D Formulas
Adjusting Column Width
Absolute References
VLOOKUP Function
Conditional Formatting
Pivot Tables
Protecting Worksheets
Text Split Function
Steven guided Zach through an Excel assignment focused on financial projections for a school district. Zach practiced using `SUMIF` to calculate unit and total costs, created data visualizations (pie and bar charts), and formatted the spreadsheet for a professional presentation. They discussed how to interpret the data to identify cost drivers and prepared the analysis for presentation to a manager.
Formatting Consistency
Relative vs. Absolute References
Chart Customization
SUMIF Function
Projected Cost Analysis
Steven tutored Alyne on various Excel functions and techniques, including cell referencing, IF statements, Text to Columns, COUNT/COUNTA, SUM, and AVERAGE. They discussed using these functions for data validation, calculations, and automation. Alyne will bring a real-world data problem to the next session to apply these concepts practically.
Data Validation with IF Statements
COUNT vs COUNTA
Text to Columns
Dynamic vs. Absolute Cell References
Automating Tasks with Code
Data Consistency
Steven and S A reviewed S A's database assignment, specifically focusing on functional dependencies, partial dependencies, and database normalization. Steven provided guidance on identifying and correcting errors in the database design. S A will send Steven module 8 materials and the group project details for review before their meeting on July 28th.
Partial Dependency
Non-Dependency
Composite Key
Module 8 & Group Project
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 tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.