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.
195 Students 
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.
2 Students 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
Shivam Sunil patil
Microsoft Excel Training Requirement for:Advanced Excel,Basic Excel,Excel Macro Training
"The best and very intellectually way to teaching is very smooth thank you sir. It was a very good experience and learnt very knowledgeable and useful things in this session. "
Suvidh Sharad mhatre
Microsoft Excel Training Requirement for:Advanced Excel,Basic Excel,Excel Macro Training
"Superb Experience in excel training and formulas advanced for daily working. Also how these excel training used also in daily use is teach by sir. "
Viren Patil
Microsoft Excel Training Requirement for:Advanced Excel,Basic Excel
"Training was excellent and also very useful in day to day work. Sometimes in the session sir taken some general knowledge questions and query solving problem which gives us mind fresh in the session. "
Swapnil Bhoir
Microsoft Excel Training Requirement for:Advanced Excel,Basic Excel
"His lessons are very good and easy to understand. He is a good mentor and very effective in professional life. "
Bhagyashree Panchal
Microsoft Excel Training Requirement for:Advanced Excel,Basic Excel
"It was a fantastic learning experience. I learned a lot during the session. Sir not only explained the formulas but also showed us how to apply them in different scenarios. "
Nishant
Microsoft Excel Training Requirement for:Basic Excel
"It was a great experience under Rajan Sir's guidance. got to learn new techniques. Taking home a bag full of knowledge. "
Nikita
Microsoft Excel Training Requirement for:Basic Excel
"Excellent Training Mr. Rajan Sir is Very much experienced and have good knowledge about the excel he taught us basis excel that is in use in our day-to-day office work can save your work from 2 hours to 20 mins. "
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."
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...
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
Thane West Brahmand, Thane 
