Computer Application



 Title  Credit  Format  Price  View
+    Excel - Working with Downloaded Text Data 3 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

 

+    Fraud Audit Techniques Using Excel 3 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

 

   
+    Arrays- A Powerful Excel Tool 2 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 8 Online $59.00 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

+    Computer Security: Crime And Fraud Protection 12 Online $89.00 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

+    Information systems and technology For managers 22 Online $119.00 View

 

The course covers information systems  in  all  phases  of business and  in  all  functional  areas  to  analyze  and  solve business problems  in  the  "real  world."    The practical and efficient use of computer technology, both software and hardware, are highlighted.   All types of business applications are covered. The importance of data bases, networking, telecommunications, and wireless mobile technology are presented. Popular accounting, tax, finance, management, manufacturing, and marketing software are explained for easy use.   Software for  decision  support  systems  (DSS), Executive Information  Systems (EIS), and Expert Systems (ES) and Artificial Intelligence (AI) such  as financial  modeling, budgeting,  strategic planning and control,  forecasting, data analysis, inventory planning, and optimization  software   are  discussed.

+    E-commerce: Applications for cyberspace technology 11 Online $79.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


+    C - Creating Custom Functions in Excel 2 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.

+    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

+    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

+    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
+    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.