Hitesh Arora

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

4.7(151)

FREE TRIAL

Profile photo of Hitesh, Computer Science tutor at Wiingy
Profile photo of Hitesh, Computer Science tutor at Wiingy
Profile photo of Hitesh, Computer Science tutor at Wiingy
Verified degree or teaching certification of Hitesh

Show all photos

tutor-image
tutor-image

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

Hitesh graduated from Panjab University
Hitesh graduated from Panjab University

Programming tutor specialities

Paired coding icon

Paired coding

Project help icon

Project help

Code Review icon

Code Review

Job readiness icon

Job readiness

Debugging icon

Debugging

CoTutorCoTutor

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 icon

College students

Elementary School students icon

Elementary School students

High School students icon

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

Computer Science

Python

Python

Microsoft Excel

Microsoft Excel

Icons

Computer Science concepts taught by Hitesh

Student learned 8 days ago

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

Show more

Student learned 16 days ago

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

Show more

Student learned 5 months ago

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

Show more

Student learned 7 months ago

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

Show more

Student learned 7 months ago

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

Show more

Student learned 7 months ago

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

Show more

Teaching tools used by tutor

PyCharm image

PyCharm

Dynamic programming classes

Open Q&A icon

Open Q&A

Pets are welcomed icon

Pets are welcomed

Record lessons icon

Record lessons

Note taking icon

Note taking

Weekend lessons icon

Weekend lessons

tutorFooter

Coding tutors on Wiingy are vetted for quality

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