MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Excel 2007 Intermediate

Course Summary

Expand your Excel abilities with charts, outlines, workbooks and much more

  • +

    Course Syllabus

    • Introduction
      • Introduction
    • Workbooks
      • Navigate, Name, Color Worksheets
      • Naming Worksheets
      • Setting the Tab Color
      • Inserting and Deleting Worksheets
      • Moving and Copying Worksheet
      • Move Sheet to Another Workbook
      • Group Worksheets
      • Formatting Grouped Worksheets
      • Entering 3D Formulas
      • Using the Watch Window
      • Anchoring the Watch Window
    • Range Names
      • Viewing Rules for Range Name
      • Naming a Range of Cells
      • Moving to a Range Name
      • Creating a Range Name from Headings
      • Name Manager
      • Performing Calculations with Range Names
      • Creating 3D Range Names
      • Using Range Names in 3D Formulas
    • Working with Outlines and Subtotals
      • Applying an Outline Manually
      • Applying an Automatic Outline
      • Expanding and Collapsing an Outline
      • Clearing an Outline
      • Creating Subtotals
      • Changing the Function Used in Subtotals
      • Clearing Subtotals
    • Using Paste Special
      • Pasting with No Borders
      • Transposing
      • Paste Values
      • Linking Worksheets and Workbooks
      • Arrange Windows Tool
    • Charts
      • Creating an Embedded Chart
      • Moving a Chart to a Separate Sheet
      • Selecting Chart Designs and Styles
      • Changing the Chart Type
      • Switching Row/Column Data
      • Selecting a Chart Layout
      • Adding Chart Titles and Axis Labels
      • Creating a Chart Legend, Data Labels, and a Data Table
      • Formatting the Chart Axis
    • Drawing Objects
      • Inserting a Text Box
      • Adding and Formatting Shapes
      • Using Connector Lines
      • Adding Shape Effects and Styles
    • Creating Hyperlinks
      • Using Hyperlinks
      • Linking to a Named Range
      • Linking to a Specific Cell
      • Linking to a URL
      • Linking to an External File
    • Working with Templates
      • Using an Existing Template
      • Modifying a Template
      • Saving a Template
      • Opening a Template
    • Conclusion
      • Conclusion

Course Fee:
USD 30

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top