K2 Tech Update Header

 Published by

The K2 Enterprises Team                                                                                     March 2011

In this month's K2 Tech Update we discuss the release of Internet Explorer 9 and our Webinar schedule for April.

You'll find technology tips for Windows 7, PivotTables and Excel's traffic light conditional formats, along with news about SecurID and creating personal hotspots on your iPhone 4. Be sure to participate in our annual Technology Survey prior to March 31st for a chance to win a free netbook computer.

This month our course spotlights are focused on Excel PivotTables for Accountants - Part I, Outlook Essentials, and Word Essentials.

We hope you find this issue timely, relevant, and useful.  If you have topics you would like for us to cover here in the coming months, please let us know.

The K2 Team
Page Break C  (600)


Apple_logo News You Can Use

SecurID Information Stolen

Pinning a Folder to the Explorer Jump List in Windows 7

Oftentimes there is a folder that we need to access frequently. In many cases, this folder might be several layers deep in our Documents folder or Documents library in Windows 7. Fortunately, we can "pin" frequently used folders to the Jump List in Explorer with just a few quick mouse clicks.

Creating Many PivotTables From One
Suppose you have created an Excel PivotTable that summarizes sales data by quarter, by product line, and by item. Further, suppose that you have added a Report Filter to the PivotTable that allows you to filter by Region. Now, in anticipation of a staff meeting with all of the Regional managers, you would like to create a separate PivotTable for each Region so you will find yourself constantly changing the Report Filter. Is there an easy way to quickly create many PivotTables from one? Of course - it goes by the funny name of Show Report Filter Pages. 
Getting the Green Light Conditional Format in Excel Worksheets

As many Excel 2007 and Excel 2010 users know, one of the enhanced conditional formats available in those versions of Excel is that of traffic lights. Traffic light conditional formats allow users to segment or stratify data into three tiers - red light, yellow light, and green light. But what if we only wanted to see just the data that meets the green light criteria? How can we modify the conditional formatting rules in Excel 2007/2010 to change the way traffic light conditional formatting is applied? Fortunately, the answer is quite simple.

 IE9 Feature article March 2011
Internet Explorer 9 Release Reignites Browser Wars
Coming on the heels of Google's release of a new version of Chrome and shortly before Mozilla's release of a new version of Firefox, Microsoft released Internet Explorer 9 (IE9) on March 14, indicating that browser wars are not likely to disappear anytime soon. With competition heating up on the cloud computing front, look for the battle over browsers to escalate, as Microsoft, Google, Mozilla, and others all vie to provide the browser used by most people to access the cloud.

FeatureArticle2 K2 Enterprises Webinar Schedule for April 2011  

To better serve the accounting community, K2 Enterprises has partnered with CPA Crossings to offer a series of two-hour webinar training events.

Additionally, K2 Enterprises is pleased to offer an expanded multi-media CPE platform for Accountants. This CPE content is available via ACPEN's high quality, streaming video webcast format over the Internet. It incorporates panel style review and discussions of topics critical to today's business environment.
 Click here for topics and dates
Page Break C  (600)

News1SecurID Information Stolen


Proving yet again that the perfect information security regime does not yet exist and that information security is about reducing risk and not eliminating it, RSA has reported "an extremely sophisticated cyber attack"  has extracted information from some of the company's SecurID two-factor authentication products.

Page Break C  (330)
News2Personal Hotspots for AT&T iPhone 4 Users


iPhone 4 users on the AT&T network plan received some welcome - and largely unexpected news - on March 11. By upgrading the operating system to version 4.3 (which became available on March 11), you can use your iPhone 4 to create personal hotspots to share your 3G cellular data connection with up to 5 other WI-FI capable devices. 

Page Break C  (330)
News3K2 Enterprises Requests Your Responses to its 3rd Annual Technology Survey


Annually, K2 Enterprises conducts a survey on how accountants in all facets of the profession use technology. Please consider this your invitation to participate in the 3rd Annual K2 Enterprises Technology Survey.

Page Break C  (330)
 PivotTables for Accountants - Part I
PivotTables are the most powerful feature of Excel, yet few accountants use them in their day-to-day activities. For some, PivotTables are too intimidating; for others, PivotTables are a foreign concept. With a little information, guidance, and demonstration from the instructor, you will be ready to begin using PivotTables to accomplish routine analysis and reporting. This session will begin with basic PivotTables and progress to advanced PivotTable topics.


Spotlight2Outlook Essentials

Are you ready to learn the essential features in Outlook to help you manage your e-mail, contacts, and calendar more effectively? If so, then you should plan to invest four hours in this fast-paced seminar designed to help you become more proficient with some of Outlook's basic features.



Continuing Professional Education
for Accountants and Financial Professionals

K2 Enterprises offers continuing professional education seminars and conference sessions to accounting and finance professionals throughout the U.S.  

Page Break C  (600)
About K2 Tech Update

K2 Tech Update is published by K2 Enterprises and features technology and productivity news, information, and tips for accounting and financial professionals.

Keep up with the latest news and information
regarding Accounting and Finance Technology today!

Join our mailing list!

2011 K2 Enterprises |  All rights reserved