true
true

Rajan Ghadi

Naupada, Thane, India - 400601

Rajan Ghadi photo

Platinum

Rajan Ghadi

Microsoft Certified Office 2016 Specialist Tutor

Naupada, Thane, India - 400601.

64 Students taught

5.0

UrbanPro Rating

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.

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

Demo Class

No

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

Microsoft Excel Training classes Overview

Microsoft Excel Training classes

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

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.

Courses in Microsoft Excel Training classes

Gallery (18)

Microsoft Certification of Office...

Dashboards

Dashboards with Excel Referenc...

Functions that are required for...

Interactive Charts

MIS Chart, Equation chart

2 Axis Charts, Data Analysis

Lookup Functions and uses through...

Dynamic Graphs

Select Charts to Display with Indirect...

Convert Chats, Dynamic Conditional...

Exceptional Handling Technique...

New Types of Graphs - Advance ...

+9 Photos

Documents (1)

Microsoft Certification of Office...

Reviews (26)

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

4.8 out of 5.0 26 reviews

4.80526
D

"I fully recommend you to undergo training by rajan sir for excel. Indeed it was exhaustive sessions yet very informative and great learning experience during the course. One additional benefit is of his whats app excel group which keeps stimulating you to learn new excel skills everyday. Thanks rajan sir. "

S

"Thanks for the classes and teaching. You are best in Excel. The most important part of your teaching is that it comes with practical experience. "

R

"This course was very helpful for me , Rajan sir teaching was also superb , the one to one session was very interactive . Thanks Rajan Sir for your teaching . "

R

"He has expert knowledge and can solve any problem with multiple options as per candidates understanding. "

Have you attended any class with Rajan? Write a Review

FAQs

1. What Excel features do you teach?

Basic Excel and Advanced Excel

2. Which classes do you teach?

I teach Microsoft Excel Training Class.

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 (16)

Answered on 21 Feb IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training 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 Feb IT Courses/MS Office Software Training 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 Jan IT Courses/MS Office Software Training 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

Answered on 17 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

No software required. You can do file save as and select PDF in file type.
Answers 8 Comments
Dislike Bookmark

Answered on 19/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

I want to learn and master Excel in a month or two. What would you recommend?

You can learn excel in a month also. But mastering takes much time beyond that. Mastering means you need to know which steps to follow, which tools to be used where and when. Mastering means to reach goal with minimum number of tools in shortest time. And this is only possible through experience. I... ...more

You can learn excel in a month also. But mastering takes much time beyond that.  Mastering means you need to know which steps to follow, which tools to be used where and when.  Mastering means to reach goal with minimum number of tools in shortest time.  And this is only possible through experience.

I being Microsoft Certified professional, still cannot claim that I am master, so huge is excel.  Learning Excel is important but learning logic is more important.

Answers 2 Comments
Dislike Bookmark

RajanDirections

x
Microsoft Excel Training classes 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

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.

Courses in Microsoft Excel Training classes

Answers by Rajan (16)

Answered on 21 Feb IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training 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 Feb IT Courses/MS Office Software Training 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 Jan IT Courses/MS Office Software Training 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

Answered on 17 Jan IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

No software required. You can do file save as and select PDF in file type.
Answers 8 Comments
Dislike Bookmark

Answered on 19/12/2018 IT Courses/MS Office Software Training IT Courses/MS Office Software Training/Microsoft Excel Training

I want to learn and master Excel in a month or two. What would you recommend?

You can learn excel in a month also. But mastering takes much time beyond that. Mastering means you need to know which steps to follow, which tools to be used where and when. Mastering means to reach goal with minimum number of tools in shortest time. And this is only possible through experience. I... ...more

You can learn excel in a month also. But mastering takes much time beyond that.  Mastering means you need to know which steps to follow, which tools to be used where and when.  Mastering means to reach goal with minimum number of tools in shortest time.  And this is only possible through experience.

I being Microsoft Certified professional, still cannot claim that I am master, so huge is excel.  Learning Excel is important but learning logic is more important.

Answers 2 Comments
Dislike Bookmark

Enquire

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 2016 Specialist Tutor. He conducts classes in Microsoft Excel Training. Rajan is located in Naupada, Thane. Rajan takes at students Home and Regular Classes- at his Home. 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 26 reviews till now with 100% positive feedback.

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.

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 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 6.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