How can I learn macros in Excel?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Nev Laishram

Start with simple tasks; You will be learning as well as enjoying it. Start recording with Macros, For example, you try recording and then delete a few rows and stop to record. Press Ctrl Alt + F11 and check the code. Put a button on the sheet assessing this though macro. Now you have the first macro...
read more
Start with simple tasks; You will be learning as well as enjoying it. Start recording with Macros, For example, you try recording and then delete a few rows and stop to record. Press Ctrl Alt + F11 and check the code. Put a button on the sheet assessing this though macro. Now you have the first macro button. Now you can start assigning small tasks. For example, you could try to accomplish these with macros. Check the first 100 rows and delete the rows which have 'deleteme' text in their first cells. Put five shapes on the sheet. When you select that particular button, your macro would be painted red. All these processes might make it a bit difficult to find the correct way of doing something "specific". Thus, you can open a fresh new book like "Ultimate guide to the World of Excel VBA" or you can also find tutors here and get experts in Excel to answer your queries. Hope this helps read less
Comments
Dislike Bookmark

Related Questions

I have completed MBA in Finance and operation and have done SAP MM consultant training after 5 yrs of working experience in the sap mm domain. But I am not getting a job opportunity because it is challenging to get sap fresher job opening; I struggle for a long time for a job opening. Please guide or suggest another best course with a fresher job opportunity to start my career again.
I think you should go with Project Management. You can do certification courses like PMI-PBA(PMI professional In Business Analysis) or Portfolio management. These specialised courses will give you an edge over others.
Priya
What are the 5 most essential excel tools to master?
tools? Is that right, is that what you wanna know? there is no such thing as tools inbuilt in excel. Tools are specifically designed for a set of people or a company for a specific purpose to be added...
Yashraj
0 0
View Comments6
How do I type new line inside a single cell? I don't want to go to another cell but there should be a new line inside 1 cell. Please help.
You can type Alt+Enter, in case you wanted word wrap, then goto the Home Tab, Alignment group and select Word Wrap otion
Arjun
Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Ramkumar
0 0
View Comments7
How to develop skill on Excel Macros VBA. I want to be perfect on VBA. As soon as I see the problem.. within minutes it should come in my mind what code i have to write for this situation...I know its not that easy.. but I feel that its not hard too. I need advise as to what I have to do.. Eagerly waiting for the encouraging responses from all the teachers& trainers..
You need to understand the grammar of VBA Language first like collections ,objects ,methods and properties,syntax of different objects and their uses etc ..Once you are clear with these concepts ,you can...
Sandeep

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Datedif() Function
Purpose: This function calculates difference between two dates. it can show the result in days, months and years. Syntax: =datedif(start_date,end_date,"unit") start_date This is earliest...

Saburudeen Ma

0 0
View Comments0
Ever been stuck calculating GST manually?

Mahesh

0 0
View Comments0
MS Project: Delete Calendar
In MS Project, you may want create custom calendar and later you may want to delete if it is not necessary. This video explains how to delete a calendar in MS Project 2016 Professional.

Xcoach

0 0
View Comments0
Excel Database Functions List
Excel Database Functions List Database Functions DAVERAGE Calculates the average of values in a field of a list or database, that satisfy specified conditions DCOUNT Returns...
U

Uma Sahu

0 0
View Comments0
Microsoft Word
Microsoft Word is a widely used commercial word processor designed by Microsoft. Microsoft Word is a component of the Microsoft Office suite of productivity software, but can also be purchased as a stand-alone...

Itech Analytic Solutions

0 0
View Comments0

Recommended Articles

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Find MS Office Software Training near you
MS Office Software Training in Delhi
MS Office Software Training in Mumbai
MS Office Software Training in Hyderabad
MS Office Software Training in Bangalore
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Ahmedabad
MS Office Software Training in Kolkata
MS Office Software Training in Gurgaon
MS Office Software Training in Jaipur

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you