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

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
Is there any free software to convert a word file to PDF?
You don't need any software. Just go to "Save as" and when the save window pops up, below the file name you will find the option to select file type, here click on the drop down arrow and change from...
Gaurang
0 0
View Comments7
What is Microsoft Excel?
It is an Application which consist of Spread Sheet for creating Document based on requirement
Swati
0 0
View Comments5
What is shortcut to rename the spreadsheet name?
Alt+H+O+R
Umang
How to use the h look up in excel worksheet ???
Horizontal lockup
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

SQL Join Types
There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all...

Itech Analytic Solutions

0 0
View Comments0
Rand() Function
Purpose: Get a random number between 0 and 1. Return Value: Any decimal number between 0 and 1. Syntax: =RAND() Usage: RAND() function will returns a number between 0 and 1. For example, = RAND()...

Saburudeen Ma

0 0
View Comments0
Pivot table - Transform numbers in calculated field
How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...

Phanitha P.

0 0
View Comments0
What Are Olap, Molap, Rolap, Dolap, Holap?
1. OLAP: On-Line Analytical Processing: Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal...

Itech Analytic Solutions

0 0
View Comments0
Hidden Gems Of MS Excel - Sort (add Multiple Levels to Sort Data)
Please refer following dataset: You would know:- To Sort Month from Oldest → Newest OR Newest → OldestOR- To Sort Region from A → Z OR Z → AOR- To Sort Units Sold from Smallest →...

Ankur Sharma

2 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 Pune
MS Office Software Training in Chennai
MS Office Software Training in Kolkata
MS Office Software Training in Ahmedabad
MS Office Software Training in Jaipur
MS Office Software Training in Ghaziabad

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