- We're looking at a worksheet called CopyFormulas,…in the workbook, 03 - Creating Formulas and Functions.…A formula is written in cell B4.…Remember, if the cell is selected, you can see the formula…in the formula bar, or if you've zoomed in,…as this particular worksheet has been,…you can double click here, perhaps see it…a little bit better, and it is color coded.…Now, we need to do this for February, March,…April, May, June.…Possibly in a similar worksheet,…we might have 12 months here.…We don't want to be retyping this kind of a formula…many, many more times.…
In Excel, it's not uncommon…that after you've written a formula,…you need to copy it either rightward into adjacent cells,…or downward.…And it's a huge time saver to be able to do this.…Now, the formula that we're seeing here,…and I'll double click it again, is B2-B3.…We certainly do not want to see that formula right here.…But when you copy a formula,…Excel does what we would want it to do.…In other words, and if we think of this formula…in a different way, this is a formula…
Author
Dennis Taylor
Released
9/22/2015- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome38s
-
-
1. Getting Started with Excel
-
What is Excel used for?2m 14s
-
Using the menu system5m 50s
-
Using the Formula bar1m 37s
-
Using the Status bar5m 20s
-
Using navigation tools3m 24s
-
Creating new workbooks2m 37s
-
Using Excel Help5m 28s
-
-
2. Entering Data
-
Entering data with AutoFill3m 56s
-
Working with dates and times4m 28s
-
Using Undo and Redo4m 13s
-
Adding comments2m 52s
-
Using Save or Save As4m 11s
-
3. Creating Formulas and Functions
-
Creating simple formulas7m 11s
-
Using SUM and AVERAGE5m 18s
-
Using other common functions7m 44s
-
-
4. Formatting
-
Designing borders2m 55s
-
Formatting numbers and dates7m 18s
-
Using conditional formatting8m 13s
-
Creating and using tables11m 18s
-
5. Adjusting Worksheet Layout and Data
-
Finding and replacing data5m 30s
-
6. Printing
-
Previewing page breaks5m 53s
-
7. Charts
-
Creating charts6m 45s
-
Exploring chart types9m 53s
-
Formatting charts7m 12s
-
New charts in Excel 201610m 19s
-
-
8. Adjusting Worksheet Views
-
9. Multiple Worksheets and Workbooks
-
10. IF, VLOOKUP, and Power Functions
-
11. Security and Sharing
-
Protecting workbooks5m 50s
-
Sharing workbooks3m 57s
-
Tracking changes5m 17s
-
12. Data Management Features
-
Sorting data9m 44s
-
Using filters6m 43s
-
Removing duplicate records2m 23s
-
Using validation tools10m 45s
-
-
13. Data Analysis Tools
-
Using Goal Seek7m 14s
-
Using Solver7m 3s
-
Using Scenario Manager6m 38s
-
Using data tables8m 21s
-
-
14. PivotTables
-
Creating PivotTables12m 25s
-
Manipulating PivotTable data11m 27s
-
Grouping by date and time10m 50s
-
Grouping by other factors4m 40s
-
Using PivotCharts4m 42s
-
-
15. Introduction to Macros
-
Creating a simple macro10m 20s
-
Running a macro13m 46s
-
Conclusion
-
Goodbye35s
-
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: Copying a formula into adjacent cells