logo

Steven Lawrence

Data Analysis Tutor from Thomas College Offering Comprehensive Data Science Sessions

4.8(32)

Free trial within 24 hours

Loading...
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

Data visualization icon

Data visualization

Business intelligence icon

Business intelligence

Deep Learning icon

Deep Learning

Assignment help icon

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

Data Analysis

Excel

Excel

keyLearning

Data Science concept taught by Steven

Student learned 23 days ago

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

Show more

Student learned 27 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 28 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 28 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.

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

Show more

Student learned 29 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 29 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

Learner types for data science class

Adult/Professionals icon

Adult/Professionals

College icon

College

All levels icon

All levels

School icon

School

Interactive data science classes

Note taking icon

Note taking

Weekend lessons icon

Weekend lessons

Chat for quick help icon

Chat for quick help

Open Q&A icon

Open Q&A

Pets are welcomed icon

Pets are welcomed

Teaching tools used by data science tutor

Google Colab image

Google Colab

tutorFooter

Data Science tutors on Wiingy are vetted for quality

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