UrbanPro
true
Gaurav S. Microsoft Excel trainer in Delhi

Platinum

Gaurav S.

Apps script, Google sheet & Advance Excel & VBA SQL Training Experience 5 years

Deoli Khanpur, Delhi, India - 110062.

10 Students

Contact
Referral Discount: Get ₹ 250 off when you make a payment to start classes. Get started by Booking a Demo.

Details verified of Gaurav S.

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Overview

As a highly skilled Advanced Excel Tutor with over 5 years of experience, I specialize in helping individuals and corporate teams enhance their proficiency with Excel's advanced features. My expertise includes complex formulas, pivot tables, data analysis, automation through VBA, Python , google scripting and dashboard creation. I have successfully taught students ranging from beginners to advanced Excel professionals, focusing on creating customized lesson plans that meet specific learning needs. With a strong passion for data-driven decision-making and a commitment to fostering problem-solving skills, I strive to make Excel both accessible and powerful for all my learners."


Advanced Formulas: INDEX, MATCH, VLOOKUP, XLOOKUP, SUMPRODUCT, ARRAY formulas
Data Analysis & Modeling: Pivot Tables, Power Query, Power Pivot
Data Visualization: Dashboards, Charts, Conditional Formatting
Automation: VBA, Macros
Data Cleaning & Transformation
Financial Modeling & Forecasting
Troubleshooting Complex Formulas
Data Validation and Error Checking
Excel Add-ins & Tools (Solver, Analysis Tool Pak)
Training and Workshop Facilitation

Languages Spoken

Hindi Proficient

English Proficient

Education

CSJM kanpur 2015

Bachelor of Computer Science (B.Sc. (Computer Science))

Address

Deoli Khanpur, Delhi, India - 110062

Verified Info

ID Verified

Phone Verified

Email Verified

Report this Profile

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Teaches

Microsoft Excel Training classes
5 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

4

Teaches following Excel features

Advanced Excel, Excel VBA Training, Excel Macro Training, Basic Excel

Teaching Experience in detail in Microsoft Excel Training classes

Basic excel to advance Excel training like Vlookup Hook-up pivot table chart dashboard MIS Data validation conditional formatting etc...

Computer Classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Computer Classes

6

Type of Computer course taken

Software Programming, Training in Software application usage, Basics of Computer usage, Training in Computer tools usage

Teaching Experience in detail in Computer Classes

Basic excel,ms words,PPT ETC...

Script Writing classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Script Writing classes

4

Teaching Experience in detail in Script Writing classes

Google sheets Google scripting google Data studio Email reminder WhatsApp Automation Daily follow-up automation etc...

Website Scripting Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Website Scripting Training

3

Teaching Experience in detail in Website Scripting Training

HTML,JAVA.CSS

SQL Programming Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SQL Programming Training

6

Teaching Experience in detail in SQL Programming Training

Primary Keys and Foreign Keys: Enforcing data integrity between tables Creating Tables: CREATE TABLE and table constraints ALTER TABLE: Modifying table structures Relationships: One-to-many, many-to-one, and many-to-many relationships 10. Indexing and Performance (2 hours) What are Indexes? Types of Indexes: Unique, Composite, and Full-Text indexes Creating and Dropping Indexes Query Optimization: Using indexes to speed up query performance Day 6: Advanced Topics and SQL Best Practices (4 hours) 11. Working with Views and Stored Procedures (2 hours) What are Views? Creating and querying views Benefits and use cases for views Stored Procedures: What are stored procedures? Creating and executing stored procedures Passing parameters to stored procedures 12. SQL Best Practices (2 hours) SQL Formatting and Readability Writing clean and readable queries Commenting queries Error Handling: Using TRY...CATCH blocks (in SQL Server, for example) Security: Avoiding SQL Injection Using parameterized queries for security

Reviews (2)

5 out of 5 2 reviews

Gaurav Singh https://p.urbanpro.com/tv-prod/member/photo/8389874-small.jpeg Deoli Khanpur
5.0052
Gaurav Singh
M

Advance Excel Requirement for :Advanced Excel

"Very Good trainer. He teaches a lot of formulas and explain all the things easy way. So I have learnt basic excel to advance excel from Gaurav sir. "

Reply by Gaurav

Thank You so much

Gaurav Singh
M

Advance Excel Requirement for :Advanced Excel,Basic Excel,Excel Macro Training

"Training was fantastic. He teaches step by steps formula and explain all the things easy way. So I learnt proper basic excel to advance excel from Gaurav sir. Really I was so much confused but after the join the class everything was good. "

Reply by Gaurav

Thank you so much.

Have you attended any class with Gaurav?

FAQs

1. What Excel features do you teach?

Advanced Excel, Excel VBA Training, Excel Macro Training and others

2. Which classes do you teach?

I teach Computer, Microsoft Excel Training, SQL Programming, Script Writing and Website Scripting Classes.

3. Do you provide a demo class?

Yes, I provide a free demo class.

4. How many years of experience do you have?

I have been teaching for 4 years.

Answers by Gaurav (2)

Answered on 20/11/2020 Learn IT Courses

Advance Exce+Google Scripting
Answers 301 Comments
Dislike Bookmark

Teaches

Microsoft Excel Training classes
5 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

4

Teaches following Excel features

Advanced Excel, Excel VBA Training, Excel Macro Training, Basic Excel

Teaching Experience in detail in Microsoft Excel Training classes

Basic excel to advance Excel training like Vlookup Hook-up pivot table chart dashboard MIS Data validation conditional formatting etc...

Computer Classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Computer Classes

6

Type of Computer course taken

Software Programming, Training in Software application usage, Basics of Computer usage, Training in Computer tools usage

Teaching Experience in detail in Computer Classes

Basic excel,ms words,PPT ETC...

Script Writing classes

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Script Writing classes

4

Teaching Experience in detail in Script Writing classes

Google sheets Google scripting google Data studio Email reminder WhatsApp Automation Daily follow-up automation etc...

Website Scripting Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Website Scripting Training

3

Teaching Experience in detail in Website Scripting Training

HTML,JAVA.CSS

SQL Programming Training

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in SQL Programming Training

6

Teaching Experience in detail in SQL Programming Training

Primary Keys and Foreign Keys: Enforcing data integrity between tables Creating Tables: CREATE TABLE and table constraints ALTER TABLE: Modifying table structures Relationships: One-to-many, many-to-one, and many-to-many relationships 10. Indexing and Performance (2 hours) What are Indexes? Types of Indexes: Unique, Composite, and Full-Text indexes Creating and Dropping Indexes Query Optimization: Using indexes to speed up query performance Day 6: Advanced Topics and SQL Best Practices (4 hours) 11. Working with Views and Stored Procedures (2 hours) What are Views? Creating and querying views Benefits and use cases for views Stored Procedures: What are stored procedures? Creating and executing stored procedures Passing parameters to stored procedures 12. SQL Best Practices (2 hours) SQL Formatting and Readability Writing clean and readable queries Commenting queries Error Handling: Using TRY...CATCH blocks (in SQL Server, for example) Security: Avoiding SQL Injection Using parameterized queries for security

5 out of 5 2 reviews

Gaurav Singh
M

Advance Excel Requirement for :Advanced Excel

"Very Good trainer. He teaches a lot of formulas and explain all the things easy way. So I have learnt basic excel to advance excel from Gaurav sir. "

Reply by Gaurav

Thank You so much

Gaurav Singh
M

Advance Excel Requirement for :Advanced Excel,Basic Excel,Excel Macro Training

"Training was fantastic. He teaches step by steps formula and explain all the things easy way. So I learnt proper basic excel to advance excel from Gaurav sir. Really I was so much confused but after the join the class everything was good. "

Reply by Gaurav

Thank you so much.

Have you attended any class with Gaurav?

Answers by Gaurav S. (2)

Answered on 20/11/2020 Learn IT Courses

Advance Exce+Google Scripting
Answers 301 Comments
Dislike Bookmark

Gaurav S. describes himself as Apps script, Google sheet & Advance Excel & VBA SQL Training Experience 5 years. He conducts classes in Computer, Microsoft Excel Training and SQL Programming. Gaurav is located in Deoli Khanpur, Delhi. Gaurav takes Regular Classes- at his Home and Online Classes- via online medium. He has 6 years of teaching experience . Gaurav has completed Bachelor of Computer Science (B.Sc. (Computer Science)) from CSJM kanpur in 2015. HeĀ is well versed in Hindi and English. Gaurav has got 2 reviews till now with 100% positive feedback.

X

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more