K2 Tech Update Header
Published by
The K2 Enterprises Team
 
DECEMBER 2010
Greetings!
 
In this month's K2 Tech Update we cover steps you can take now for better computing in 2011.

You'll find technology tips for Excel
and Windows 7, along with news about Cloud Based CS Professional Suite, CCH Intelliconnect, the 2011 CPE and Ski Conference, and ACPEN Webcasts.

This month our course spotlights are focused on Excel Macros Part I, Excel PivotTables Part I, and Moving to Office 2010.

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_Excel 
Using SUMPRODUCT Function To Multiply Values and Sum the Results

Excel's SUMPRODUCT function multiplies corresponding values in multiple ranges and returns the sum of those products.



TechTip2
TechTips_Excel
Adding Date and Time Stamps To Excel Worksheets

Oftentimes, Excel users need to add date and/or time stamps to a worksheet. Fortunately, users can add date or time stamps to any worksheet quickly using keyboard shortcuts 



TechTip3
TechTips_windows7
A Windows 7 Hidden Feature - The Power Efficiency Diagnostics Report

For most laptop users, nothing is more frustrating than running out of battery life while you are in the middle of working on a task. Fortunately, Windows 7 includes a feature that helps you to determine what is causing your battery to drain so quickly. 

Connections
FeatureArticle1
TechFeatureHeader_330x48









Articleicon
Take Ten Steps Now for Better Computing in 2011

As we approach year-end, many of us anxiously look forward to the Holidays and the opportunity of spending time with friends and family, reflecting on the year past, and planning for the year upcoming. Most of us likely do not spend much time thinking about our technology assets or how a few simple moves now might make 2011 even more profitable and successful. Yet if we were to spend just a short period of time addressing the following ten technology fundamentals, our technology assets are likely to run leaner and cleaner and provide us with a better return on investment than what we are currently receiving


 


News1

icon_newsCloud-Based CS Professional Suite Implementation Up 117%

Earlier this month, the Tax and Accounting division of Thomson Reuters announced that the number of firms using the CS Professional Suite software as a service model has more than doubled since the end of 2009. 

Page Break C  (330)
News2
icon_newsCCH Enhances IntelliConnect In Time For Busy Season

CCH's IntelliConnect now offers a new series of customer-focused advancements that leverage  technology to give accounting and financial professionals the active intelligence and fast answers they need. Serving as the gateway to CCH's content and award-winning tools, the IntelliConnect research platform provides outstanding search capabilities, features and options.

News3
icon_newsStill Time To Register for 2011 CPE & Ski Conference

January 10-12, 2011 - Vail, CO


For those looking for a great way of earning up to 24 hours of CPE credits while enjoying some of the best skiing and related winter activities anywhere in the world, take a moment to consider participating in the 2011 CPE & Ski Conference in Vail, Colorado. The 2011 CPE & Ski Conference is supported by twenty-two state CPA societies and offers you the very best CPE & Ski Conference at the number one snow ski resort in the United States. 

News4
icon_newsLive Webcast Replays from ACPEN

K2 instructors Bob Spencer, Randy Johnston and Will Fleenor partnered with ACPEN to provide 4 eight-hour CPE webcasts targeted to CPAs in industry. These live webcast replays will be held over the next six months

Spotlight1
course_spotlight_header

icon-spotlightExcel Macros - Part I

You have used Excel for years and Lotus prior to that. During this time, you have said repeatedly, "One day, I'll learn how to write macros." Well, that time has arrived because this four-hour program will introduce you to the wide world of macros and Visual Basic for Applications (VBA) in Excel.


Spotlight2
icon-spotlightExcel 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.

 



AboutK2Seminars
k2_seminars_header

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

2010 K2 Enterprises |  All rights reserved