Advance Your Education Goals with MyCAA! The Department of Defense (DoD) currently provides financial assistance to military spouses to pay for certifications and education in high growth, high demand portable fields at no cost through the MyCAA program. The DoD will provide $6,000 in financial assistance to military spouses of Active Duty and activated Guard and Reserve service members through Career Advancement Accounts.

For military spouses who are interested in pursuing such careers, this is a FREE benefit. Let New Horizons Memphis show you how to achieve your career goals through the MyCAA program!

http://www.LearnAtNewNorizons.com/MyCAA/Memphis

Windows 7 is finally here, and New Horizons is here to help guide you through the training and transition process! We are thrilled to share the features, tools & elements of Windows 7 with our students. Throughout the next few months, we will be adding new Windows 7 courses and seminars, so check back often!

There are so many resources available to help you get to know Windows 7 right now! See what's new and see how it works...

What people are saying about Windows 7: (excellent resource!)
http://www.microsoft.com/windows/social/

Explore new features:
http://www.microsoft.com/windows/windows-7/what-is-windows-7.aspx

1. Use Snap to compare two files side by side with a quick drag to the edge of the screen.
2. Cruise through all your open windows with Live Taskbar Previews.
3. Use HomeGroup to share files, music—even printers—in just four clicks.
4. Got a file, photo, or website you use a lot? Open it in two clicks with Jump Lists.
5. Quickly find virtually anything on your PC with Windows Search.
6. and more...!

Take the Windows 7 tour with 7-second demos:
http://www.microsoft.com/windows/windows-7/videos-tours.aspx

Performance Improvements:
http://www.microsoft.com/windows/windows-7/features/performance-improvements.aspx

Compare Editions:
http://www.microsoft.com/windows/windows-7/compare/default.aspx

The Windows 7 Sneak Peek at New Horizons Memphis was a great success...Thank you to all 100+(!) students who joined us to preview the latest Microsoft Operating System throughout the day!

Our very own Charles Watkins covered multiple Windows 7 topics from Hardware Requirements to loads of Tips & Tricks. We also announced our first Windows 7 courses coming up in just a few weeks:

• 6291 Updating your Technology Skills from Windows XP to Vista/Windows 7 (Beta): November 30
• 6292 Installing and Configuring Windows 7 Client: December 9-11

Missed the Sneak Peek? Here are a few Tips for Windows 7 Users

Tip #1: Crunch The Numbers
The new Windows 7 calculator is a number cruncher’s dream. New functionality allows calculations in the following modes: Standard, Scientific, Programmer, Statistics. And that’s not all! Conversion formulas are available for: Temperature, Weight, Area, Time. Templates for gas mileage, lease estimations, and mortgage estimations are available as well!

Tip #2: Project Your Display With Ease
Plugging in a projector and projecting your display is a snap with the Windows 7 driver display utility, displayswitch.exe. Press Win+P to display the easy-to-navigate pop-up window. By hitting your arrow keys (or Win+P) you can switch through multiple display settings, such as “clone”, “extend” or “external only".

Tip #3: Command Junkies Only
One of the most popular power toys in Windows XP was “Open Command Prompt Here”, which enabled you to use the graphical shell to browse around the file system and then use the context menu to open a command prompt at the current working directory. In Windows 7 hold the Shift key down while selecting the context menu to get exactly the same effect. If the current working directory is a network location, it will automatically map a drive letter for you.

To view the original PDF article with illustrations, please click here: http://bit.ly/8wmCC

Photoshop’s Transform command is great when you need to scale images and keep the image proportions the same. However, if you dare attempt to scale in just one direction, Photoshop will distort your image and its contents. Not anymore: CS4’s Content-Aware Scale command comes to the rescue! You can now scale an image — without constraining proportions — and prevent certain image elements from distorting, as shown in Figure A.

The new Content-Aware Scale command

CS4’s Content-Aware Scale command allows you to resize an image but preserve an image’s contents. That means that you can protect image areas with important visual content, such as the girl in Figure A, or other objects important to your image’s composition, but you can scale an image out if its original ratio. Here are a few things you should keep in mind as you use this new feature:

• If you want to use this command on a locked background layer you must first press [command]A (Ctrl]A in Windows) to Select All or make a selection on the layer to transform.
• If you want to preserve the aspect ratio while using the Content-Aware Scale command, click the Maintain Aspect Ratio button located on the tool Options bar. Tip: The button has a chain link icon on it and is located to the right of the Width text box.
• You can’t use the Content-Aware Scale command on adjustment layers, individual channels, Smart Objects, layer masks, 3D or Video layers, layer groups, or multiple layers at the same time. The same scaling rules apply in regards to increasing and decreasing image sizes: If you scale too far in either direction, you’ll lose image quality.
• If you’re going to scale your image larger, you should increase the canvas size first.

Time To Resize

To use the Content-Aware Scale command you’ll need an image to work with. We’ll use the file shown in Figure B. (Images provided by PhotoSpin. Some images modified for educational purposes.)

Our image consists of one unlocked layer so we can jump right in and access the command. We’re going to maintain the image’s height but make the width narrower. When we attempt to do this task with the Transform command, the taxi shrinks down to the size of a Mini Cooper. So we’ll preserve the taxi image in preparation for scaling.

To preserve the taxi in preparation for scaling:

1. Select the Lasso tool from the Tools panel and create a loose selection around the taxi.
2. Choose Select > Modify > Feather to display the Feather dialog box.
3. Enter 5 in the Feather Radius text box and click OK.
4. Choose Select > Save Selection to open the Save Selection dialog box.
5. Keep the defaults and click OK.
6. Open the Channels panel (Window > Channels).
7. Double-click on the new Alpha 1 channel to display the Channel Options dialog box. Make sure the Masked Areas option button is selected and then click OK.
8. Click on the RGB composite channel (not the eye icon) to select the composite channels and turn off visibility for the Alpha 1

Scale the image

With the selection saved, you’re ready to Content-Aware Scale the image:

1. Press [Ctrl]D ([command]D on the Mac) to deselect all.
2. Choose Edit > Content-Aware Scale.
3. Choose Alpha 1 from the tool Options bar’s Protect pop-up menu.
4. Hover over the center bounding box on the left side of the image until it displays a double arrow, and then click and drag the bounding box handle to the right to scale the image narrower.
5. Click the Commit Transform button on the tool Options bar or press [return] ([Enter] in Windows) to commit the transformation.

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; 5 pm GMT
• Register: http://bit.ly/qQ0zg

SEPTEMBER


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, September 2, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern; 5 pm GMT
• Register: http://bit.ly/qQ0zg

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, September 9, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern; 5 pm GMT
• Register: http://bit.ly/qQ0zg

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

Get the most out of 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, September 16, 2009
• Time: 10 am Pacific; 12 pm Central; 1 pm Eastern; 5 pm GMT
• Register: http://bit.ly/qQ0zg

We're witholding the urge to make a separate post grumbling about Twitter being down ...again..., so we'll just announce our good news HERE first...!

New Horizons Memphis invites you to join us for a sneak peek at the latest Microsoft Windows Operating system, Windows 7!

• Thursday, September 17
  9:30 a.m. - 11:30 a.m.
• Register today!

See what’s coming as we show you Windows 7 tips and tricks and how Windows 7 was designed with you in mind. Users get an operating system that meets the advanced needs of their businesses and they get to keep working with the applications and devices they use today. Windows 7 improves on the fundamentals, while delivering the latest in mobility and user experience. It’s fast, stable, and compatible!

Join us to discover how this powerful combination of innovation, improved performance, and productivity:

• Works the way you want.
• Helps you get more done.
• Safeguards your work.

All attendees are automatically entered to win 1 of 10 Windows 7 Release Candidate discs. Limited seating available! Register today!

http://www.learnatnewhorizons.com/newsletters/memphis0809.html

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 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 thatyou can snag to add some zip to your PowerPoint presentations. We’ll show you how to insertand 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 havetrouble 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!

Learn how to accommodate colorblind viewers using Photoshop CS4

Any amount of color blindness hinders the ability for viewers to discern between certain colors in your designs. Therefore, what looks like a different color to most people simply blends into the background for those with color-deficient vision. Photoshop CS4 makes it easier to make your web and print designs accessible to those with differing degrees of color blindness.

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

Color in their world

There are differing degrees of colorblindness, ranging from the very rare complete color blindness (characterized by a total lack of color vision) to the more common partial color blindness, where individuals have deficiencies in certain hues, such as red and green. In supporting Color Universal Design (CUD), Photoshop CS4 includes soft proofing features that simulate color blindness. In the U.S., “one out of every 10-12 males and 200 females is believed to be colorblind,” according to the Color Universal Design Organization. For more information on CUD, visit http://www.cudo.jp/e/. Specifically, you can now see what your image will look like for people with the two most common types of colorblindness: protanopia and deuteranopia, which are both forms of dichromacy, where one cone cell type is missing from the individual’s retinas.

• Protanopia. Individuals with this deficiency have an absence of red cone cells.
• Deuteranopia. Individuals with this deficiency have an absence of green cone cells.

New CS4 accessibility options

To check for CUD-compliance:

1. Choose Window > Arrange > New Window for file name to preview your original image alongside the soft proof.
2. Repeat step 1 so you have three open windows of the same image.
3. Choose Window > Arrange > Tile, or click the Arrange Documents button on the Application Bar and select one of the options from the pop-up menu to arrange all three images on your monitor.
4. Select one image window and choose View > Proof Setup > Color Blindness > Protanopia-type, as shown in Figure A.
5. Select another image window and then choose View > Proof Setup >Deuteranopia-type. Figure B shows our original image and the two soft proofs.

Related Courses (Search our Course Catalog)

• Photoshop CS4 — Level 1
• Photoshop CS4 — Level 2

Make adjustments

Your designs should have adequate tonal contrast. Colors that are too close in tonal range will blend, making your designs illegible for folks with varying degrees of color blindness. While you can’t change your viewer’s vision, there are ways you can make your images a little more visually pleasing to your colorblind audience:

• Experiment with adjustment layers including Levels, Hue/Saturation, Curves, and Brightness/Contrast. Your goal is to achieve a full tonal range in your image.
• Avoid using the following color combinations: red and green; yellow and bright green; light blue and pink; dark blue and violet.
• Vary your designs with different patterns, shapes, or textures. These visual changes will help your audience distinguish the different design elements.

Quick Tip: Create a strong focal point with selective color (Photoshop CS/CS2/CS3)

Oftentimes you’ll want to draw viewers’ attention to just a portion of your image. One way to enhance your image’s focal point is to isolate that portion of your image’s color. We’ve got a quick-and easy technique you can use so that just the important elements of your photo really stand out, such as the barn shown in Figure A. To selectively isolate an image’s color:

1. Launch Photoshop and open any image or open our sample file.
2. Select the area you want to isolate from the rest of the image. If you’re working with our sample image, create a path around the barn and tree with the Pen tool. Tip: Make sure you select the Paths button on the tool Options bar before you make your path.
3. Click the Load Path As Selection button located at the base of the Paths palette. Alternatively, you can choose Make Selection from the Paths palette pop-up menu, and then click OK in the resulting dialog box to accept the default settings.
4. Choose Select > Inverse.
5. Press [Ctrl][Shift]U or choose Image > Adjustments > Desaturate.

The unselected area retains its color, and the selected area appears as though it’s grayscale.

Graphic & Design eTips to Enhance Your Work

If you are an expert at what you do, then you want to sign up for FREE New Horizons Graphics & Digital Designer eTips. Click here to sign up! http://bit.ly/7EoRh Each week you will receive expert advice from our experienced editors that will improve your productivity and enhance your work. Learn more about the applications you use every day, including: Adobe Illustrator, Adobe InDesign, Adobe Pagemaker, Adobe Photoshop, Digital Photography and QuarkXPress. Imagine the possibilities with the skills you’ll gain! http://bit.ly/7EoRh

Search our Course Catalog

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/qQ0zg

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/qQ0zg

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/qQ0zg

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

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.

Start	End	Course Title
6/22	6/26	2279B - Planning Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure
6/22	6/26	2310 Developing Microsoft ASP.NET Web Applications using Visual Studio.NET
6/22	6/26	2779B - Implementing a Microsoft SQL Server 2005 Database
6/22	6/26	2780B - Maintaining a Microsoft SQL Server 2005 Database
6/22	6/26	6231A - Maintaining a Microsoft SQL Server 2008 Database
6/22	6/26	6425A - Configuring Windows Server 2008 Active Directory Domain Services
6/22	6/26	SNAF- Securing Networks with ASA Foundation
6/22	6/26	Virtualization with VMware ESX and VirtualCenter SMB to Enterprise (4 Day and 5 Day Available)
6/22	6/24	6214A - Effective Team Development Using Microsoft Visual Studio Team System
6/22	6/26	6430A - Planning and Administering Windows Server 2008 Servers
6/22	6/27	Cisco - Interconnecting Cisco Networking Devices - ICND1
6/24	6/26	2792A - Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
6/25	6/26	Flash CS3 - Level 2
6/29	7/1	2275C - Maintaining a Microsoft Windows Server 2003 Environment
6/29	7/1	2830B - Designing Security for Microsoft Networks
6/29	6/30	2934A - Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006
6/29	7/1	3938A - Updating Your Skills from Exchange Server 2000 or 2003 to Exchange Server 2007
6/29	7/1	6418A - Deploying Windows Server 2008 (Beta 3)
6/29	7/1	ITIL V3 Foundations
6/29	7/2	Security+ Certification
6/30	6/30	Illustrator CS3 - Level 2
6/30	6/30	SharePoint Designer L1
7/6	7/10	2274C - Managing a Microsoft Windows Server 2003 Environment
7/6	7/10	2277C - Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure:
7/6	7/10	2780B - Maintaining a Microsoft SQL Server 2005 Database
7/6	7/7	2783A - Designing the Data Tier for Microsoft SQL Server 2005
7/6	7/10	4995A - C# - Programming with the Microsoft .NET Framework using Microsoft Visual Studio 2005
7/6	7/10	6232A - Implementing a Microsoft SQL Server 2008 Database
7/6	7/8	6235A - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
7/6	7/10	6416B - Updating your Network Infrastructure and Active Directory Technology Skills to Windows Server 2008
7/6	7/10	6421A - Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure
7/6	7/10	6425A - Configuring Windows Server 2008 Active Directory Domain Services
7/6	7/6	Axzo press Visio Professional 2007 Level 1 (Basic)
7/6	7/10	Cisco - Implementing Cisco IOS Unified Communications - IIUC
7/6	7/10	Cisco - Interconnecting Cisco Networking Devices - ICND1
7/6	7/10	Cisco - Interconnecting Cisco Networking Devices - ICND1
7/6	7/7	Flash ActionScript 3.0
7/6	7/10	PHP - Programming with Connectivity to My SQL
7/6	7/6	SharePoint Designer L2
7/8	7/10	2784 - Tuning and Optimizing Queries Using Microsoft SQL Server 2005
7/8	7/8	Illustrator CS3 - Level 1
7/8	7/8	Project 2007 - Basic
7/9	7/10	Crystal Reports XI Basic
7/13	7/14	Dreamweaver CS4 Level 2
7/13	7/15	2596B - Managing Microsoft Systems Management Server 2003
7/13	7/15	2792A - Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
7/13	7/17	2823B - Implementing and Administering Security in a Microsoft Windows Server 2003
7/13	7/14	50027 - Querying and Processing SQL Server Data Using Microsoft SQL Server
7/13	7/17	50028A - Managing System Center Operations Manager 2007
7/13	7/14	5060A - Implementing Windows SharePoint Services 3.0
7/13	7/15	6236A - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
7/13	7/13	Acrobat 9.0 Level 1
7/13	7/17	Cisco - Building Scalable Cisco Internetwork Devices - BSCI
7/13	7/17	Security+ Certification
7/13	7/18	Cisco - Interconnecting Cisco Networking Devices - ICND2
7/15	7/17	5061A - Implementing Microsoft Office 2007 SharePoint Server
7/15	7/17	6422A - Implementing and Managing Windows Server 2008 Hyper-V
7/15	7/15	Project 2007 - Advanced
7/15	7/15	Project 2007 - Basic
7/15	7/17	Project+ Certification - A CompTIA Certification (Second Edition)
7/16	7/17	6428A - Configuring and Troubleshooting Windows Server 2008 Terminal Services
7/16	7/16	Illustrator CS3 - Level 2
7/16	7/17	Photoshop CS4- Level 1
7/17	7/17	Excel 2007 - Level 2
7/17	7/17	Infopath 2007 Level 1
7/20	7/22	2275C - Maintaining a Microsoft Windows Server 2003 Environment
7/20	7/24	2310C - Developing Microsoft ASP.NET Web Applications using Visual Studio.NET
7/20	7/22	2793B - Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
7/20	7/24	50028B - Managing System Center Operations Manager 2007
7/20	7/24	50146A - Programming Microsoft Office SharePoint Server
7/20	7/22	6424A - Fundamentals of Microsoft Server 2008 Active Directory
7/20	7/22	Access Programming with VBA
7/20	7/24	Certified Ethical Hacker (CEH)
7/20	7/24	Cisco - Interconnecting Cisco Networking Devices - ICND2
7/20	7/24	Linux+
7/20	7/20	Visio 2007 Level 2 (Advanced)
7/20	7/25	Security+ Certification
7/21	7/21	SQL - Level 1
7/22	7/24	2957B - Advanced Foundations of MS.NET 2.0 Development
7/22	7/22	SQL - Level 2
7/23	7/24	2276C - Implementing a Microsoft Windows Server 2003 Network Infrastructure Network Hosts
7/23	7/24	Excel VBA
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/31	Certified Ethical Hacker (CEH)
7/27	7/31	Cisco - Interconnecting Cisco Networking Devices - ICND1
7/27	7/31	Cisco - Securing Networks with ASA Advanced (SNAA)
7/27	7/31	CISSP
7/27	7/31	Network+ Certification
7/28	7/30	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/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	6419A - Configuring Managing and Maintaining Windows Server 2008 Servers
8/3	8/7	6425A - Configuring Windows Server 2008 Active Directory Domain Services
8/3	8/4	6431A - Managing and Maintaining Windows Server 2008 Network Infrastructure Servers
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/7	Cisco IP Telephony Part 1 (CIPT1)
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/7	Indesign CS4 - Level 1
8/10	8/12	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/14	6420A - Fundamentals of Windows Server 2008 Network and Applications Infrastructure
8/10	8/12	6422A - Implementing and Managing Windows Server 2008 Hyper-V
8/10	8/14	CISSP
8/10	8/14	2596B - Managing Microsoft Systems Management Server 2003
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/14	Windows SharePoint Services 3.0 - Level 1
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/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/21	Cisco Implementing Cisco Quality of Service (QoS)
8/17	8/20	Cisco Wireless Networking Site Survey (CWNSS) v1.0
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 Maintaining 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/28	Cisco - Voice over IP (CVOICE)
8/24	8/26	Microsoft ASP.NET AJAX Using Visual Studio 2005
8/26	8/28	6417B - Updating your Applications Infrastructure Technology Skills to Windows Server 2008
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/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 - ICND2
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/9	6463A - ASP.NET 3.5
9/8	9/9	6463A - ASP.NET 3.5
9/9	9/10	2439 - Scripting Using Microsoft Windows Management Instrumentation
9/9	9/11	6423A - Implementing and Managing Windows Server 2008 Clustering
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/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/16	6434A - Automating Windows Server 2008 Administration with Windows PowerShell
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	50031A - Complete .NET 2.0 Security
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	Cisco - Implementing Cisco IOS Network Security - IINS
9/21	9/25	Computer Hacking Forensic Investigation
9/23	9/23	Excellence in Service: Basic
9/28	10/2	2779B - Implementing a Microsoft SQL Server 2005 Database
9/28	10/2	2933A - Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006
9/28	10/2	6231A - Maintaining a Microsoft SQL Server 2008 Database
9/28	10/2	Linux+
9/28	9/29	Photoshop CS4 - Level 2
10/1	10/2	6431A - Managing and Maintaining Windows Server 2008 Network Infrastructure Servers
10/5	10/7	6426A - Configuring Identity and Access Solutions with Windows Server 2008 Active Directory
10/7	10/9	6158A - Updating Your SQL Server 2005 Skills to SQL Server 2008
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	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/19	10/23	6430A - Planning and Administering Windows Server 2008 Servers
10/26	10/30	Project Management Professional Certification

Power Up and Save with New Horizons Memphis!

For a limited time, New Horizons Memphis is offering an exciting opportunity to power up your computer skills at an incredible value. Purchase any regular price Microsoft Office Suite training class with New Horizons and use promo code POWERBOGO to receive 50% off a second class of equal or lesser value. Sign up for as many classes as you like by June 30th and take the classes anytime you like.

No matter where you are in your career- just starting out, looking for change or planning to upgrade your current skills - New Horizons has plenty of classes to meet your needs.

Choose From Microsoft Office Classes Such As: Access, Outlook, Excel, PowerPoint, InfoPath, Publisher, Visio, OneNote, and Word

Click here to view our entire course catalog and save today! But hurry, because this "suite" deal ends on June 30.

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/Memphis 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 http://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.

********************************************

http://www.newhorizons.com/content/pressReleases.aspx?id=2264&sub=3&did=125&more=1