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, you'll dig into the details and name a few formulas. You'll 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. The webcast was originally broadcast on June 1, 2016. Note: There is a minimum passing rate of 70% for this course.
Highlights
• Named ranges • Named contstants • 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.
Designed For
Accountants using Excel for Windows.
Course Pricing
WYOCPA Member Fee
$69.00
Non-Member Fee
$89.00
Your Price
$89.00
Upcoming Courses
-
The Best Individual Income Tax Update Course by Surgent
October 31, 2024
-
Surgent's Industry Accountant Key Performance Metrics
October 31, 2024
-
Advanced Excel: Hidden Secrets and Gems
October 31, 2024
View all upcoming courses