header

Technology-Focused Continuing Professional Education

ACPEN Training Opportunities


In a continued effort to provide the highest-quality CPE available to accounting and financial professionals in the United States and Canada, K2 Enterprises has partnered with ACPEN (https://k2enterprises.acpen.com/). ACPEN is the largest CPE network in the United States, and partners with many state CPA societies. With dedication to bringing, highly relevant, NASBA accredited, world-class CPE courses for CPAs and financial professionals, the goal of the network is to provide accounting continuing education to every CPA in the most convenient and economical way possible.

ACPEN is owned and managed by Business Professionals' Network (BPN). BPN is responsible for the development of online CPE content, management of the network, and ensuring that the internet and live video streaming technology is and stays at the cutting edge, for the benefit of state societies and their members.

For seventeen years, ACPEN has been providing the highest quality online CPE available for accountants, financial professionals, and enrolled agents. ACPEN’s course catalog includes over 150 courses ranging in length from one hour to multi-day conferences.

ACPEN courses are created and presented by experienced presenters, renown experts, and seasoned practitioners. The ACPEN Signature courses are presented in broad topic panels, while the Specialized Area courses tend to be lead by fewer presenters, focusing on specific areas of industry, tax, and financial planning.

All ACPEN courses include downloadable written materials for use during and after the course, and live credit is awarded for all Live Webcasts and Live Webcast Replays. In addition, questions may be submitted to the presenters at any time during the course, and technical support is available during all courses, to ensure you have a great experience.

ACPEN logo

K2's Technology Trends and Productivity Tools

Course Description

Windows 10, Microsoft Office 2016, PDF documents, security issues and solutions, mobile devices, emerging technologies, and more – this course has it all! If you need to stay on top of the major technologies that affect today’s professional, along with the emerging technologies that will affect you in the future, you can’t afford to miss this event. In this fast moving session, you will learn about which tools belong on your technology roadmap and which you should avoid. You will also learn specific strategies for implementing key technologies, which upgrades you should consider, and, perhaps most importantly, you will learn how to maximize your return on your investment in technology.

Designed for business professionals, not information technology professionals, in this program you will learn the major trends in hardware, software, and services and how to utilize these tools to meet organizational objectives. More than just a seminar on the latest computers, you will learn about the full spectrum of practical technology available to you and your team along with how to implement these tools to realize maximum ROI.

Technology has never been better, so join us in this session to learn how to take full advantage of the tools available to you.

Course Information

CPE credit: Recommended for 8 hours Computer Software and Applications

Instructional delivery method: Group-live demo and discussion using color computer projection – laptop friendly, with access to demonstration files

Prerequisites: None

Program level: Update

Advance preparation: None

Who should attend: Accounting, financial, and other business professionals seeking an update of relevant technology

Learning Objectives

Upon completing this course, you should be able to:

  • Identify and implement relevant new features in Windows 10 and Microsoft Office 2016, determine if and when you should upgrade to one or both of these tools, and develop an optimal upgrade strategy
  • List critical security issues facing businesses and individuals and identify and implement practical solutions for addressing these risks
  • Identify the risks associated with mobile devices and develop a strategy for managing phones and tablets
  • Evaluate emerging technologies such as virtualization and biometrics for practical applications in everyday business settings
  • Determine which mobile apps provide needed functionality and features in business settings
  • Create a strategy for accessing critical documents from any device with an Internet connection
  • Evaluate competing Cloud Computing options to determine to what extent, if any, your organization should migrate to the Cloud

 

K2's Excel Essentials for the Busy Professional

Course Description

Let this be the year that you learn how to take advantage of Excel's best features for busy professionals. Tables, conditional formatting, interactive charting, multi-condition formulas, lookup functions, and formatting shortcuts are all examples of techniques that you should be using to get better results in less time with Excel. If you're not using all of these features, or if you are unsure if you are taking full advantage of these features, you should make plans now to participate in this laptop-friendly session to boost your Excel skills.

In this program, you'll learn about each of the techniques listed above, along with countless others, to improve your efficiency and effectiveness with Excel, the busy professional's tool of choice. More than just an Excel tips session, you'll learn by working through relevant examples and case studies that will show you the real-world applications of each of the topics covered. By the end of the course, you'll be a master of essential Excel features, functions, and techniques that boost your productivity, save you time, and increase the accuracy of the Excel spreadsheets you prepare.

Course Information

CPE credit: Recommended for 8 hours Computer Software and Applications

Instructional delivery method: Group-live demo and discussion using color computer projection – laptop friendly, with access to demonstration files.  Program focuses on Excel for Windows, but many of the features can be found in Excel for Mac.

Prerequisites: Good working knowledge of Microsoft Excel

Program level: Intermediate

Advance preparation: None

Who should attend:  Accountants and business professionals who want to use Excel more efficiently and effectively

Learning Objectives

Upon completing this course, you should be able to:

  • Identify how to create presentation-quality Excel-based reports quickly by using templates and applying formatting shortcuts.
  • Implement Tables as dynamically resizing data ranges and build reports that use Tables as mini-databases in Excel.
  • Prepare dynamic charts that allow end-users to filter the data on the fly.
  • Utilize Excel's VLOOKUP, HLOOKUP, and CHOOSE functions to find exact data points and work with Excel's Fuzzy Lookup add-in to create approximate matches of data.
  • Create formulas that evaluate multiple conditions before summarizing data.
  • Apply Conditional Formatting to assist in analyzing data.\
  • Identify how to track multiple versions of a spreadsheet using Excel's Scenario Manager feature.

 

 

K2's Preventing and Detecting Fraud

Course Description

Fraud continues to plague businesses of all sizes, with 5% to 10% of gross revenues walking out the door every year. Based on these numbers, all organizations need to double-down on their anti-fraud efforts and look for innovative ways to prevent and detect fraud. In this program, you'll learn practical approaches for doing precisely that.

To be effective at reducing fraud losses, you'll need to understand the types of frauds that are common in today's climate and who is committing them; the first section of this program focuses specifically on that topic. With this understanding in place, you'll then learn innovative techniques for preventing and detecting fraud, including the importance of practical anti-fraud internal controls, the need for sound policies, and, perhaps most importantly, specific tools and techniques for analyzing your data in real-time to identify potentially fraudulent transactions. Throughout this session, the focus will remain on real-world examples and best practices for reducing fraud losses and reclaiming lost revenues. You don't want to miss this unique opportunity to learn practical techniques for stamping out fraud losses!

Course Information

CPE credit: Recommended for 8 hours Computer Software and Applications

Instructional delivery method: Group-live demo and discussion using color computer projection – laptop friendly, with access to demonstration files. 

Prerequisites: Basic understanding of computer operations

Program level: Intermediate

Advance preparation: None

Who should attend: Accounting, financial, and other business professionals seeking to mitigate the threat of fraud in their businesses or in those run by clients

Learning Objectives

Upon completing this course, you should be able to:

  • Identify the most common frauds impacting businesses today and the median loss associated with each of these fraud schemes
  • Describe the characteristics of those who are most likely to commit fraud
  • Develop and implement effective general controls to mitigate the instances of fraud within an organization
  • Create effective analyses of data using common desktop tools such as Excel and Access to identify transactions that may indicate fraud
  • Implement effective internal controls within accounting software applications to limit an organization's exposure to fraud

 

K2's Excel Tables and Data Models - Efficiently Managing, Analyzing & Reporting Your Data

Course Description

To efficiently manage, analyze, and report in Excel, you need more than traditional ranges of data – you need tables and data models! Two of Excel’s best features about which most users know very little, tables and data models allow you to process large volumes of data into dynamic reports and analytical elements with unsurpassed ease, accuracy, and speed.

Far more than just a formatting tool, tables should revolutionize how you work with data in Excel, including serving as dynamically re-sizing ranges of data, providing a simplified means of writing formulas, and facilitating quick and easy sorting of large volumes of data. Couple tables with data models – a means of joining, or relating, two or more tables together – and you have the recipe for unparalleled efficiency when managing, analyzing, and reporting with Excel, even if your source data lies in other data sources! You do not want to miss this chance to learn how to harness the power of these tools by participating in this program!

Course Information

CPE credit: Recommended for 2 hours Accounting and 2 hours Information Technology

Instructional delivery method: Group-live demo and discussion – laptop friendly, with access to demonstration files. Program focuses on Excel for Windows, but many of the features can be found in Excel for Mac.

Prerequisites: Fundamental knowledge of Microsoft Office Excel

Program level: Advanced

Advance preparation: None

Who should attend: Accounting and business professionals who use Excel 2013 and Excel 2016 and are seeking to manage, analyze, and report data more efficiently using Excel

Learning Objectives

Upon completing this course, you should be able to:

  • List the key features and advantages of working with tables and data models
  • Create tables and data models in Excel,
  • Construct formulas in tables using Structured References, including formulas that refer to tables in other worksheets and workbooks
  • Use tables as automatic re-sizing data sources for other objects, including PivotTables and PivotCharts
  • Sort and filter data in tables, including applying Slicer filters\
  • Generate financial reports and data analyses – including PivotTables – which reference information from tables and data models and update dynamically

 

RegisterButton

WCPEButton

ACPENButton

On Site 2015 cover

On-Site CPE
Planning Guide

Click Here to Download

WebCatalogIcon

2017 Web Catalog
Click Here to Download

Are you receiving
the K2 Tech Update
by email every month?

Sign up now
so you don't miss
the next issue.

« Click here to sign up »

CONTINUING PROFESSIONAL EDUCATION FOR ACCOUNTING AND FINANCIAL PROFESSIONALS