Computer & Software CPE Courses

Course number: CC764706

Covers what accountants should know about computers, information systems and technology. Explains the use of popular accounting, compliance, tax, audit, write-up, forecasting, budgeting, project management, and activity-based accounting (ABC) software. The importance of information system and data protection, databases, artificial intelligence and expert systems, client/server computing, and telecommunications are also discussed. Also teaches you how to make lease-purchase decisions and analyze and evaluate information technology investments. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Information Technology.     Course credit: 6 hours

Course number: CC446402

Even a well-run company can be brought down by a disaster, such as a fire or flood. In the Disaster Recovery Planning course, we describe how to identify risk areas and create and test a plan for how to deal with them. Topics covered include risk analysis, developing a recovery strategy, crisis management, disaster recovery priorities, and dozens of best practices for mitigating all kinds of disasters. This is the go-to guide for setting up a disaster recovery plan. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam and grading service.

NASBA field of study: Information Technology    Course credit: 6 hours

Course number: CC713301

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 course covers all aspects of electronic commerce: the internet, advertising and marketing, and specific technologies. It also addresses steps to move business online, e-commerce strategies, and the concerns of business managers such as security issues. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam and grading service.

NASBA field of study: Specialized Knowledge    Course credit: 6 hours

Course number: CC669421

Understanding how to use the many features of Excel is only half the battle. The other half is understanding what these features can do for you. So whether you\'re starting out or upgrading, using Excel on your desktop or tablet, this course covers what you need to know. In this course, you’ll delve into some of Excel’s more advanced topics such as: building and maintaining tables; filters; queries; performing what-if scenarios; generating (and formatting, sorting, and modifying) PivotTables; building and running macros; and VBA programming. Course includes integrated text and study guide, final exam, and grading service. Note: This version of Excel works only with Windows 10 or later.

NASBA field of study: Computer Software & Applications    Course credit: 16 hours

Course number: CC667521

Understanding how to use the many features of Excel is only half the battle. The other half is understanding what these features can do for you. So whether you’re starting out or upgrading, using Excel on your desktop or tablet, this course covers what you need to know. In this course you’ll learn the basics: working with worksheets — learn to set up, edit, manage, format, edit, proof, reorganize, and print worksheets. Also covers how to customize Excel, how to use Excel on a touchscreen, and all the different ways to enter data. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service. Note: This version of Excel works only with Windows 10 or later.

NASBA field of study: Computer Software & Applications    Course credit: 18 hours

Course number: CC668821

Understanding how to use the many features of Excel 2021 is only half the battle. The other half is understanding what these features can do for you. So whether you\'re starting out or upgrading, using Excel on your desktop or tablet, this course covers what you need to know. In this course you’ll learn how to build basic formulas, array formulas, date and time formulas, financial formulas, math and statistical formulas, and more. Also learn all about how to chart your worksheet data and add graphic objects like clip art, text boxes, WordArt, screenshots, graphics and more. In addition, you’ll learn how to use themes. IMPORTANT NOTE: This version of Excel is not compatible with versions of Windows prior to Windows 10. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 12 hours

Course number: CC410102

It can be difficult to convey the meaning derived from a spreadsheet, especially when there are large amounts of data involved. An excellent solution is to use the charts and other data visualization tools contained within Excel. In the Excel Charts and Visualizations course, we discuss how to create and modify charts, the many types of charts and when they are most applicable, advanced charting practices, sparkline graphics, custom formatting codes, shapes, icons, and dashboard concepts – everything you need to achieve the best possible presentations. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 2 hours

Course number: CC410302

It can be difficult to extract any meaningful information from the large amounts of data stored in an Excel worksheet, or to sort through multi-variable problems. The Excel Data Analysis Tools course provides a number of solutions to these issues by showing how to use PivotTables, what-if analysis, data tables, goal seeking, and the Scenario Manager and Solver tools. This course reveals how to extract the maximum amount of usable information from large data sets, as well as provide ready solutions to seemingly intractable analysis problems. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 2 hours

Course number: CC410502

A central concern when using Excel is whether the data being used is sufficiently clean and well-organized to be useful for further analysis. In the Excel Data Management course, we cover the importing of data from other sources, cleaning it, validating data at the point of data entry, protecting it from unauthorized changes, and organizing it properly. The outcome is much more reliable data, which improves the quality of any subsequent analyses conducted on the data. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 2 hours

Course number: CC410702

Excel is an essential spreadsheet tool for the accountant. To wring the greatest possible use from it, one should have a detailed understanding of how to use formulas and functions. In the Excel Formulas and Functions course, we discuss the mechanics of constructing formulas and how to use many of the functions that apply to common business problems, such as net present value analysis, using date calculations, and calculating depreciation. The course also covers how to create error-free worksheets. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 3 hours

Course number: CC410901

Hackers have many methods for breaking through the security surrounding a CPA firm’s information systems. The Information Security for CPAs course describes the ways in which hackers can attack a computer system, as well as the many ways in which a CPA firm can protect its systems from attack. The course also addresses the FTC Safeguards Rule, which applies to tax return preparers. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Information Technology    Course credit: 1 hour

Course number: CC411202

Excel is one of the primary tools of the accountant. It is needed for many accounting activities, such as tracking the contents of accounts and conducting financial analyses. However, Excel is a massive program with hundreds of commands and quirky formatting options. In Introduction to Excel, we cover the basics of setting up and populating an Excel worksheet, as well as producing well-organized outputs. Topics covered include the menu system, formatting, named styles, templates, and a variety of printing options. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 3 hours

Course number: CC646721

Technology is supposed to help us get things done faster and more efficiently. With the tips, shortcuts, and how-tos in this course, you will be able to do just that with Office 2021. Master all the features the different applications have in common, and then learn how to get the most from each individual part of Office. This course covers the ins and outs of Word 2021, Excel 2021, and PowerPoint 2021. You’ll learn how to create every type of document in Word; how to crunch numbers, design worksheets, and analyze data with Excel; put together and deliver PowerPoint presentations that get attention and really communicate; and more. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 20 hours

Course number: CC646821

Technology is supposed to help us get things done faster and more efficiently. With the tips, shortcuts, and how-tos in this course, you will be able to do just that with Office 2021. Master all the features the different applications have in common, and then learn how to get the most from each individual part of Office. This course covers the ins and outs of Outlook 2021, Access 2021, and special Office features. You’ll learn how to track and manage e-mail, contacts, tasks, and calendars with Outlook; create an Access database and discover how useful it can be; explore methods of customizing Office, creating brochures and newsletters with Publisher; and more. Course level: Basic. Prerequisites: A basic knowledge of Office or Course CC646721 (Office 2021 – Part 1). Course includes integrated text and study guide, final exam and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 14 hours

Course number: CC672122

Discover how QuickBooks 2022 can help you build the perfect budget, process payroll, simplify your tax return prep work, create invoices, manage inventory, generate income statements, balance accounts, and much more. You will learn what you should do before you install and set up QuickBooks. Also takes you through the steps of going online and backing up your data. You’ll learn how to: set up QuickBooks; enter data; create and populate lists; create invoices and credit memos; record and print sales receipts; monitor your job costs; record customer payments; make bank deposits; enter and pay bills; work with inventory; write checks; reconcile bank accounts; set up a credit card account; process payroll; perform job estimating, billing, and tracking functions; work with fixed assets and vehicles; generate most common financial reports; and more. In addition, the course includes an overview of small business finance and accounting, budgeting, and business plans. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 24 hours

Course number: CC672123

Discover how QuickBooks 2023 can help you build the perfect budget, process payroll, simplify your tax return prep work, create invoices, manage inventory, generate income statements, balance accounts, and much more. You will learn what you should do before you install and set up QuickBooks. Also takes you through the steps of going online and backing up your data. You’ll learn how to: set up QuickBooks; enter data; create and populate lists; create invoices and credit memos; record and print sales receipts; monitor your job costs; record customer payments; make bank deposits; enter and pay bills; work with inventory; write checks; reconcile bank accounts; set up a credit card account; process payroll; perform job estimating, billing, and tracking functions; work with fixed assets and vehicles; generate most common financial reports; and more. In addition, the course includes an overview of small business finance and accounting, budgeting, and business plans. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam, and grading service.

NASBA field of study: Computer Software & Applications    Course credit: 24 hours

Course number: CC626108

QuickBooks Online provides the best and most current information for those looking to get the most out of the leading QuickBooks Online software. This course walks you through each and every step of creating an invoice or credit memo, recording a sale, paying bills, setting up and managing your inventory, and tracking your business checkbook and credit cards. It also includes: new updates on exporting data to Microsoft Excel or Google Sheets so that you can analyze your business data in new ways; walk-throughs of how to install and set up QuickBooks Online; exclusive tips for accountants working with clients in QuickBooks Online, including new techniques for automating monthly reports that you create in Excel from data that you export from QuickBooks; and more. Course level: Basic. Prerequisites: None. Course includes integrated text and study guide, final exam and grading service.

NASBA field of study: Computer Software & Applications     Course credit: 16 hours