|
|
Published by The K2 Enterprises Team March 2011 |
| Greetings!
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 |
|
|
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.
|
|
 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.
|
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
 |
|
SecurID 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.
|
Personal 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.
|
K2 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.
|
Excel 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.
|
Outlook 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.
|
Word Essentials
|
|
|
|
|
|
|
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.
 |
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!
 |
| © 2011 K2 Enterprises | All rights reserved |
|
|
