Join Lorna Daly for an in-depth discussion in this video Why use macros?, part of Excel 2007 Essential Training.
To automate repetitive tasks, you can quickly record a macro…in Excel 2007 so that you don't have to repeat the same set of commands or steps over and over and over.…So this is a real timesaver, especially if you're going to be doing this often…to the same worksheet or sets of workbooks.…Now, to set up or to record a macro, you need to set up Excel to allow you to see the Developers tab. Now there's different ways…that you could record macros in Excel, and…again, because we're working in the essential things that you need to know about Excel, we're going to use the simplest way of doing…that. And that's to record our movements on the screen.…
First of all though, we need to see the Developers tab, which is not visible at the moment. So what we have to do is we…need to go up to our Microsoft Office button…and select it,…and go back over to our Excel options button that we were looking at at the very beginning of our set of movies.…And in doing that, on our very first screen here,…we are going to enable the Show Developer tab in the ribbon. So I want you to select that…
Author
Released
1/31/2007Skill Level Beginner
Duration
Views
Q: When trying to apply the techniques from the “Relative and absolute referencing” video to a worksheet other than the exercise file included with the title, the formulas did not work for the entire worksheet. The formulas would only work when going through the worksheet row by row. What could be causing this to happen?
A: When trying to apply formulas to a whole workshee, here is a tip to try:
If you want to always refer to the same cell then use an absolute reference. For example, always pulling the value from cell A3 would be referenced as $A$3. This will never change no matter where you copy it to in the spreadsheet.
If you want to reuse the same formula, but with values in different cells, use the relative reference, A3. This way formula =A3*B3 will become =A4*B4 as you copy it down a column.
Q: In the chapter 7 video "Sorting and Grouping" at approximately 4:05, the author says to go to cell 5 on the worksheet and click on Subtotal to subtotal the grouping. My screen will not allow me to click on the Subtotal option at the top of the page. Is this an issue with my version of Excel?
A: It seems that there is an error in the instructions in this video. The video should have instructed users to do the subtotaling first, then create the table.
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
Related Courses
-
Excel 2007 Power Shortcuts
with Michael Ninness2h 4m Intermediate -
Excel 2007: Advanced Formatting Techniques
with Dennis Taylor3h 8m Intermediate -
Excel 2007: Macros
with Dennis Taylor2h 29m Intermediate -
Excel 2007: Charts
with Dennis Taylor3h 36m Intermediate
-
Introduction
-
Welcome35s
-
-
1. Getting Started
-
Why use a spreadsheet?1m 25s
-
The Ribbon2m 9s
-
The Microsoft Office Button1m 27s
-
-
2. Setting Up Excel 2007
-
What's on the Ribbon?1m 56s
-
Customizing the Ribbon3m 8s
-
-
3. Modifying Worksheets
-
Opening old worksheets2m 23s
-
Inserting and deleting cells6m 53s
-
-
4. Basic Formatting
-
Width and height7m 25s
-
Numeric formats2m 20s
-
Alignment of data3m 18s
-
Playing with fonts2m 57s
-
AutoFilter2m 21s
-
Formatting as a table2m 27s
-
-
5. Advanced Formatting
-
Removing duplicates6m 1s
-
Converting text to columns4m 35s
-
Data validation3m 41s
-
-
6. Using Templates, Styles, and AutoFormat
-
Templates3m 45s
-
Styles3m 35s
-
AutoFormat3m 36s
-
-
7. Managing Lists in Excel
-
Converting text to columns3m 10s
-
Sorting and Grouping5m 9s
-
Creating a summary report1m 21s
-
8. Reviewing Worksheets
-
Proofing your work3m 30s
-
-
9. Sharing Worksheets
-
Track Changes3m 43s
-
10. Printing Workbooks
-
Preparing to print2m 31s
-
Print Preview3m 33s
-
The Page Layout Tab3m 56s
-
Page Breaks4m 35s
-
The Page Layout View3m 53s
-
Headers and Footers4m 12s
-
-
11. Enhancing Worksheets
-
Scale to Fit2m 26s
-
Worksheet options5m 28s
-
Inserting images3m 46s
-
12. Using Templates
-
Using templates3m 49s
-
-
13. Manipulating the Screen Display
-
Workbook Views2m 52s
-
Hiding and Zooming3m 44s
-
Window Panes5m 31s
-
More screen options5m 40s
-
-
14. Importing Data
-
Importing from Access2m 24s
-
-
15. Finding and Replacing Data
-
The Find and Select button4m 34s
-
Find and Replace2m 48s
-
Removing duplicates4m 1s
-
-
16. Working with Formulas
-
What are formulas?3m 20s
-
Order of Operations2m 49s
-
The new Formula Tab5m 59s
-
-
17. Working with Basic Functions
-
What are Functions?2m 56s
-
AutoSum2m 47s
-
Minimum3m 55s
-
Trim5m 2s
-
Left2m 48s
-
-
18. Working with Advanced Functions
-
Concatenation4m 9s
-
SumIf4m 23s
-
Lookup7m 24s
-
What-If Analysis3m 53s
-
-
19. Charts
-
Why create a chart?2m 11s
-
Creating your chart3m 37s
-
Modifying your chart6m 46s
-
Laying out your chart4m 8s
-
-
20. Pivot Tables
-
Creating a PivotTable4m 47s
-
Laying out your PivotTable2m 30s
-
Creating a PivotChart3m 25s
-
21. Working with Macros
-
Why use macros?2m 13s
-
Creating a macro4m 31s
-
Macro security2m 12s
-
-
22. Workflow in Excel 2007
-
Conclusion
-
Conclusion22s
-
- 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: Why use macros?