Steven Lawrence
Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions
Loading...
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
Data visualization
Business intelligence
Deep Learning
Assignment help
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!
Your data science tutor also teaches
Data Analysis
Excel
Data Science concept taught by Steven
The Student and Tutor worked through calculating daily revenue, identifying stockouts and errors, and using Power Pivot tables. The Student learned to perform calculations, use logical functions (`IF`, `VLOOKUP`), and analyze data using pivot tables. The session concluded with setting up a follow-up to continue working with Power Pivot tables and DAX formulas.
VLOOKUP Function
Excel Tables
IF Function
XLOOKUP function
Absolute Value (ABS) Function
Daily Revenue Calculation
Power Pivot Tables
Steven and Sangeetha engaged in a collaborative effort to design a database schema. Their discussion centered on crucial aspects such as table relationships, naming conventions, and effective strategies for managing null values within company targets, financials, ownership, and scope emissions data. For their upcoming lesson, Sangeetha will visually map out the database schema, and they've arranged a subsequent meeting to continue refining the design and consider alternative names.
Table Classifications
Primary & Foreign Keys
Null Value Elimination
Database Naming Conventions
Database Design Trade-offs
Steven guided Nancy through several Excel projects, focusing on data validation, scenario analysis with 'What-If Analysis' tools, and macro creation and implementation. They engaged in various exercises to deepen Nancy's understanding of these Excel functionalities. A follow-up lesson is planned for the next week to tackle remaining assignments.
Data Validation
Macros
Solver Add-in
Named Ranges
SUMIF & SUMPRODUCT
Steven tutored Steven Lawrence on advanced Excel functions, including dynamic tables, absolute vs. relative cell references, and custom number formatting. Steven Lawrence will email the spreadsheet from the lesson to Steven for troubleshooting, and they plan to cover pivot tables in their next lesson.
Currency vs. Accounting Format
Switch Rows/Columns in Charts
Chart Data Structure
Moving Rows/Columns (Shift+Drag)
Locking Rows/Columns ($)
Absolute vs. Relative References
Dynamic Formulas in Tables
Steven provided support to Nancy on her Excel projects, delving into areas like worksheet manipulation, data consolidation, number formatting, and advanced functions such as INDEX, XMATCH, and SUMIFS. They achieved 100% on both of the two assignments they tackled. Nancy's next task involves a different project from her school's canvas, scheduled for tomorrow.
Merge & Center
Selecting Multiple Worksheets
Autofill & AutoFit
Absolute vs. Relative References
INDEX & XMATCH Functions
SUMIFS Function
Steven and a learner delved into database design during a recent lesson, concentrating on structuring tables for company targets and environmental framework references. They thoroughly explored data types, constraints, and primary/foreign key relationships to ensure data integrity and facilitate querying. The learner, a student at Springfield University, was then assigned the task of restructuring existing tables to incorporate the 'firm year' table concept and separate company targets into individual tables.
NULL vs. NO
Data Type Restrictions
Entity vs. Attribute
FirmYear Table
Primary Key as Foreign Key
Learner types for data science class
Adult/Professionals
College
All levels
School
Interactive data science classes
Note taking
Weekend lessons
Chat for quick help
Open Q&A
Pets are welcomed
Teaching tools used by data science tutor
Google Colab
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.
