We've added more courses to our Remote Classroom Schedule! To learn more about our courses and how New Horizons Remote Classroom works, just visit the portal @ http://www.LearnAtNewHorizons.com/RemoteClassroom.

We are happy to answer any questions you have, and as always, if you do not see a course listed on the schedule, just let us know! You can contact us directly or just fill out the form here. We look forward to hearing from you.

Here is the update for July, August, September, October & November 2009.

Start	End	Course Title
7/23	7/24	2276C - Implementing a Microsoft Windows Server 2003 Network Infrastructure Network Hosts
7/23	7/24	Excel VBA
7/23	7/24	Windows SharePoint Services 3.0 - Level 1
7/24	7/24	Excel 2007 - Level 3
7/24	7/24	Project 2007 - Advanced
7/24	7/24	Project Management Fundamentals (Second Edition)
7/27	7/29	2261C - Supporting Users Running the Microsoft Windows XP Operating System
7/27	7/28	2795A - Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services
7/27	7/31	4994A - VB - Introduction to Programming Microsoft .NET Applications with Microsoft Visual Studio 2005
7/27	7/27	5049A - Managing Messaging Security Using Microsoft Exchange Server 2007
7/27	7/29	6158A - Updating Your SQL Server 2005 Skills to SQL Server 2008
7/27	7/29	6214A - Effective Team Development Using Microsoft Visual Studio Team System
7/27	7/29	6417B - Updating your Applications Infrastructure Technology Skills to Windows Server 2008
7/27	7/28	Access 2007 - Level 1
7/27	7/31	Certified Ethical Hacker (CEH)
7/27	7/31	Cisco - Interconnecting Cisco Networking Devices - ICND1
7/27	7/31	CISSP
7/27	7/31	Network+ Certification
7/27	7/27	SQL - Level 1
7/27	8/1	Cisco - Interconnecting Cisco Networking Devices - ICND2
7/29	7/31	6236A - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
7/29	7/31	6417B - Updating your Applications Infrastructure Technology Skills to Windows Server 2008
7/30	7/31	2262B - Supporting Users Running Applications on a Microsoft Windows XP Operating System
7/30	7/31	6215A - Implementing and Administering Microsoft Visual Studio 2008 Team Foundation Server
8/3	8/7	2277C - Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure:
8/3	8/7	2277C - Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure:
8/3	8/5	2791A - Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
8/3	8/5	2792A - Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
8/3	8/5	5047B - Introduction to Installing and Managing Microsoft Exchange Server 2007
8/3	8/5	5115A - Installing and Configuring the Windows Vista Operating System
8/3	8/7	6421A - Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure
8/3	8/7	6425A - Configuring Windows Server 2008 Active Directory Domain Services
8/3	8/5	6460A - C# - Visual Studio 2008: Windows Presentation Foundation
8/3	8/7	Cisco - Interconnecting Cisco Networking Devices - ICND1
8/3	8/7	Cisco - Interconnecting Cisco Networking Devices - ICND1
8/3	8/4	Illustrator CS4 Level 1
8/3	8/3	Project Management Fundamentals (Second Edition)
8/5	8/7	5928A - Microsoft Office Project Server 2007 Managing Projects
8/6	8/7	5116A - Configuring Windows Vista Mobile Computing and Applications
8/6	8/7	50027 - Querying and Processing SQL Server Data Using Microsoft SQL Server
8/6	8/7	5051A - Monitoring and Troubleshooting Microsoft Exchange Server 2007
8/6	8/6	Adobe Captivate 3.0
8/6	8/7	Indesign CS4 - Level 1
8/10	8/15	AXZO Press CompTIA Security+ Certificiation 2008 Edition + CertBlaster
8/10	8/14	2278 - Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
8/10	8/12	2543B - Core Web Application Development with Visual Studio 2005
8/10	8/14	2780B - Maintaining a Microsoft SQL Server 2005 Database
8/10	8/12	2792A - Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
8/10	8/11	5060A - Implementing Windows SharePoint Services 3.0
8/10	8/14	6419A - Configuring Managing and Maintaining Windows Server 2008 Servers
8/10	8/12	6422A - Implementing and Managing Windows Server 2008 Hyper-V
8/10	8/14	6425A - Configuring Windows Server 2008 Active Directory Domain Services
8/10	8/14	Certified Ethical Hacker (CEH)
8/10	8/14	CISSP
8/12	8/14	5061A - Implementing Microsoft Office 2007 SharePoint Server
8/12	8/14	6418A - Deploying Windows Server 2008 (Beta 3)
8/12	8/14	6460A - C# - Visual Studio 2008: Windows Presentation Foundation
8/13	8/14	2544A - Advanced Web Application Development with Visual Studio 2005
8/13	8/14	6438A Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008
8/13	8/13	Cold Fusion 8 - Level 1
8/13	8/14	Windows SharePoint Services 3.0 - Level 1
8/14	8/14	Cold Fusion 8 - Level 2
8/17	8/21	2279B - Planning Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure
8/17	8/18	2547A - Advanced Windows Application Development with Visual Studio 2005
8/17	8/19	2778A - Writing Queries Using Microsoft SQL Server 2008 Transact - SQL
8/17	8/17	5050A - Recovering Messaging Servers and Databases Using Microsoft Exchange Server 2007
8/17	8/19	5118A - Maintaining and Troubleshooting Windows Vista Computers
8/17	8/21	6232A - Implementing a Microsoft SQL Server 2008 Database
8/17	8/19	6236A - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
8/17	8/21	6416B - Updating your Network Infrastructure and Active Directory Technology Skills to Windows Server 2008
8/17	8/21	6420A - Fundamentals of Windows Server 2008 Network and Applications Infrastructure
8/17	8/21	6436A - Designing a Windows Server 2008 Active Directory Infrastructure and Services
8/17	8/19	6461A - C# - Windows Communication Foundation
8/17	8/21	Cisco - Interconnecting Cisco Networking Devices - ICND2
8/17	8/18	Crystal Reports XI Advanced
8/17	8/21	Network+ Certification
8/17	8/17	SQL - Level 1
8/18	8/19	5051A - Monitoring and Troubleshooting Microsoft Exchange Server 2007
8/18	8/18	SQL - Level 2
8/19	8/20	2544A - Advanced Web Application Development with Visual Studio 2005
8/20	8/21	5119A - Supporting Windows Vista Computers with Desktop Images and Application Packages
8/20	8/21	6462A - C# - Windows Workflow Foundation
8/24	8/26	2830B - Designing Security for Microsoft Networks
8/24	8/28	4995A - C# - Programming with the Microsoft .NET Framework using Microsoft Visual Studio 2005
8/24	8/28	50028A - Managing System Center Operations Manager 2007
8/24	8/28	6421A - Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure
8/24	8/25	6431A - Managing and Maintaing Windows Server 2008 Network Infrastructure Servers
8/24	8/28	Certified Ethical Hacker (CEH)
8/24	8/28	Cisco - Interconnecting Cisco Networking Devices - ICND2
8/24	8/26	Microsoft ASP.NET AJAX Using Visual Studio 2005
8/26	8/26	JavaScript Programming
8/27	8/28	50051A - Architecting Microsoft Office SharePoint Server 2007 Portals and Collaboration Solutions
8/27	8/28	6432A - Managing and Maintaining Windows Server 2008 Active Directory Servers
8/27	8/27	Excel 2007 - Level 2
8/31	9/4	2278 - Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
8/31	9/4	2779B - Implementing a Microsoft SQL Server 2005 Database
8/31	9/4	5929A - Managing Projects and Programs
8/31	9/2	6317A - Your SQL Server 2000 Skills to SQL Server 2008
8/31	9/2	6422A - Implementing and Managing Windows Server 2008 Hyper-V
8/31	9/4	6451A - Planning Deploying and Managing Microsoft System Center Configuration Manager 2007
8/31	9/2	6461A - C# - Windows Communication Foundation
8/31	9/4	Cisco - Implementing Cisco Unified Wireless Networking Essentials - IUWNE
8/31	9/4	Cisco - Interconnecting Cisco Networking Devices - ICND1
8/31	9/4	Cisco - Interconnecting Cisco Networking Devices - ICND2
9/1	9/2	Flash CS3 - Level 1
9/1	9/1	Project 2007 - Basic
9/2	9/4	6234A - Implementing and Maintaining Microsoft SQL Server2008 Analysis Services
9/3	9/4	6462A - C# - Windows Workflow Foundation
9/3	9/4	Dreamweaver CS4 - Level 1
9/8	9/10	2793B - Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
9/8	9/10	6424A - Fundamentals of Microsoft Server 2008 Active Directory
9/8	9/9	6463A - ASP.NET 3.5
9/8	9/9	6463A - ASP.NET 3.5
9/8	9/8	Project 2007 - Advanced
9/9	9/10	2439 - Scripting Using Microsoft Windows Management Instrumentation
9/9	9/11	6423A - Implementing and Managing Windows Server 2008 Clustering
9/9	9/9	Acrobat 9.0 - Level 1
9/10	9/11	6464A - Visual Studio 2008: ADO.NET 3.5
9/10	9/11	6464A - Visual Studio 2008: ADO.NET 3.5
9/11	9/11	Project Management Fundamentals (Second Edition)
9/14	9/19	Cisco - Interconnecting Cisco Networking Devices - ICND1
9/14	9/18	2272B - Implementing and Supporting Microsoft Windows XP Professional
9/14	9/18	2779B - Implementing a Microsoft SQL Server 2005 Database
9/14	9/18	6231A - Maintaining a Microsoft SQL Server 2008 Database
9/14	9/18	6232A - Implementing a Microsoft SQL Server 2008 Database
9/14	9/16	6235A - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
9/14	9/18	6425A - Configuring Windows Server 2008 Active Directory Domain Services
9/14	9/16	6434A - Automating Windows Server 2008 Administration with Windows PowerShell
9/14	9/16	Access Programming with VBA
9/14	9/15	Crystal Reports XI Basic
9/14	9/18	Network+ Certification
9/16	9/18	6424A - Fundamentals of Microsoft Server 2008 Active Directory
9/21	9/25	2274C - Managing a Microsoft Windows Server 2003 Environment
9/21	9/25	50031A - Complete .NET 2.0 Security
9/21	9/24	5047B - Introduction to Installing and Managing Microsoft Exchange Server 2007
9/21	9/25	6231A - Maintaining a Microsoft SQL Server 2008 Database
9/21	9/23	6235A - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
9/21	9/25	6419A - Configuring Managing and Maintaining Windows Server 2008 Servers
9/21	9/25	6425A - Configuring Windows Server 2008 Active Directory Domain Services
9/21	9/25	6430A - Planning and Administering Windows Server 2008 Servers
9/21	9/25	Cisco - Implementing Cisco IOS Network Security - IINS
9/21	9/25	Cisco - Interconnecting Cisco Networking Devices - ICND2
9/21	9/25	Computer Hacking Forensic Investigation
9/21	9/21	Illustrator CS3 - Level 2
9/23	9/23	Excellence in Servie: Basic
9/25	9/25	5049A - Managing Messaging Security Using Microsoft Exchange Server 2007
9/28	10/2	2779B - Implementing a Microsoft SQL Server 2005 Database
9/28	10/2	2780B - Maintaining a Microsoft SQL Server 2005 Database
9/28	10/2	2933A - Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006
9/28	9/29	50027 - Querying and Processing SQL Server Data Using Microsoft SQL Server
9/28	10/2	6231A - Maintaining a Microsoft SQL Server 2008 Database
9/28	10/2	Linux+
9/30	10/1	2276C - Implementing a Microsoft Windows Server 2003 Network Infrastructure Network Hosts
9/30	10/1	Photoshop CS4 - Level 2
10/1	10/2	6431A - Managing and Maintaing Windows Server 2008 Network Infrastructure Servers
10/1	10/1	Cold Fusion 8 - Level 1
10/2	10/2	Cold Fusion 8 - Level 2
10/5	10/7	2275C - Maintaining a Microsoft Windows Server 2003 Environment
10/5	10/9	2310C - Developing Microsoft ASP.NET Web Applications using Visual Studio.NET
10/5	10/7	2792A - Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
10/5	10/6	5060A - Implementing Windows SharePoint Services 3.0
10/5	10/7	6426A - Configuring Identity and Access Solutions with Windows Server 2008 Active Directory
10/5	10/9	Cisco - Interconnecting Cisco Networking Devices - ICND1
10/5	10/9	Cisco - Interconnecting Cisco Networking Devices - ICND1
10/5	10/9	CISSP
10/7	10/9	5061A - Implementing Microsoft Office 2007 SharePoint Server
10/7	10/9	6158A - Updating Your SQL Server 2005 Skills to SQL Server 2008
10/8	10/9	2276C - Implementing a Microsoft Windows Server 2003 Network Infrastructure Network Hosts
10/8	10/9	6428A - Configuring and Troubleshooting Windows Server 2008 Terminal Services
10/8	10/9	Organizational Behavior
10/12	10/12	Excellence in Service: Advanced
10/12	10/16	2277C - Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure:
10/12	10/16	2780B - Maintaining a Microsoft SQL Server 2005 Database
10/12	10/14	2791A - Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
10/12	10/16	6425A - Configuring Windows Server 2008 Active Directory Domain Services
10/12	10/14	6427A - Configuring and Troubleshooting Internet Information Services in Windows Server 2008
10/12	10/16	Building Cisco Multilayer Switched Networks (BCMSN)
10/12	10/16	Certified Ethical Hacker (CEH)
10/14	10/16	6436A - Designing a Windows Server 2008 Active Directory Infrastructure and Services
10/15	10/16	2934A - Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006
10/19	10/23	2272B - Implementing and Supporting Microsoft Windows XP Professional
10/19	10/21	2793B - Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
10/19	10/23	4994A - VB - Introduction to Programming Microsoft .NET Applications with Microsoft Visual Studio 2005
10/19	10/23	6232A - Implementing a Microsoft SQL Server 2008 Database
10/19	10/21	6426A - Configuring Identity and Access Solutions with Windows Server 2008 Active Directory
10/19	10/23	6430A - Planning and Administering Windows Server 2008 Servers
10/19	10/23	Cisco - Interconnecting Cisco Networking Devices - ICND2
10/21	10/23	2278 - Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
10/26	10/30	2279B - Planning Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure
10/26	10/30	2310C - Developing Microsoft ASP.NET Web Applications using Visual Studio.NET
10/26	10/30	2780B - Maintaining a Microsoft SQL Server 2005 Database
10/26	10/30	50028B - Managing System Center Operations Manager 2007
10/26	10/30	6231A - Maintaining a Microsoft SQL Server 2008 Database
10/26	10/30	6417B - Updating your Applications Infrastructure Technology Skills to Windows Server 2008
10/26	10/30	6451A - Planning Deploying and Managing Microsoft System Center Configuration Manager 2007
10/26	10/30	Cisco - Interconnecting Cisco Networking Devices - ICND1
10/26	10/30	CISSP
10/26	10/30	Project Management Professional Certification
11/2	11/6	Cisco - Interconnecting Cisco Networking Devices - ICND2

You’ll want your website visitors to stick around and read the great information on your web page. But if the text isn’t legible, they won’t have the patience to stay. Use our typography tips to increase your site’s appeal.

Note: All images referenced in this article can be viewed @ http://bit.ly/tyqqt

Because it’s so easy to set fonts, background colors, and other formatting with CSS, some developers forget to choose this formatting carefully for legibility. Of course, it doesn’t matter how pretty the text looks if the reader can’t read it and leaves your site in disgust.

To make judging legibility even trickier, many developers don’t see the full text that will appear on the site, since the server-side code may generate it automatically. While a few test words on the site may look okay, bad formatting can cause readers to struggle while attempting to read whole paragraphs. To avoid these kinds of mistakes, it pays to know a few readability principles.


Key rules for readability

Readability refers to the ability to read all the text added to a web page. It’s much harder to read text onscreen than in print, so special considerations are required. For starters, consider the following guidelines:

• Don’t size text too small or too large.
• When possible, avoid specifying absolute font sizes, since they may prevent readers from making the text larger through their browser options. For example, fontsize: 1.5em is better than fontsize: 15px.
• Avoid overuse of type styles (e.g., bold, italic, all caps). A long paragraph in italics, for example, can be difficult to read.
• Don’t contradict common web practice in your use of type styles. For instance, avoid using colored, underlined text for anything that’s not a hyperlink.
• Be careful about placing text on a colored background.
• Choose common fonts that are easy to read on the web.

Choose appropriate fonts

Let’s take a closer look at font choice. Two key rules apply here:

• Some fonts that are good when you print a document aren’t so great online. Often, the difference comes from subtle character spacing issues. So once you find a font you like, try out several similar ones on the screen. You can use the CSS font-family property to specify your first, second, and third (etc.) choices.
• Sans serif fonts are usually easier to read than serif fonts, and they tend to look bigger. This is one good reason to specify some fonts in your style code, since browsers often default to serif fonts.

Tip: Avoid mixing serif and sans serif fonts; the transition between reading such different types of fonts can slow down a reader.

Not all sans serif fonts are created equal

Just because a font is sans serif doesn’t guarantee legibility. And while the fancier fonts may look great in titles, they can be hard to read in paragraphs. Let’s see what happens when we take even a great piece of text and put it onto a website with a poor font choice. We’ll make a CSS declaration specifying the Impact font (or any sans-serif font if the client machine doesn’t have Impact):

See page 6: http://bit.ly/iCFJt

Even great words lose impact with the wrong font

We’ll now apply this style to an excerpt from a famous speech Lincoln gave in October, 1854:

See page 6: http://bit.ly/iCFJt

Apologizing to the great Lincoln in advance, we see that the results, as shown in Figure A, demonstrate that even the most cogent text in the world is virtually unreadable in the wrong font. Even if you find it not bad reading once you get into it, the mere appearance of such a font can intimidate readers from reading it at all.

More legible alternatives

Perhaps a better choice is to stick with a system font, such as Geneva (Mac) or Arial (Windows). These fonts aren’t only easier to read onscreen, but are also more likely to be installed on the user’s computer, thus reducing the risk of font substitution.


Be careful with colored backgrounds

Another area that’s important to watch out for is the colored background. As with most things on the web, less is more. Simply put, it’s hard to beat black text on a white background (or some shade of white) for legibility.

Certainly, depending on your site’s theme and purpose, you can still get satisfying results with other color combinations, as long as the contrast is adequate. And, in some cases, a client may demand a particular color scheme.

The trick to text on color: Make it bigger

One of the problems with any colored background is that it tends to make the text look smaller — especially if the text color is lighter than the background. For instance, suppose we apply the following style definitions to a page:

div {padding:1em;}
.withcolor {background-color:#880088; color:#00FF00;}
.bigger {background-color:#880088; color:#00FF00; font-size:1.3em;}

While the result in Figure B is okay in print, the second block of text is hard to read onscreen and looks surprisingly small — as if the text is dissolving into the color around it. The final block of text uses a larger font size to help overcome the readability problems caused by the background color.


Break up the text

Choosing the right font and size with which to format text is just the beginning. Also consider the way in which you place text on a web page. As a rule, it’s easier to read text that’s in narrow columns, rather than long rows that span the entire width of the page.

Create a column effect without multiple columns

Of course, this rule creates a little of a dilemma: You certainly don’t want readers to have to scroll up and down the website to read the sort of multiple column layout you’d see in the newspapers. That’s probably why such layouts aren’t as popular as they were a few years ago. However, you can still keep text from going all the way across. The one danger here is that this sort of formatting may not come out on a printer, which is why The New York Times offers a button to see a printer-friendly page.

Keep paragraph size small

A related issue is the size of the paragraphs. If you’re involved in writing any of the actual text for the web page (e.g., instructions for a web application), favor short paragraphs over long ones that seemingly never end. Otherwise, readers may lose patience and not even read what you wrote.

Don’t let your code get rid of all the white space either

Similarly, if your web application reports on data that users have entered, don’t get rid of all the white space. Some applications trim every bit of white space out of a string of text, assuming that every line break or indent is wasteful. In some instances, developers fail to encode text entered as a line break as an HTML break <> . The result is large blocks of impenetrable text.


Design for legibility

Even using techniques to increase text readability doesn’t guarantee the content will be entirely legible. Legibility has to do with the overall design of text on the page. The goal is to format and position the text so it’s easy for viewers to recognize the hierarchy of the content.


A matter of purpose

You’ll probably notice that some sites deliberately seek to be disorderly, jarring, or even annoying. Glitzy, flamboyant sites, may work as part of marketing strategy, or to appeal to specific audiences. But if your goal is to impart information, your best bet is usually to create an orderly page.

You don’t have to be a fancy web developer to take advantage of Flash animations in your PowerPoint presentation. We’ll show you how it’s done.

Note: All images referenced in this article can be viewed @ http://bit.ly/tyqqt

In a world in which it’s rare to see a static web page — yet common to see a boring slideshow— it’s likely that your website designers have some Shockwave Flash File (SWF) animations that you can snag to add some zip to your PowerPoint presentations. We’ll show you how to insert and take charge of them, as shown in Figure A, so they work perfectly and are at your disposal.

Prepare PowerPoint to use SWF files

Before you can insert or control SWF files, you need to ensure that PowerPoint is set up to handle the format. If it isn’t, you can easily download the controls you need.

To determine whether you can use SWF files:

1. Open PowerPoint to the slide on which you want to insert your Flash file.
2. Select View Toolbars Control Toolbox. (In 2007, go to the Developer tab’s Controls group. If you don’t see a Developer tab, click the Office button, click PowerPoint Options, and in the Popular section, select the Show Developer Tab In The Ribbon check box.)
3. Click on the More Controls icon to expand the list of available items.
4. Scroll down and look for the Shockwave Flash Object, as shown in Figure B.
5. If it’s listed, you can skip to the next section. If you don’t see the control, visit www.adobe.com/products/flashplayer and download the free player.

You may have to close and reopen PowerPoint to activate the control. If you’ve updated Shockwave from a previous version, you may have trouble getting a SWF movie to play. See the Adobe TechNote article at www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_12727 to fix the problem.

Plan your file’s resting place

Now that PowerPoint is able to play SWF files, you must decide where to store the file permanently.

• If you plan to play your presentation at various locations, you can store it on the web and link to it there.
• On the other hand, if you want to use the presentation solely on your computer, simply place it in a folder and use that path.
• You can also embed the file, which increases the PowerPoint file’s size, but avoids the need to keep track of multiple files.

Whichever method you choose, note the path to your SWF file.

Insert the Flash file

Inserting a Shockwave Flash Object is straightforward. Just navigate to the slide on which you want the object to appear, and follow these steps:

1. Once again, click on the More Controls icon on the Control Toolbox toolbar and select Shockwave Flash Object, as shown in Figure B.
2. When the pointer changes to crosshairs, click and drag a rectangle to house your SWF movie. (You can resize it later.)
3. Right-click on the placeholder that appears, and select Properties. Click on the Alphabetic tab if necessary.
4. Note the text shown in the (Name) property text box — you’ll need it later. For instance, ours is ShockwaveFlash1.
5. Set the Playing property to False by selecting it from the dropdown list.
6. Click in the Movie property field and enter the URL or pathname for the SWF file you wish to insert, as shown in Figure C.
7. Close the Properties sheet and view your slideshow to ensure the movie plays correctly.

At this point, you may wish to embed your movie. To do so, simply reopen the Properties sheet, set the EmbedMovie property to True, and then close the Properties sheet.

Take control of the SWF playback

Now that your movie is in place, you can allow it to play as soon as your slide displays by setting the Playing property to True. However, if you want more control over the movie, you can add a bit of Visual Basic script and a few colorful buttons that allow you to Play, Rewind, or Pause your movie. This can really come in handy when you need to address an audience question or replay the movie a second time.

I can’t control my movie!
Some versions of Flash allow developers to disable the play, pause, and rewind navigation commands. If you use a movie file secured in this manner, the action buttons described in this article won’t work. If you know the Flash developer, however, you can request a navigable version of the file.

Let VB code do all the work

To create seamless navigational controls for Flash movies in PowerPoint, you need to enter a few lines of VB code into the Visual Basic Editor (VBE).

1. Choose Tools Macro Visual Basic Editor (or press [Alt][F11]) to launch the editor. (In 2007, go tothe Developer tab and click Visual Basic in the Code group or use the shortcut key.)
2. In the VBE, choose Insert Module and type the code in Listing A into the new module.
3. Replace all instances of SlideX with the number of the slide on which you’ve inserted your movie(for instance, Slide2, in our sample presentation).
4. Replace all instances of ShockwaveFlashName with the name of your Shockwave Flash Object we noted earlier. (We used ShockwaveFlash1.)
5. After you enter the code, save your work and close the VBE.

Each Sub line creates and names a new macro that you’ll use later to make your movie play, pause, or rewind on command. For instance, Sub PlayShock() created a macro named PlayShockthat, when activated, plays your ShockwaveFlash1 movie.

Check your macro security settings: The VB code creates macros that PowerPoint may block depending on your current security settings. To adjust them, select Tools Macro Security. (In 2007, go to the Developer tab, and in the Codegroup, click the Macro Security button.)

Create the control buttons

With the code in place, all that’s left to do is to create the control buttons on our slide and assign the appropriate code to each one.

1. On your movie slide, select Slide Show Action Buttons.
2. Select Action Button: Custom button (the blank square).
3. Click and drag a rectangular button on your slide where you want the Play button to sit. When you release the mouse button, the Action Settings dialog box appears.
4. On the Mouse Click tab, select Run Macro, and then select PlayShock from the Run Macro dropdown list and click OK.
5. Right-click on the button you just created and select Add Text.
6. Enter Play and click away from the button.
   

Adapt for PowerPoint 2007: In 2007, you need to insert a shape for your action button first; just go to the Insert tab, click the Shapes button, select a shape you want to use, and then click and drag theshape onto your slide. Then you can select the shape and click the Action button in the Insert tab’s Link group to open the Action Settings dialog box. From there, you can set up your macro to run just as you would in earlier versions.

Your button is ready to use, but you may wish to format it to match your slide. Right-click on it and use the Format AutoShape dialog box to change its appearance. Our finished button is shown in Figure D.

Repeat the process for the PauseShock and RewindShock macros. When you’ve finished, you should have three buttons on your slide, as shown in Figure A. Now, when you run your slideshow, you can use the buttons you just created to play, pause, and rewind your movie to your heart’s content.

We’ve already told you that New Horizons is going to be at Cisco Live in booth #1243.

But we’ve added a little something extra just for our followers on Twitter. When you follow us @NHCisco you’ll be eligible to win a Free Wii!

So follow us today and we’ll tweet about how to enter the drawing for a Free Wii from New Horizons.

Here’s the fine print:

• One entry per day per account. One bonus entry per day per account may be earned.
• Winner must follow @NHCisco in order to be eligible for the drawing on Thursday, July 2, 2009.
• Enter Monday, June 29 through Wednesday, July 1.
• Open to residents of US & Canada only.

So start following us now @NHCisco to find out all about how to win your Free Wii from New Horizons!

JULY

Tips & Tricks for Microsoft Office 2007, PowerPoint and Excel
Explore how Excel 2007 takes advantage of a new, results-oriented user interface that provides easy access to powerful productivity tools, offers a larger workspace, and delivers faster performance. See how to quickly create pivot Tables and Charts to better analyze you information, while still creating easy to read & use spreadsheets. Additionally, discover the synergy of working with Microsoft PowerPoint 2007 to present and deliver your information to your audience with presentation tools that allow you to paint a picture of what you need to convey.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, July 8, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Register: http://bit.ly/Ur1Z

Creating Complex Documents with Microsoft Word 2007
Creating Complex document with Microsoft Word 2007 Get informative tips to help you create better Microsoft Word 2007 documents more easily than ever before, and learn why the less work you do, the better your Microsoft Office Word documents will be. Witness how Microsoft SharePoint Services enhances the collaborative process. See the options available to streamline the creation of your documents and learn how to share this with other Word users, 2007 & previous.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, July 22, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Register: http://bit.ly/Ur1Z

AUGUST

Collaborating with Microsoft Office 2007 using Microsoft SharePoint Services
See how enhancements in Microsoft Windows SharePoint Services 3.0 and Microsoft Office 2007 make it easier than ever to share documents, track tasks, use e-mail efficiently and effectively, and share ideas and information. Discover the tools to create Team Sites, Document libraries, and meeting sites with Microsoft SharePoint Services.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, August 26, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Register: http://bit.ly/Ur1Z

ENROLL in all New Horizons Webinars at: http://bit.ly/Ur1Z

We've added more courses to our Remote Classroom Schedule! To learn more about our courses and how New Horizons Remote Classroom works, just visit the portal @ http://www.LearnAtNewHorizons.com/RemoteClassroom.

We are happy to answer any questions you have, and as always, if you do not see a course listed on the schedule, just let us know! You can contact us directly or just fill out the form here. We look forward to hearing from you.

Our Excel article shows you which functions to use when you want to count data that you’ve already filtered. To view the graphics to the table references in this article, please view the pdf document located here.

If you’ve ever tried to count the number of rows in your data table, you might have felt frustrated when you filter the data and realize your row count remains the same. Even when you filter the data, your count might still include the entire data table — especially if you use the COUNT function. Instead, we’ll show you how the SUBTOTAL function can give you the accurate total you need. Your SUBTOTAL formula will update with your filtered data — whether you’re working with text or numeric data.

Cast out the COUNT function

The COUNT function comes in handy when you’re dealing with numeric data, but it doesn’t play well with filtered data. First, the COUNT function only recognizes numeric data. If you include text data in the COUNT function’s range, the formula won’t recognize the text data. If your data range only includes numeric data, the COUNT function includes every row — even rows hidden when you filter the data.

Even the COUNTA function, which recognizes both text and numeric data, still includes hidden filtered rows in its final tally.

To illustrate these functions’ failings, take a look at our comparison table in Figure A. Our data includes 12 months of expense and revenue data. We’ve filtered the data to show the five months with the highest expenses. So, logically, our row count should equal five. But even when we include different ranges — the entire data table, a column of text data only, and a column of numeric data only — none of the COUNT or COUNTA functions give us the correct result.

Adapt for Excel 2007

The SUBTOTAL function works the same way in Excel 2007 as it does in earlier versions. The only difference is that Excel 2007 allows up to 254 ref arguments (ranges to include in the SUBTOTAL formula) whereas earlier versions allow only 29 arguments.

Important:
Note that when you include the entire data table in your COUNT or COUNTA function’s range, the formula counts every cell. If you want to count the number of rows in your filtered data table, you should only include one column of the data range in your formula.

Get the right results with the SUBTOTAL function

Don’t despair! The SUBTOTAL function can give you the accurate row count you need for a filtered data table. The SUBTOTAL function follows this syntax: =SUBTOTAL(function_num, ref1, ref2, . . .) The ref1 and ref2 arguments represent any ranges or references you want to include in the subtotal. You can add up to 29 ref arguments, and they should include columns — not rows. The SUBTOTAL function is designed for columns, according to Microsoft.

The function_num argument represents the function you want Excel to use when it subtotals the data in your ref ranges. We’ve listed all of the available functions and their function_num equivalents in Table A.

Learn how hidden data factors into the equation

Table A includes function_num values that both include and exclude hidden values. You might assume that filtered data includes hidden data — after all, the AutoFilter does its job by hiding rows that don’t fit your chosen criteria. But Excel doesn’t consider filtered data “hidden” in this case. When it comes to the SUBTOTAL function, hidden data refers only to rows that you hide by choosing Format Row Hide from the menu bar (or right-clicking on a row number and choosing Hide from the shortcut menu).

So in most cases, it won’t matter which set of function_num values you use for filtered data. But if your data table does include rows you’ve hidden manually, pay attention to whether you want to include those hidden rows in your SUBTOTAL results.

Choose the right function_num value

For our purposes, we’ll need to use either the COUNT or the COUNTA function to count the number of rows in our filtered data. We’ve updated our comparison table to include SUBTOTAL formulas that use COUNT and SUBTOTAL formulas that use COUNTA.

When you use a range that includes column B, which contains numeric data, you can use COUNT with SUBTOTAL for an accurate row count. You can also use COUNTA in this case because COUNTA recognizes both numeric and text data. But when you use a range that includes column A, which contains text data, the COUNTA function_num argument gives you an accurate count. For text data, you can’t use the COUNT function.

For this reason, if you’re counting data that doesn’t contain consistent formatting (such as dates), the COUNTA function_num is your safest bet.

Watch your data flex

When you change the filter on your data range, watch your SUBTOTAL formula’s results update to match the new row count. While using the COUNT or COUNTA functions alone give you the wrong results, the SUBTOTAL function works.

To view the graphics to the table references in this article, please view the pdf document located here.

Business skills for the new world of work

In business today, productivity is key to your success. Whether that means setting up projects for success, forecasting and analyzing trends, or managing critical business information, it is vital that you have the skills to work at peak performance. You already know how to use Microsoft® Office System applications. New Horizons offers Microsoft Business Skills Series Courses to teach you how to use those applications to more efficiently manage, work with, and prioritize information to make better decisions.

Go to www.NewHorizons.com/ for information on courses that cover topics such as:

• 4002 Forecasting and Trend Analysis Using Microsoft Office Excel 2003
• 4004 Managing Critical Business Information Using Microsoft Office Access 2003
• 4008 Building Better Microsoft Office Word 2003 Documents In Less Time
  

Related Course

• Excel 2007 - Level 3

Conshohocken, PA U.S.A. – June 8, 2009 – New Horizons Computer Learning Centers announced today that it is the recipient of a Cisco Partner Summit theatre award for Learning Partner of the Year. Cisco unveiled the winner on June 2nd at its annual partner conference in Boston.

“I have the honor and privilege of recognizing New Horizons Computer Learning Centers as a Cisco Partner Summit regional award winner," said Wendy Bahr, senior vice president, U.S. and Canada channels at Cisco. “The Learning Partner of the Year recognizes New Horizons’ performance and accomplishments as a Cisco channel partner in US and Canada in 2008.”

“We believe Cisco to be a very important partner for New Horizons around the world. Throughout the year, our primary goal has been to deliver the highest quality Cisco training to our students. We look forward to growing and expanding our partnership with Cisco and it is an honor to be recognized for this esteemed award on behalf of all New Horizons Centers,” commented Mark A. Miller, President and Chief Executive Officer of New Horizons Worldwide.

Cisco Partner Summit awards are presented at three levels: regional, theater and global. Cisco Partner Summit U.S. and Canada theater awards reflect a partner’s performance across the United States and Canada.

About New Horizons Computer Learning Centers
With over 300 centers in 60 countries, Conshohocken, Pennsylvania-based New Horizons Worldwide, Inc. (OTC Bulletin Board: NEWH) is the world’s largest IT training company. Through an integrated learning approach that ensures that new knowledge can be applied to real life situations, New Horizons delivers a full range of technology and business skills training from basic application and desktop productivity tools to complex and integrated business systems. New Horizons continues to expand its offerings, locations, and solutions to meet the growing demands placed on organizations and their employees. For more information, or to find a local New Horizons Computer Learning Center, visit www.newhorizons.com.

Cisco, the Cisco logo, and Cisco Systems are registered trademarks of Cisco Systems Inc. in the United States and certain other countries.

Smart companies will take advantage of this training and software offer!

Expert IT training and certification are more important than ever in a tough economy, because they can help companies boost productivity and get the most from their technology investments.

A recent IDC Performance Impact Study* found that teams that met most or all of their objectives typically had twice the amount of training as teams that achieved only partial success.

Take advantage of this great offer to get up to speed and certified on Microsoft SQL Server technology, plus get a free copy of the software so you can gain hands-on experience.

Click here to download the SQL Server 2008 certification path flyer and Promotion Details >>>

How to get this offer: Enroll in and attend any one of the following eight Microsoft SQL Server 2008 courses before SEPTEMBER 30, 2009 (while supplies last), and you get a fully licensed copy of Microsoft SQL Server 2008 Standard Edition with one client access license (CAL).

Get best-in-class training and build outstanding skills when you train with Microsoft Certified Partners for Learning Solutions.

Act now! This free software offer is available for a limited time, and only while supplies last, so enroll today in New Horizons SQL Server 2008 Training near you!

More from Microsoft >>>

The many benefits of Microsoft Certification, as articulated by real Microsoft Certified Professionals (MCPs), who share their own certification experience, and the positive impact that it has had on their careers.

Press play to view the video below, or click here to open the video in a new window.

New Horizons Computer Learning Centers conducts more Microsoft technical training and Microsoft Certification than any other company.

According to a study conducted by Applied Research Consultants, 90% of Microsoft Certified Professionals (MCP's) said certification was extremely useful in their work. In another study, managers and supervisors felt their MCP’s were significantly more competent than non-certified employees. This is valuable proof certification means increased knowledge and enhanced credibility.

New Horizons is among the largest networks of Microsoft Gold Certified Partners for Learning Solutions and Microsoft Certified Partners for Learning Solutions (CPLS) in the world. We provide courses to thousands of students each year - more than any other company. Every course follows the Microsoft Official Curriculum and is taught by a Microsoft Certified Trainer.

• View New Horizons Remote Classroom Courses
• Search New Horizons Courses
• Learn more about Microsoft Certification

Visit http://www.LearnAtNewHorizons.com/RemoteClassroom to view the newly updated New Horizons Remote Classroom Schedule, Orientation Video, Online Training Resources and more!

Eliminate your commuting challenges with New Horizons Remote Classroom! Stay home and log-in - you'll remain an interactive student with your own designated seat and computer in our on-site classroom.

Remote Classroom offers students the flexibility of taking courses from a remote location, with LIVE video and audio participation integrated with our Classrooms & Instructors. This makes it even easier for you to get the course you want, when and where you need it.

New Horizons can enroll one student or an entire group of students in our online Remote Classroom courses, and virtually any course we provide through our Instructor-Led Classroom curriculum can be delivered to you through our Remote Classroom.

Want to learn more? Just submit your information via the short form located on the Remote Classroom Portal Page @ http://www.LearnAtNewHorizons.com/RemoteClassroom/index.html#contact and we'll get you the information you need to see if Remote Classroom fits your training needs.

When you’re working with a team, you value everyone’s input. But trying to consolidate two versions of the same document often means overlooked changes or a final document riddled with mistakes. The Compare And Merge Documents feature from Word 2003 and earlier lets you combine two versions of the same document into one file, marking each user’s changes just as if they’d used the Track Changes feature. But you can’t view the original documents simultaneously, and with so many changes you might leave some edits unresolved. Let’s look at how Word 2007 improves on the previous Compare And Merge Documents feature.

Refresh your memory

The Compare And Merge Documents feature from the pre-2007 era did prove helpful for getting two versions of a document into one final, polished document. You just had to select Compare And Merge Documents from the Tools menu, select the documents you wanted to merge, and Word created a combined document with its differences marked up like tracked changes (even if the two documents didn’t use the Tracked Changes feature).

The feature’s major limitation was its inability to let you review either of the two original documents. If you wanted to double- check one of them, you had to open the document separately or try to arrange it in one window using the Compare Side By Side feature. And if you wanted to view both original documents and the merged document — forget it. Plus, with so many changes in one document — some of them conflicting changes — you can easily overlook some changes and mar your final version. Word 2007 gives you more control over what you view onscreen and adds a Reviewing pane, which lists all of a document’s revisions in a panel you can view simultaneously. As a result, you can even view your combined document, its two original source documents, and the Reviewing pane, all at once.

Compare vs. combine
You must decide whether you need to compare documents or combine them. Compare documents when you don’t want to make changes or consider input from multiple users; you just want to see how two versions of one document differ. Combine documents when you want to consolidate two documents edited by more than one user and reconcile the changes.

Compare two versions of the same document

In Word 2003 and earlier, you can choose to compare documents without merging them, called a legal blackline. Word 2007 also offers you this option in the case where you don’t want to compare changes from several users — you just want to compare two versions of a document to see what differences lie between them.

To compare two documents without combining them:

1. Launch Word 2007 and select the Review tab.
2. Click the Compare button in the Compare group and choose Compare from the resulting dropdown list.
3. In the Compare Documents dialog box, select Browse from the Original Document dropdown list and navigate to the first version of your document in the Open dialog box.
4. Select the document and click Open to add it to the Original Document dropdown list.
5. Follow steps 3 and 4 to add your second version of the document to the Revised Document dropdown list.
6. Click the More button to further specify your comparison settings.

Note: Any documents open in Word when you use the Compare feature, along with documents from your Recent Documents list, will display automatically in the Original Document and Revised Document dropdown lists. You might not need to browse for your document, so check the dropdown list’s choices first.

Handle existing tracked changes

Ideally, if you’re comparing documents (as opposed to combining them) neither document should include tracked changes. If one or both of your documents includes tracked changes, Word displays a dialog box warning you that, for the purposes of comparison, Word will consider the changes as accepted. Click Yes if you want to continue or No to cancel the comparison.
Keep in mind that letting Word accept the changes for the comparison doesn’t affect the original document. The comparison opens as a new, unsaved document (unless you’ve changed this preference in the Compare Documents dialog box’s Show Changes section).

View more comparison information

By default, once you compare your original document with the revised document, Word displays one new document. Word marks only the changes that signify how the revised document differs from the original document.

If you want to view one or both source documents, click the Show Source Documents button in the Compare group of the Review tab. Select either Show Original, Show Revised, or Show Both from the resulting dropdown menu. If you view one additional document, it displays in a vertical panel to the right of your comparison document. If you view both documents, the right panel splits into two panels. You can dismiss any of the documents at any time by clicking the Close button in the upper-right corner.

Combine two edited documents

While earlier versions of Word included comparing and merging in one, overarching feature, Word 2007 separates them, giving you more flexibility. If you have two documents that different users have edited using the Track Changes feature, you’ll want to consolidate those changes into one document for easier review. Instead of comparing those documents, you’ll want to combine them.

To combine two documents with tracked changes:

1. Go to the Review tab and, in the Compare group, click the Compare button.
2. Choose Combine from the dropdown list.
3. In the Combine Documents dialog box (which looks identical to the Compare Documents dialog box), select Browse from the Original Document dropdown list and navigate to the first version of your document in the Open dialog box.
4. Select the document and click Open to add it to the Original Document dropdown list.
5. Follow steps 3 and 4 to add your second version of the document to the dropdown list.
6. Click the More button to further specify your comparison settings.

Tip: You can change the name attributed to each document’s unmarked changes.
Enter new text in the Label Unmarked Changes With text box.

By default, Word displays the username of the document’s existing tracked changes. Unlike the Compare feature, when you click OK to combine two documents, Word splits your window to show the combined document, the two original source documents, and the Reviewing pane.
You can dismiss any of these areas if you don’t need them in view. Or, you can modify what changes the documents show using the options in the Tracking group of the Review tab. For example, to view the document without marked changes, just choose Final from the Display For Review dropdown list.

More than two documents?
Word 2007 can only combine two documents at a time. So what if you have four reviewers who have all given you their edits for the same document? Combine two of the documents and save the result. Then, combine the resulting document with the third document, and so on.

Never miss an unresolved change

The Reviewing pane in particular boosts Word’s editing capabilities. A summary at the top of the reviewing pane tells you the number of unresolved changes in the document, along with breaking down that number into the type of change: insertions, deletions, moves, formatting, and comments.

As you’re reviewing changes and accepting or rejecting them, The Reviewing pane updates this information automatically. But if you want to force an update, you can click the Update Revision Count button at the top of the Reviewing pane.

You can also display the Reviewing pane horizontally instead of its default vertical display. Just click the Reviewing Pane button’s dropdown list in the Tracking group. Select Reviewing Pane Horizontal from the dropdown list. Now your Reviewing pane spans horizontally along the bottom of your screen.

Now you can save your combined document as a new document, keeping your two original documents intact.

We often hear that network security is a multi-layered or multi-level concept, but exactly what are the specific layers? Moving from the most abstract to the most specific, we define the major levels of network security as:

• Policy level.
  This is all about planning, strategy, and decision-making. At this level, you define the organization’s security needs and make rules designed to meet those needs.
  
• Physical level.
  This pertains to the physical security of your network’s components. It includes the obvious—physically controlling access to workstations, servers, and network devices such as firewalls, routers, and switches. It also includes preventing unauthorized persons from obtaining physical possession of or access to the network cable (or, in the case of wireless networking, airwaves). Finally, it involves protecting network information that’s in hard copy form, such as written password lists and network diagrams, as well as smart cards, tokens, keys to removable hard disks, backup tapes, CDs, and anything else that pertains to your network.
  
• Perimeter level.
  This involves stopping unauthorized persons or data from entering your local network from across the internet, through the phone lines, or other outside locations. The most obvious manifestation of perimeter security is the firewall, but it also includes network access controls in the form of logon authentication, intrusion detection systems, network-based anti-virus systems, network-based spam filtering, remote access quarantine controls and similar methods of keeping undesirable packets out of the network.
  
• Host level.
  This includes security mechanisms designed to protect individual systems, such as host-based firewalls like the Windows firewall, host-based IDS and anti-virus programs, client-side spam filtering programs, operating system hardening and security patches, and securing individual applications.
  
• Data level.
  This pertains to security of the data stored on your computer or sent across the network, and includes encryption technologies such as NTFS file level encryption, third-party disk/partition encryption, and IPsec encryption to protect data in transit. It also includes folder and file level access controls such as Windows share and file permissions.

By implementing security at multiple levels (preferably at all of the levels listed), you avoid the dangers of a single point of failure when it comes to protecting your network.

APRIL

Introduction to Tips & Tricks for Microsoft Office 2007 (Level 100)

Get the most out of the Microsoft Office 2007 System. As someone beginning to use Microsoft Office 2007, you will learn about new features and timesavers to help you in your day-to-day work. This session is good for beginner, intermediate, or advanced users – everyone will learn something! The Microsoft Office System has evolved from a suite of personal productivity products to a more comprehensive and integrated system. This presentation will demonstrate useful tips and tricks for Outlook, Word, Excel and PowerPoint.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, April 15, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Click here to register: www.newhorizons.com/webinars

Tips and Tricks for Maximizing Outlook 2007

Attend this webinar and witness how Microsoft Office Outlook 2007 delivers the functionality to provide better information sharing including publishing and sharing calendars, and exporting Outlook data. Also, see how Outlook 2007 can be configured using settings, trust, add-ins, and customized appearance and content. In this session, we also provide a better under standing of some of the terms used for communications and the capabilities; see Really Simple Syndication (RSS) versus XML, phishing, signatures, and other useful features of Outlook 2007

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, April 22, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Click here to register: www.newhorizons.com/webinars

MAY

Intermediate Tips & Tricks for Microsoft Office 2007 (Level 200)

Get even more out of the Microsoft Office 2007 System. As someone who has worked with the Microsoft Office system for some time, you will discover efficient ways to configure, customize and utilize Microsoft Word, Excel and Outlook to get the most out of Microsoft Office. The presentation will demonstrate useful tips and tricks for Microsoft Outlook, Word and Excel. In addition, you will see useful ways to interact between these Microsoft applications.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, May 6, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Click here to register: www.newhorizons.com/webinars

Introducing Microsoft Windows Vista® for Microsoft Office 2007 Users (100)

This webinar introduces to those familiar with Microsoft Office the features of Microsoft Vista that best suits them. You will see the advantages of using Windows Vista and Office together including better file origination, starting programs, search, communication, and Internet navigation. Get tips & tricks to better share and find your files, discover the consistency of search capabilities throughout Windows Vista, and navigate the new features of Internet Explorer. From this session, you’ll get a number of tips to help you immediately benefit from installing Windows Vista into your Microsoft Office 2007 environment.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, May 20, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Click here to register: www.newhorizons.com/webinars

Join us from the comfort of your own office… on the Web! Webinar events are quick and convenient.

New Horizons Webinars are a great opportunity for business decision-makers, training professionals, developers, engineers and project managers to see the real value these new technologies can bring to your organization. With new topics every month, there's something for everyone.

ENROLL in all Webinars at: www.newhorizons.com/webinars

Enter the New Horizons Power Up Your Skills $25,000 Training Sweepstakes for your chance to win the grand prize worth $10,000 of computer training classes.

Then play our Power Up scratch off game daily to win a free class instantly!

Arm yourself with the IT and computer skills you need to succeed in today's competitive job market and put the power back in your hands!

Enter today! http://newhorizons.promo.eprize.com/powerup/

Here's a chance to prove yourself in the ultimate knowledge game! Prepare for your next Microsoft certification exam with this free online game from Microsoft!

Are You Certifiable? has two tracks (IT professional and developer) full of certification exam questions, engaging characters, and leader board spots to compete for!

Click here to play: http://www.microsoft.com/click/areyoucertifiable/

Join us from the comfort of your own office… on the Web! Webinar events are quick and convenient.

New Horizons Webinars are a great opportunity for business decision-makers, training professionals, developers, engineers and project managers to see the real value these new technologies can bring to your organization. With new topics every month, there's something for everyone. Go to www.newhorizons.com/webinars to enroll in all events.

APRIL

Introduction to Tips & Tricks for Microsoft Office 2007 (Level 100)

Get the most out of the Microsoft Office 2007 System. As someone beginning to use Microsoft Office 2007, you will learn about new features and timesavers to help in your day-to-day work. This session is good for beginner, intermediate, or advanced users – everyone will learn something! The Microsoft Office System has evolved from a suite of personal productivity products to a more comprehensive and integrated system. This presentation will demonstrate useful tips and tricks for Outlook, Word, Excel and PowerPoint.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, April 15, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Click here to register: www.newhorizons.com/webinars
  

Tips and Tricks for Maximizing Outlook 2007

Attend this webinar and witness how Microsoft Office Outlook 2007 delivers the functionality to provide better information sharing including publishing and sharing calendars, and exporting Outlook data. Also, see how Outlook 2007 can be configured using settings, trust, add-ins, and customized appearance and content. In this session, we also provide a better understanding of some of the terms used for communications and the capabilities; see Really Simple Syndication (RSS) versus XML, phishing, signatures, and other useful features of Outlook 2007.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, April 22, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Click here to register: www.newhorizons.com/webinars

MAY

Intermediate Tips & Tricks for Microsoft Office 2007 (Level 200)

Get even more out of the Microsoft Office 2007 System. As someone who has worked with the Microsoft Office system for some time, you will discover efficient ways to configure, customize and utilize Microsoft Word, Excel and Outlook to get the most out of Microsoft Office. The presentation will demonstrate useful tips and tricks for Microsoft Outlook, Word and Excel. In addition, you will see useful ways to interact between these Microsoft applications.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, May 6, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Click here to register: www.newhorizons.com/webinars

Introducing Microsoft Windows Vista® for Microsoft Office 2007 Users (100)

This webinar introduces to those familiar with Microsoft Office the features of Microsoft Vista that best suits them. You will see the advantages of using Windows Vista and Office together including better file origination, starting programs, search, communication, and Internet navigation. Get tips & tricks to better share and find your files, discover the consistency of search capabilities throughout Windows Vista, and navigate the new features of Internet Explorer. From this session, you’ll get a number of tips to help you immediately benefit from installing Windows Vista into your Microsoft Office 2007 environment.

• Presenter: Andy Reed, Senior Training Specialist, Microsoft Corporation
• Date: Wednesday, May 20, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern
• Click here to register: www.newhorizons.com/webinars

In the March 2009 issue of The Elevate Newsletter from New Horizons:

Microsoft Office Productivity
Three ways to protect your Excel data with confidence
Sometimes you need to keep your Excel data away from prying eyes. But you can protect your data in so many ways that the whole process gets confusing. We’ll break it down for you so your data never stays vulnerable. more >

Information Systems Protection
Twelve ways to harden your domain controllers and prevent security breaches
Domain controllers (DCs) hold a lot of valuable information about your Windows server, which means that you must secure them. We’ve compiled a few ways for you to keep intruders out of your network by strengthening your domain controllers. more >

Web Design & Development
Employ interactive elements to keep users on your site
Finally, nothing drives away online visitors like a boring website. We’ll introduce you to a few ideas for adding interactive elements to your site so visitors want to stay. more >

_____________________________________

New Horizons' goal is for our students to become more productive and successful in their daily activities. With this in mind, we have created Elevate, a newsletter specifically created for New Horizons students. In this free monthly publication you will read articles on how to put what you learned at New Horizons into action.

Simply click on the following link to access the March issue of Elevate.
http://www.newhorizons.com/uploadedFiles/ElevateNewsletter/Elevate_March2009.pdf

Good luck on your path of lifelong learning.

Enter for a Microsoft training giveaway from New Horizons Computer Learning Center!
New Horizons Computer Learning Center is offering a free Microsoft training course worth up to $2,500 to be given to one lucky Microsoft Subnet reader. Deadline for entry is March 31.

http://www.networkworld.com/subnets/microsoft/


How can Microsoft Certification help you and your career?

View Microsoft Certification Movie Clip >

Microsoft Certification has proven effective for growing skills and gaining professional recognition. According to a study conducted by Applied Research Consultants, 90% of Microsoft Certified Professionals (MCPs) said certification was extremely useful in their work. In another study, managers and supervisors felt their Microsoft Certified Professionals were significantly more competent than non-certified employees. This is valuable proof that certification means increased knowledge and enhanced credibility.

New Horizons Computer Learning Centers conducts more Microsoft technical training and certification courses than any other training company. New Horizons is the world's largest network of Microsoft Gold Certified Partners for Learning Solutions and Microsoft Certified Partners for Learning Solutions (CPLS). We provide courses to thousands of students each year - more than any other company.

As a Microsoft Gold Certified Partners for Learning Solutions, New Horizons maintains the rigorous standards required by Microsoft. Every Microsoft course follows the Microsoft Official Curriculum and is taught by a Microsoft Certified Trainer.


The New Microsoft Certifications Provide a Better Fit

The new generation of Microsoft certifications was created to be more cost effective and more targeted to enable IT professionals to work toward certification that truly meets their needs. Microsoft's new certifications are more specific in order to directly relate to the latest technology and your specific job role. These new certifications, starting with Microsoft® SQL Server™ 2005 and Microsoft Visual Studio™ 2005, help confirm your skills as an IT Professional or Professional Developer.

New Horizons offers a full range of Microsoft offerings, including courses mapping to the following certifications:

Microsoft Certified Professional (MCP)

Individuals with expertise in a particular Microsoft® product can pursue the Microsoft Certified Professional (MCP) credential. MCPs have demonstrated in-depth knowledge of at least one Microsoft technical product. The MCP credential provides a helpful first step on the way to other Microsoft technical certifications. more >

Microsoft Certified IT Professional (MCITP)

The new Microsoft Certified IT Professional (MCITP) credentials provide IT professionals with a simpler and more targeted framework to display their technical and professional skills. Now you can distinguish yourself as an IT professional with the current skills and proven job-role capabilities to work effectively with a comprehensive set of Microsoft technologies. The Microsoft Certified IT Professional paths include: Business Intelligence Developer, Customer Support Technician, Database Developer, Database Administrator, Enterprise Messaging Administrator, Enterprise Project Management with Microsoft Office Project Server 2007, Enterprise Support Technician, Enterprise Administrator and Server Administrator. more >

Microsoft Certified Professional Developer (MCPD)

The Microsoft Certified Professional Developer (MCPD) credential demonstrates your ability to use Microsoft Visual Studio and the Microsoft .NET Framework to excel in a specific, real-world job role. There are three MCPD certification paths: Windows Developer, Web Developer, and Enterprise Applications Developer. more >

Microsoft Certified Technology Specialist (MCTS)

The Microsoft Certified Technology Specialist credential enables professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise within their area of specialization. Microsoft Certified Technology Specialists are consistently capable of implementing, building, troubleshooting, and debugging a particular Microsoft technology. more >

Microsoft Certified Systems Administrator (MCSA)

Candidates for the Microsoft Certified Systems Administrator on Windows Server 2003 (MCSA: Windows Server 2003) verify their knowledge as system administrators of Microsoft Windows operating systems. MCSA certification can help advance your career by confirming that you have the skills necessary to successfully manage and troubleshoot system environments. The Microsoft Certified Systems Administrator (MCSA) certification helps you advance your career by ensuring that you have the skills you need to manage and troubleshoot network environments running on the Windows operating system. more >

Microsoft Certified Application Developer (MCAD)

The Microsoft Certified Application Developer (MCAD) credential provides industry recognition for professional developers who build powerful applications using Microsoft Visual Studio® .NET and Web services. Responsibilities include implementing requirements, developing, testing, deploying and maintaining department-level applications components, Web or desktop clients, or back-end data services by using Microsoft tools and technologies. more >

Microsoft Certified Database Administrator (MCDBA)

The Microsoft® Certified Database Administrator (MCDBA) credential is the premier certification for professionals who design, implement, and administer Microsoft SQL Server™ databases. more >

Microsoft Certified Desktop Support Technician (MCDST)

The Microsoft Certified Desktop Support Technician (MCDST) credential proves that you have the skills to successfully support end users and to troubleshoot desktop environments running the Microsoft Windows operating system. more >

Microsoft Certified Solution Developer (MCSD)

The Microsoft Certified Solution Developer (MCSD) credential is the premium certification for professionals who design and develop custom business solutions with Microsoft development tools, technologies, and platforms. The credential covers job tasks ranging from analyzing business requirements to maintaining solutions. more >

Microsoft Certified Systems Engineer (MCSE)

Candidates for the Microsoft Certified Systems Engineer on Windows Server 2003 (MCSE: Windows Server 2003) verify their ability to analyze the business requirements for information systems solutions, and to design and implement infrastructures based on Windows Server 2003. more >

Microsoft Office Specialist (MOS)

The Microsoft Office Specialist program is globally recognized as the standard for demonstrating desktop skills with the Microsoft Office suite of business productivity applications (Word, Excel, PowerPoint, Access and Outlook) and the Microsoft Project applications. With an Office Specialist certification, thousands of people have demonstrated increased productivity and have proved their ability to utilize the advanced functionality of these Microsoft applications. more >