Oreilly - Excel 2007 Intermediate
by Pam Conway | Released January 2013 | ISBN: 00040COMPUWORKS
This course is designed to expand on the skills learned in the Introduction to Excel 2007 training. Specifically this class will focus on using multiple sheets in a workbook, the advantages of working with range names, creating and applying spreadsheet templates, using the outline features and creating subtotals, and understanding all the options found in Paste Special. A significant amount of the course will be spent covering creating and manipulating charts and using drawing tools to annotate charts and spreadsheets. Show and hide more
- Introduction
- Workbooks
- Navigate, name, color worksheets 00:02:59
- Inserting and Deleting Worksheets 00:01:13
- Group Worksheets 00:01:55
- Using the Watch Window 00:02:27
- Naming Worksheets 00:04:16
- Setting the Tab Color 00:02:16
- Moving and Copying Worksheets 00:02:30
- Move Sheet to Another Workbook 00:02:35
- Formatting Grouped Worksheets 00:07:00
- Entering 3D Formulas 00:03:52
- Anchoring the Watch Window 00:02:00
- Range Names
- Viewing Rules for Range Names 00:01:02
- Naming a Range of Cells 00:01:11
- Moving to a Range Name 00:01:47
- Creating a Range Name from Headings 00:01:57
- Name Manager 00:03:24
- Performing Calculations with Range Names 00:05:10
- Creating 3D Range Names 00:03:40
- Using Range Names in 3D Formulas 00:01:33
- Working with Outlines and Subtotals
- Applying an Outline Manually 00:03:20
- Applying an Automatic Outline 00:00:41
- Expanding and Collapsing an Outline 00:01:58
- Clearing an Outline 00:00:50
- Creating Subtotals 00:04:48
- Changing the Function Used in Subtotals 00:02:27
- Clearing Subtotals 00:00:38
- Using Paste Special
- Pasting with No Borders 00:02:21
- Transposing 00:02:20
- Paste Values 00:02:30
- Linking Worksheets and Workbooks 00:03:27
- Arrange Windows Tool 00:03:23
- Charts
- Creating an Embedded Chart 00:02:40
- Moving a Chart to a Separate Sheet 00:02:10
- Selecting Chart Designs and Styles 00:00:22
- Changing the Chart Type 00:01:36
- Switching Row/Column Data 00:01:15
- Selecting a Chart Layout 00:03:25
- Adding Chart Titles and Axis Labels 00:02:59
- Creating a Chart Legend, Data Labels, and a Data Table 00:03:55
- Formatting the Chart Axis 00:13:44
- Drawing Objects
- Inserting a Text Box 00:07:50
- Adding and Formatting Shapes 00:01:14
- Using Connector Lines 00:01:24
- Adding Shape Effects and Styles 00:03:24
- Creating Hyperlinks
- Using Hyperlinks 00:01:02
- Linking to a Named Range 00:01:40
- Linking to a Specific Cell 00:01:05
- Linking to a URL 00:00:47
- Linking to an External File 00:01:53
- Working with Templates
- Using an existing template 00:02:46
- Modifying a Template 00:00:31
- Saving a Template 00:04:14
- Opening a Template 00:02:13
- Conclusion
Show and hide more
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.