logo

John Archer

Data Science Tutor at University of South Florida for Excel

4.8(32)

Free trial lesson

Profile photo of John, Data Science tutor at Wiingy
Graduation ceremony photo of John
Verified degree or teaching certification of John
Travel snapshot of John during a trip
tutor-image
tutor-image

Data Science tutor - John Archer

Bachelors degree

/ 30 min

About your data science tutor

Greetings!  I'm John "Coleman" Archer, a Bachelors-educated tutor with over a decade of experience specializing in Accounting and Finance. My passion lies in providing personalized Excel tutoring for all ages from School Kids to Adult Professionals looking to sharpen their skills. Whether you are just opening Excel for the first time or would like to freshen up your resume to feel confident labeling yourself as an Excel Intermediate/Expert - I have many lessons to share with you! Additionally, I offer expert guidance in various accounting software, financial statement comprehension, and personal finance best practices. If you are searching for the right tutor who cares and goes above and beyond to make sure their students are learning and fulfilled please consider a demo lesson where we can embark on your Excel journey together!

John graduated from University ofSouth Florida

John graduated from University ofSouth Florida
John graduated from University ofSouth Florida

Data Science tutor skills

Data visualization icon

Data visualization

Assignment help icon

Assignment help

Business intelligence icon

Business intelligence

Data engineering icon

Data engineering

Statistical analysis icon

Statistical analysis

Data sciece class overview

My tutoring approach starts with you!  How do you learn best and what would you like the results of our sessions to be?  From there we work backwards to make sure you are getting the exact outcomes with my lessons that you are paying good money for!  If you would rather give me a topic to explain and run with I can certainly facilitate that as well as I have many years of experience training and teaching how to leverage the amazing tools Excel and other accounting software provides.  By focusing on hands on practice, interactive lessons, and YOUR needs first, I ensure that students grasp in-depth Excel concepts effectively and build a strong foundation for academic and professional success alike!  I have a range of special interest topics that most of my students like to learn including some you may know or have heard of: Conditional Formatting, Pivot Tables, Formulas (VLookup/HLookup/Xlookup/Index-Match). Excel is THE tool to learn and you will be a high-level user who will  impress your friends, family and coworkers after a few good sessions together!    

keyLearning

Data Science concept taught by John

Deirdre learned 3 months ago

Deirdre and Coleman had a Wiingy session focused on Excel spreadsheets. Deirdre struggled with concepts like absolute values, pivot tables, and XLOOKUP. They spent time troubleshooting screen sharing and formula errors, particularly with XLOOKUP, focusing on correct cell references (relative vs. absolute) and data types. They also touched on data cleanup, including removing unwanted characters and addressing capitalization issues. They reviewed a sample actor data template and scheduled their next session, planning to cover flash fill, absolute references, and data cleanup tools further.

XLOOKUP Formula

Absolute References

Data Cleanup

Text to Columns

Keyboard Shortcuts

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

Learner types for data science class

College icon

College

All levels icon

All levels

Data Science for Beginners icon

Data Science for Beginners

Data Science for College students icon

Data Science for College students

Data Science for Adults icon

Data Science for Adults

Data Science for School students icon

Data Science for School students

School icon

School

Adult/Professionals icon

Adult/Professionals

Data Science for Kids icon

Data Science for Kids

Interactive data science classes

Pets are welcomed icon

Pets are welcomed

Weekend lessons icon

Weekend lessons

Mobile joining icon

Mobile joining

Record lessons icon

Record lessons

Chat for quick help icon

Chat for quick help

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