Your source for accounting information in West Virginia Your source for accounting information in West Virginia

Log in to access your benefits

Not registered? Get a free login
Not a member? Join for great discounts

Reporting Information with Excel

03.06.18 1:00PM – 03.06.18 3:00PM

Details

Credits
2.00

Level
Intermediate

Fees

Member Fee
$60.00

Nonmember Fee
$94.00

Want to register?

View registration options

General Info

Description

 Many accounting and business professional could effectively use Microsoft Excel as a report generation tool to great success because of powerful analysis functionality, formatting capabilities and graphical output creation tools the application possesses. The material delves into ways to make both financial and non-financial data “pop” as it is presented with Excel. It discusses cell formats, conditional formatting, ways to summarize data quickly and easily, time-saving oft used formulas that can help make reports more actuate, and the powerful Excel charting engine. Those that regularly report information using Excel will benefit greatly by taking this course.

Highlights
  •    The power of Excel tables
  •   Report enhancing functions and formulas
  •   Using Excel templates
  •   Cell formatting and conditional cell formatting
Objectives

 Once participants have completed this session they should be able to:

  •   Work with cell formats to enhance the presentation of information
  •   Use formulas to check the accuracy of information and to present information in a more automated fashion
  •   Create Excel templates to save time and add consistency to reports
  •   Use tables to enhance Excel-based reports
Designed For

 Accountants and business professionals that wish to become more proficient using Excel as a report creation tool

Vendor
CalCPA Education Foundation
You must be logged in to add items to your cart. If you don't have a login you may create one for free, or save a bundle by becoming a member.