How can I learn macros in Excel?

Asked by Last Modified  

1 Answer

+1 Microsoft Excel Training

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

Why do we use a dollar sign in Excel?
A dollar sign $ is called a locked cell reference. Locked cell references are one of the building blocks of Excel modeling. Without them, you will waste endless amounts of time re-writing formulas.
Poonam
0 0
8
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff
Through Time Sheets
Bikram Jeet
0 0
7
What are the benefits of using Excel in business?
Excel is mostly and widely used tool of Microsoft for business purposes, to maintain data, to maintain records as well as to have efficient result through calculations. Excel provides a bunch of formulas...
Vijay
0 0
8
Need to enhance skills on MS Project and in Power Point
Join a Advance course for MS and PPT
Sri

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

Ask a Question

Related Lessons

Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 0
0
Microsoft Excel Functions Examples
Functions Discover how functions in Excel help you save time. If you are new to functions in Excel, we recommend you to read our introduction to Formulas and Functions first. 1 Count and Sum: The most...

Dheeraj

0 0
0
Today am teaching a excel formula like SUM, in this I'll take a name and no of student and you can see total i'll use here a advanced excel
NAME STUDENT SAURABH 1 ANJALI 2 MAHESH 1 SANJAY 2 SURABHI 1 NEELAM 2 TOTAL 9

Saurabh Sharma

0 0
0
Eight Bug Reduction Tips: VBA
You cannot completely eliminate bugs in your programs, but there are a few tips that will help you keep them to a minimum: i. Use an Option Explicit at the beginning of your module: Doing so will require...

Gaurav C

1 0
0
Learn in Excel To Create a LIST in One Minute

Sanjay Singh

7 0
0

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 Bangalore
MS Office Software Training in Hyderabad
MS Office Software Training in Mumbai
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Kolkata
MS Office Software Training in Ahmedabad
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