Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


This course's emphasis is on the visual aspects of an Excel spreadsheet. Whether it's something as simple as getting cells to colour themselves based on the values entered, to mid-level tricks like making in-cell menus, to complex topics like making a gr


 
Course Outline
A simple spreadsheet is often enough, but many times you need to make it look good too. This course's emphasis is on the visual aspects of an Excel spreadsheet. Whether it€'s something as simple as getting cells to colour themselves based on the values entered, to mid-level tricks like making in-cell menus, to complex topics like making a graph, you€'ll learn it here.

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

Reviews
 
Trainer was great, he was very knowledgable in the topic! The course was great, however I would have liked to complete exercises at the end of each topic as oppose to one big exercise at the end.
Reviewed by 2013
Perhaps give option for 1/2 hour lunch as not familiar with area and just passing time during the break.
Reviewed by 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 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 11838 times.