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
Avinash
Microsoft Excel Training
"Rajan is a best tutor who goes the extra mile to make learning easy for me. He is humble and understands students' needs, adjusting his teaching for beginners. I highly recommend Rajan if you want to get comfortable and skilled with MS Excel. "
Snehal Shinde
Microsoft Excel Training
"It was excellent, explained in ease with lots of examples. Session was worth investing time. Daily usage of excel in data making with proper data management was explained nicely. Liked the session a lot. "
Neelam Fernandes
Microsoft Excel Training
"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. "
Mohit
Microsoft Excel Training
"Very good and informative session given by Rajan Sir. Having excellent knowledge and communication. This will definitely help in my day to day work. Practical examples were very good. It was good for me. "
Sumesh Nair
Microsoft Excel Training
""It was good and very informative with simple explanation was able to apply in my day to day work very effectively. "
Venkatesh Potti
Microsoft Excel Training
"Excellent in depth knowledge received on pivots, data validation, charts post attending Microsoft excel training - Thanks. "
Reply by Rajan
Many thanks sir. Good to see you liked it.
Shyam
Microsoft Excel Training
"Its good training and its more helpful for my profile of work in account and as well its help me for all data."
Minakshi Sandeep kalbar
Microsoft Excel Training
"He is a good trainer and cover all the area of given session. Having excellent knowledge and communication. "
Minal Chalke
Microsoft Excel Training
"It was good and very informative. Would like to learn and grasp speed as good as much i can. "
Shraddha Jadhav
"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. "
Nayan Surti
"Good exp for the person who is just on the base level of Excel nice teaching skills. Wish to attend session again with the Rajan sir. "
Kapil
"Very good and informative training need more such type of advance excel training in corporates for better knowledge."
Priyanka Patil
Microsoft Excel Training
"Training was excellent!! I Really enjoyed it. Easy Teaching and understanding thing very well. Recinnebded "
Ritesh Vasant patil
Microsoft Excel Training
"Very fantastic training session & trainer explanation & practical examples is very excellent. We enjoy session with good knowledge "
Milagri Lobo
Microsoft Excel Training
"Training is Good. It is help in my day to day work. Practical example is very good. its was good for me . "
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 
