Platinum
Naupada, Thane, India - 400601.
Verified 255
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.
+11 more
Marathi Mother Tongue (Native)
English Proficient
Hindi Proficient
Mumbai University 2003
Bachelor of Commerce (B.Com.)
Microsoft Corporation 2018
Microsoft Office 2016 Specialist
Naupada, Thane, India - 400601
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.
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
Advanced Excel, Basic 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.
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 87 reviews
Priyanka
Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel
"Fun session with great examples and understanding of the problems faced. Great patience throughout the session "
Nilangi Sadrekar
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."
Vishal Mishra
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. "
Prerna Gothi
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. "
1. What Excel features do you teach?
Advanced Excel and Basic 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.
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...
Answered on 24/09/2020 Learn IT Courses
Answered on 04/12/2019 Learn IT Courses/Tally Software/Tally ERP 9
Answered on 21/02/2019 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training
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.
Answered on 08/02/2019 Learn IT Courses/MS Office Software 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 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)
Answered on 25/01/2019 Learn IT Courses/MS Office Software Training
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
Advanced Excel, Basic 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.
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 87 reviews
Priyanka
Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel
"Fun session with great examples and understanding of the problems faced. Great patience throughout the session "
Nilangi Sadrekar
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."
Vishal Mishra
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. "
Prerna Gothi
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. "
Answered on 24/09/2020 Learn IT Courses
Answered on 04/12/2019 Learn IT Courses/Tally Software/Tally ERP 9
Answered on 21/02/2019 Learn IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training
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.
Answered on 08/02/2019 Learn IT Courses/MS Office Software 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 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)
Answered on 25/01/2019 Learn IT Courses/MS Office Software Training
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...
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*
Your reply has been successfully submitted.