John Archer
Data Science Tutor at University of South Florida for Excel




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


Data Science tutor skills
Data visualization
Assignment help
Business intelligence
Data engineering
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!

Data Science concept taught by John
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
Your data science tutor also teaches
Data Analysis
Excel
Free lesson slots
1 / 1
Teaching tools used by data science tutor
Google Colab
Learner types for data science class
College
All levels
Data Science for Beginners
Data Science for College students
Data Science for Adults
Data Science for School students
School
Adult/Professionals
Data Science for Kids
Interactive data science classes
Pets are welcomed
Weekend lessons
Mobile joining
Record lessons
Chat for quick help

Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.