Join Dennis Taylor for an in-depth discussion in this video Working with relative, absolute, and mixed references, part of Excel 2013 Essential Training.
In this worksheet called "Absolute", we're about to put a formula in column…F. We're going to create New Salary simply by giving everybody a $2000 salary increase.…Now, a formula like this involves a standard Excel technique.…If I type = and click cell E3+2000, and after typing this entry, you would want…to copy this down the column.…If you work with Excel formulas a bit, you know Excel will do exactly the right thing here.…In other words, if we complete the formula and drag from the lower right-hand…corner--let's just check it out on a few cells--…Excel is not using E3 over and over and over again.…
It's surely adjusting to using E4 and as I double-click on these, E5 and E6 and…so on, for as far down as we might copy this.…That's called a Relative Reference.…It's the most common kind of reference in Excel--a cell reference…that is relative.…If we copy the formula into different rows, it adjusts the Row Reference of a formula.…Let's take a different situation here where we want everybody's salary to go up…
Author
Dennis Taylor
Released
1/30/2013- What is Excel and what is it used for?
- Using the menus
- Working with dates and times
- Creating simple formulas
- Formatting fonts, row and column sizes, borders, and more
- Inserting shapes, arrows, and other graphics
- Adding and deleting rows and columns
- Hiding data
- Moving, copying, and pasting
- Sorting and filtering data
- Printing your worksheet
- Securing your workbooks
- Tracking changes
Skill Level Appropriate for all
Duration
Views
-
Introduction
-
Welcome39s
-
-
1. Getting Started with Excel 2013
-
What is Excel used for?1m 49s
-
Using the menu system4m 30s
-
The Quick Access Toolbar4m 41s
-
Using the Formula bar1m 43s
-
Using the Status bar2m 24s
-
Using the built-in help2m 54s
-
Creating new files2m 11s
-
-
2. Entering Data
-
Working with dates and times3m 32s
-
Using Undo and Redo4m 50s
-
Adding comments2m 55s
-
Using Save or Save As3m 57s
-
3. Creating Formulas and Functions
-
Using SUM and AVERAGE3m 25s
-
4. Formatting
-
Designing borders3m 26s
-
Formatting numbers and dates4m 31s
-
Conditional formatting4m 21s
-
Creating and using tables9m 59s
-
5. Adjusting Worksheet Layout and Data
-
6. Printing
-
Previewing page breaks4m 56s
-
7. Introduction to Charting
-
Creating charts4m 36s
-
Exploring chart types7m 47s
-
Formatting charts5m 42s
-
-
8. Adjusting Worksheet Views
-
9. Multiple Worksheets and Workbooks
-
10. IF, VLOOKUP, and Power Functions
-
11. Security and Sharing
-
Protecting workbooks2m 40s
-
Sharing workbooks4m 7s
-
Tracking changes4m 32s
-
12. Database Features
-
Sorting data6m 9s
-
Using filters6m 16s
-
Removing duplicate records2m 38s
-
-
13. PivotTables
-
Creating PivotTables8m 36s
-
Manipulating PivotTable data9m 47s
-
Grouping by other factors2m 33s
-
Using PivotCharts3m 59s
-
-
14. Data Analysis Tools
-
Using Goal Seek6m 8s
-
Using Solver6m 34s
-
Using Scenario Manager6m 11s
-
Using Data Tables4m 36s
-
-
15. Introduction to Macros
-
Definition and examples6m 48s
-
Running a macro10m 43s
-
-
Conclusion
-
Next steps29s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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: Working with relative, absolute, and mixed references