Engaging Python and excel programming lessons

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.

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.

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.

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.

Hitesh tutored Kelly on using VLOOKUP in Excel, covering basic syntax, locking cell references with dollar signs, troubleshooting errors, and applying VLOOKUP across multiple sheets. Kelly practiced applying the formulas and identifying potential errors. Hitesh assigned practice exercises and requested Kelly to share a specific Excel sheet with a description of the problem for review in the next session, where they will also discuss combining data from three sheets.

Hitesh and Lea had a class on July 26, 2025, covering Excel functions and problem-solving. Hitesh helped Lea understand VLOOKUP and HLOOKUP, emphasizing when to use each based on data orientation. He also introduced her to ChatGPT, demonstrating its use for Excel tutorials, data generation, and even solving real-world problems like organizing her Gmail inbox using labels and filters. The session was rescheduled and included a discussion about Coursera vs. Udemy and Lea's accident.