Welcome to New Horizons!

With 300 centers in 70 countries, New Horizons is the world’s largest independent IT training company. Our innovative, award-winning learning methods have revolutionized the way students learn, retain and apply new knowledge; and we offer the largest Guaranteed-to-Run course schedule in the world.

Our real-time, cloud-based lab solution allows students to access their labs anytime and anywhere. And we offer an extensive selection of vendor-authorized training and certifications for Microsoft, Cisco, CompTIA and VMware, ensuring that students are able to train on the latest products and technologies. Over our 30-year history, New Horizons has trained over 30 million people worldwide.

New Horizons is Giving Away a Wii a Day!

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!

Upcoming Webinars | New Sessions JUST Added

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

New Remote Classroom Schedule Update

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.

Count your filtered data using just the right function for the job

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

New Horizons Computer Learning Centers Wins United States and Canada Learning Partner of the Year Award at Cisco Partner Summit


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.

SQL Server 2008 Free Software Offer Now Extended to September 30, 2009



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

Get Hired | Get Noticed | Go Further - with Microsoft Certification

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.

Remote Classroom Learning Portal *NEW!*

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.

Word 2007 enhances the Compare And Merge Documents Feature

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.