MS Office VBA Automation Specialist #2

Hi there,

is there such a certificate? MS Office VBA Automation Specialist, I tried 
googling it on microsoft website and couldn't find any info. I just passed 
the excel 2k expert exam and I want to take the excel instructor exam, I 
haven't however been an instructor. is it possible to take the exam without 
an instructor experience?

last but not least, I am thinking about putting together some excel webcasts 
for beginners for free. I have always liked to learn by audio/visual versus 
reading so I am thinking about implementing this...

here is the link for the first test webcast that I created, ofcourse I need 
a better mic, I know...  

Excel for beginners
http://www.leitek.com/Webcasts/Excel%20for%20Beginners.htm

your feedback is greatly appreciated...

thanks a lot..
________________
Thanks,
salah
http://leitek.com
0
salooha (5)
8/15/2005 6:57:23 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
441 Views

Similar Articles

[PageSpeed] 4

Reply:

Similar Artilces:

EXCEL Sort #2
Sometimes when the cursor is in a singe cell in a spreadshhet and I sort, it will sort all the rowsin all the columns, sometimes it only sorts rows in some columns. The only way I feel safe is to highlight the entire working area, then sort the spreadshhet. George Lawshe George@Lawshe.com ...

Some sent items r going 2 junk email folder,filter is off,how fix
Outlook 2007, XP pro, Having a problem with some of the sent items going to the junk email folder instead of being sent. Junk email filter is turned off, data base is fairly large at over 14 gb but had been up to 18gb with no problems. Any suggestions how to fix this otr why its even happening? Are you running a 3rd party spam filter? I've never heard of Outlook's junk e-mail filter even looking at outgoing messages, much less putting them in Junk E-mail. -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower http://www.rolandschorr.com http://www.officeforlawyers....

FRx calculations #2
I'm not sure how to set this up or if it is a possibility - we have an Frx report with Actual and Budget columns. One section of the report shows the actual and budget for period and YTD. Column B Actual Period Data Column C Budget Data Column D YTD Actual Column E YTD Budget Data In the next section we would like to have the following: Column B Actual Period Data Column C - a calculated budget amount based on a percentage of sales from a row above Column D YTD Actual Column E calculated budget amount as in column C I tried entering the calculated budget amounts on rows at the ...

Conditional Format #2
is it possible to apply conditional formatting to an auto shape. i want the shape to only be visible when a certain cell's conditions are met. i know i can do it with a macro, but i don't have any macros in the workbook rite now and i don't really want one just for this. TIA Spence I can not get this to run automatically but perhaps you could run it after all the calculations. Private Sub Worksheet_Calculate() If Range("B3").Value >= 50 Then ActiveSheet.Shapes("AutoShape 1").Select Selection.ShapeRange.Fill.ForeColor.SchemeColor = 43 S...

Which version of Microsoft Office #2
I've just bought a PC with Windows XP. I need to upgrade Microsoft Office (I had Office '97). Can anyone confirm that to have a version that will run and send/receive emails I'll need Office 2003? Can't get a straight answer from the shop I go to and I don't want to make a mistake. Cheers. Peter To answer your question, and not try to steer you to options you did NOT inquire about, yes, Office 97 is a qualifying product for Office 2000 through 2003. You may want to look at 2003 as it is the latest version of Office and has the longest support available. Offic...

can someone tell me why this isnt working? #2
sorry alison, i know how to do that... look again. =INDIRECT("'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$D$"&'C:\PCS Connection\[Company Discounts.xls]Sheet5'!$A$1) what i'm trying to do, is call the information from column D on Sheet1, but to use the number in Sheet5$A$1 to define the row number from which to call on Sheet1. So if: Sheet5!$A$1 = 7 then i would be calling the information from Sheet1!$D$7 but if Sheet5!$A$1 = 8 then i would be calling the information from Sheet!1$D$8 see where i'm going with this? that way when i go in...

Can't set color in any Office application
I can not set font color in any Office application: Word, Power Point, Excel. I am in 2003 Office version. But also in 2007 i have the same thing. There is the same in WordArt. What may be the reason? Could be a corrupt Office Installation. In Office 2003, try Detect & Repair from the Help Menu and in Office 2007 try Office Diagnostics from any application in Office 2007 suite. hth student25 wrote: >I can not set font color in any Office application: Word, Power Point, Excel. >I am in 2003 Office version. But also in 2007 i have the same thing. There is &g...

VS2008 Framework 3.5 Web Service Accessed from Web 2.0 Client
Hi, I'm wondering if I made a large architectural screwup. I wanted to use new features in VS2008 including LINQ in my web service and have targeted the 3.5 framework with the web service. However, my Windows Forms client targets the 2.0 framework as I don't want my clients to have to download 3.5 All this works nicely in development but trying to deploy to a staging env I experience problems. I've deployed the web service sucessfully to IIS on my local machine and can browse to the service definition using the address below OK. My app.config file contains the reference:...

See internet update for MS Internet Explorer
--tqhunngadh Content-Type: multipart/related; boundary="rgqagsbpxqofsaum"; type="multipart/alternative" --rgqagsbpxqofsaum Content-Type: multipart/alternative; boundary="sogqyokaer" --sogqyokaer Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Partner this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to help protect you...

How to activate compiled HTML Help file using VBA code?
Hi, Can anyone tell me how to activate compiled HTML help file (*.chm) using VBA code in Excel? Or better yet, how to open a help file by clicking an added custom toolbar? I'm hoping that users of my Excel applications can access to the help files by clicking an added custom toolbar. I tried the shell command like the following, neither worked: program="c:\myapplication.chm" taskid=shell(program,1) helpfile="c:\myapplication.chm" shell("start" & helpfile) THANKS A LOT! Charles, Do it like this: Application.Help("c:\myapplication.chm") St...

Upgrade/change license from Office 2008 Home and Student Edition to Office 2008 Standard Edition
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel The product is great for what I have been using personally at home on my new Mac for a while now. Somehow wondering if I want to move my Mac to my workplace for my day-to-day work, do I need to change my license to a standard one (rather than the current 2008 Home Edition). If so, how do I upgrade it? Thanks in advance for any advice. Contact MS customer support: Microsoft Product Support Services 1-866-474-4882; M-F, 5:00 AM - 9:00 PM Pacific Time Or via Mactopia: http://support.microsoft.com/default.aspx?scid=kb;[...

sum negative and positive values separately #2
Hi, I have a time series like this: 1995, -.05 1996, -2.1 1997, 3.6 1998, 4.3 1999, -0.7 2000, -0.08 and I would like to sum just the positive and negative value separately in this way 1995, -2.15 1997, 7.9 1999, -0.78 And I don't know if it is possible, thanks in advance. ...

Displaying several phases of a task on MS Project
Hi, I'm trying to display different phases of a single task on one line in Project 2007. There are over 40 individual tasks on the Gantt chart I am using and each of these will contain separate phases. I would like to represent these phases as bars in a different colour so it's easy to pick out the length of each distinct section of the task (e.g. Planning, Approval, Implementation). Is it possible to do this? Thanks, Richard In article <B087FBC9-60B6-44DA-9A57-CDB06199CC37@microsoft.com>, Richard <Richard@discussions.microsoft.com> wrote: &...

Best solution VBA/C++
Hello I am seeking some advice on the best solution for a small program I have to build. I need to design a program which can be launched in Excel, would acquire some data from Excel, then run some cash flow calculations (so mostly working on multiple small arrays with a lot of conditions and simple calculations) and would run some monte carlo simulations. So basically I need a program which would be fast enough so that I can run my calculations 1,000s of times in a reasonable time, that would have access to a proper random number generator (I guess I have to go for a commercial product for ...

Sheet Reference #2
I have cell 'D8' which contains a formula linked to another sheet ie ='Payroll CC100'!D10. Payroll CC100 is the name of the other sheet. Is it possible to have a formula whereby cell 'C8' ie next to 'D8' indicates the sheet name (ie Payroll CC100) linked to 'D8'. Can anyone help? Have a look in HELP for INDIRECT -- Don Guillett SalesAid Software donaldb@281.com "Etienne Borg" <etienne.borg@go.com.mt> wrote in message news:69ca01c49408$93862db0$a601280a@phx.gbl... > I have cell 'D8' which contains a formula linked to >...

OWA Signatures #2
Hi, I'm attempting to push out email signatures for all my users. What I'd like to know is, can I have a signature generated for all users in OWA? Currently they have to log into OWA, and got to options and manually create a signature, can I automate this and have a standard signature for all my users without manaually configuring it one by one? I'm running Exchange 2003 native mode. Cheers ...

Changing Page Orientation #2
How do I change the page orientation for one page in my Publisher document from portrait to landscape? When I change the orientation, it changes it for all pages. Inserting a section break does not do it either. Select all on the page, group, rotate 90 degrees. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "CPCC" <CPCC@discussions.microsoft.com> wrote in message news:1770E28C-CFD6-4F25-A510-0E1FBC3CC5CD@microsoft.com... > How do I change the page orientation for one page in my Publisher document > from portr...

PF Replication #2
We have migrated NT/Exch 5.5 to W2K3AD/Exch2K3. We have 2 Exchange 2003 servers (clean installs) and are trying to remove the first one (weak transition hardware) following http://support.microsoft.com/default.aspx?scid=kb;en-us;822931. However, we cannot get Public Folders to replicate. "Local Modified" is the status for the replica on the "new" server. It never goes to "In Sync" and the folder does not appear on the "new" server. We've tried pushing with Send Hierarchy and Send Contents also. No events are logged. What are we missing?...

freezing formulas after calculation #2
I've tried manually calculating and it won't work because as I move down the rows it will manually calculate all formulas within sheet. I'm adding information to target cells in which the formula cells are pulling from. Then I need to keep changing the target cells without altering the prior cells calculations. Does this make sense You can do it with macros by setting the range to calculate. Sub ManCalc() With Application .Calculation = xlManual .MaxChange = 0.001 End With Range("H4:H6").Select Selection.Copy Range("F4&quo...

Microsoft Visual C++ Runtime Library Error Message #2
Hi all, Does anyone know how to solve this? When i clicked on any mails in my Outlook 2000, it prompts out this error message (dialog box) saying "Microsoft Visual C++ Runtime Library - Program: C:\Program Files\Microsoft Office\Office\OUTLOOK.EXE. - abnormal program termination." Once I clicked on the OK button, the whole Outlook 2000 just shuts down and I am unable to view any mails at all. Please help!! :( ...

VBA with asp and excel
I wrote a VBA form to manipulate an existing Excel spreadsheet. My manager liked it so much he wanted it put on the web. I used this block of code in an asp page: code: ----------------------------------------------------------- --------------------- <%@ LANGUAGE="VBSCRIPT" %> <% Response.ContentType = "application/vnd.ms-excel" %> ----------------------------------------------------------- --------------------- It was followed by an HTML table with the data and formulas duplicated from my original spread sheet. So far so good. Now my ...

Bill Pay Help #2
I just signed up with Bill Pay and don't understand how to coordinate Bill Pay with my Bills list and checking account. It makes a separate Bill Pay register which I am unable to merge with the checking account register (as Help suggests). Any way to get Bill Pay transactions noted as "paid" in the Bills section AND in my checking account register? One other question, any way for me to find out 2004 financial institutions supported? My bank was not in 2003, and I am generally very unhappy with 2005. Thanks ...

Stock Spinoff
In Microsoft Money 2004 I recently entered a stock spinoff. The program entered the quantity of shares and in the Activity Column as "Add Shares" but the price of the stock was not entered. In order for the program to properly monitor progress of the spinoff I added the price of the stock at the time of spinoff. My Portfolio now shows a Total Return of "NA" and I am sure it is because of the soaring percentage rate of this stock (4,000%) due to the short time period the stock was held. Do I have to wait for the portfolio to show a total return until time reduces this high p...

MacBookPro, Leopard: "Corrupted Fonts" In Microsoft Office 2004
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Hi, My new MacBook Pro does not seem to want to work with my 2004 Office. When I open it it says: "The font "....." is corrupt and should be removed." Now, the "....." does not actually give a font name (or not one I recognize) it says: "�l�r �o�S�V�b�N" or "�l�r �o�aei�" or "�l�r ��i" or "����" or "&#8721;s&#8804;"�'&#8776;�" or one other one but it is Chinese characters so I don't recognize it at all. I tried deleting all the Chines...

how can i retrieve windows version from vba
how can i retrieve windows version from vba ???? Take a look at application.operatingsystem -- HTH RP (remove nothere from the email address if mailing direct) "Alexandre Brisebois (www.pointnetsolutions.com)" <alexandre.brisebois@gmail.com> wrote in message news:1123788637.073126.36450@g49g2000cwa.googlegroups.com... > how can i retrieve windows version from vba ???? > ...