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.
176 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.
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 87 reviews
Sunil
Microsoft Excel Training
"Mr Rajan Ghadi gave me excellent service. It was exceptional in its service and vocation. I am left with a lot of gratitude and gratefulness to him and his excellent service and gratitude in helping me solve this issue. "
Dinesh
"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. "
Swapnil Mandalia
"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. "
Roshan
"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 . "
Rohit Gulati
"He has expert knowledge and can solve any problem with multiple options as per candidates understanding. "
Saurabh Srivastav
"It was an excellent experience. Even after the course is over day to day support through WhatsApp is excellent. "
Sunny
"Awesome in training. Very Good teacher. Great shortcut skills. He is the best to learn excel from. I am doing good in my business after learning excel from him. "
Mukesh
"Excellent way of teaching and content is really good. Overall I am satisfied. Though initially I felt 2 sessions would be really less but it's enough to understand and learn. "
Neelkanth Jadhav
"The good thing about course is that we connect to what's app group organised by Rajan Sir where we are in regular touch with Excel experts "
Atul Angale
"Excellent teaching skills and a wonderful person, also the best part is giving new challenges on wats up. "
Manish
"I like the way Rajan sir teach he has a good experience and gives such a good corporate examples which relate to day to day office work, he teaches with great practical examples which make ultimately easy to understand. "
Kishor Patil
"Excel Advance training given by Rajan is excellent. Learnt a lot shortcuts and formulas. Teaching method is very good. Explains with different example. His after season whats up assistance is very helpful. Thanks Rajan. "
Dhanashree Ojale
"He is highly professional in all aspects, in depth knowledge of subject. He continues to support even after class forming support WhatsApp group in which response is prompt. "
Manoj R sharma
"The teaching method was fantastic as Rajan sir explained it very well with some interesting examples. He emphasized more on understanding the logical part rather than just teaching, even if the student makes mistakes (even repeatedly) he was always supportive and explained again. It was great experience. Thank you. "
Krushna sahoo
"Rajan Ghadi is an excellent trainer. Works with clear , quick, easy way. It was easy to learn and practice. Thanks Rajan ji for the training. "
Reply by Rajan
Many Thanks Krishna sir for your kind words. Such reviews increases confidence of trainer too.
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...
Want to learn from Rajan?
Share this Profile
Recommended Profiles
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.
0
Kothrud, Pune 
