- In Excel, you can name a cell or name a range of cells.…And then you can use those names in formulas.…And sometimes it's really helpful to clarify…what a formula is doing.…In other words, a cell address, although fine…and appropriate, is nearly as clear as a name,…provided it's a sensible name.…I'm about to write a formula in Cell I2…to calculate a new salary.…And everybody on the list here, moving down Column I,…is going to get a 2.91% increase, so that's in Cell K1.…
All these cells will be referring to that,…and I'll start off with just a simple formula.…We could do this in two or three different ways, certainly.…One way to write this formula =G2*K1.…We want this to be an absolute address,…so I'll press the function key F4 and +G2.…We have our answer.…We can copy it down the column.…However, what if we were to name that cell?…Then we could use the name in the formula.…It's going to be a little bit clearer, and the cell,…by the way, if it's farther away,…possibly this cell might be moved off to the right…or maybe it's way off to the right to begin with.…
Author
Updated
3/1/2016Released
1/28/2016- Displaying and highlighting formulas
- Converting formulas to values
- Tabulating data from multiple sheets
- Understanding the hierarchy of operations in formulas
- Using absolute and relative references
- Creating and expanding nested IF statements
- Looking up information with VLOOKUP, MATCH, and INDEX
- Using the powerful COUNTIF family of functions
- Analyzing data with statistical functions
- Calculating dates and times
- Analyzing data with array formulas and functions
- Extracting data with text function
Skill Level Advanced
Duration
Views
Q: This course was updated on 03/01/2016. What changed?
A: We added one tutorial about the new formulas in Excel 2016.
Related Courses
-
Excel Tips Weekly
with Dennis Taylor33h 56m Intermediate -
Excel 2016 Essential Training
with Dennis Taylor8h 53m Beginner -
Excel 2016: Pivot Tables in Depth
with Curt Frye3h 42m Intermediate
-
Introduction
-
Welcome50s
-
-
1. Formula and Function Tips and Shortcuts
-
Using Auditing tools6m 15s
-
2. Formula and Function Tools
-
3. IF and Related Functions
-
IF logical tests4m 27s
-
-
4. Lookup and Reference Functions
-
Nesting lookup functions4m 12s
-
5. Power Functions
-
Using MAXIFS and MINIFS4m 14s
-
Preventing double counting4m 48s
-
6. Statistical Functions
-
7. Math Functions
-
8. Date and Time Functions
-
9. Array Formulas and Functions
-
10. Reference Functions
-
11. Text Functions
-
12. Information Functions
-
Conclusion
-
Next steps33s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Enhancing readability with range names