Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Reporting Information with Excel 4173387Y
Register View Registrations Tell a Friend About This EventTell a Friend
 

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.

 Export to Your Calendar 3/6/2018
When: 11:00 AM to 1:00 PM
Where: Webinar/Webcast
United States
Presenter: Karl Egnatoff, CPA
Contact: April Deneault
801-466-10973


Online registration is available until: 3/6/2018
« Go to Upcoming Event List  

Curriculums:   Computers and Technology

NASBA Credit Category:  Computer Software and Applications

CPE Hours:  2

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.



Major Subjects

  •    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

Level:  Intermediate

Designed For

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

Advanced Prep:

 None

Prerequisite

 A basic understanding of spreadsheet use and Microsoft Excel conventions

Membership Management Software Powered by YourMembership  ::  Legal