Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 5


In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

  • Course Start Date: May. 11
  • Location: Ottawa (Map)
  • Time: 9:00 am - 4:00 pm (Note on end times)
    • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 1 Day
  • Delivery Method(s):Instructor Led
    • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Discount Seats Available:2
  • Category:Microsoft Excel Training

 
Course Outline

Course Length: 6hrs (1 Day)
 
In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. 

Learning Objectives:
You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Course Outline:
Section 1: Advanced File Tasks
Lesson 1.1: Using My Computer within Excel
Lesson 1.2: Saving Your Files
Lesson 1.3: Using Templates

Section 2: Working with Functions and Formulas
Lesson 2.1: Using Formulas in Excel
Lesson 2.2: Exploring Excel Functions
Lesson 2.3: Using Functions in Excel
Lesson 2.4: Working with Names and Ranges
Lesson 2.5: Working with Array Formulas

Section 3: Managing Tables
Lesson 3.1: Working with Tables
Lesson 3.2: Working with Records and Fields
Lesson 3.3: Working with Tables and Filters
Lesson 3.4: Using Excel as a Database

Section 4: Enhancing your Workbook
Lesson 4.1: Customizing your Workbook
Lesson 4.2: Working with Text Boxes
Lesson 4.3: WordArt
Lesson 4.4: ClipArt
Lesson 4.5: Using Objects

Section 5: Finalizing Your Workbook
Lesson 5.1: Protecting Your Workbook
Lesson 5.2: Finishing Your Workbook
Lesson 5.3: Using Excel in Word
Lesson 5.4: Using Excel and Access
Lesson 5.5: Using Excel with other Programs and Files


Prerequisites & Certificates
Pre-Requisites

Excel 2007 Level 1 or equivalent experience.

Certificates offered

Training includes 1 course manual, a Certificate of completion, and a voucher for 30 days of After Training Support


Cancellation Policy

Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.


Map & Reviews
CompuEase
[ View Provider's Profile ]

CompuEase Training Classroom
130 Albert Street
Suite 801
Ottawa, ON
Canada   K1P 5G4


Reviews
 
Thank you for an enjoyable day of learning. Pierre was a great help. He answered our questions, and was very patient when we did not understand. Thank you again for an enjoyable learning experience.
Reviewed by 2012
The course provided by CompuEase was great. The instructor was excellent and very knowledgeable. The course content directly applied to my needs. I would recommend this course to others and am considering taking the next level myself.
Reviewed by 2011
11-May-2018 $212 Regular Price $265 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:



This page has been viewed 16 times.