LAN Systems
September/October 2010
Working with computers
Please vote for LAN Systems in the Best of Gwinnett competition.
Here's the link:
LAN Systems, Inc is listed under Business / Best I.T. Service
Thanks a million!

Microsoft Office 2010: The best new features in Excel

Excel is arguably the most under-utilized Microsoft Office product when it comes to advanced features.  Ask people what features they most like in Excel and they usually describe the spreadsheet and graphing tools.  But that is just a very small part of the capabilities built into Excel.  From tools for statistical, engineering and financial functions, to pivot tables, to Visual Basic for Applications (VBA) programming, you can use Excel for simple to complex data analysis and display with easy to read graphs and charts. 

If you haven't used the advanced tools in Excel, start by trying the new features to get the most from your software investment. Analyze your data to discover patterns or trends, then display with graphs and charts that illuminate the best course of action.  With a little practice, you will improve your ability to study large data sets and make the most informed decisions. 

Make fast, effective comparisons 

Sparklines - Use sparklines to graphically display data in a single cell.  You can display data in line, column or win/loss format to highlight trends. On the Insert tab, choose the type of Sparkline and your data range.  Customize your sparklines for optimum effect by selecting the sparkline and choosing the Design tab. 






Slicer - Slicers are filtering components that allow you to slice-and-dice your data without having to open drop down lists.  Slicers make it easier to segment and filter data in PivotTables for high powered business intelligence. 

Step up your analysis


Search Filter - Use the new Search Filter to quickly and easily narrow your search in tables, PivotTable, and PivotChart views. You can instantly sort through a million or more items.


PowerPivot (formerly called Project "Gemini") Add-In - Groundbreaking technology that allows you streamlined integration of data from multiple sources and lightning-fast manipulation of large data sets with up to millions of rows. Effortlessly publish and share analysis through Microsoft SharePoint Server 2010 and have other users enjoy the same Slicer and fast-query capabilities when working on their Excel Services report.




Backstage - The Microsoft Office Backstage view replaces the traditional file menu with an ergonomic approach that uses In and Out features for efficiency.  The improved Ribbon lets you access your favorite commands quickly and create custom tabs to personalize the way you work.


Jazz up your data presentations

Conditional Formatting - Excel 2010 adds sophistication to conditional formatting.  Give your document a professional look by adding eye-catching formats.  You have more choices and control over styles and icons, improved data bars, and the ability to highlight specific items in a few clicks. You can also display data bars for negative values and use color for effect.

Work from anywhere

Online - Post your spreadsheets online and work on them from virtually anywhere from the Web or your Windows Mobile-based Smartphone. With Excel 2010, you can take advantage of a best-in-class spreadsheet experience across multiple locations and devices.

Excel Web App - Extend your Office experience to the Web, and view and edit your spreadsheets through the Excel Web App when you're away.

Excel Mobile 2010 - Stay up-to-the-minute and communicate on-demand by using a mobile version of Excel specifically suited to your Smartphone.

For other interesting features and functions, try Goal Seek to give you a what-if analysis to test your scenarios, experiment with linear regression to understand relationships in your data or just play with the new formatting tools. But once you uncover the "hidden" features in Excel, you will be enthusiastically hooked.

For more technical notes and information go to: 

If you have any questions or need help with the instructions, email me at:

Email Hoax - Critical Microsoft Windows Upgrade 
We have noticed the reappearance of this old email hoax.  If you get an email similar to the one below asking you to log into a site to download your upgrade, don't do it!
 Dear Microsoft Windows User,

You are recieving this notification because the version of Windows you are running is affected by a crucial security flaw.

In order to protect yourself and other users of the Windows operating system, it is extremely important that all customers update Windows at their earliest convenience.
It is a fraudulent email designed to steal your identity or attack your computer.
Microsoft will only send you security bulletins if you sign up for the service.  You will need a Windows Live ID and can sign up at the Microsoft Security site.
More information on email hoaxes and fraudulent links at Microsoft Online Safety.
If you have questions or concerns, please contact the LAN Systems HelpDesk at 770 662-0312 or
**Notice the spelling error in the email.  This is quite common in fake emails.
Join Our Mailing List
In This Issue
Microsoft Excel 2010
Email Hoax
Network Group

Solutions and Services to help you grow your business

System and Network
Design & Installation

Microsoft, Linux and Unix
Servers and desktops
vCIO Strategy
Architecture review
System installation
Network security
Storage solutions
Service and Support
Support  agreements
Onsite services
HelpDesk support
System maintenance
Emergency services
Data recovery
Managed Services
24/7 system monitoring
Real-time notification
Automatic updates
Quickly fix problems
Alarming for critical events
System health reports
Follow up action plan
Data Backup Plans
Online combined with local or offsite storage
Easy to manage
Restore individual files or entire system
Safe and affordable

Special limited time offer 

5% off Microsoft Office Professional 2010*

 Only $474.99    *MSRP $499.99.Offer good through September 2010

   Microsoft Office 2010  Big Ideas for Small Business

Keep life running smoothly from managing personal finances to creating professional client presentations.

Office Professional 2010Office Professional 2010

Get powerful e-mail and scheduling tools, sophisticated information and data management, and professional-caliber marketing tools.

Call 770 662-0312 or email for more information or to order!