The K2 Enterprises Team
In this month's K2 Tech Update we look at the value offered by several leading Accountants Partner programs, including the Sage Accountants Network and the Quickbooks ProAdvisor Program.
You'll also find technology tips for Excel, and PowerPoint along with news about CCH Intelliconnect, Windows XP SP2 Support, and Windows 7 SP1. This month, our course spotlights are focused on Advanced Excel, Microsoft Word Essential Tools and Techniques, and Tech Tools for Preventing and Detecting Fraud.
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
Displaying a Worksheet Name in a Worksheet Cell
Excel's CELL( ) function is a
little-used feature that offers a tremendous amount of information regarding
the formatting, location, or contents of a cell.
Creating Videos from PowerPoint 2010
One of the enhancements to PowerPoint 2010 is the ability to create a
video directly from a PowerPoint presentation. This option allows you to create
a full-fidelity video that you can distribute on a CD/DVD, over the Internet,
via e-mail, or with a flash drive.
[ Return to Top ]
command provides an effective way of
consolidating financial information, whether imported or created in Excel. In
short, Consolidate allows us to summarize our data quickly and accurately.
Support for Windows XP SP2 Ends
On July 13,
Microsoft ended all support for Windows XP Service Pack 2 (SP2). Thus, current
users of that version of Microsoft's venerable operating system are now running
on an unsupported platform, increasing the likelihood of a security breach. According to
the security implications could be a rude awakening for many organizations...
Windows 7 SP1 Beta Now Available
On July 12, Microsoft released the public beta of Windows 7
Service Pack 1 (SP1) to select users. SP1 does not add any end-user
functionality and is not intended for home use.
Although many accountants consider themselves experts in using Excel,
most accountants are self-taught and do not use Excel to its full potential.
This course is designed to take experienced, self-taught users to the next
level. It provides real world examples developed by accountants for accountants
in the following six major topic areas:
- Collaboration and workbook security
- Using tables to analyze and report data
- Integrating and manipulating data from
- Creating and auditing complex formulas
- Advanced data
analysis with subtotals, filters, and PivotTables
- Using charts to analyze
and communicate information.
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 |