Excel 2007/2010 Intermediate Level 2

This course examines features of Microsoft Excel which assist in working with larger spreadsheets, as well as creating graphs and using drawing tools.

Course Outline

This course examines features of Microsoft Excel which assist in working with larger spreadsheets, as well as creating graphs and using drawing tools.

Detailed List of Topics Format as Table
Using The Design Tab
Design Your Own Table Style
Creating and Editing Cell Styles
Using Cell Styles in Other Workbooks

Passwords
Protecting Sheets
Protecting Workbooks
Unprotecting Specific Cells
Password Protect Files

Data Validation
Setting the Validation Rules
Setting the Allowable Values
Choosing from a List
Input Message
Error Alert

Conditional Formatting
Highlight Cell Rules
Top/Bottom Rules
Data bars, Color Scales, Icon Sets
Manage Rules
Stop if True
Clearing Rules
 
Charts (Graphs)
Creating and Editing
Formatting Items in a Chart
Changing Chart Types
Naming Charts
Printing Charts
Unlinking Charts From Data
 
Drawing Tools
Lines, Arrows, Freehand
Boxes, Circles, Arcs
Text Boxes
Group, Ungroup, Order
Colours and Shadows
Moving, Sizing, Formatting Objects
Add Pictures and Clip Art
SmartArt Graphics
Lines, Arrows, Freehand
Boxes, Circles, Arcs
Text Boxes
Group, Ungroup, Order
Colours and Shadows

Additional Details

Pre-Requisites

Excel Introduction or equivalent knowledge. It is not a necessary to take Intermediate Level 1 before this course. The topics in this course are unrelated to Intermediate Level 1. However you must have a solid understanding of the basics in Excel (Introduction topics) before attempting this course.

Certificates offered

Certificate of completion

Cancellation Policy

A full 5 business days notice is required to change or cancel any course date.

Once payment has been received, a credit will be held in your account if we have received sufficient notice of your cancellation or date change (we do not provide refunds). If insufficient notice is received, the entire fee or Tickets for that course date will be charged.

There is no charge for substitutions. If you cannot attend your course and cannot provide the 3 business days notice, you can send someone else in your place with no penalty.

Course Retake

If you cannot provide 5 business days notice of cancellation, you may take the course at a later date at no further charge with the following conditions.

1. You must take the course within 6 months of the original course date (no exceptions). After that time, the full course fee will be charged again.

2. Registration is on a stand-by basis only. If the course date you select becomes fully booked you will be asked to choose another date, which must be within 6 months of the original course date.

3. If you need to change or cancel your free re-take course, we must receive a full 5 business days notice of the change. If insufficient notice is received, this offer no longer applies and the full course fee will be charged again, should you choose to book another date.

4. This course is not transferable to another person. It must be taken by the same person who was scheduled for the original course.

5. This offer applies to the same course only (same software program, same course level and the same software version as was originally booked).

Map & Reviews

Excel Training Toronto
[ View Provider's Profile ]

Newmarket Training Centre
16635 Yonge St Unit 19
(Yonge St & Mulock Dr.)
Newmarket, Ontario
Canada   L3X 1V6

Reviews

 

   

Perhaps give option for 1/2 hour lunch as not familiar with area and just passing time during the break.

Reviewed by Robin M. 2012

   

The instructor, Katie Geoghan was phenomenal. Her energy and level of expertise were wonderful. This is the best class I have ever attended and I learned so much from it.

Reviewed by Karen C. 2011