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
Upskilling
Homework help
Code Review
Exam prep
Job readiness
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
College students
Middle School students
Elementary School students
High School students
Your programming tutor also teaches
Artificial Intelligence
Computer Science
Databases
Computer Science concepts taught by Darshankumar
The tutor and student reviewed data visualization techniques, focusing on creating and customizing pie charts, donut charts, and bar charts in spreadsheet software. They practiced data input, chart generation, and formatting for improved readability, with homework assigned for further practice.
Pie Charts
Data Label Customization
Donut Charts
Bar Charts vs. Column Charts
The class focused on advanced Excel functions for data manipulation and financial calculations. The student practiced using text joining functions such as CONCAT, CONCATENATE, and TEXTJOIN, and learned about financial functions like PMT, IPMT, and PPMT to calculate loan payments and amortization schedules. The session concluded with a practical exercise to build a loan amortization table.
PMT
IPMT
and PPMT Functions for Loan Calculations
MID Function for Text Extraction
IF Function with Textjoin
Text Concatenation Functions
The student and tutor worked on advanced Excel functionalities, including data validation for creating dropdown lists and implementing automated calculations for an invoice system. They then practiced creating various types of charts, such as clustered column charts and line charts, to visualize data effectively and convey insights to clients.
Choosing the Right Chart Type for Data Visualization
Stacked Column Charts for Composition Analysis
Automated Invoice Generation with Linked Data
Data Validation for Dropdown Lists
The Student and Tutor practiced advanced Excel lookup functions, primarily focusing on VLOOKUP with conditional logic and extensively exploring XLOOKUP. They covered XLOOKUP's simplified syntax, built-in error handling, and its unique ability to perform lookups from right-to-left. The next session is planned to cover XMATCH, approximate XMATCH, and wildcards.
XLOOKUP for Approximate Match & Lookup Mode
XLOOKUP for Horizontal Lookup (HLOOKUP Equivalent)
Directional Flexibility (Right-to-Left Lookup)
XLOOKUP's 'if_not_found' Argument
XLOOKUP Basics & Simplicity
VLOOKUP with IF for Dynamic Table Selection
The session focused on practical Excel applications, with the Student learning to create a budget calculator, a meal planner using data validation and named ranges, and a professional invoice template. The Student practiced applying formulas and formatting techniques. Homework was assigned to design a holiday trip planner in Excel, incorporating cost breakdowns and visuals, with a plan to learn invoice automation in the next session.
Essential Excel Formulas & Cell Manipulation
Crafting a Professional Excel Invoice
Dynamic Dropdowns with Named Ranges
Building Your Personal Budget Calculator
The Student and Tutor reviewed various Excel VLOOKUP functionalities, including exact, approximate, and partial text matching, and addressed how VLOOKUP handles duplicate entries. They also explored the INDEX MATCH function for lookups with multiple criteria and discussed proper date formatting using the TEXT function. The session concluded with the Tutor addressing the Student's quiz questions and planning to cover multiple lookup tables in the next class.
VLOOKUP: Exact Match Lookup
VLOOKUP: Approximate Match for Ranges
VLOOKUP: Partial Text Matching with Wildcards
INDEX MATCH: Multiple Criteria Lookups
Custom Date Formatting with the TEXT Function
Teaching tools used by tutor
Google Colab
Postman
Visual Studio Code
Android Studio
Git & GitHub
Coding tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.