Hitesh Arora
Experienced Certified Python and Microsoft Excel Tutor. Book a demo session with me.
Loading...
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
Code Review
Upskilling
Paired coding
Assignment help
Job readiness
CoTutorAI 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
Computer Science for Adults
Computer Science for Kids
Computer Science for College students
Computer Science for Beginners
Computer Science for 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 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.
SUMIF Function for Conditional Summation
Creating Pie Charts for Data Visualization
Efficient Data Handling with Formulas and Cell References
Formatting Data as Tables with Keyboard Shortcuts
Creating Column Charts from Pivot Tables
The Tutor and Student worked extensively on an Excel assignment involving dynamic data entry and summarization. They practiced using functions like IF, FILTER, INDIRECT, and VLOOKUP, and explored Pivot Tables for data analysis and chart creation. The next session will focus on refining the assignment's presentation, particularly the creation of specific pie charts.
Excel Charts from Pivot Tables
Excel Pivot Tables
Excel VLOOKUP Function
Excel IF Function
Excel Data Validation
The Tutor and Student worked on understanding Excel functionalities, specifically VLOOKUP and data validation with the INDIRECT function, in the context of the Student's business budget assignment. The Tutor demonstrated VLOOKUP for data extraction and error handling, and addressed issues with dynamic data lists, planning to continue working on the assignment and related concepts in future sessions.
Personal Business Budgeting in Excel
Pivot Tables and Charts
Data Validation & Indirect Function
VLOOKUP Function
The session covered the application of the IF formula in Excel, focusing on comparing values and using conditional formatting for data visualization. The student practiced applying the IF formula using different methods, including cell referencing and conditional formatting. The Tutor explained the importance of absolute cell referencing and the applications of conditional formatting in real-world scenarios.
Dynamic Thresholds
Fixing Cell References Using Dollar Signs ($)
Conditional Formatting for Data Visualization
IF Formula Basics
Column-Specific Application
Teaching tools used by tutor
PyCharm
Dynamic programming classes
Mobile joining
Note taking
Chat for quick help
Record lessons
Open Q&A
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.