Darshankumar Chauhan
Expert in AI, networking, cybersecurity, and database systems, with over 15 years of experience in the education sector.
Loading...
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
Upskilling
Code Review
Job readiness
Assignment help
Homework help
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
Middle School students
Elementary School students
College students
High School students
Your programming tutor also teaches
Artificial Intelligence
Computer Science
Databases
Computer Science concepts taught by Darshankumar
The Student and Tutor reviewed various Excel statistical and lookup functions, including `MODE`, `INDEX`, `MATCH`, `MEDIAN`, `AVERAGE`, `STDEV`, `MIN`, `MAX`, `LARGE`, `SMALL`, `SUM`, `COUNT`, and `AVERAGEA`. The Student practiced applying these formulas to different datasets. The next session is planned to cover `VLOOKUP` and `XLOOKUP` functions.
Excel Mode Functions: MODE
MODE.SNGL
MODE.MULT
Excel MATCH & INDEX Functions for Advanced Lookups
Excel MEDIAN Function: Locating the Middle Value
Excel Standard Deviation: STDEV.S (Data Dispersion)
Excel LARGE & SMALL Functions (Finding K-th Values)
Excel AVERAGE vs. AVERAGEA Functions (Handling Data Types)
The session focused on teaching the Student various statistical functions in Excel, including AVERAGE, MEDIAN, MODE, STDEV, MIN, MAX, LARGE, SMALL, and AVERAGEIF. The Tutor explained each function's purpose, demonstrated its application with examples, and clarified how Excel processes data for each calculation. They also briefly discussed the upcoming class schedule.
Leveraging Excel's AI for Data Input: Data from Image
Understanding Standard Deviation (STDEV)
Analyzing Data Extremes: MIN
MAX
LARGE
SMALL
Conditional Averaging: AVERAGEIF
Core Statistical Functions: AVERAGE
The tutor and student practiced advanced VLOOKUP functions in Excel, covering exact and approximate matches, handling multiple criteria, and using wildcards for partial text searches. They also began exploring two-way lookups using the MATCH function within VLOOKUP, with plans to continue this topic in the next session.
VLOOKUP Exact Match
VLOOKUP Approximate Match
Handling Duplicates in VLOOKUP
VLOOKUP with Wildcards
Two-Way Lookup (VLOOKUP with MATCH)
The Tutor and Student reviewed several Excel functionalities, including shortcuts for deleting rows and cells, converting formulas to values, and advanced copy-paste methods. They practiced line break formatting and extensively explored the VLOOKUP function for data retrieval, with the Student completing VLOOKUP exercises and receiving additional homework.
Keyboard Shortcuts for Deletion
Converting Formulas to Values
Copying and Pasting Values Only
VLOOKUP Function
Line Break Insertion (Alt + Enter)
The tutor provided an in-depth lesson on Excel keyboard shortcuts, covering basic operations, navigation, selection, formatting, and function keys. The student practiced various shortcuts to improve efficiency in Excel. The session concluded with a discussion on scheduling future classes.
Inserting Rows and Columns with Shortcuts
Function Key Shortcuts (F1-F12)
Excel Formula and Formatting Shortcuts
Excel Selection Techniques
Basic Excel Navigation and Selection Shortcuts
Workbook Management Shortcuts
The class provided an in-depth tutorial on using various date and time functions in Excel, including YEAR, MONTH, DAY, DATE, NOW, TODAY, and DATEDIF. The student practiced extracting date components, performing date arithmetic, and calculating differences between dates, while also learning how to create static date/time entries. The tutor emphasized practical application through hands-on exercises and problem-solving.
Extracting Date Components
Working with Time Components
DATEDIF Function for Date Differences
Date and Time Manipulation with Formulas
Current Date and Time Functions
Teaching tools used by tutor
NetBeans
Git & GitHub
Visual Studio Code
Bitbucket
Postman
Coding tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.