Excel with Excel Intermediate

Excel with Excel Intermediate

Date(s): Nov. 23, 30, 2016

Duration: 2 half day sessions

Time: 8:30 am – 12:00 pm

Member Price: $325.00 + HST

Non-Member Price: $423.00 + HST

***This course is Gold Seal accredited (1 Credit)***

Who Should Attend: Anyone interested in taking their Excel knowledge and skills to the next level.

*No prerequisite required if you work with Excel comfortably but The Basics course is a definite asset.

This level of skill is required to work with multiple worksheets, filter data, use more advanced functions, and manipulate databases. With this level of skill, a person understands the concepts of databases and is able to work with charts and use the list management capabilities of Excel.

Topics:

• Create, modify, and format charts

• Use graphic objects such as SparkLines to enhance worksheets and charts

• Filter data and manage a filtered list

• Protect your workbook, data and formulas

• Create and modify tables

• Use mathematical, logical, statistical, and financial functions

• Use naming to create solid formula and navigate more easily

• Group data and perform interactive analysis





Cancellation Policy

-Cancellations must be received no later than 10 business days prior to the course date to be eligible for a 75% refund of registration fees.
-No refunds will be issued after this date.
-If you register for the course and do not attend, you are liable for the full registration fee unless you cancel according to the terms stated above.
-If you are unable to attend after registering you may send a substitute up to and including the day of the course. Please provide a name and email address for name tag and records.
-CANS reserves the right to cancel any course and will, in such an event, provide a full refund of registrations fees. Every effort will be made to give registrants a reasonable notice of cancellation.
-No liability is assumed by the organization for changes in course dates, content, speakers, or venue.