K2 Tech Update Header
Published by
The K2 Enterprises Team
 
APRIL 2010
Greetings!
 
In this month's K2 Tech Update you'll learn about the four top data security concerns identified in the AICPA's Top Technology Initiatives survey.

You'll also find technology tips for QuickBooks, Outlook, and Excel, along with news about 2010 IRS Filing Statistics, Office 2010, and a Google Password System Breach.

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

The K2 Team
Page Break C (600)
TOPTOC

TechTips_(190x48)

TechTip1
TechTips_Quickbooks
Reconciliation Report
---------------------------
Creating a Reconciliation Report
in QuickBooks

In QuickBooks, a custom report can be very helpful when attempting to reconcile an account. 


TechTip2

Techtips_outlook
Email Merge
Creatingan Email Merge in Outlook

Using Outlook's Mail Merge tool to create and send e-mail messages to selected contacts in Outlook's Contact List is a simple and easy task.

[ Return to Top ]

TechTip3

TechTips_Excel
PivotTables
---------------------------
New PivotTable Options in Excel 2010

Significant additions to Excel 2010 include the ability to change how percentage calculations display in PivotTables. More specifically, among other new options users now have the options of showing data as a percentage of the parent row total, percentage of the parent column total, and percentage of parent total.

Connections
FeatureArticle1
TechFeatureHeader_330x48

DataSecurity
Accountants Face
Data Security Dilemma

In addition to the state of the economy, data security ranks as a primary concern of accountants in all areas of the profession. According to the AICPA's "2009 Top Technology Initiatives" (TTI) survey results, the three top technology initiatives that accountants will face over the next twelve to eighteen months are directly related to data security, and a fourth security item makes the list in the seventh position.

Read the full article to learn more about these four critical data security concerns:
  • Information Security Management
  • Privacy Management
  • Securing Data File Storage, Transmission, and Exchange
  • Identity and Access Management
>> Click here to read the full article
Page Break C (330)
News1
NewsHeader_330x48

IRS Releases 2010 Filing Season Statistics

Through April 9, 2010, the IRS received and processed fewer individual income tax returns than in the comparable period from the previous year, but average refunds to taxpayers increased by 9.1%, according to statistics published by the Service.

News2
Office 2010 Hits RTM Milestone

While many accountants were concerned with other events on April 15, Takeshi Numoto, a Corporate Vice President at Microsoft, announced that Office 2010, SharePoint 2010, Visio 2010, and Project 2010 reached the release-to-manufacture (RTM) milestone. RTM is the final pre-release engineering milestone of an application and means that an application is now in the production phase.

Page Break C (330)
News3
Google Password System May Have Been Comprimised in January Attacks

 That Google suffered security breaches in December of 2009 year is no secret. What has recently surfaced regarding the December cyber-attacks is that the hackers may have gained access to Google's password system.

Page Break C (330)
FeatureArticle3
Course Spotlight
-----------------------------------------
QuickBooks Reconciling and Analyzing Financial Statements

This seminar features discussions on using QuickBooks' Reconcile feature in conjunction with custom reports to lend credence and credibility to balances in historically problematic accounts such as Prepaid Expenses, Customer Deposits, and Retainers.

FeatureArticle2
Course Spotlight
-----------------------------------------
Excel PivotTables For Accountants - Part II

This course is a continuation of Excel PivotTables for Accountants - Part I. It extends and builds upon the foundation of PivotTable topics covered in that course and includes in-depth coverage of using advanced data summary functions and creating calculated items and fields.

AboutK2Seminars
K2 Seminars

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.  

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

Avalara

© 2009 K2 Enterprises |  All rights reserved