Darshankumar Chauhan
Expert in AI, networking, cybersecurity, and database systems, with over 15 years of experience in the education sector.
Show all photos
Darshankumar Chauhan
Masters degree
/ 55 min
Darshankumar - Know your tutor
Here is an expanded version of your profile to approximately 1100 words, keeping it professional, engaging, and suitable for tutoring platforms: With over 15 years of experience in the field of computing and a Master’s degree in Computer Science, I am Darshankumar Chauhan, a dedicated and passionate tutor committed to helping learners succeed in an ever-evolving digital world. My career has been shaped by a strong foundation in both academic knowledge and real-world application, allowing me to deliver lessons that are not only theoretically sound but also highly practical and relevant. Throughout my professional journey, I have worked extensively with students across a wide range of educational levels, including Elementary, Middle School, High School, and College learners. This diverse experience has enabled me to understand the unique learning needs of different age groups and tailor my teaching approach accordingly. Whether you are just beginning your journey in computing or looking to deepen your expertise in advanced topics, I adapt my methods to suit your pace, goals, and preferred learning style. My areas of expertise include Computer Science fundamentals, Artificial Intelligence, and Database Systems. Within these domains, I offer comprehensive support in topics such as programming, algorithms, data structures, machine learning concepts, database design, SQL, and system optimization. I also specialize in code optimization techniques, helping students not only write functional code but improve efficiency, readability, and performance—skills that are essential in both academic assessments and professional environments.
Darshankumar graduated from JNU
Programming tutor specialities
Job readiness
Homework help
Code Review
Upskilling
Exam prep
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
High School students
Elementary School students
Middle School students
College students
Your programming tutor also teaches
Artificial Intelligence
Computer Science
Databases
Computer Science concepts taught by Darshankumar
The Student and Tutor engaged in an intensive session on advanced Excel functions, including INDIRECT, INDEX and MATCH for multi-criteria lookups, and XMATCH for enhanced matching capabilities. The Student actively practiced applying these functions to various data sets. They also briefly discussed the Student's upcoming test and the plan for the Student to bring their own practice materials to the next session for further hands-on application.
The INDIRECT Function: Dynamic Cell Referencing
The XMATCH Function: Enhanced Item Position Finding
Two-Column Lookups with INDEX & MATCH: Multi-Criteria Data Retrieval
Student and Tutor focused on mastering the INDIRECT function in Excel, exploring its applications for cell, range, name, and worksheet references. The Student practiced applying these concepts through several hands-on exercises within a live spreadsheet and a provided workbook. They discussed continuing with 'two column lookup' in their next session.
INDIRECT Function Overview
INDIRECT with Cell References
INDIRECT with Range References
INDIRECT with Named References
INDIRECT with Worksheet References
The Student and Tutor practiced advanced Excel lookup and data analysis functions. They learned how to perform "left lookups" using `INDEX` and `MATCH`, and then simplified this process using `XLOOKUP`. The session also covered methods to locate maximum values and their cell addresses using `MAX`, `MATCH`, and `ADDRESS` functions, with the Student completing practical exercises.
Left Lookup with INDEX and MATCH
XLOOKUP for Versatile Lookups
Locating Maximum Values in a Range
The Student and Tutor continued their work on advanced Excel data manipulation. The session reviewed two-way lookups using `INDEX` and `MATCH`, and then focused extensively on the `OFFSET` function, covering its basic application, moving through rows and columns, and utilizing negative offsets for upward and leftward navigation. The Student practiced these concepts through multiple exercises, and an Excel file with 13 `OFFSET` practicals was assigned as homework, with the next session planned to cover case-sensitive and left lookup functions.
Two-Way Lookup Review (INDEX & MATCH)
Introduction to the OFFSET Function
Navigating Data with OFFSET (Positive Rows & Columns)
Negative Offset: Moving Up and Left
Dynamic Range Summation with SUM and OFFSET
The Student and Tutor focused on mastering advanced Excel lookup functions, specifically INDEX and MATCH. They practiced combining these functions for single-criterion lookups and then progressed to two-way lookups, retrieving data based on multiple criteria. The Student completed several practical exercises and was assigned homework for continued practice, with the next session planned to cover Left Lookup and Two-Column Lookup.
MATCH Function: Finding Position
Nesting MAX with INDEX & MATCH
INDEX & MATCH (2-Way Lookup)
INDEX & MATCH (1-Way Lookup)
INDEX Function: Retrieving Value by Position
The Student and Tutor practiced advanced Excel lookup functions, specifically VLOOKUP and XLOOKUP, focusing on retrieving data from multiple sheets. The session involved several practical exercises, including extracting patient information, calculating student fees based on their major, and assigning grades based on test scores. The Tutor also clarified when to use VLOOKUP with an approximate match for range-based data. Future sessions will continue with XLOOKUP practice.
VLOOKUP Essentials: Syntax and Cross-Sheet Lookups
XLOOKUP Introduction: Flexible Data Retrieval
Absolute & Relative Cell References
VLOOKUP for Range Lookups (Approximate Match)
Comparing VLOOKUP and XLOOKUP
Teaching tools used by tutor
Android Studio
Visual Studio Code
Google Colab
Postman
NetBeans
Coding tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.