Microsoft Excel 2010 - Level 1

This course is designed for new Excel users who require the skills necessary to set up a spreadsheet and use basic business spreadsheet functions.

Course Outline

Course Description

This course is designed for new Excel users who require the skills necessary to set up a spreadsheet and use basic business spreadsheet functions.  Students will become familiar with the Excel 2010 program screen, Ribbon, Office Button, Quick Access toolbar as well as contextual menus and the Mini toolbar.  Participants will learn worksheet basics including creating, saving and opening workbooks, and basic editing tools.  This course will show students how to create simple formulas, use built in functions as well as an introduction to relative and absolute references.  Participants will learn to manipulate windows for better viewing as well as work with cut/copy/paste features to move data, format their worksheet and prepare headers and footers for printing.

Course Content

Getting Started with Excel 2010

Understanding Spreadsheet Concepts
Getting Started
Creating and Saving Workbooks
Opening and Closing Workbooks    

Modifying Worksheets

Working with Columns and Rows
Working with Cell Contents

Using Formulas and Functions

Creating and Using Formulas
Creating and Using Functions
Using Absolute Cell References
Inserting Functions

Formatting and View Worksheets

Formatting Worksheets
Viewing Worksheets
    
Print Workbooks

Using Workbook Views
Changing the Page Setup
Previewing and Printing Workbooks

Additional Details

Pre-Requisites

Basic computer concepts/skills and knowledge of Windows.

Certificates offered

Certificate of Completion

Cancellation Policy

10 business days cancellation or full course fee will be charged

Map & Reviews

Technology Training Centre
[ View Provider's Profile ]

Edmonton Training Center
B-11 Cameron Library
University of Alberta
Edmonton, Alberta
Canada   T6G 2J8

Reviews

 

   

Concise, clear and well presented. I would request this facilitator for any future courses based on my confidence is her ability to communicate effectively and based on her knowledge of the materials.

Reviewed by Angelique W. 2012

   

Had never done Excel before, it was all greek to me. Maybe need to repeat work sheets twice. I will come back for repeat class.

Reviewed by Brenda K. 2012

   

Great training, had to meet the various needs from no experience to some with experience. Washrooms looked tired and need of improvement. Personally prefer an early start/early finish 8am to 3pm would be great

Reviewed by David S. 2011