Webcast: In-depth with Excel Names (XCIDEXN17)
Tell a Friend About This EventTell a Friend
 

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.

12/8/2017
When: 12/08/2017
10:30 AM until 12:30 PM
Where: Webcast
CALCPA
4173132B
United States
Presenter: Jeff S. Lenning, CPA, CITP


Online registration is closed.
« Go to Upcoming Event List  

Acronym XCIDEXN17
CPE 2 hours
Vendor CalCPA
Category
Management
Level Overview
Prerequisite None
Adv Prep None
Yellow Book? No
Designed for Accountants using Excel for Windows.
Registration
Member $60
CPA Non-Member $94

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Course Description

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.

Materials are provided as an ebook.

Objectives

  • 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