|
Published by The K2 Enterprises Team
| SEPTEMBER 2010 |
Greetings!
In this month's K2 Tech Update we take a first look at Google's new Chrome operating System.
You'll also find three technology tips for Excel along with news about Thomson Reuters, QuickBooks ProAdvisor, Windows 7, and CCH TaxPlan.
This month, our course spotlights are focused on MS Access, Excel PivotTables, and Excel-Based Dashboards.
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 |
|
Selecting Cells With Special Characteristics
When working in Excel, professionals often would like to identify cells that possess specific characteristics, such as cells that contain formulas, cells that contain constants, or cells that are blank. Fortunately, you do not need to look at the contents of every cell and make individual judgments about cells. Rather, you can use Excel's built in Find & Select tool to do the work for you.
Using Tables As Dynamically Expanding Ranges Tables were added to the 2007 release of Excel and are one of the most significant enhancements to spreadsheets in the past fifteen years. One of the many benefits of working with Tables in Excel is that they serve as dynamically expanding ranges of data. Thus, as data is appended either horizontally or vertically, the definition of the Table automatically expands to include the appended data and any object based on the Table also includes the appended data.
Sorting Subtotaled Data
Many Excel users know how to use the SUBTOTAL function to create subtotals of data based on predefined criteria. But once Excel subtotals the data, how can we sort the data in the order that we want, instead of the order that Excel demands? Fortunately, the answer is surprisingly simple.
|
|
Is There A New Operating System In Your Future?
Pending Release of Google's Chrome OS Could "Cloud" The Picture
Just over one year ago, Google announced that it would develop and release Chrome OS, a new operating system to compete with Windows 7, Mac OS X Snow Leopard, and other operating systems. At a recent trade show, Sundar Pichai, Google's Vice President of Product Management, said that the Chrome OS "will be offered to users in the fourth quarter." At the same time, Google will open the Chrome Web Store, allowing consumers to purchase and download Web applications that can be installed on computers running the Chrome OS. Of course, all of this leads to the question "is there a new operating system in your future". More specifically, is the Chrome OS one that business users will embrace?
Learn more about:
- Enhanced Security
- Speed
- User Interface
|
|
Thomson Reuters Releases iPhone App for Tax and Accounting Professionals
The Tax & Accounting business of Thomson Reuters announced the
release of Mobile CS, an iPhone app for tax and
accounting professionals. Using mobile application technology, this practice
management tool extends the reach of Practice CS from desktop to iPhone, giving
more than 60,000 Practice CS users the ability to access firm, staff, and
client data anytime, anywhere.
|
QuickBooks ProAdvisor Promotion Ends September 30
|
Microsoft Announces Windows 7 Upgrade Discounts
For current users of Windows
XP or Windows Vista, Microsoft has announced the
return of the Family Pack upgrade program. At
a suggested retail price of $149.99, the Family Pack provides upgrade licenses
of Windows 7
Home Premium that can be installed on three computers in the same
household.
|
CCH TaxPlan Offers Tax Planning Guidance And Practice Tools
Tax professionals now have a powerful new resource to guide them through
each step of the tax planning process with CCH TaxPlan. Available on the IntelliConnect research platform, CCHTaxPlan integrates tax planning guidance and
interactive practice tools to help practitioners perform efficient and
effective tax planning engagements.
|
Microsoft Access For Accountants
Microsoft Access has the
potential to be an extremely useful tool for many accountants, yet it remains
among the least utilized of the Microsoft Office suite of applications. This is
unfortunate because Access is a truly powerful application that is relatively
easy to learn and use. Once you understand the basic components of Access -
tables, queries, forms, and reports -
and how they work together, it is often much easier and faster to use
Access than Excel to perform many accounting, auditing, and other related
tasks.
|
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.
|
Excel-Based Dashboards
|
|
|
|
|
|
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.
|
� 2010 K2 Enterprises | All rights reserved |
|
|