->
Oreilly - Excel 2007 Intermediate - 00040COMPUWORKS
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
  1. Introduction
    • Introduction 00:02:37
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. Conclusion
    • Conclusion 00:02:17
  11. Show and hide more

    Oreilly - Excel 2007 Intermediate


 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.


 Coktum   |  

Information
Members of Guests cannot leave comments.




rss