Hitesh Arora
Experienced Certified Python and Microsoft Excel Tutor. Book a demo session with me.




Show all photos
Hitesh Arora
Bachelors degree
/ 55 min
Hitesh - Know your tutor
Hi, I'm Hitesh, a passionate tutor with a BE in Electrical & Electronics from Panjab University. As a certified Python and Microsoft Excel tutor, I specialize in teaching from basics to advanced levels. My approach focuses on practical examples, step-by-step explanations, and hands-on practice. I cover topics like Decorators, OOPs, Lists, Tuples, and Functions in Python, and data analysis, visualization, and formulas in Excel. Let's get started on your learning journey! Certified Python & Excel Tutor. Expertise in building strong foundations for students. With personalized attention and guidance, I help you overcome challenges and achieve your goals. My teaching style is supportive, interactive, and tailored to your learning needs. Let's work together to unlock your potential! I look forward to helping you succeed in Python, Excel, and beyond. Book a session today!
Hitesh graduated from Panjab University


Programming tutor specialities
Paired coding
Project help
Code Review
Job readiness
Debugging
AI modules
Summary
Podcast
Quiz
Learnings
Flashcard
Spotlight
Zero Risk Guaranteed
15-days refund
Free tutor swap
No cancel fee
1-yr validity
24/7 support
Learner for programming class
College students
Elementary School students
High School students
Programming class overview
Hi, I'm Hitesh, a passionate tutor with a BE in Electrical & Electronics from Panjab University. As a certified Python and Microsoft Excel tutor, I specialize in teaching from basics to advanced levels. My approach focuses on practical examples, step-by-step explanations, and hands-on practice. I cover topics like Decorators, OOPs, Lists, Tuples, and Functions in Python, and data analysis, visualization, and formulas in Excel. Let's get started on your learning journey! Certified Python & Excel Tutor. Expertise in building strong foundations for students. With personalized attention and guidance, I help you overcome challenges and achieve your goals. My teaching style is supportive, interactive, and tailored to your learning needs. Let's work together to unlock your potential! I look forward to helping you succeed in Python, Excel, and beyond. Book a session today!
Your programming tutor also teaches
Computer Science
Python
Microsoft Excel

Computer Science concepts taught by Hitesh
The Student and Tutor focused on fundamental Excel skills, including data entry using Flash Fill, sheet organization, and cell content management. They practiced reformatting data with the Transpose feature and performed basic aggregations using both AutoSum and manual formulas like SUM and AVERAGE. The Student was encouraged to practice MAX and MIN formulas as homework.
Flash Fill (Ctrl+E): Automated Data Separation
Worksheet Management: Renaming & Coloring Tabs
Data Cleaning: Clear Options for Cells
Data Transformation: Transpose (Paste Special)
Basic Aggregations: AutoSum Feature
Formula Basics: SUM() and AVERAGE() Functions
Student and Tutor focused on learning the VLOOKUP function in Excel, practicing its application to extract data from a large table. The session covered understanding VLOOKUP's parameters, applying the formula, and critically, how to prevent errors by fixing cell references with dollar signs when dragging formulas. They also briefly touched upon manual table formatting and clearing options in Excel, and decided to start with basic Excel navigation and interface in the next session.
VLOOKUP Formula Fundamentals
Efficient Table Array Selection
Determining the Column Index Number
Preventing Errors with Absolute Cell References ($)
Understanding Exact vs. Approximate Matching
The Student and Tutor worked on advanced Excel functions, specifically practicing the 3D sum consolidation formula across multiple sheets. The Student actively identified and corrected data inconsistencies in their worksheets to ensure the formula's accuracy. They also discussed the appropriate use cases for VLOOKUP and the need for manual data organization. The next session will further explore Excel consolidation with refined data examples.
Manual Data Preparation and AI Tool Limitations
Prerequisite: Data Alignment for 3D Sums
VLOOKUP's Role and Limitations in Data Integration
Excel 3D Sum Consolidation Formula
The tutor and student worked through an Excel assignment, covering functions like INDIRECT, VLOOKUP, SUMIF, and data validation. They practiced creating dynamic charts and pivot tables, and the tutor shared the completed workbook and an additional practice sheet with the student.
VLOOKUP Function
Conditional Formatting
Named Ranges and Data Validation
SUMIF Function
Pivot Tables
The student and tutor discussed an assignment focused on proposing technology enhancements for a university's Human Kinetics department within a $30,000 budget. They planned to collaborate on the Excel spreadsheet component, which requires using specific functions like Named Ranges, Data Validation, and Pivot Tables.
Excel Functions: SUMIF
Excel Functions: VLOOKUP
Excel Features: Named Ranges
Excel Features: Data Validation
Excel Features: Conditional Formatting
Excel Features: PivotTables and PivotCharts
The student and tutor worked on creating specific pie charts for income and expense categories using formulas like SUMIF and generating tables with shortcuts. They also practiced creating column charts from pivot tables and customizing chart elements, which are key skills for data analysis and presentation.
Formatting Data as Tables with Keyboard Shortcuts
Creating Column Charts from Pivot Tables
Creating Pie Charts for Data Visualization
SUMIF Function for Conditional Summation
Efficient Data Handling with Formulas and Cell References
Teaching tools used by tutor
PyCharm
Dynamic programming classes
Open Q&A
Pets are welcomed
Record lessons
Note taking
Weekend lessons
Find programming tutors in similar subjects

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