Steven Lawrence
Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions
Loading...



Show all photos
Steven Lawrence
Bachelors degree
Enroll after the free trial
Each lesson is 55 min
50 lessons
20% off
/ lesson
30 lessons
15% off
/ lesson
20 lessons
10% off
/ lesson
10 lessons
5% off
/ lesson
5 lessons
-
/ lesson
1 lessons
-
/ lesson
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!
Data Science tutor skills
Data visualization
Assignment help
Deep Learning
Business intelligence
Learner types for data science class
Adult/Professionals
School
College
All levels
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!
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.
Your data science tutor also teaches
Data Analysis
Excel
Flexible Scheduling
Allows 1h early scheduling
Allows 1h early rescheduling
Can wait for 20 mins after joining

10 day Refund
Free Tutor Swap

Data Science concepts taught by Steven
The session focused on practical Excel functions for data manipulation and analysis. The tutor guided the student through text functions (LEFT, RIGHT, MID, TRIM, UPPER, LOWER), rounding functions (ROUND, ROUNDDOWN, ROUNDUP), and lookup functions (VLOOKUP, XLOOKUP). Date functions like TODAY, EOMONTH, MONTH, YEAR, and DATEDIF were also covered, with plans to discuss INDEX MATCH and multiple criteria in the next session.
IFERROR Function: Error Handling
Date and Time Functions (TODAY
EOMONTH)
VLOOKUP and XLOOKUP: Data Retrieval
Text Manipulation Functions (LEFT
RIGHT
MID
LEN
The Student and Tutor explored advanced Excel functions like Goal Seek and Scenario Manager to manipulate financial data, specifically within a divorce settlement context involving asset and liability splits. They worked on making the spreadsheet more intuitive and functional, discussing potential automation and structural improvements for future use.
Dynamic Calculation with Excel Formulas
Advanced Excel Automation with VBA
Data Formatting and Readability in Excel
Excel's Goal Seek and Scenario Manager
The Student and Tutor collaboratively worked on designing an Excel-based maintenance log and dashboard system. They discussed data structure, visualization methods for flagging maintenance needs, and strategies for handling a large inventory of equipment. Future steps include further research into lookup functions and consultation with the Student's business partner.
Dashboard Design Principles
Lookup Functions and Data Retrieval
Data Organization and Efficiency
Maintenance Log Structure
The student and tutor worked on advanced Excel techniques for generating a federal grant salary report. They focused on data cleaning, using SUMIFS formulas with multiple criteria for date and name matching, and understanding cell referencing for accurate calculations. The session aimed to automate a previously manual and time-consuming reporting process.
SUMIFS Function
Date Criteria in SUMIFS
Cell Reference Locking for Dragging Formulas
Absolute Cell References ($)
The class focused on Excel data manipulation and analysis functions. The student practiced using `Text to Columns`, `COUNTIFS`, and `SUMIFS`, and learned best practices for data cleaning, handling leading zeros, and applying filters. The next session will continue with remaining functions and pivot tables.
Text to Columns: Data Separation
COUNTIF and COUNTIFS: Conditional Counting
SUMIF and SUMIFS: Conditional Summation
Data Cleaning: Handling Dates and Formatting
AND vs. OR Logic in Formulas
The Student and Tutor worked on improving data organization within a spreadsheet, focusing on managing dynamic data entries and structuring a maintenance log. They practiced converting data ranges into tables, implementing sorting, and setting up conditional logic for service alerts using Excel functions.
IFS Function for Complex Logic
Conditional Formatting for Alerts
Multilevel Sorting
Freeze Panes and Tables for Navigation
Data Structure and Organization
Dynamic Data Arrays (Spilling)
Teaching tools used by data science tutor
Google Colab
Interactive data science classes
Note taking
Parent feedback
Pets are welcomed
Open Q&A
Record lessons

Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.
