Home
    .
     
 
July  2006
In this issue...

>Total Network Support
>
Are You Prepared?
>
Emailing Securely
>
Kane Reece Study
>Microsoft Tip
 

Microsoft Tips

Deleting Duplicate
Rows In Excel

In Excel, how do I delete rows that are duplicates—that is, rows that match in multiple columns like Last Name, First Name, House Number, and Street Name?

It's surprisingly simple. What you do is make a copy of your data that leaves out the duplicate rows.

Click somewhere in the data area.
Select Data | Filter | Advanced Filter from the menu.
Check the Unique records only box.
Click OK. This hides all the duplicate rows.
Highlight the slimmed-down data area.
Copy/Paste the data to a new location.

The copy will omit the hidden rows, so you now have a version of your data with no duplicates.


 
Panurgy Corporation
100 Ford Road
Denville, New Jersey 07834

Phone:
1-877-PANURGY
1-877-(726-8749)
Fax:
973-400-3701
http://www.panurgy.com/
 info@panurgy.com

Total Network Support,
When network support is critical, you need guaranteed priority service and fast remediation without worrying about exceeding your IT budget. Panurgy's highly qualified , certified professionals deliver expert support at a fixed annual cost, saving our clients money and frustration. Our Total Support program includes: Remote Server Monitoring, Reporting and Administration, End User Support and Managed Firewall solutions. All at reasonable annual rates which allows you to plan and budget—eliminating unplanned service expenses.

Services:
Remote Server Monitoring, Reporting and Administration:
Our unlimited remote server monitoring and administration service can solve most network issues remotely within minutes rather than hours, saving you time and money. Our Remote administration services relieves your IT staff of the everyday burdens of maintenance, updates and backup supervision, as well as, users and group accounts, e-mail mailbox creation and administration. Server print queue administration, file permission and policy management are all covered under this service, as well.

End User Support:
Your end-users receive unlimited and immediate telephone and e-mail response to their workstation support needs, freeing up your IT staff to focus on your organizations strategic IT initiatives. Unlimited on-site end-user/workstation support included as well as hardware repair labor. Support includes Windows 98/NT/2000/XP Operating Systems issues, network/internet connectivity issues, printing issues and e-mail issues.

Read more...

Prepare for the Unexpected
Summary: Having an incident response plan can mean the difference between recovering quickly and losing your business entirely. Learn about some key areas to focus on when developing your incident response plan.

Your business most likely relies on IT for a variety of tasks, including the storage of business documents, customer information, financial records, and accounting information. In addition, you probably rely on computers to conduct many daily business operations. Though no one wants to deal with the possibility of something unfortunate happening to their business, planning for the unexpected today could save your business tomorrow. Here are some key areas to focus on when developing your incident response plan.

Data protection: Your business may have thousands of records that are updated on a regular basis, so it's critical to develop a system for backing up all of your files. There are a variety of methods available. One option is called Disk-based backup, which is becoming the method of choice for many small businesses, due to both its cost effectiveness and its ability to provide continuous data protection.

Read more...


Emailing Securely
Summary: In spite of its obvious advantages, email can also introduce a number of security threats and risks to your business. This article discusses how to use email securely in your small business.

In almost no time at all, email has become one of the most widely used applications in business. But email is not without its risks; there is always the potential that confidential business information and intellectual property could be stolen, destroyed, or distributed without your knowledge. In addition, email is subject to viruses or worms, and other types of Internet attacks.

Some of the more serious threats to email include:

Viruses and worms: Though these threats have been around for years, they continue to grow in quantity and sophistication. Viruses have the potential to damage files, software, and hardware. Worms are types of viruses that automatically self-replicate and are therefore more dangerous, since they can damage numerous computers without human intervention.

Read more...

CASE STUDY:

CLIENT BACKGROUND: Kane Reece is a growing valuation and technical consulting firm located in Westfield, NJ. The firm, serves businesses, attorneys, financial institutions, and governments. Clients range from "Fortune 500 companies" to closely held firms and partnerships. Engagements involve firms with underlying asset values ranging from millions to billions of dollars.

PROBLEM:
Kane Reece's business was growing. They began to experience some performance and stability problems with their aging Windows 2000 File/Print/Mail server. They also needed a more robust messaging and collaboration solution for their local and remote employees. Panurgy was contracted to design and deploy an upgraded Back office server infrastructure to support their current and future needs.

SOLUTION:
Panurgy designed, implemented, migrated and provides ongoing support of their new Windows 2003 File/Print/Mail server, utilizing Active Directory. The server is an HP Proliant server running Windows 2003 Server and exchange 2003 server. Panurgy migrated the existing Exchange 2000 resources to Exchange 2003 fro a quick and seamless cutover for the end-users. Workstations are PCs and laptops running Windows XP Pro. Clients use MS Outlook 2003 locally and remotely via Panurgy-Managed VPN Connection, as well as Outlook Web access. Panurgy provides ongoing 24x7 remote monitoring and administration of the entire network, as well as managed firewall and VPN services. Panurgy also provides our Mailprotect email virus content and spam filtering service for all Kane Reece email.

Contact Panurgy at 1-877-726-8749 or visit us at http://www.panurgy.com/



Home