Can you recommend a good book for learning Excel programming and macros?

1 Answer

Answer :

answer:Yes, (at least in Office 2010), VBA is still part of the installation package, and highly useful. I would suggest that you start to learn coding on your own, before buying a book and going that route. And that’s easier to do than say (as opposed to the way that saying usually goes), because you can learn VBA syntax by recording macros and then learning how to edit them to make them more universal, more interactive and more powerful. Open a new workbook in Excel. Go to the “Developer” tab (you may need to activate this as part of the ribbon, which you can do through the “customization” menus). At “Developer” click “record macro” and accept the default option to save “in this workbook”. (Later, when your macros become more general and more useful, you’ll want to save them to a file called Personal.XLSM, which should open every time Excel opens, making your useful macros available to you all the time. But I digress. Record yourself doing some things in Excel. At this point it hardly matters what. Navigate to a new worksheet, enter a formula or something, and just generally mess around a bit. Or do something very intentional. At this point it doesn’t matter. Click the button at the bottom of the screen to “stop recording”. Go back to the Developer tab and click “View Code” navigate as needed to review the VBA code that has been recorded. Now you’re ready to start learning VBA. I advise a site such as MrExcel.com (there are loads of them out there) to browse, ask general and specific questions, and even more importantly: answer questions from people who know even less than you. I didn’t start to really learn Excel until I tried to answer others’ questions, which led me down paths that I hadn’t even considered. You’d be surprised. You’d be surprised how quickly you start to learn VBA just by reading and tweaking what you’ve recorded, too, and then learning the steps to write IF… THEN… ELSE… ENDIF and DO WHILE and other looping and branching statements. Before long you’ll be answering my questions there, I suppose. They can also give excellent advice about books, other websites, and even some of the Microsoft MVP websites that many of them maintain.

Related questions

Description : Excel Help - Macros question?

Last Answer : this is the first post on here that i have not gotten a response for within minutes…I am shocked! Have a stumped your guys?

Description : When opening the Excel version of Capstone®, you should do what to Macros? a. Enable b. Disable c. Engage d. Disarm e. Does not matter

Last Answer : a. Enable

Description : Is there a specific name for this programming concept and can you recommend a website or book I could use to learn about it?

Last Answer : It's hard from your question to establish what sort of programming you mean more specifically than just graphics programming . My advice to you is to investigate C++ graphics libraries, find one that ... (not all libs will compile to all platforms) and what specifically you mean to make it do.

Description : How can I get macros out of my Microsoft Word documents?

Last Answer : I'm on Mac OSX.

Description : What are macros in a word document?

Last Answer : In text editors (such as Word, or other editors like VIM) a macro is a recorded sequence of commands that can be played back at any time. Say you wanted to do some fairly complex task many times in a ... which you may have heard of. So be wary of using Word macros from people/places you don't trust.

Description : Is VPN helpful for learning Programming languages ?

Last Answer : I'm not aware of any nation-blocking for free programming sites, let alone that being a widespread thing. It seems to me that usually when someone posts information for free online, they rarely then ... of thinking. But if you find some, I imagine you can likely spoof your location easily enough.

Description : The war between the book and the keyboard..(in learning a programming skill)..?

Last Answer : Of course practice. Look at code others have written, and see how they got the computer to do the functions they wanted. What lauguage are you wanting to study?

Description : Which of the following is a programming language? A) Lotus B) Pascal C) MS-Excel D) Netscape

Last Answer : Answer : B

Description : The window version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of _____: a) Visual Support b) Visual Basic c) Visual Format d) None of These

Last Answer : b) Visual Basic

Description : What are macros?

Last Answer : A shortcut that will make several things function/occur in a sequence

Description : MS Office Macros?

Last Answer : Try askLeo.com and ask him http://ask-leo.com/

Description : What are Macros: a) Small add - on programs that are installed afterwards if you need them b) Small programs created in MS - Word to automate repetitive tasks by using VBA c) Automatic Virus Scanning Programs d) None of The Above

Last Answer : b) Small programs created in MS - Word to automate repetitive tasks by using VBA

Description : The type(s) of auto executing macros, in Microsoft word is/are A) Auto execute B) Auto macro C) Command macro D) All of the above

Last Answer : D) All of the above

Description : More subtle because you are not aware that you are running these macros (A) The purpose of copyright (B) Danger of macro viruses (C) Derivative works (D) computer-specific crime

Last Answer : (B) Danger of macro viruses

Description : More subtle because you are not aware that you are running these macros (the document opens and the application automatically runs); spread via email A. The purpose of copyright B. Danger of macro viruses C. Derivative works D. computer-specific crime

Last Answer : B. Danger of macro viruses

Description : More subtle because you are not aware that you are running these macros (the document opens and the application automatically runs); spread via email A. The purpose of copyright B. Danger of macro viruses C. Derivative works D. computer-specific crime

Last Answer : B. Danger of macro viruses 

Description : Which of the following is true about CISC processors? A. The instruction set is non-orthogonal B. The number of general purpose registers is limited C. Instructions are like macros in c language D. Variable length instructions E. All of these F. None of these

Last Answer : E. All of these 

Description : Which of the following is incorrect in C++ ? (A) When we write overloaded function we must code the function for each usage. (B) When we write function template we code the function only once. (C) It is difficult to debug macros (D) Templates are more efficient than macros

Last Answer : (D) Templates are more efficient than macros 

Description : Why don't the links work in the Excel work book I emailed?

Last Answer : They (links and macros) are on your hard-drive and not part of the attachment, you emailed .

Description : Can you recommend a book, ebook or website for learning statistics?

Last Answer : I loved Statistics for Dummies. It explained everything clearly and gave examples for many things that weren’t instinctive (to me anyway).

Description : How To Excel In Language Learning At Any Age?

Last Answer : Learning to speak a foreign language is an adventure to open your mind to international culture and sharpen your communication skills. The language learning process should be as free and natural as it ... that may discourage a new foreign language learner is the use of proper grammar and syntax.

Description : Should high level programming be a mandatory class next to learning writing and reading in primary school and onwards? Your arguments please.

Last Answer : No, because it is not a skill that everyone needs to have. The people who use it will learn it, but it isn’t equivalent to reading and writing.

Description : Ruby, a class XI student has just started learning java programming. Help her in the following: (i) Explain her the concept of variable -Technology

Last Answer : (i)Variables are named storage location to store values temporarily which can be changed during program execution.Data type states the way the values of that type are stored, the operations that can be done ... setText( Just Pass );In the above if statement, value of marks is being compared with 40.

Description : Ruby, a class XI student has just started learning java programming. Help her in the following: -Technology

Last Answer : i. Variables are named storage location to store values temporarily which can be changed during program execution.Data type states the way the values of that type are stored, the operations that can be done ... setText( Just Pass );In the above if statement, value of marks is being compared with 40.

Description : Shaping teaching techniques to fit the learning patterns of individual students is the goal of __________ a) decision support b) automatic programming c) intelligent computer-assisted instruction d) expert systems

Last Answer : c) intelligent computer-assisted instruction

Description : What is a URL? a) A computer software program b) A type of programming object c) The address of a document or page on the World Wide Web d) An acronym for Unlimited resources for Learning e) None of these

Last Answer : c) The address of a document or page on the World Wide Web

Description : Is branch of science that deals with programming the system in such that they automatically learn with experience (a) Machine learning (b) Deep earning (c) Neural learning (d) All of above

Last Answer : (a) Machine learning

Description : Recommend online course in Cocoa programming (Objective C for Mac OS X)?

Last Answer : I beleive http://developer.apple.com had some resources, both for online training and locating local resources to train you. Good luck!

Description : Can you recommend a programming application for kids?

Last Answer : answer:Visual Basic is the easiest out there as far as I'm aware of. I took a class back sophomore year in highschool and it was as simple as anything, not to much coding in it, and it's good ... either, then it got deleted :( But yea I'd suggest Visual Basic, it's an excellent starting point.

Description : What book(s) should I get for learning Java?

Last Answer : Can you clarify one thing before I answer. Are you looking to learn Java or Javascript? There’s a HUGE difference between them, so that’s why I’m asking.

Description : Can someone recommend a good book on home wireless networking?

Last Answer : http://www.dummies.com/how-to/computers-software/home-networking.html

Description : I have the basics of Python nailed. Can anyone recommend a good Python/Django book?

Last Answer : Dive Into Python (http://diveintopython.prg) is an excellent Python book for programmers. How to Think Like a Computer Scientist is another excellent book to learn Python, for non-programmers. Bruce ... s AppEngine cloud, which makes it very easy to bring value to people while playing with Django

Description : Excel experts: how do I make this kind of a dropdown list (details inside)?

Last Answer : while in Excel, hit F1 key. Type in drop down. This is the MS help function to get you there

Description : Help with an Excel question, I want to center the page on screen?

Last Answer : Well, first, in the view tab, uncheck all of the grid lines, formula bars, ruler and headings. Is that more like what you're looking for? Protecting is kind of clunky. First highlight the cells you want to ... It should open up like that for people you send it to. You can practice on me if you want.

Description : Why do people look at me in such surprise when I tell them I know Word, Excel, Powerpoint, etc?

Last Answer : You could have written an IF function that automatically enters “Plastic” if it finds “BM”, “BR”, and “IB”, and then paste that function into every cell of the column.

Description : Can you tell me how to do this in Excel?

Last Answer : answer:Oh hail yes, I figured it out all by my self. Thanks for the HELP!

Description : How can I make this conditional formatting rule in Excel?

Last Answer : answer:Conditional formatting isn't too difficult, but the interface is unusual (not like other Excel interfaces), so that takes some getting used to. Assuming you know how to access the commands via the menu, I'll ... to a number of cells in B:B. You'll get it if you just keep playing with it.

Description : Is it true you can't send a single tab from excel in an email?

Last Answer : I really think the easiest way would be to use a PDF printer driver like Cute PDF Writer to print that one sheet. By design, it really isn't any more of a hassle than printing it out ... different printer ), and partly for compatibility, as they work with any program that has a Print option.

Description : Do you have a solution for this problem concerning Excel?

Last Answer : answer:Use the same excel data base saved as a different file with the new year and simply have the person search for their name, and then mark an X in a new column titled Present 2013 ... of elimination) and also will identify anyone attending for the first time. Hope this is helpful somehow.

Description : Is it possible to change the icon on a a saved Excel or Word file?

Last Answer : answer:If you change the extension to something other than one that Windows knows and already associates with Excel, including: .xls .xlsx .xlsm .xlt & etc. then you'll have to make a manual association ... which recognizes the .dxls file type, and still tell it to open with Excel.) Just do it.

Description : Do you know Excel?

Last Answer : Yes, I’ve regularly used Excel for many years. If you ask your question, I’ll be happy to try to answer it.

Description : How do I leave certain cells in an Excel spreedsheet unlocked so that other users can modify them?

Last Answer : I wonder if the fact that the cells I’m trying to leave unlocked are merged is part of what is creating this problem…?

Description : How else can you correlate data on Excel?

Last Answer : Can the data be paired, as in, do you have readings from both machines on the same samples? If yes then yo can plot the dat using Y vs X where Y is the new machine and X is the old. For ... with smooth lines. You now have your chart. Now play with the other options to make it pretty. Good luck.

Description : How do I set defaults in excel?

Last Answer : answer:You can save your tweaked in chart as default chart type; you need to save it as a custom chart type. To do that, follow these steps: 1. Create the chart that you want to use (your tweaked ... this helps (since it's Excel 2003, otherwise you can refer to this post). And here is another link.

Description : Can any of you tell me how to access the embedded games the good engineers at Microsoft insert into Excel?

Last Answer : From what I’ve gathered, Vista and 7 don’t have any.

Description : How to export search results from Microsoft Excel?

Last Answer : answer:If you highlight the labels at the top of each column, then click on the data tab, and the big filter button.. you'll be able to sort out which ones are from New Jersey. ( ... paste those into a new spreadsheet. Without actually seeing an example of your spreadsheet this is my best guess.

Description : Excel conversion functions?

Last Answer : answer:I am not aware of an off-the-shelf solution. Hopefully someone has an easier way, but here's how I approach the question: 1) The INT function will give you the whole number (41) =INT(41 ... fractions-in-excel.php Sorry to give an incomplete answer, but that's all I have time for this morning.

Description : Why does Microsoft Excel do this with graphs and how can I fix it?

Last Answer : Can you e-mail me the file? I will play with it. You should know my e-mail Inverted Treestump..

Description : How to make columns into lists for .csv (excel) with Python?

Last Answer : answer:data = open( grades.csv , r ).readlines() for line in data: [t]items = line.split() [t]print items[0], items[2] note that Fluther strips the required tabbing from the program, replace [ ... to delimit columns. Should really close the file in the program and not leave the OS to sort it out.

Description : Microsoft Excel for Mac 2001?

Last Answer : You might try uninstalling the program, uninstalling Office and then reinstalling it.