Join Dennis Taylor for an in-depth discussion in this video Using absolute and relative references, part of Excel 2010: Advanced Formulas and Functions.
Certainly one of the most common things you do in Excel when working with…formulas is rather than putting in a formula repeatedly across or down multiple…cells, we enter a formula once, as in the example here--a simple little formula…to subtract the cells--and then we copy the formula.…Now whether you have used the word or not, most copying of formulas in Excel…involves the idea of a relative copy.…This formula literally says K2-K3.…
When we copy a formula, we copy it relatively, unless we take steps to do…otherwise: meaning we don't want to see the formula K2-K3. It wouldn't make any sense.…We would have the same answer as this. It's not true.…We automatically get a feature called relative copying, meaning the column…letters have been adjusted.…If we move one column to the right our column references have been adjusted by one.…If we had somehow moved this down and to the right, the row references would have…become adjusted also.…
It wouldn't make sense in this context.…And so whether we say the words or not, relative copying is what we do most of…
- Referencing, copying, updating, and converting formulas
- Using the logical functions and creating compound logic tests
- Searching for and matching data based on specific criteria
- Reconfiguring cell data using text functions
- Calculating dates, times, and days of the week
- Analyzing mathematical and financial data
- Using the power functions, COUNTIFS, SUMIFS, and AVERAGEIFS
- Working with rounding functions
- Returning cell references
Skill Level Advanced
1. Formula and Function Tips and Shortcuts
2. Formula and Function Tools
3. IF and Related Functions
4. Lookup and Reference Functions
5. Power Functions
6. Statistical Functions
7. Date Functions
8. Math Functions
9. Array Formulas and Functions
10. Text Functions
11. Financial Functions
12. Information Functions
13. Reference Functions
- 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.Cancel
Take 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.