Excel Financial Reporting and Analysis

Description

Microsoft Excel is a powerful tool for analyzing financial data and preparing financial reports, but like most powerful tools, it contains hidden features and functionality useful for these purposes that are not obvious to users, both novice and expert alike. The purpose of this course is to uncover these hidden features so that users may prepare computationally accurate and aesthetically pleasing reports in a more effective and efficient manner. It provides solutions for accountants in the following six major topic areas: advanced techniques for formatting reports and financial statements, assembly and printing of reports and schedules, using templates to automate reporting processes, advanced financial analysis with PivotTables connected to the general ledger using ODBC, data consolidation, and using charts and digital dashboards for presenting financial information. Participants will have access to sample data files. This course includes coverage of features found in Excel 2003, 2007, and 2010.

Learning Objectives

* Identify and understand how to format financial statements and other Excel-based reports more effectively with tools such as custom formats, conditional formatting, the accounting format, and multicolumn line headings
* Recognize opportunities to streamline report assembly and printing with tools such as camera, custom views, Report Manager, linked and embedded objects, and saving Excel-based reports as PDF documents
* Differentiate between Excels default templates and templates for financial reporting and analysis and describe how to create templates and apply them to financial reporting and analysis situations
* Describe how Excel features such as Sorting, Data Tables, Subtotal, Filters, and PivotTables aid in financial reporting and analysis and apply each of these tools in context
* List four techniques for consolidating data, describe advantages of each technique, and apply each technique when consolidating data
* Create Excel-based charts and dashboards to aid in communicating financial data to information consumers, including differentiating between different types of charts and describing the circumstances under which certain types of charts are preferable

Major Topics

* Easily apply and control underlining, spacing, and label alignment with the accounting format
* Use Precision as Displayed to insure accuracy of footings and cross-footings and to eliminate positive and negative zeros in reports
* Select and act on multiple cells, ranges, rows, columns, and sheets simultaneously
* Use custom number formats to report in thousands, millions, or billions
* Customize your work environment by modifying the default workbook and worksheet templates
* Use custom views and the Report Manager to automate report printing and use the camera to create complex reports from multiple ranges
* Link Word documents to Excel data
* Import or work with data stored in external databases, such as the general ledger, using
ODBC
* Use advanced techniques, such as text to columns, paste special, and go-to special, to clean up imported data
* Perform advanced data analysis with data tables, subtotals, filters, PivotTables, and Pivot Charts
* Use array formulas to round-off in totals and other useful tasks
* Use conditional formatting to create dynamic dashboard displays of tabular data
* Create, manipulate, and customize charts for analyzing and communicating information
* Consolidate data using sum-through and wild-card formulas, the data consolidate command, and consolidation PivotTables
* Produce rolling reports with formulas using end-point sheets or end-point columns
* Save documents as PDF or XPS files to ease communication and distribution
* Protect documents using password encryption or Information Rights Management
* Digitally sign and restrict changes to Word documents and Excel workbooks
* Remove hidden metadata from workbooks and documents before distribution

Provider
K2 Enterprises, L.L.C.
Course Level
Advanced
CPE Field of Study
Accounting
8.0
Instructor(s)
Karl Egnatoff
Prerequisites

Fundamental knowledge of Excel operations

Advanced Preparation

None

Location

Colorado Society Of CPAs, 7887 E. Belleview Ave, Suite 200, Englewood CO 80111

View in Google Maps
Register Now
When
Oct 22, 2012
8:30 am - 4:30 pm
Location
Colorado Society Of CPAs, 7887 E. Belleview Ave, Suite 200, Englewood CO 80111
Total CPE Credits
8.0
Format
In-Person
Instructor
Karl Egnatoff

MEMBER


$ (% off)
$325.00

NON-MEMBER


$ (% off)
$464.00
Become A Member

Register for this Event

Excel Financial Reporting and Analysis


Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×