Naupada, Thane, India - 400601
Verified 
238
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.
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.
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
Vinay salvi
"Mr Rajan Sir is very much patient and interactive. I would strongly recommend to join course and learn excel from him. Thank you very much sir for providing best knowledge. "
Swatej H
"It was a great learning! Topics are covered extensively with alternative approaches to a use-case. Teaching style is also lucrative. Highly recommended. "
Reply by Rajan
Thanks Swatej for your review. Good learners understand the value and appreciate. I am glad you liked personal training. Also you are part of my WhatsApp community. Keep solving questions I post there. Good to learn there too.
Dinesh D sahane
Microsoft Excel Training
"It is very excellent training with dynamic way to explaining the logic behind problem statement and to find out appropriate solution for the same. "
Rajat
"Rajan Sir is very patient and extremely interactive. He can think of questions on the spot and explains concepts very well. Very punctual and dedicated. "
Romil Upadhyay
"Very informative and patient teaching by sir. Would recommend it to everyone. Even beginners Worth it. "
Reply by Rajan
Glad you liked it Romil.
Santosh Todkar
"Rajan Sir has given his best knowledge of excel. I was solving in a live class with sir. Best in Xlookup, Index match, offset. graph linked with logical formula. "
Rishi Sharma
Microsoft Excel Training
"Sincere thanks Rajan for imparting need based training. Being in the middle level management task is to instantaneously take prudent decisions with data crunching. Rajan meticulously worked with me to hone my analytical skills with par excellence training content. My gratitude to Rajan for transferring customised knowledge & helped me to excel in Corporate journey. Strongly recommend to corporate folks to opt for this training programme so as to be ahead of the curve in this dynamic environment. "
Roshan M
"I enjoyed this course so much. I learned a lot about how I can become a better learner. This course was very interesting and useful. I have some tools that I can use to optimize my learning potential. "
Chirag Bhatia
Microsoft Excel Training
"Excellent knowledge & excellent teaching capabilities. I would strongly recommend rajan sir for excel training. "
Viral Vora
"I have today completed excel training course with rajan sir. Sir, has taught very meticulously the nitty gritty of excel. I was taught with the intent to learn excel without using mouse and I have now gained much confidence to use in that way. Further, there are many shortcuts which are being taught and more importantly what shortcuts we should use and also what not to use with specific reasoning. I am quite happy with the coaching which was simple to understand and the attention given by rajan sir. Lastly, the intention of sir, that the student should learn makes us learn. Thank you rajan sir. "
Sudhir Ghadage
"Very good coaching with concept clarity. Mr. Rajan has excellent skill level of excel and depth of knowledge. "
Ninad R kocharekar
"I had very good experience with Rajan sir. Session with him have been so worthwhile. He has amazing way of breaking things down so that they are understandable. It is very comfortable to practice conversations, which is also a huge plus. I recommend him highly. He doesn’t waste your time in explaining meaningless background information and always lectures with the intent to help you understand the material. "
Haneesh Babu
"Just now I completed my course. If ask me to tell about the tutor I can simply say he is brilliant. His teaching skills are excellent. I strongly recommend rajan for those want to learn excel. "
Sachin Sule
"Rajan is very knowledgeable and clear with the concept. He was able to explain the various module of Excel very clearly. "
Reply by Rajan
धन्यवाद सचिनजी. Happy to have you as student.
Guru Kulkarni
"Fantastic trainer best is the country. I had been struggling to find a good trainer who can simplify excel. Rajan sir had made it really easy and simple. I am not afraid of excel any more. "
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
Paschim Vihar, Delhi 
