Microsoft Excel 2007 - Level 2

This course introduces a user to Excel's intermediate features for editing a worksheet, using cell commands and tracking changes. Charting data is explored along with building skills to manage multiple worksheets.

Course Outline

This course introduces a user to Excel’s intermediate features for editing a worksheet, using cell commands and tracking changes. Charting data is explored along with building skills to manage multiple worksheets. Building on skills learned in Level 1, more advanced uses of functions and formulas are explored along with creating and defining range names. Analyzing and organizing data along with manipulating and formatting objects such as clip art, SmartArt and graphic onjects is revisited.

Course Content

Worksheet Organization

• Range Names
• Workbook Templates
• Worksheet Security
• Outlining

Advanced Formulas

• Using the IF Function
• Linking Formulas

Using Multiple Workbooks and Worksheets

• Working with Multiple Workbooks
• Setting Up Multiple Worksheets
• Using Multiple Worksheets
• Creating Links with Formulas
• Modifying and Restoring Links
• Consolidating Data

Working with Charts

• Creating Charts
• Changing Chart Data
• Modifying Chart Elements
• Creating Custom Charts

Applying Formatting

• Creating Styles
• Working with Styles
• Using Conditional Formatting
• Annotating Worksheets

Additional Details

Pre-Requisites

Excel 2007 - Level 1 or equivalent experience

Certificates offered

Certificate of completion

Cancellation Policy

10 business days cancellation or full course fee will be charged

Map & Reviews

Technology Training Centre
[ View Provider's Profile ]

Edmonton Training Center
B-11 Cameron Library
University of Alberta
Edmonton, Alberta
Canada   T6G 2J8

Reviews

 

   

The instructor was excellent. It was evident that several of us who were competent with Excel 2003 Level 1 should have probably taken Excel 2007 Level 1 again rather than Excel 2007 Level 2, but the instructor was very patient and managed to cover basics from Level I as well as Level 2.

Reviewed by Kim C. 2011