UrbanPro
true
Shreyas Naik Microsoft Excel trainer in Bangalore

Shreyas Naik

(10)
(10)
locationImg Marathahalli, Bangalore
10 yrs of Exp
students 13 students
10 hrs of classes completed
rsIcon 250 per hour
Book a Free Demo
Book a Free Demo

Details verified of Shreyas Naik

Identity

Education

Know how UrbanPro verifies Tutor details

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

Software Engineer with 10+ years of experience in IT industry

Online Classes
I am a Software Engineer by profession and have a passion for teaching. I would like to pass on my skills which I have developed over 10+ years working in the IT industry.

The key skills I teach are Microsoft Excel (Basic to Advanced) and SQL (Oracle).
Sriraksha

I took an MS Excel course from Shreyas Naik. The teaching was very good and understandable. It helped me to gain more insight into MS Excel, so I highly recommend it to everyone. He is the best tutor.

Languages Spoken

Kannada Mother Tongue (Native)

Hindi Proficient

English Proficient

Address

Marathahalli, Bangalore, India - 560037

Verified Info

ID Verified

Education 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
3 Students

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

10

Teaches following Excel features

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

SQL Programming Training

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in SQL Programming Training

5

Reviews

4.5 out of 5 10 reviews

Shreyas Naik https://p.urbanpro.com/tv-prod/auth/photo/8805405-small.jpg Marathahalli
4.50510
Shreyas Naik
S
Verified Student

Microsoft Excel Training - Beginner and Advanced Level

"I took an MS Excel course from Shreyas Naik. The teaching was very good and understandable. It helped me to gain more insight into MS Excel, so I highly recommend it to everyone. He is the best tutor. "

Shreyas Naik
A
Verified Student

Microsoft Excel Training - Beginner and Advanced Level

"Thank you very much for a great training session. Learned a lot from this training program. It was enjoyable. "

Shreyas Naik
S
Verified Student

Microsoft Excel Training - Beginner and Advanced Level

"I recently took an MS Excel course from tutor Shreyas Naik. It was a well-structured and detailed course. His practical approach helped me to apply the concepts efficiently. I highly recommend this course to anyone looking to master Excel. "

Shreyas Naik
R
Verified Student

Microsoft Excel Training - Beginner and Advanced Level

"Very informative course, I learnt a lot from Shreyas, and he was very patience in explaining the things. "

Have you attended any class with Shreyas?

Answers by Shreyas

Answered on 27/01/2024 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/HLOOKUP in Excel

Ask a Question

Post a Lesson

Yes- IF function can be used with both VLOOKUP and HLOOKUP. An example for VLOOKUP with IF: =IF(VLOOKUP(D1,$F$2:$G$10,2,FALSE)=0,"No","Yes") The above statement compares Vlookup's result with zero, and returns "No" if it is equal to 0, "Yes" otherwise.
Answers 2 Comments
Dislike Bookmark

Answered on 23/12/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/PowerPivot in Excel

Ask a Question

Post a Lesson

Power pivot can handle more data than the excel worksheets that is more than millions of rows of data. But the exact number of records also depends on your system configuration. If the memory on your system is not sufficient, it will limit the number of records that can be processed.
Answers 1 Comments
Dislike Bookmark

Answered on 23/12/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/PowerPivot in Excel

Ask a Question

Post a Lesson

Steps to create a Power Pivot table:1. Open Excel and navigate to 'Insert' tab.2. Click on 'PivotTable' and select 'PivotTable and PivotChart'.3. Choose the data source for the pivot table.4. Drag and drop fields into the pivot table.5. Add filters and fields to the pivot table. ...more

Steps to create a Power Pivot table:
1. Open Excel and navigate to 'Insert' tab.
2. Click on 'PivotTable' and select 'PivotTable and PivotChart'.
3. Choose the data source for the pivot table.
4. Drag and drop fields into the pivot table.
5. Add filters and fields to the pivot table.

Answers 1 Comments
Dislike Bookmark

Answered on 12/12/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

Ask a Question

Post a Lesson

Some of the formulas like VLOOKUP, HLOOKUP are very useful but often underutilized. VLOOKUP is used to lookup values in a table vertically whereas HLOOKUP searches for values horizontally.
Answers 4 Comments
Dislike Bookmark

Answered on 12/12/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

Ask a Question

Post a Lesson

In order to use Excel efficiently, we need to memorize some of the commonly used shortcuts. Apart from that, try using the keyboard a bit more rather than the mouse. Some of the common shortcuts I use: Ctrl + A=> This selects all contents of the worksheet Ctrl + B=> Highlights the selected cell... ...more
In order to use Excel efficiently, we need to memorize some of the commonly used shortcuts. Apart from that, try using the keyboard a bit more rather than the mouse. Some of the common shortcuts I use: Ctrl + A=> This selects all contents of the worksheet Ctrl + B=> Highlights the selected cell in bold Ctrl + C=> Copy contents Ctrl + D=> Fill contents from the above cell to current selected cell Ctrl + F=> Find contents in the worksheet Ctrl + H=> Find and replace contents in the worksheet Ctrl + I=> Italicize selected cell Ctrl + N=> Open a new workbook Ctrl + S=> Save the current workbook Ctrl + U=> Underline current selection Ctrl + V=> Paste contents Ctrl + X=> Cut selected contents Ctrl + Z=> Undo last action.
Answers 2 Comments
Dislike Bookmark
x

Ask a Question

Please enter your Question

Please select a Tag

Teaches

Microsoft Excel Training classes
3 Students

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

10

Teaches following Excel features

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

SQL Programming Training

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in SQL Programming Training

5

Answers by Shreyas Naik

Answered on 27/01/2024 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/HLOOKUP in Excel

Ask a Question

Post a Lesson

Yes- IF function can be used with both VLOOKUP and HLOOKUP. An example for VLOOKUP with IF: =IF(VLOOKUP(D1,$F$2:$G$10,2,FALSE)=0,"No","Yes") The above statement compares Vlookup's result with zero, and returns "No" if it is equal to 0, "Yes" otherwise.
Answers 2 Comments
Dislike Bookmark

Answered on 23/12/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/PowerPivot in Excel

Ask a Question

Post a Lesson

Power pivot can handle more data than the excel worksheets that is more than millions of rows of data. But the exact number of records also depends on your system configuration. If the memory on your system is not sufficient, it will limit the number of records that can be processed.
Answers 1 Comments
Dislike Bookmark

Answered on 23/12/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/PowerPivot in Excel

Ask a Question

Post a Lesson

Steps to create a Power Pivot table:1. Open Excel and navigate to 'Insert' tab.2. Click on 'PivotTable' and select 'PivotTable and PivotChart'.3. Choose the data source for the pivot table.4. Drag and drop fields into the pivot table.5. Add filters and fields to the pivot table. ...more

Steps to create a Power Pivot table:
1. Open Excel and navigate to 'Insert' tab.
2. Click on 'PivotTable' and select 'PivotTable and PivotChart'.
3. Choose the data source for the pivot table.
4. Drag and drop fields into the pivot table.
5. Add filters and fields to the pivot table.

Answers 1 Comments
Dislike Bookmark

Answered on 12/12/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

Ask a Question

Post a Lesson

Some of the formulas like VLOOKUP, HLOOKUP are very useful but often underutilized. VLOOKUP is used to lookup values in a table vertically whereas HLOOKUP searches for values horizontally.
Answers 4 Comments
Dislike Bookmark

Answered on 12/12/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training

Ask a Question

Post a Lesson

In order to use Excel efficiently, we need to memorize some of the commonly used shortcuts. Apart from that, try using the keyboard a bit more rather than the mouse. Some of the common shortcuts I use: Ctrl + A=> This selects all contents of the worksheet Ctrl + B=> Highlights the selected cell... ...more
In order to use Excel efficiently, we need to memorize some of the commonly used shortcuts. Apart from that, try using the keyboard a bit more rather than the mouse. Some of the common shortcuts I use: Ctrl + A=> This selects all contents of the worksheet Ctrl + B=> Highlights the selected cell in bold Ctrl + C=> Copy contents Ctrl + D=> Fill contents from the above cell to current selected cell Ctrl + F=> Find contents in the worksheet Ctrl + H=> Find and replace contents in the worksheet Ctrl + I=> Italicize selected cell Ctrl + N=> Open a new workbook Ctrl + S=> Save the current workbook Ctrl + U=> Underline current selection Ctrl + V=> Paste contents Ctrl + X=> Cut selected contents Ctrl + Z=> Undo last action.
Answers 2 Comments
Dislike Bookmark
x

Ask a Question

Please enter your Question

Please select a Tag

Book a Demo

Load More
  • Want to learn from Shreyas?

  • Book a Demo
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