UrbanPro
true
Rajan Ghadi Microsoft Excel trainer in Thane

Platinum

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

Details verified of Rajan Ghadi

Identity

Education

Know how UrbanPro verifies Tutor details

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

Overview

I am working in Accounts Finance for more than 15 years where I am most of the time work on Microsoft Excel. I am power user of excel and am Microsoft Certified Office 2016 Specialist with 94% score.
I have strong analytical ability, have judgement to find out shortest route to achieve goals in complex analysis of excel.
With my experience and in depth knowledge of excel, I can give trainees something extra which they would rarely find on Internet as knowledge.
I have many illustrations, in coaching contents. Many trainees have already benefited out of advance excel training. More than 10 years of coaching experience including corporate clients like Datamatics, Tata Consultancy Services, Tata Communications etc.
From Excel Basics to Excel MIS and Dashboards, whatever is requirement, no worries. I not only teach Excel but Logic to derive answers which also benefits trainees in any other DBMS tools as well.
I also offer services at client end without any extra cost, reason being client's comfort with own machines, flexibility of timings and most important, convenience.
So, Excel is for Excel, and I, Mr. Rajan Ghadi, Microsoft Certified Office Specialist is here to give you excellence.

+11 more

Languages Spoken

Marathi Mother Tongue (Native)

English Proficient

Hindi Proficient

Education

Mumbai University 2003

Bachelor of Commerce (B.Com.)

Microsoft Corporation 2018

Microsoft Office 2016 Specialist

Address

Naupada, Thane, India - 400601

Verified Info

ID Verified

Education Verified

Phone Verified

Email Verified

Facebook 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
175 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

15

Teaches following Excel features

Basic Excel, Advanced Excel

Teaching Experience in detail in Microsoft Excel Training classes

I not only teach individual professionals but I take corporate clients too. My corporate clients include Tata Consultancy Services, Tata Communications, Datatamatics Financial Services Ltd., Shriram Rayons etc. My most of the students are from accounts and finance background.

Microsoft Power BI classes
2 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Power BI classes

6

Teaching Experience in detail in Microsoft Power BI classes

Power BI, new Microsoft Business Intelligence tool for detailed insights for your business, work.

Documents (1)

Microsoft Certification of Office...

Reviews (86)

4.9 out of 5 86 reviews

Rajan Ghadi https://p.urbanpro.com/tv-prod/member/photo/4522892-small.png Naupada
4.90586
Rajan Ghadi
N

Microsoft Excel Training Requirement for :Basic Excel

"Excel training was great. I have learnt new formulas which add up in my skill set. Efforts put by Rajan sir is recommendable."

Rajan Ghadi
V

Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel

"I had an amazing experience of learning advanced Excel from Rajan Ghadi's training session. It was very interactive and he gave us examples to solve and helped us whenever we asked for. "

Rajan Ghadi
P

Microsoft Excel Training Requirement for :Basic Excel

"It was interactive and a good learning experience. It had lots of interesting concepts and understanding was easy. "

Rajan Ghadi
K

Microsoft Excel Training Requirement for :Basic Excel

"The best and very intellectually way to teaching is very smooth with sir are very friendly thank you sir. "

Have you attended any class with Rajan?

FAQs

1. What Excel features do you teach?

Basic Excel and Advanced Excel

2. Which classes do you teach?

I teach Microsoft Excel Training and Microsoft Power BI Classes.

3. Do you provide a demo class?

No, I don't provide a demo class.

4. How many years of experience do you have?

I have been teaching for 15 years.

Lessons (1)

AND Function In Excel

Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE. Eg. =AND(A2>1, A2<100) which means answer displays TRUE if A2 is greater than 1 AND less than...

26/02/2018
1 0
0

Answers by Rajan (18)

Answered on 21/02/2019 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training +1 IT Courses/Adobe RoboHelp

If you want true answer read below: Firstly, Excel and VBA directly has no relation. VB (Visual Basic) is a separate programming language like other languages Java, .Net, C++ etc. Visual Basic for Application (VBA) is used as support to all Microsoft Office applications in form of Macros. So, VBA... ...more

If you want true answer read below:

Firstly, Excel and VBA directly has no relation.  VB (Visual Basic) is a separate programming language like other languages Java, .Net, C++ etc.  Visual Basic for Application (VBA) is used as support to all Microsoft Office applications in form of Macros.

So, VBA macro is nothing but that component of Visual Basic which does certain tasks alowng with Microsoft office applications which helps in some automations.  People have misconcept that for automation VBA is required.  It's INCORRECT.

Excel is application full of logic through it's formulae and functions.  So, automation can be done using formulae only even better than VBA.  Just by putting input, you can get output if your solution model is perfect.  There is no need to run any macro.  Further, disadvantage of macro is that one should learn VB first and editing is not simple for person who has not learned VB.  Also modification in existing VBA code is not that simple unless you know thoughtprocess of coder.

So, logic is most important.  If you have it clear, you will creat path to reach solution and excel functions are powerful enough to help you doing that.  VBA or excel functions are not going to help you with logic.

To conclude, make your logic clear first and learn excel functions.  If you are good with those, then only jump for VBA coding.

Answers 7 Comments
Dislike Bookmark

Answered on 08/02/2019 Learn IT Courses/MS Office Software Training +1 IT Courses/MS Office Software Training/Microsoft Excel Training

Using dollar sign means either make column or row or both constant. When we copy formulae vertically down or horizontally right, it freezes reference of particular cell and do now allow that reference to move from it's position. Type of cell references where $ sign is used: 1. Absolute Referece (Dollar... ...more

Using dollar sign means either make column or row or both constant.  When we copy formulae vertically down or horizontally right, it freezes reference of particular cell and do now allow that reference to move from it's position.

Type of cell references where $ sign is used:

1. Absolute Referece (Dollar sign against both row and column reference)

2. Mixed Reference with column constant (Dollar sign against column name only)

3. Mixed Reference with row constant (Dollar sign against row number only)

Answers 9 Comments
Dislike Bookmark

Answered on 25/01/2019 Learn IT Courses/MS Office Software Training +1 IT Courses/MS Office Software Training/Microsoft Excel Training

16384. In empty worksheet, cell A2 type function: =COUNTBLANK(1:1). This will give you answer. COUNTBLANK counts number of cells in a range. Now we have counted blanks from row # 1.
Answers 3 Comments
Dislike Bookmark

Teaches

Microsoft Excel Training classes
175 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

15

Teaches following Excel features

Basic Excel, Advanced Excel

Teaching Experience in detail in Microsoft Excel Training classes

I not only teach individual professionals but I take corporate clients too. My corporate clients include Tata Consultancy Services, Tata Communications, Datatamatics Financial Services Ltd., Shriram Rayons etc. My most of the students are from accounts and finance background.

Microsoft Power BI classes
2 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Microsoft Power BI classes

6

Teaching Experience in detail in Microsoft Power BI classes

Power BI, new Microsoft Business Intelligence tool for detailed insights for your business, work.

4.9 out of 5 86 reviews

Rajan Ghadi
N

Microsoft Excel Training Requirement for :Basic Excel

"Excel training was great. I have learnt new formulas which add up in my skill set. Efforts put by Rajan sir is recommendable."

Rajan Ghadi
V

Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel

"I had an amazing experience of learning advanced Excel from Rajan Ghadi's training session. It was very interactive and he gave us examples to solve and helped us whenever we asked for. "

Rajan Ghadi
P

Microsoft Excel Training Requirement for :Basic Excel

"It was interactive and a good learning experience. It had lots of interesting concepts and understanding was easy. "

Rajan Ghadi
K

Microsoft Excel Training Requirement for :Basic Excel

"The best and very intellectually way to teaching is very smooth with sir are very friendly thank you sir. "

Load More
Have you attended any class with Rajan?

Answers by Rajan Ghadi (18)

Answered on 21/02/2019 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training +1 IT Courses/Adobe RoboHelp

If you want true answer read below: Firstly, Excel and VBA directly has no relation. VB (Visual Basic) is a separate programming language like other languages Java, .Net, C++ etc. Visual Basic for Application (VBA) is used as support to all Microsoft Office applications in form of Macros. So, VBA... ...more

If you want true answer read below:

Firstly, Excel and VBA directly has no relation.  VB (Visual Basic) is a separate programming language like other languages Java, .Net, C++ etc.  Visual Basic for Application (VBA) is used as support to all Microsoft Office applications in form of Macros.

So, VBA macro is nothing but that component of Visual Basic which does certain tasks alowng with Microsoft office applications which helps in some automations.  People have misconcept that for automation VBA is required.  It's INCORRECT.

Excel is application full of logic through it's formulae and functions.  So, automation can be done using formulae only even better than VBA.  Just by putting input, you can get output if your solution model is perfect.  There is no need to run any macro.  Further, disadvantage of macro is that one should learn VB first and editing is not simple for person who has not learned VB.  Also modification in existing VBA code is not that simple unless you know thoughtprocess of coder.

So, logic is most important.  If you have it clear, you will creat path to reach solution and excel functions are powerful enough to help you doing that.  VBA or excel functions are not going to help you with logic.

To conclude, make your logic clear first and learn excel functions.  If you are good with those, then only jump for VBA coding.

Answers 7 Comments
Dislike Bookmark

Answered on 08/02/2019 Learn IT Courses/MS Office Software Training +1 IT Courses/MS Office Software Training/Microsoft Excel Training

Using dollar sign means either make column or row or both constant. When we copy formulae vertically down or horizontally right, it freezes reference of particular cell and do now allow that reference to move from it's position. Type of cell references where $ sign is used: 1. Absolute Referece (Dollar... ...more

Using dollar sign means either make column or row or both constant.  When we copy formulae vertically down or horizontally right, it freezes reference of particular cell and do now allow that reference to move from it's position.

Type of cell references where $ sign is used:

1. Absolute Referece (Dollar sign against both row and column reference)

2. Mixed Reference with column constant (Dollar sign against column name only)

3. Mixed Reference with row constant (Dollar sign against row number only)

Answers 9 Comments
Dislike Bookmark

Answered on 25/01/2019 Learn IT Courses/MS Office Software Training +1 IT Courses/MS Office Software Training/Microsoft Excel Training

16384. In empty worksheet, cell A2 type function: =COUNTBLANK(1:1). This will give you answer. COUNTBLANK counts number of cells in a range. Now we have counted blanks from row # 1.
Answers 3 Comments
Dislike Bookmark

Contact

Load More

Lessons (1)

AND Function In Excel

Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE. Eg. =AND(A2>1, A2<100) which means answer displays TRUE if A2 is greater than 1 AND less than...

26/02/2018
1 0
0

Rajan Ghadi describes himself as Microsoft Certified Office Specialist & Power BI Tutor. He conducts classes in Microsoft Excel Training and Microsoft Power BI. Rajan is located in Naupada, Thane. Rajan takes at students Home, Regular Classes- at his Home and Online Classes- via online medium. He has 15 years of teaching experience . Rajan has completed Bachelor of Commerce (B.Com.) from Mumbai University in 2003. HeĀ is well versed in English, Hindi and Marathi. Rajan has got 86 reviews till now with 100% positive feedback.

X
X

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Rajan

Let Rajan know you are interested in their class

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.

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