Mobile Edition


Excel Power User Module 6: Time-Saving Techniques (4172986B)

 
Date:Friday, January 5, 2018
Time:2:00 PM - 4:00 PM
(Registration at 1:30 PM)
Facility:Webcast or Webinar, Online
CPE Credit:2.0 Technical Business
Instructor: Jeff S. Lenning
Vendor:California CPA Education Foundation
Course Level:Overview
Early Bird Price:$60.00 FICPA Members, $90.00 Non-Members

Description:

The Excel Power User series helps you improve your Excel proficiency and quickly complete tasks.

In this session, apply numerous features and functions examined in previous sessions in a variety of time-savings techniques. Continue to integrate these features as we proceed throughout the series.

Note: This session is presented with Excel for Windows. Items covered may not be available in Excel for Mac.



Objectives:
  • Identify which function help build dynamic report headers.
  • Recall a technique that helps Excel translate a data label to a report label.
  • Recognize which feature can be used to provide a filter for dynamic digital reports.


Major Topics:
  • Dynamic Headers.
  • Horizontal Reports.
  • Mapping Tables.
  • Data Validation and Reporting.
  • Improving Error Check with Boolean Values and the Logical AND Function.


Who Should Attend:

Accounting professionals that use Excel for Windows.



Prerequisite:
Excel Power User Modules 1-5 or knowledge of the topics covered.

Advanced Preparation:
None.

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.