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
Amol Baviskar
"Rajan sir teaching is easy to understand. He teach tricks in excel which help me to understand complex function easy way. Thank you so much for your support. Highly recommended to all. Has good grip in the concept. "
Bineet Walia
"Mr Rajan is an excellent tutor with complete mastery in excel and in teaching skills. He is very focused and understanding and makes it easier to learn. "
Reply by Rajan
Thank you sir for your review.
Harsha
"During our day to day life we used excel frequently. By knowing pivot and vlookup I thought that I was well versed with excel. However, this class helped me to view at excel in a logical way. Mr. Rajan is a best teacher who taught me the skills and techniques to use excel functions optimally. By using this functions and shortcut keys now I am able to make my reports in presentable format. Thanks for his support. "
Ninad
Microsoft Excel Training
"Mr. Rajan teaches with easy to understand methods and make sure to clear the concepts. He explains in an understandable way with lots of opportunities to ask questions and talk about real-time examples which all made a well-designed wonderful practical course. Thank you. "
Nitin Chhokar
"If you want best start in Excel. If you want to achieve perfect position in corporate sector. Take Course under Rajan Sir. I took this course and feel I will get high returns in future. Thanks Rajan Sir. "
Rajendra Pardale
Microsoft Excel Training
"Mr Rajan Ghadi teaching extremely well in Excel and easy to understand and explain magical his methods in Excel. He teach very well. His every session is very learning to know more and more about Microsoft Excel. "
Neeta
"He has dept knowledge of excel and formulas, his way of teaching is very simple and easy to understand, this 12 days excel classes really helpful in my profession. I recommend Mr. Rajan Ghadi to all. "
Reply by Rajan
Many Thanks Neeta. I am glad to get student like you who is also a CA. Currently accounting cannot happen without excel. Let Excel help you throughout your life. All the best.
Vinod Tambhale
"He Teaches very well I learnt a lot things from him which I need in Excel. Every session was nice his method is very good and simple so I could understand easily. I recommend to Mr. Rajan."
Zaahir Bootwala
"His teaching skills are really amazing as he knows the hidden insights of Microsoft Excel. The whole excel he has taught me over one Keyboard. As his 1st rule is not to use a MOUSE. Overall it was a fantastic learning experience. "
Amey Tupe
"He is a professional who gives his everything that he knows of excel to explain his student in a simple way. "
Krishna Murthy raju
"It was a wonderful experience learning excel with Mr. Rajan Ghadi. It was an excellent training with practical examples. I will recommend Mr. Rajan Ghadi, to all who intend to expertise in excel. "
Sameer Suman
"Excellent experience. Rajan Sir is helpful for solving excel related issues. He provides support even after the completion of course. "
Rishikesh Tatpuje
Microsoft Excel Training
"Thorough knowledge and step by step execution of excel topics in scheduled training period. Resolves yser queries and always ready to support. Best wishes to Rajan Sir. Thank you. "
Chetan Vaidya
"Rajan is excellent teacher and he understand his student needs and accordingly modify his teaching. I had a fabulous experience with rajan. Moreover he constantly updates with new development and new function with a very easy and understandable manner. "
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. "
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 
