logo

Steven Lawrence

Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions

4.8(32)

Free trial within 24 hours

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

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!

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 Science tutor skills

Assignment help icon

Assignment help

Business intelligence icon

Business intelligence

Data visualization icon

Data visualization

Deep Learning icon

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!

Your data science tutor also teaches

Data Analysis

Data Analysis

Excel

Excel

keyLearning

Data Science concept taught by Steven

Student learned 7 days ago

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

Show more

Student learned 7 days ago

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

Show more

Student learned 7 days ago

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.

Moving Rows/Columns (Shift+Drag)

Switch Rows/Columns in Charts

Chart Data Structure

Currency vs. Accounting Format

Locking Rows/Columns ($)

Absolute vs. Relative References

Dynamic Formulas in Tables

Show more

Student learned 8 days ago

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

Show more

Student learned 9 days ago

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

Show more

Student learned 10 days ago

Steven and Sangeetha collaborated on a database schema design, specifically working on the creation of tables for firms, verification statuses, sectors, and peer groups. They meticulously defined primary and foreign keys to establish robust relationships among these tables. To prepare for their upcoming lesson, Sangeetha was assigned the task of applying the discussed database principles to smaller data segments.

Many-to-Many Relationship

Database Efficiency

Primary Key (PK)

Data Types

Vertical Scaling

Foreign Key (FK)

Show more

Learner types for data science class

Adult/Professionals icon

Adult/Professionals

All levels icon

All levels

School icon

School

College icon

College

Interactive data science classes

Open Q&A icon

Open Q&A

Record lessons icon

Record lessons

Pets are welcomed icon

Pets are welcomed

Weekend lessons icon

Weekend lessons

Note taking icon

Note taking

Teaching tools used by data science tutor

Google Colab image

Google Colab

Free lesson slots

1 / 1

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