Excel for Staff Level 2 - Getting More Out of Excel

OL1437  |  On Demand Course  |  Update  |  Self-Study

Description

Excel can do so many things but what are some of the features that can really help accountants take their Excel skills to the next level? This course is designed to do just that. To learn ALL the capabilities of Excel would take hundreds of hours of training, so this two-hour course is designed to give you a jump start on the most important features that you can immediately begin implementing in your spreadsheets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Credits

Number of Credits Type of Credits
2.00 Computer Software & Applications

Designed For

Any Excel user that wants to their spreadsheets to the next level.

Highlights

The major topics that will be covered in this class include:

  • Overview of setting up spreadsheets for data analysis and how Excel Tables can help
  • Learning the importance of Consistent Column Calculations
  • How to use Conditional Formatting to highlight important information
  • How to leverage Excel Tables by analyzing them in PivotTables
  • Learning to leverage array formulas

Objectives

After attending this presentation, you will be able to...

  • Identify the best practices for setting up spreadsheets for data analysis
  • Apply the use of Consistent Column Calculations to improve the accuracy of your spreadsheets
  • Determine how to leverage array formulas

Prices

Member (Early Bird)
$89.00
Non-Member (Early Bird)
$129.00
Member
$89.00
Non-Member
$129.00
Your Price: $129.00

This is your base price and does not reflect any additional session fees, optional add-ons, or guest registrations.

Members log in and save $40.00 on this event. Not a member? join today.

Instructors

Bryan L. Smith, CPA, CITP, CISA

Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan's expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.

Back to Instructors
Return to Events