Thane West Sambhaji Nagar, Thane, India - 400604
Verified
Certified 15 yrs of Exp
282
Details verified of Rajan✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
UrbanPro Certified Tutor
For Microsoft Excel Training
Class Location
Online class via Zoom
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 class via Zoom
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 109 reviews
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 Ghadi
Many Thanks Krishna sir for your kind words. Such reviews increases confidence of trainer too.
Ashutosh Mahadev Mangale
"Classic training. I recommend this all students who are about to explore excel with proper guidance. Thanks Rajan sir."
Dhananjay Jadhav
"We had arranged a Corporate Training on Advance Excel at Kota, Rajasthan at a Listed Public Limited Company. The training was very systematic, well planned and all the given topics were covered in details. As Mr Ghadi has worked in Accounts & Finance for more than a decade, it gives him added advantage of knowing the common mistakes/problems faced by users. This training is appreciated by all the participants. "
Arvind
"Excellent training. Most appropriate for me, as I use Excel infrequently. I would look forward to undergo further training on different modules from Mr Rajan. "
Satish
"It was fine learning the new things in excel it really helped me in my daily routine activity which i do in the office. I want to thanks Rajan sir for your valuable support for teaching a new things in excel. "
Johnson Poojari
"His orientation is good .He gives you more practical workings.He makes you understand very well. He gives proper time to each modules .He is the best tutor for me. "
Reply by Rajan Ghadi
Thanks Johnson for your review. Looking forward for Excel Master in you soon.
Jigar Shah
"I am glad that Rajan was my tutor for excel. He has excellent hold of his subject and training way is excellent. I will always recommend him to anyone seeking excel knowledge. Thanks once again for your efforts. "
Venkit
"Rajan is a very committed tutor and has walked that extra mile to ensure simplicity in the learning process for me. He is humble and connects well the requirements of the students and accordingly fine tunes his approach to teach even the rookies. I will strongly recommend Rajan if you think of gaining familiarity and also expertise on MS Excel. "
Reply by Rajan Ghadi
Thanks Venkit for your review. Nice to get you as student as well.
Rajendra Morye
"Only one word to describe, Fantastic There is no definition of Advance Excel. I learnt 'Advance Excel' from few classes what was Advance as per them. But Rajan showed me what Advance Excel is actually. His moderate level training is equivalent to Advance of other classes. His Advance is beyond reach of other tutors or classes. His Advance Excel training is Super Advance. "
Answered on 24/09/2020
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
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
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...
Share this Profile
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.