I am thinking about taking a class to get certified in Microsoft Excel, since I am already certified in Word and Access. The class description gives a good overview of what will be learned in the class. The only part I really don't understand is macros. What are macros and how are they used in Excel or a spreadsheet program or any program. I don't remember having to learn any in my previous courses of certification. Can you give me some examples of what they would look like and be used for?
Macros in Excel are just like Macros in Word, they automate otherwise long tasks with shortcuts, buttons, and such. Like you, I would like to be certified in WORD. Can you give me some examples of what the [tests] would look like and [they expect Word to] be used for?
Well when I was certified I took it at a university that was a Microsoft approved spot for certification and these spots aren't always at universities or colleges. The test has about 20 parts to it and it each part you had to utilize a specific feature in Word. The test began easy, you know changing up font and spacing and other things, but later became more detailed and advanced in that you had to deal with some advanced features of Word. I believe the passing grade was like 650 out of 800 or something like that. The thing is I never had to deal with macros in Word testing but it is listed as a subject in the Excel description, that's why I was wondering what they are. So basically macros are just animations that provide shortcuts for long tasks? Do you have an example or something you could post. not like an actualy example but one you could just explain. Thanks!
Ask me one of the questions you think most people would know, then a more difficult one, then a really difficult one. Do you remember?
I am certified in Excel and Access. I haven't really thought about getting any other certs. I am glad you started this thread Dookie because I have some questions about Excel myself that I was pondering over. One of my companies does a lot of business with coders on Rent-A-Coder.com and we just got a new piece of equipment that scans bar codes and the software for that equipment places the bar codes into a spreadsheet. We are wanting the bar codes to be placed in certain cells within the spreadsheet, and when a level reaches a certain we want the cursor to blink or do another action. I've never done something like this before, does it sound like it is possible to do in Excel? If so I am going to post a work order on RAC for the work.
as far as i know, a macro is just a program that is attached to some button or object so that when you click on the button or object, the program is executed. i don't know if there are other types, but the only way i've dealt with macros is writing Visual Basic code (that does whatever you want it to with the cells in the spreadsheet) into the Visual Basic editor and then attaching that code to a button. i didn't even know you could do this until about a year ago but i'm glad i found out because it helped a bunch with saving time on my research (going through 322 sets of data by hand would've sucked). and visual basic was close enough to c++ that it was easy to pick up.
So no examples of the WORD test or what it was like? I would like to try to get MCP certificied soon... maybe
