logo

Steven Lawrence

Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions

4.8(32)

Free trial lesson

Profile photo of Steven, Data Science tutor at Wiingy
Data Science learning materials by Steven
Data Science learning materials by Steven
Data Science learning materials by Steven
tutor-image
tutor-image

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!

icon

Improved problem-solving skills

92% of students report faster problem-solving after lessons.

icon

Project-based learning for real-world skills

90% of students complete relevant coding projects.

icon

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 icon

Data visualization

Business intelligence icon

Business intelligence

Assignment help icon

Assignment help

Deep Learning icon

Deep Learning

keyLearning

Data Science concept taught by Steven

Saira learned 1 day ago

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

Show more

Zach learned 2 days ago

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

Show more

Briana learned 3 days ago

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

Show more

Zach learned 3 days ago

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

Show more

Alyne learned 4 days ago

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

Show more

Saira learned 4 days ago

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

Show more

Your data science tutor also teaches

Data Analysis

Data Analysis

Excel

Excel

Free lesson slots

1 / 1

Teaching tools used by data science tutor

Google Colab image

Google Colab

Student types for data science class

School icon

School

College icon

College

Adult/Professionals icon

Adult/Professionals

All levels icon

All levels

Interactive data science classes

Record lessons icon

Record lessons

Note taking icon

Note taking

Pets are welcomed icon

Pets are welcomed

Parent feedback icon

Parent feedback

Open Q&A icon

Open Q&A

tutorFooter

Data Science tutors on Wiingy are vetted for quality

Every tutor is interviewed and selected for subject expertise and teaching skill.

Report this listing