Naupada, Thane, India - 400601
Verified 256
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.
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.
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 98 reviews
Yatish Tambadkar
Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel
"The instructor demonstrated expertise and explained challenging concepts with clarity, ensuring that participants of varying experience levels could follow along. The hands-on exercises were particularly beneficial, allowing us to immediately apply the skills we learned. "
Jayesh Koli
Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel,Excel Macro Training,Excel VBA Training
"Its very use full in official as well as in personal life.The method is very simple but effective. "
Shree Ramchandra thakur
Microsoft Excel Training Requirement for :Advanced Excel
"Very good Experience and learning more important things in Excel. thank you so much and welcome again. "
Yashwant Mane
Microsoft Excel Training Requirement for :Advanced Excel,Basic Excel,Excel Macro Training,Excel VBA Training
"Excellent classes, everyone should join this classes for developing new skillset in excel. Special thanx to rajan sir for giving us this knowledge in brief. "
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. "
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...
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.