Engaging Python and excel programming lessons

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.

Hitesh taught Jennifer Jones-Cox how to use the VLOOKUP function in Excel to efficiently retrieve data from a table. Jennifer practiced applying the formula and learned how to name a table range to prevent errors when dragging the formula. Hitesh assigned practice exercises and will send notes on pivot tables, with the next class scheduled for Wednesday, July 30th, to cover more advanced techniques for fixing the range in VLOOKUP.

Hitesh explained Active Directory (AD) as a Microsoft tool for managing users and computers within a Windows domain, focusing on its role in controlling access and simplifying IT administration. The discussion covered user account management, password resets, and the concept of domains and organizational units. There was also a brief mention of Python, though it was not the main focus.

Hitesh taught Aarnav about Python f-strings, demonstrating their use in formatting strings and simplifying code compared to traditional string concatenation. The lesson included practice exercises and examples using loops and the `range` function. Hitesh provided code notes and scheduled a follow-up session due to Aarnav's time constraints.