Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4

You will create and edit basic formulas in Microsoft® Office Excel® 2007 worksheets and workbooks as well as learn basic formula's & functions, adding/deleting columns, adjusting heights & widths, learn about absolute references, formatting, templates..

  • Course Start Date: Nov. 4
  • Location: Winnipeg (Map)
  • Time: 8:30 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:1
  • Category:Microsoft Excel Training

Course Outline
Course Objective:
You will create and edit basic formulas in Microsoft® Office Excel® 2007 worksheets and workbooks as well as learn basic formula's and functions, adding/deleting columns, adjusting heights and widths, learn about absolute references, formatting, templates and much more.

Target Student:
This course is designed for people who are new to Excel or not familiar with formulas and functions.

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

  • explore the Excel 2007 environment.
  • create a basic worksheet.
  • modify a worksheet.
  • perform calculations.
  • format a worksheet.
  • develop a workbook.
  • print workbook contents.
  • customize the layout of the Excel application window.
Course Content
Lesson 1: The Fundamentals

  • Explore the Ribbon
  • Obtain Help
  • Customize the Quick Access Toolbar
Lesson 2: Worksheet Basics
  • Creating and Opening a Workbook
  • Navigating in a Worksheet
  • Select and Enter Data
  • Performing Calculations
  • nderstanding Absolute and Relative Cell References
  • Using Autofill
  • Using Undo and Redo
  • Saving, Previewing and Printing a Workbook
Lesson 3: Editing a Worksheet
  • Editing Cell Data
  • Cutting, Copying and Pasting Cell Data
  • Using the Paste Special Command
  • Spell Check a Worksheet
  • Insert and Delete Cells, Columns, and Rows
  • Using Find and Replace Commands
  • Using Comment
  • Track Changes
Lesson 4: Formatting a Worksheet
  • Formatting Labels and Values
  • Adjusting Row Height and Column Width
  • Working with Cell Alignment
  • Adding Borders, Background Colours and Patterns
  • Using Format Painter
  • Using Cell Styles and Document Themes
  • Applying Conditional Formatting
  • Find and Replace Formatting
Lesson 5: Managing Workbooks
  • Viewing a Workbook
  • Working with the Workbook Window
  • Splitting and Freezing a Workbook Window
  • Selecting Worksheets
  • Inserting and Deleting Worksheets
  • Renaming, Moving and Copying Worksheets
  • Working with Multiple Workbooks
  • Hiding Rows, Columns, Worksheets and Windows
  • Protecting a Workbook, Worksheet and Worksheet Elements
  • Sharing a Workbook
  • Creating a Template
Lesson 6: Working with Page Layout and Printing
  • Creating Headers and Footers
  • Set Page Breaks
  • Adjusting Margins and Orientation
  • Adjusting Size and Scale
  • Adding Print Titles, Gridlines and Headings
  • Advanced Printing Options

Prerequisites & Certificates

To ensure your success, we recommend that you know how to use a mouse comfortably as well as understand Windows Explorer. If you are not familiar with this, then we suggest that you take an Introduction to Computers.

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 ]

ASAP - New Location
950 167 Lombard Avenue
Winnipeg, MB
Canada   R3B 0V3

I was very satisfied with the class. Instructor was very informed, and very helpful to the class with any question's.
Reviewed by 2013
4-November-2016 $196 Regular Price $245 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!

Not interested in this Course?

Tell us why:

This page has been viewed 37 times.