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
Priyanka
Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel
"Fun session with great examples and understanding of the problems faced. Great patience throughout the session "
Nilangi Sadrekar
Microsoft Excel Training Requirement for :Basic Excel
"Excel training was great. I have learnt new formulas which add up in my skill set. Efforts put by Rajan sir is recommendable."
Vishal Mishra
Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel
"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. "
Prerna Gothi
Microsoft Excel Training Requirement for :Basic Excel
"It was interactive and a good learning experience. It had lots of interesting concepts and understanding was easy. "
Kapil Ahmead siddique
Microsoft Excel Training Requirement for :Basic Excel
"The best and very intellectually way to teaching is very smooth with sir are very friendly thank you sir. "
Sandeep Baban pawar
Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel,Excel Macro Training
"The best and very intellectual way of teaching. Teaching is very smooth with Sir are very friendly. thank you sir. "
Jharna
Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel
"Briefly explained all the process in detail and made sure if that was understood or not. Overall, a very good experience. "
Sanika Rajigare
Microsoft Excel Training Requirement for :Basic Excel
"Fruitfull and very informative and can apply in multiple aspects will try and practice the same in order to excel in my excel sheets."
Saachi Bamba
Microsoft Excel Training Requirement for :Basic Excel
"The workshop is very helpful and in-depth. You get in practice during the workshop itself which is easier to understand and implement. "
Anjali
Microsoft Excel Training Requirement for :Basic Excel
"Fun session with great examples and understanding of the problems faced. Great patience throughout the session. "
Viju Shankar
Microsoft Excel Training Requirement for :Advanced Excel
"Very good experience, the classes were very useful and it helped me a lot in getting the desired skillset. Rajan sir is an expert coach with strong excel. Highly recommend. "
Durgesh Sawant
Microsoft Excel Training Requirement for :Advanced Excel
"In detail one to one sessions to clear and learn the concept. Also excercise and homework there which were helpful during learning period."
Nivedita Oak
Microsoft Excel Training
"Really a good trainer! Is more focused on logic. Also you can post the training ask any queries. Totally recommended. "
Nilesh Rajani rajendra vinerkar
Microsoft Excel Training
"Very good and informative session given by Rajan Sir. Learn new excel formulas which is useful for daily purposes. "
Mitali Gupta
Microsoft Excel Training
"The training was excellent and Rajan had explained each and every formulas with good examples. It was a good session. "
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 
