Computer Application



 Title  Credit  Format  Price  View
+    Spreadsheet Controls under Sarbanes Oxley 2 Online $19.99 View

Spreadsheet Controls Under Sarbanes-Oxley Section 404

 

Course Description:

Spreadsheets have become pervasive in most companies and have many uses.  Those that are used in the financial reporting process are of most concern to the assessment of the effectiveness of internal controls over financial reporting mandated by Sarbanes-Oxley. This course discusses how to evaluate spreadsheets under the rules of Section 404 and AS 2201 as well as what specific compensating spreadsheet controls are supported by Excel 2007, Excel 2010, Excel 2013 and Excel 2016.  This course has been written for Excel 2007.  Steps that differ in Excel 2010, 2013 and 2016 have been noted in gray shadow boxes for the few instances where there is a difference.

NASBA Category:

Audit (1 Hour)/ Computer Science (1 Hour)

Level: Basic/ Overview  (See Prerequisites)


Prerequisites:
Excel 2007/ Excel 2010/ Excel 2013/ Excel 2016 is needed. 

+    Optimizing Searches with Google 1 Online $19.99 View

 

Course Description:

Google is a well-known and often used tool to search for information.  Many don’t know that there are certain search operators and tools embedded in Google search that may be used to find desired information quicker and easier.  This course reviews basic, intermediate and advanced search operators and techniques as well as other useful Google tools that are available.  Your new search skills are tested throughout the course with 10 short case study questions.

  

Learning Objectives

Upon completion of this course, you should be able to:

·         Identify operators and techniques that enhance your ability to find information using Google

 

 

Prerequisites: None

Level: Overview

NASBA Category: Computer Science

Recommended CPE:  1 hour

+    Network Security for Internal Control Assurance 8 Online $59.99 View

Introduction

Internal control requires that the information systems in a company are secure, reliable, and can be trusted. Cyberattacks and data breaches represent the greatest threat to most company’s today. Network security for internal control assurance is a course that will describe the importance of network security for all types of businesses and practices. This course will identify the vulnerabilities and define safeguards for computers, networks, networking components, software applications, and mobile devices. This course will describe the threats that can compromise the computers and company data such as viruses, trojans and phishing. This course will describe some simple steps that users can take to properly protect themselves from any threats that penetrate the network and protect confidential company data. Finally, this course will discuss how to create a data security plan and an information security risk management plan along with some recommendations and best-practices for keeping networks safe.

 

Learning Objectives

 

At the end of this course, students will be able to:

        Identify the importance of network security for CPAs and Tax Practitioners.

        Identify what a network is along with the different components that make up a network.

        Identify the different types of network security that contribute to a comprehensive information security protocol.

        Define the term “identify theft” and recognize how identify theft most commonly occurs.

        Recognize why CPAs and Tax Professionals are being targeted by cybercriminals.

        Recognize the importance of encrypting client data.

        Identify the importance of creating internal controls and a security plan to protect client data.

 

CPE Credit: 7 CPE for CPAs and EAs

Level: Intermediate

Instructional Method: Self-Study

NASBA Field of Study: Information Technology

Program Prerequisites: None

Advanced Preparation: None

 

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies

+    Information Security Malware Trends and Mitigation Strategies 6 Online $49.99 View

 

Introduction

The malware and cybersecurity landscapes are constantly shifting in response to the actions of one another. On one side, cybersecurity experts are identifying, analyzing, and patching new forms of malware as consistently as possible so they can be detected by antivirus software and purged from infected systems before they can cause harm to their potential victims. On the other side, malware creators and cybercriminal organizations are constantly creating new malware, and altering old malware, to circumvent cybersecurity efforts and continue to infect as many computers as possible for a variety of purposes. This course will identify the overarching concepts that make up the current information security landscape. This course will provide an overview of the different types of malware that can infect a computer system as well as the different techniques used to conduct both phishing attacks and identity theft. This course will identify the general malware trends over the past several years and explain how the current malware landscape arrived at where it is today. Finally, this course will describe the most commonly seen pieces of malware from this year and provide both an in-depth explanation on how the malware operates and best practices to properly deal with each piece of malware.

 

Learning Objectives

At the end of this course, students will be able to:

        Identify the importance of information security for CPAs and Tax Practitioners,

        Identify the different types of malware that can infect computer systems,

        Define the term “Phishing” and recognize how phishing occurs,

        Define the term “Identify Theft” and recognize how identify theft most commonly occurs,

        Identify the major malware events that have occurred in recent years, and

        Identify the operating processes and mitigation techniques for the most commonly seen malware programs of the current year.

 

CPE Credit: 6 CPE for CPAs and EAs

Level: Intermediate

Instructional Method: Self-Study

NASBA Field of Study: Information Technology

Program Prerequisites: None

Advanced Preparation: None

 

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies

+    Information Security Basic Safeguards for Practitioners 6 Online $49.99 View

Introduction

 

All CPAs and Tax Practitioners deal with very sensitive client data. Cybercriminals are highly sophisticated, well-funded, and technologically adept at hacking computers and sealing information. CPAs and tax practitioners are some of their most highly desired targets. Cybercriminals desire the client data of all CPAs and tax practitioners. If these cybercriminals can successfully obtain the client information of CPAs and tax practitioners, they can file fraudulent tax returns for refunds or commit identify theft. As a result, all CPAs and tax practitioners must protect their client’s information by protecting their computers, networks and by taking some simple safety approaches. This course will define information security, describe the numerous types of threats that exist today and define how to protect your computer systems and networks to keep client data safe.

Learning Objectives

At the end of this course, students will be able to:

        Identify the importance of information security for CPAs and Tax Practitioners,

        Define the term “identify theft” and recognize how identify theft most commonly occurs,

        Recognize why CPAs and Tax Professionals are being targeted by cybercriminals,

        Recognize the importance of encrypting client data,

        Identify the importance of creating internal controls and a security plan to protect client data, and

        Recognize the actions that must be taken in the event of a breach of sensitive client identity data.

 

CPE Credit: 6 CPE for CPAs and EAs

Level: Intermediate

Instructional Method: Self-Study

NASBA Field of Study: Information Technology

Program Prerequisites: None

Advanced Preparation: None

 

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies

+    Fraud Audit Techniques Using Excel 2 Online $19.99 View

Microsoft Excel provides some easy to use tools that can greatly enhance and expedite the fraud audit process. With all detective work, you want to be able to sift through a large volume of data and utilize a tool that is adequately flexible for you to perform immediate investigations of anything questionable. Excel provides a number of different tools however we are going to focus on a couple of extremely useful ones: Auto filter, Arrays as well as a couple of extremely useful functions that include WEEKDAY and MOD.

Another tool used in fraud audits that does not necessarily require Excel, but can be used in conjunction with Excel, is Benford’s Law. Benford’s law is based on an observation that in certain large data sets, certain digits appear more frequently than others. By comparing the distribution of first digits in some accounting data, this tool can assist you in determining where more investigation is necessary by helping to pinpoint where data may have been contrived through fraud.

This course provides step by step instruction and Excel practice exercises as well as answer files.

 

COURSE LEARNING OBJECTIVES


Upon completion of this course, a participant should be

1. To improve your ability to sift through large volumes of data to determine the possibility of fraud.

2. To learn which Excel tools are more useful when conducting a fraud audit and how to utilize them effectively.



Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies

 

   
+    Excel Tips Tricks and Tools for CPAs 3 Online $29.99 View

This course is designed for the intermediate user of Excel 2010 and 2013 who are looking to improve their productivity and to learn some cool new Excel skills.  The course covers some basics, along with some advanced tips and tricks on selecting, navigating as well as copying and moving data efficiently. It also covers a spectrum of functions that can be used in everyday practice. Functions such as SUBTOTAL, SUMIF, SUMIFs as well as INDEX MATCH are discussed. The 2013 AGGREGATE and IFNA functions are covered. Comparing lists using arrays is overviewed. Pivot tables are discussed in detail. Other topics include: functions and tools for importing data into Excel, conditional formatting as well as charts. There are no associated Excel files.

 

Learning Objectives:

1.      Recognize different short cut keys and what they do

2.      Recognize the steps needed to pin a file

3.      Identify and create range names

4.      Recognize different ways to navigate within and between Excel workbooks

5.      Identify some of Excel 2013 new features and functions

6.      Recognize different copy and move methods

7.      Identify different types of formatting and how to apply them

8.      Identify different functions and formulas and when to apply them

9.      Recognize the different components of a pivot table and how to create and edit them

10.  Identify types of charts to use and how to create them

 

Version:  Excel 2010, 2013

 

 

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies

+    Excel Time Value of Money 4 Online $29.99 View

Objectives

 

 

  • Identify which Excel time value of money function should be used in a given circumstance
  • Associate compounding periods with the appropriate adjustments to rate and number of periods
  • Identify Excel’s sign convention
  • Recognize how to solve for rate, number of periods and payment
  • Recognize how to use Capital budgeting for internal rate of return and net present value
  • Recognize how to use data tables to present alternatives
+    Excel - Working with Downloaded Text Data 2 Online $12.99 View

This is an introductory course covering the basics of Excel tools and techniques dealing with downloaded data in a text format. It covers converting numbers formatted as text to numbers usable by Excel functions, concatenation, text to Columns and specific Excel text functions to manipulate and analyze data.

This course provides step by step instruction however it does not provide any exercise files.

Course Learning Objectives


At the conclusion of this course, you should be able to:






    • Convert numbers formatted as text to numeric values recognized by Excel • Identify and use the Trace Error button in Excel • Use the Left, Right and Mid functions in Excel • Concatenate text • Use Text to Columns to format text • Evaluate specific text data using Len and Find • Clean up text using the Upper, Lower, Proper, Trim and Clean functions in Excel • Convert dates formatted as text to dates recognized by Excel
   

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies

 

+    E-commerce: Applications for cyberspace technology 6 Online $49.99 View

The combination of growth in the commercial utilization of the Internet, the rapid changes in technology, and the complexity of management has expanded the scope of the duties of business managers.  This covers all aspects of electronic commerce: the World Wide Web, Internet, Intranet, Extranet, advertising and marketing, Web 2.0, XML, etc. It helps managers implement electronic commerce in their organization.  It also addresses steps to move business online, e-commerce strategies, and the concerns of business managers such as security concerns.

 

Field of Study

Computer Science

Level of Knowledge

Overview

Prerequisite

None

Advanced Preparation

None

 

 

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies


+    Computer Security: Crime And Fraud Protection 9 Online $64.99 View

The course is intended primarily to help business executives and information systems/computer professionals protect the computer and the data from a wide variety of threats.  Security concerns have heightened in the recent years.  Weak computer security and lack of internal controls increases an organization's vulnerability. The major steps in understanding and managing computer security are discussed in this course.  The course helps business executives identify resources in their organizations that need to be protected. 

 

Field of Study

Computer Science

Level of Knowledge

Overview

Prerequisite

None

Advanced Preparation

None

 


 

Click here for Course Objectives

 

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies

+    C - Lookup Functions – A Comprehensive Look at Lookup & Reference Functions 5 Online $59.99 View

Course Description

This course provides a comprehensive look at the Lookup and Reference category in Excel.  It starts by covering the LOOKUP function and then goes into great detail on the VLOOKUP function. You will learn how to use VLOOKUP, how to use it with Wildcards, how to use VLOOKUP to search through multiple sheets for a match and how to use VLOOKUP when a match is not in the first column of your table.
The course then takes a look at HLOOKUP
. It continues and explains the advantages and disadvantages of INDEX MATCH versus VLOOKUP. The course then takes a look at the OFFSET function which allows you to set up calculations that automatically update as data is added.  The INDIRECT function is also discussed and how to find data on other sheets in your file. A couple of minor functions such as HYPERLINK and TRANSPOSE are also briefly discussed.

Course Objective: To become familiar with the different Lookup functions in Excel and how to utilize them.

LEARNING OBJECTIVES:

Upon completion of this course, you should be able to:

1.   Identify different functions and understand their differences

2.   Recognize lookup functions’ syntax and how to use them in calculations

3.   Recognize the steps to incorporate data validation.

4.   Recognize the importance of range names and how to create one

5.   Recognize how to incorporate wildcards into functions

6.   Be able to incorporate other functions such  as COLUMN, ROW and ISERROR into VLOOKUPS

 

Prerequisites: Assumes familiarity with Excel and how to use basic functions such as SUM and COUNT. Assumes the user understands what an absolute cell reference is.

Version: Excel 2007/2010/2013

Level: Intermediate

NASBA Category: Computer Science/Specialized Knowledge

+    C - Creating Custom Functions in Excel 3 Book $24.99 View

Course Description:  This course covers how to create a custom function (sometimes called a user-defined function) in Excel.  A custom function is a calculation that the user creates and names. This custom function is then stored in Excel and can recalled when it is needed. In this course we will be using the Visual Basic Editor and using a couple of VBA keywords; however this is NOT a VBA or programming course.  You will create a couple of different custom functions and then see how to create an ADD-IN file so that these functions can be used in all your workbooks.

 

Course Objectives

·         Recognize how to find and access the Visual Basic Editor  

·         Identify the components of custom functions and how to use them

·         Recognize how to create, save and remove custom functions

·         Recognize the implications of creating custom functions and how they work

 

Category: Computer Science/Specialized Knowledge

Level: Intermediate to Advanced Excel user

Prerequisites: Excel 2007 or higher.  Should have a basic understanding of an IF statement.

+    Arrays- A Powerful Excel Tool 3 Book $33.99 View

Arrays are a powerful Excel tool that few people know about. It allows you to take multiple steps and consolidate them into one.

• If you are doing and IF statement in a separate column and then copying it down and then summing or averaging the results - an array will let you do it all in one step.
• Do you sit there and delete error values in a column so that you can sum them? This will show you a more efficient way
• Do you need to compare 2 lists and see what is different on one from the other?... Yes an array simplifies the process.

MATCH, ABS, SUMPRODUCT,SUMIF, NESTED IFs are briefly discussed and used in the Ebook.
The manual walks you slowly through each process. The manual is 42 pages.

Course Learning objectives

    • Gain an understanding of who arrays work • Understand how to utilize arrays in the workplace

 

 

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies

+    Accountant's Guide To Computers And Information Technology 6 Online $49.99 View

The course covers what every accountant should know about computers and information systems and technology. The practical and efficient use of computer technology is highlighted. Popular accounting, compliance, taxes, audit, write-up, forecasting and statistical, budgeting and planning, project management, activity-based accounting (ABC) software are explained for easy use.   The importance of information system and data protection, data bases, artificial intelligence and expert systems, client/server computing, and telecommunications are discussed. The course also teaches you how to make lease-purchase decisions and analyze and evaluate information technology (IT) investments.

 

Click here for Course Objectives

 

 

 

 

Additional Contents : Complete, no additional material needed
Advance Preparation : None
Intended Participants :
Any CPA looking to maintain or enhance their professional competence

Course Declaration : Participants must complete the final examination within one year of purchase. A minimum passing grade of 70% or better is required to receive CPE
Click here to view cancelation and record retention policies