Microsoft^® Excel 2007 Level II Intermediate

Target Student: This course is designed for the Excel user who has attended the Foundations course or who is proficient with those topics covered. 

Click here for a Table of Contents!

Course Content:

Lesson 1: Advanced File Tasks  

Using My Computer within Excel

Saving your Files       

Using Templates

Lesson 2: Working with Functions and Formulas

Using Formulas in Excel

Exploring Excel Functions

Using Functions in Excel       

Working with Names and Ranges

Working with Array Formulas

Lesson 3: Managing Tables

Working with Tables

Working with Records and Fields

Working with Tables and Filters        

Using Excel as a Database

Lesson 4: Enhancing your Workbook   

Customizing your Workbook 

Working with Text Boxes      

WordArt        

ClipArt           

Using Objects

Lesson 5: Finalizing Your Workbook    

Protecting your Workbook    

Finishing Your Workbook     

Using Excel in Word 

Using Excel and Access        

Using Excel With other Programs and Files