In-depth with Excel Names 4173132B
Register View Registrations 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.

 Export to Your Calendar 12/8/2017
When: 9:30 AM to 11:30 AM
Where: Webinar/Webcast
United States
Presenter: Jeff S. Lenning, CPA, CITP
Contact: April Deneault
801-466-10687


Online registration is available until: 12/8/2017
« Go to Upcoming Event List  

Curriculums:   Computers and Technology

NASBA Credit Category:  Computer Software and Applications

CPE Hours:  2

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.



Major Subjects

  • Named ranges
  • Named constants
  • Named formulas

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.

Level:  Overview

Designed For

Accountants using Excel for Windows.

Advanced Prep:

None.

Prerequisite

None.