Creating Macros In Excel And Word - A Free Mini-Course
In this two-hour presentation, Paul S. Natanson tells how to create and use macros to automate routine tasks in Excel and Word.
A macro is like a mini-computer program that allows you to record keystrokes and mouse clicks for later playback, thus allowing you to repeat complicated tasks with a single click.
To download drafts of some of the slides, handouts, and demonstrations used in the presentation, click on the links below.
The first link is a MS/Word2003 document (about 94 KB) telling how to create, save, and run macros. The second link is a PowerPoint2003 document (about 232 KB). Note: These two handouts contain different material. Finally, the third link (about 50 KB) is an Excel2003 spreadsheet containing a fun and scary game that shows a less serious side (and less business-like side) of what can be done with macros. (Because it was written in Excel2003, it might not work with older versions of Excel.)
Remember: To open, view, or print the PowerPoint2003 file, you must have either Microsoft's PowerPoint or the free PowerPoint2003 viewer installed on your computer. To get the viewer at no cost, go to http://www.microsoft.com/ and enter PowerpointViewer in the search box.
Paul S. Natanson, P.E. ( Licensed Professional Engineer - Chemical / Environmental )
PSN Custom Software And Computer Programming (PCSACP)
This is the bottom of the page.
Advertisement: This web site was built by PSN using
tools supplied by Homestead.
For more information on our custom business applications and what we can do for you,
call 1-908-630-0406 between 9 AM and 9 PM, Eastern USA time, or send an email.
PSN Custom Software And Computer Programming (PCSACP)
Paul S. Natanson, P.E. ( Licensed Professional Engineer - Chemical / Environmental )
Excel And Word - Tips, Tricks, And Features
This first link goes to an approximately 30-page MS/WORD document which lists more than 100 tips, tricks, and lesser known cool features of WORD and EXCEL in a brief rapid-fire format with just one or two lines about each. The document was used as a handout for a mini-course on this subject in 2006 and deals mostly with the 2003 and older versions.
Paul S. Natanson is also guest contributor to a monthly newsletter for which he writes a feature called "Excel Tips And Tricks". This second link goes to a MSWord2007 document containing some of those articles (including some that have not yet been published).
Posted by PSN in February 2006. Last updated May 16, 2008
OK, this is a bit off topic for posting here, but we thought that our visitors might enjoy it anyway. This MS/Word document, which is also available in a web (.htm) version, contains about 100 web sites that we think are pretty cool.
The list includes sites devoted to games, games, computer help and
property listings, Internet speed testers, job hunting, lottery results,
real estate property values, maps and aerial photos, legal stuff,
salary surveys, medical information, and more.
To view the WORD version of this document, click the link ending in .doc. Or, to view it in your web browser, click the one ending in .htm. Note: If you are using an older version of Microsoft WORD (MS/Word), or not using WORD at all, then you can still view Word2007 files or Word2003 files by going to www.microsoft.com and searching for (and downloading) either the free Word2003 viewer or the free Office2007 compatibility pack.
Posted by PSN in May 2006. Last updated April 2, 2008.
This web page contains downloadable handouts and other materials from some of our training courses and fun presentations.
How To Build A Web Site
This ~10-page MS/Word2003 document gives introductory information
about how to build a web site. It is a copy of PSN's speaking notes from
a presentation on this topic that he has given at several New Jersey computer clubs.
Note: If you are using an older version of Microsoft WORD (MS/Word), or not using WORD at all, then you can still view Word2007 or Word2003 files by going to www.microsoft.com and searching for either the Word2003 viewer or the Office2007 compatibility pack.
Posted by PSN on May 9, 2007. Updated (by PSN) on 9-21-07.
Comparison Of Excel2007 And Word2007 With Older Versions
The new (2007) versions of Excel and Word no longer include drop-down menus or toolbars - and that's just one of many differences (improvements???) between Office2007 and older versions. Paul Natanson has listed some of the differences between Office2007 and earlier versions. Using two computers - one running Office2007 and another running Office2003- Paul compares the two versions and shows some of the new features in Excel2007, Word2007, and PowerPoint2007. This link contains a draft of Paul's speaking notes for that presentation.
Posted by PSN on May 9, 2007. Updated May 16, 2008.
