Use Landscape to see Search/Filter
Item Types:
Field of Study:
CPE Hours:
Course Details

Creating Custom Financial Statements using Excel (Course Id 691)

QAS / Registry
  Add to Cart 
Author : Patricia McCarthy, MBA
Course Length : Pages: 22 ||| Review Questions: 6 ||| Final Exam Questions: 10
CPE Credits : 2.0
IRS Credits : 0
Price : $17.95
Passing Score : 70%
Course Type: NASBA QAS - Text - NASBA Registry
Primary Subject-Field Of Study:

Computer Software & Applications - Computer Software & Applications for Course Id 691

Description :

Most general ledger packages do a great job of aggregating journal entries and creating a trial balance. Where many fall short is in the presentation of financial information in the form of financial statements. Many have default financial statements that conform to the presentation needs of a manufacturing entity or a wholesaler, but are not very flexible beyond that. If they do provide for customizable financial statement formats, it can be a difficult and time consuming process.

The good news is that using Excel to prepare custom financial statements from a trial balance is a relatively easy and straightforward process. If the general ledger account numbers already have financial statement mapping embedded in them, the process is a few simple steps. If the general ledger account numbers do not indicate the appropriate financial statement line item, there is one intermediate step that provides a map to the financial statement from the trial balance.

Using the techniques in this course, you can create custom financial statements in any form or format that is necessary using Excel.

Usage Rank : 0
Release : 2015
Version : 1.0
Prerequisites : None
Experience Level : Overview
Additional Contents : Complete, no additional material needed
Additional Links :
Advance Preparation : Should have familiarity with formulas and functions
Delivery Method : QAS Self Study
Intended Participants : Anyone needing Continuing Professional Education (CPE)
Revision Date : 01-Jun-2021
NASBA Course Declaration : Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.
Approved Audience :

NASBA QAS - Text - NASBA Registry - 691

Keywords : Computer Science, Creating, Custom, Financial, Statements, using, Excel, cpe, cpa, online course
Learning Objectives :

Course Learning Objectives

Upon completion of this course, you should be able to:
    Define certain text functions and use them to capture a portion of a general ledger account number
    Recognize the uses of the SUMIF function
    Define and use the VLOOKUP function
    Associate the INDIRECT function with referencing Excel worksheets
Course Contents :

Chapter 1 - Creating Custom Financial Statements using Excel

Course Learning Objectives

Course Overview

Trial Balance with Financial Statement Mapping Embedded in the Account Number

LEFT, RIGHT and MID Excel Functions

Creating the Balance Sheet

Handling a Trial Balance with No Financial Statement Mapping in the Account Number

Using the INDIRECT Function

Review Questions


Review of Excel Functions Utilized

The SUM Function

Working with Text

The SUMIF Function

The VLOOKUP Function


Review Questions



Excel Course 691 Home: https://www.cpethink.com/excel-cpa-courses
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
Exam completed on .

Do you want to add the course again?