Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


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

Prerequisites & Certificates
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 ]

Reviews
 
Have not looked at the course handouts yet. Instructor does not just "go through" the book, which I really appreciate. So will look at course handouts later.
Reviewed by 2013
Awesome course. Content was extactly what I required.
Reviewed by 2012
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 2011
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 2446 times.