Mobile Edition

In-depth with Excel Names (4173132B)

Date:Friday, December 8, 2017
Time:11:30AM - 1:30 PM
(Registration at 11:00AM)
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


Excel's named reference capability allows us to create a friendly name and then use that name in a variety of places, including formulas. This session covers the basics of setting up named references with the Name Box, and then how to add, edit and delete names with the Name Manager. After naming a cell, a range and a constant, dig into the details and name a few formulas. Then, use the named formulas to create a clean and modular formula. Presented in Excel for Windows.

Note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web.

  • Recall the steps for using the Name Box.
  • Recognize the dialog box to manage named references.
  • Determine the feature that allows you to name a cell.

Major Topics:
  • Named ranges
  • Named constants
  • Named formulas

Who Should Attend:

Accountants using Excel for Windows.


Advanced Preparation:


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.