K2 Tech Update Header

 Published by

The K2 Enterprises Team                                                                                        December 2011

Greetings!
 
In this month's K2 Tech Update we look at some of the technologies that affected us in 2011.
 
You'll find three technology tips for Excel - Creating a Chart with Two Vertical Axes, Advanced SUMIF and SUMIFS Formulas, and Creating "Sticky" PivotTable Formatting. We have news about CCH's IntelliConnect Update and K2's Conference Survey. Don't forget that it's not too late to register for the CPE & Ski Conference held in Vail, Colorado and if you are looking for Webinars, K2 has offerings in January.
 
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)
TOPTOC
 
InThisIsse190x48

K2 2009 Quality Awards Logo Technology In Depth

Technology Past and Future


Apple_logo News You Can Use 

TechTips_(190x48)

TechTip1
 
 TechTips_Excel
Creating a Chart with Two Vertical Axes    

 

Sometimes when creating a chart, it is necessary to utilize two separate vertical axes because the numbers that are being charted are of different magnitudes. Doing so allows the readers of the chart to clearly see and understand the message the chart is intended to communicate. By following the steps contained in this tip, you will find that creating a chart with two vertical axes is quite easy.

 

TechTip2TechTip2A
 
TechTips_Excel
 
  
Advanced SUMIF and SUMIFS Formulas 

 

SUMIF and SUMIFS are two of Excel's best functions. Using these two functions, you can create formulas that add data, subject to one or more conditions. The primary difference in these two functions is that SUMIF allows only one condition to be evaluated, while SUMIFS allows up to 127 criteria to be evaluated; additionally, SUMIFS is only available in Excel 2007 or higher. In this tip, you will learn how to create advanced SUMIF and SUMIFS formulas that use cell references as the evaluation criteria. 

 

 

TechTip3

 TechTips_Excel

 

Creating "Sticky" PivotTable Formatting 

 

One of the more frustrating aspects of working with PivotTables is the seeming inability to format a PivotTable so that the formatting remains intact when you refresh the PivotTable. By utilizing the two simple techniques contained in this tip, you will create PivotTable formats that are "sticky" and even remain in place when you refresh the PivotTable.

Connections

TechFeatureHeader_330x48
 
 
 Holly
  Technology Past and Future 

  

It seems that every year at this time, we pause to reflect on the year soon to be passed and make predictions and promises about things that will transpire in the upcoming year. In that vein, let us take a few moments in this issue to examine some of the technologies that affected us significantly in 2011. We will follow that next month with predictions on technologies that will have significant impact in 2012.

 

 
 Page Break C  (330)
 

News1
IntelliConnect Update Includes New Library View  

 

CCH IntelliConnect, a research platform for the accounting and tax industry, now offers even greater flexibility and speed for accessing content with the new Library View. IntelliConnect delivers faster answers and better results, and the new Library View feature conveniently organizes specific information on a single page and enables users to switch easily between topics.

 

Read more here 

 

[ Return to Top ]

     Page Break C  (330)

News2K2 Conference Survey Coming Soon      

  

The annual K2 Enterprises Conference Survey will arrive in your inbox the week between Christmas and New Year's; we are asking you to participate in the survey and share your thoughts and opinions with your peers nationwide. This survey requests your input into topics K2 Enterprises should teach in its 2012 Technology Conferences. We have conducted a similar survey in each of the past three years and the responses have helped to ensure that our one and two-day Technology Conferences provided content in which you were most interested and found to be relevant.

 
 Page Break C  (330)
News6Still Time to Register for 2012 CPE & Ski Conference 

  

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 2012 CPE & Ski Conference in Vail, Colorado.

Page Break C  (330)
News4K2 Enterprises Webinar Schedule for January 2012 

  

To better serve the accounting community, K2 has partnered with CPA Crossings and ACPEN to offer high quality web-based CPE training. This gives you the opportunity of receiving leading-edge, K2 developed and presented content, in the friendly confines of your home or office.    

 

The cost of each of the CPA Crossings two-hour sessions is $79 and group discounts are available.

 

The cost of each ACPEN eight hour course is $195 and each four hour course is $129.

 

We are excited about this ability to provide web-based training and hope to see you on the Web.

 

 
Page Break C  (330)
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!

2011 K2 Enterprises |  All rights reserved