Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4

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

Course Outline
In Microsoft® Office Excel® 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Office Excel® 2007 to streamline and enhance your spreadsheets with charts, tables and formulas.

Course Objective

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

Target Student
The target students for this course are students who desire to gain the skills necessary to create charts, sort and filter data, analyze data.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:
  • create and modify charts
  • calculate with advanced formulas
  • organize data using tables
  • sort and filter data
Course Content

Lesson 1: Creating and Working with Charts

  • Creating a Chart
  • Resizing and Moving a Chart
  • Change Chart Type
  • Applying Built-in chart Layouts and Styles
  • Working with Chart Labels, Axes and Backgrounds
  • Working with Chart Analysis Commands
  • Formatting Chart Elements
  • Changing a Charts Source Data
  • Using Chart Templates
Lesson 2: More Functions and Formulas
  • Formulas with Multiple Operators
  • Inserting and Editing a Function
  • Autocalculate and Manual Calculation
  • Defining Names
  • Using and Managing Defined Names
  • Displaying and Tracing Formulas
  • Understanding Formula Errors
Lesson 3: Working with Data Ranges
  • Sorting by One Column
  • Sorting by Colours or Icons
  • Sorting by Multiple Columns
  • Sorting by a Custom List
  • Filtering Data
  • Creating a Custom AutoFilter
  • Using Advanced Filter
Lesson 4: Working with Tables
  • Creating a Table
  • Working with Table Size
  • Working with the Total Row
  • Working with Table Data
  • Summarizing a Table with a PivotTable
  • Using the Data Form
  • Using Table Styles
  • Using Table Style Options
  • Creating and Deleting Custom Table Styles
  • Convert or Delete a Table
Lesson 5: Appendix of Common Functions
  • Using Logical Functions (IF)
  • Using Financial Functions (PMT)
  • Using Database Functions (DSUM)
  • Using Lookup Functions (VLOOKUP)

Prerequisites & Certificates

Before starting this course, students are recommended to have taken or possess equivalent knowledge of Microsoft Office Excel 2007: Level 1.

Certificates offered

Certificate of Completion

Cancellation Policy
Cancellation Policy & Satisfaction Guarantee
You may cancel or reschedule your registration without penalty up to 5 business days before your class date.

Training Details
ASAP Training Ltd. is located at 950 - 167 Lombard Avenue, in Exchange District. A training manual is provided. We encourage all students to bring in a USB stick for student files as we no longer hand out course files on a CD.

Finding Us
ASAP Training Ltd. is located in the picturesque downtown Exchange District at 950-167 Lombard Avenue, in the Grain Exchange Building, you can access the building from Rorie Street and Lombard Avenue.

Class Times and Other Details
ASAP Training Ltd. classes begin promptly at 8:30 am and end around 4:00 pm. Our doors open at 8:00 am. Coffee and tea are provided for students. We have a kitchen with a microwave and refrigerator available for student use if they wish to bring their own lunch. Lunch break is one hour from approximately 11:30 to 12:30. A telephone and sitting area are available for student use. Our office is a non-smoking facility and is wheelchair accessible.

There are many restaurants available within walking distance of the school.

For your convenience, we have also provided a map of the available Parking Lots in proximity to the Grain Exchange Building, indoor and outdoor parking.
Map & Reviews
ASAP Training.ca
[ View Provider's Profile ]

I just found the instructor presented the material in a very dry and somewhat boring manner.
Reviewed by 2014
This is the second course I have taken with ASAP Training. The location is easy to find with lots of parking and is close to restaurants if needed. They do have a nice lunch area in the facility with coffee, water and a refrigerator that you can use. The staff are very friendly and helpful, it's a very relaxed atmosphere.The courses are well laid out and easy to follow. The instructor explained things well and was always willing to take extra time to answer questions.
Reviewed by 2014
Although, I found some information usefull from this seminar, the content covered did not meet the description of the course and I felt that more in depth teaching could have taken place considering we were dismissed at 2:30pm and the course was supposed to go until 4:30pm. Just felt that we could have covered more formula related material or other excel material as we did have plenty of time left at the end.
Reviewed by 2012
Course was more than what i expected! Please let my instructor, Susan Majetic know that she did an amazing job; very energetic and confident with the course content. Will definitely come back for more:)
Reviewed by 2012
The course content was good; however in the am the instructor said that we would be leaving early because of a small group (6 participants). We were dimissed between 2:30-3:00pm. The course was scheduled till 4:30 and for the cost of the course I flet the instructor should have provided us with training during that time. She could have used the remianing time to present examples, have us try to reproduce them; given us scenarios have us try to prepr the spreadsheet for this, etc. She could have offered to be in the room, let us work through the book examples and be there to guide us. Even if only one person wanted to stay she should have stayed. This offer of staying was not mentioned, I felt we had to leave.
Reviewed by 2012
Instructor needs more hands on Excel Level 2 type situations in order to answer questions presented by students with more confidence. The instructor seemed to be learning as we went along. Overall still a beneficial experience.
Reviewed by 2012
I found the course to be very helpful. Learned alot in a 1 day course.
Reviewed by 2011

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 5368 times.