Hitesh Arora
Experienced tutor helping for grade improvement
Loading...



ESL classes - Hitesh Arora
Bachelors degree
/ 30 min
Hitesh graduated from Panjab University


English tutor specialities
Listening skill
Visual learning

ESL concept taught by Hitesh
The session focused on practicing Excel skills, especially VLOOKUP, number formatting, and pivot tables, in preparation for a job interview. The Student practiced applying these skills to organize and analyze sample datasets. The Tutor recommended further practice and offered a mock interview to simulate the Excel demonstration portion of the job interview.
VLOOKUP Function
Number Formatting
Autofill Series
Pivot Tables
Table Creation
The Student and Tutor discussed using ChatGPT to generate Excel practice datasets, particularly for administrative tasks. They reviewed the VLOOKUP function and different methods for ensuring accurate formula application, including fixing ranges and naming tables. The Student was assigned the task of creating an Excel sheet using ChatGPT to share with the Tutor a week before their next session.
Understanding Absolute vs. Relative References
Using Chat GPT for Excel Assistance
Naming Ranges
Fixing Ranges with Dollar Signs ($)
VLOOKUP Function
Hitesh tutored Enio on using VLOOKUP to combine data from two sheets and introduced the IF formula for flagging data based on conditions. Enio practiced applying the IF formula to categorize employees by salary and learned to use conditional formatting to highlight the results. The next session is scheduled to cover applying multiple conditions with the IF formula.
Conditional Formatting
Absolute References (Dollar Signs)
IF Formula
VLOOKUP Function
Hitesh taught Jennifer about the IF formula in Excel, demonstrating how to use logical tests and conditional formatting to categorize and highlight data. Jennifer actively practiced applying the IF formula to flag employees based on their salary and sales performance. Hitesh assigned her to continue practicing the IF formula and conditional formatting on her own, and they scheduled their next lesson to review basic table creation and summation.
IF Formula (Basic)
Conditional Formatting
Absolute vs. Relative References
SUM Formula
Hitesh and Enio reviewed the VLOOKUP function in Excel, including its application across multiple sheets and common errors. Enio practiced applying the VLOOKUP formula in a provided Excel workbook, focusing on fixing the range and avoiding errors caused by extra spaces. Enio was encouraged to practice the concepts learned to reinforce understanding.
Column Index Number
VLOOKUP Troubleshooting
Exact Match (False/0)
VLOOKUP Across Sheets
Absolute References ($)
VLOOKUP Function
Hitesh tutored Enio on the fundamentals of the VLOOKUP function in Excel, including its syntax, parameters, and common errors. Enio practiced applying the VLOOKUP formula to a dataset of employee information to retrieve salaries. They scheduled a follow-up session for the next week and agreed to communicate via the Wingy app, with Hitesh requesting feedback through the app's survey feature.
VLOOKUP Basics
VLOOKUP Parameters
Fixing Ranges in VLOOKUP
Avoiding Errors in VLOOKUP
Combining Sheets with VLOOKUP
English tutor also teaches
English Speaking
Conversational English
Hobby English
Practical tools used in english classes
Subtitled media
Interactive quizzes
Speech recognition
Student types for english classes
ESL for Adults
Home schooled
ESL for Intermediate
ESL for Kids
ESL for Beginners
Dynamic english lessons
Mobile joining
Note taking
Open Q&A
Chat for quick help
Weekend lessons

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