Question about Microsoft Business & Productivity Software

1 Answer

Need a link

Actually i want to learn macros in excel.... can u pls suggest me a site where i can learn... i m a starter n dont know a word....

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 9 Answers

Macros are harder to understand than they are to create and use. Let me repeat "Macros are harder to understand than they are to create and use."
Here is the only understanding that you need. "they are used for repetive tasks" .

Now to the simple part of creating then using.
Get into your work and identify a task that you want to created macro for, Kapish? Just before you start on the task go into the macros screen and tell it to "create", then do your task. When through "push the stop button. Name the micro and save it. (the name may be the first step if so then give the darn thing a name, no big deal). The next time you are in the exact field where the identical task is going to be perforned you can call up the micro to run through the key strokes for you. Get ready for wildly unexpected results, with those understood you can go into the code and modify it. Or you can delete it and create anotherone that is cleaner. Keep doing this until you get the bugs out. By the way the once created micros leave a tag in the spreadsheet that alerts everyone that opens it to watch out for the dreaded micro you created.

Posted on Jun 27, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I want the all excel formulas


You will never find a fully comprehensive list anywhere because there are literally hundreds in the basic Excel application and thousands that can be added in as you go via macros. More are being added every time a new version of Office comes out.

But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.

That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.

Jun 19, 2009 | Microsoft Business & Productivity Software

1 Answer

Can i know the best website to learn excel


The best site would be a matter of opinion. However, this link: http://office.microsoft.com/en-us/training/CR100479681033.aspx will provide a lot of information and training on Excel 2007. I would also get a good book to learn from. There are tons out there. The Excel Bible and Microsoft Excel Step by Step are just a couple of books your might want to look at. Both are great for learning.

Jun 06, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

PROGRAMMING MICROSOFT EXCEL


Hey. I tried pasting this information here for you, but it was too much..

Here is the link....

http://office.microsoft.com/en-us/help/HP012163661033.aspx

Search around on that site as well for what you need to do if that link does not help...

May 28, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Learning excel program


I would start looking at Microsoft's Excel help and how -to pages. I don't know what version of Excel you are running, but below are links to the Excel 2007 how to, and the last one is the link to the Excel 2003 how to. I hope this helps.
http://office.microsoft.com/en-us/excel/FX100646951033.aspx (Excel 2007)

http://office.microsoft.com/en-us/excel/FX100646961033.aspx (Excel 2003)

Apr 04, 2009 | Microsoft Excel 2007 Home and Student...

4 Answers

I need Excel's Furmula's


I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Business & Productivity Software

1 Answer

Macro


I WONT EXCEL KEY

Jun 29, 2008 | Microsoft Excel for PC

1 Answer

Macro on excel


Macros are a timesaving feature that allow you to record a sequence of actions that you do in excel, and replay them back later.

You give each macro a name, and you can invoke them later, and Excel will "do" whatever it is you did when you recorded the macro.

To record a new macro:
1) Open Excel
2) Go to Tools->Macros->Record New Macro...
3) Type in a name for your macro and hit OK

(A new toolbar will popup with a "stop" button on it. Excel is now recording everything you do)

4) Do something, like, for example, select some cells and make them bold.
5) Click the "stop" button.


Now your macro has been recorded! You can play it back later by:

1) Open Excel
2) Go to Tools->Macros->Macros...
3) Select your macro from the list
4) Click "Run"

The actions you performed earlier will now be executed.



-------


Macros are written in Visual Basic for Applications, or "VBA". It is a programming language which uses the Excel Object Model to perform various actions. You can edit and create custom macros by writing the code manually in VBA. To do this:

1) Open Excel
2) Go to tools->macros->macros...
3) Select an already existing macro
4) Click "Edit"

(The visual basic editor will open, showing you the code for your macro)

At this point you are writing a program in Visual Basic. To learn how to edit macros, you need to learn visual basic, as well as the specific quirks related to excel macros in visual basic.

Recording a macro, and then using it as a template while you edit it is a common trick for making macros manually more quickly.

If you are not familiar with VB, I would not suggest attempting to edit your macros in any but the most simplest of ways. If you're brave, you can try to learn about editing macros in VBA here:

http://www.anthony-vba.kefra.com/

Jan 28, 2008 | Business & Productivity Software

1 Answer

Macro to be used in Excel


Instead of me teaching u. i would suggest u learn it by following the simple steps.

1. Click Tools > Macros > record
2. do some common operation like copying data, creating graphs, etc.
3. press alt+F11 to go to vb editor, to see ur macro recorded
4. study it ... u will learn easily

or

try the book 'Microsoft Excel Visual Basic Macros Examples' at http://www.add-ins.com/vbexamplestopics.htm


bye

have a nice day

Jan 26, 2008 | Business & Productivity Software

1 Answer

I want an excel e-learning book which is very comprehensive and easy to understand


Hi Chiquitta

Please click on below link you download training modules from this page.

http://Click on this link

Note- These downloads teaches about few topics of excel.

My suggestion for you to learn excel effectively would be buy a book called BIBLE OF EXCEL, even i wanted to learn excel completely and i bought this book , it teaches everything from basic to advanced in a user friendly manner, book is considerably cheap& effective compared to any E-modules available on net. Use can use net to find out problem for any specific issues but not to learn complete excel and master it.

Dont hesitate to get in touch with me if you need more help.

Hope this post was useful for you, kindly let me know by providing your valuable rating.

Thanks,
Robosoft.

Jan 06, 2008 | Microsoft Excel for PC

1 Answer

How to use macro in excel


show the macro toolbar then click on the record button.

Sep 21, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

97 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...