Computer Application



 Title  Credit  Format  Price  View
+    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.

+    C - Lookup Functions – A Comprehensive Look at Lookup & Reference Functions 5 Book $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 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