Microsoft Excel 2007 - Level 1

Designed for new Excel users who want to learn how to set up a spreadsheet & use basic business spreadsheet functions. Become familiar with the Excel 2007 program screen, Ribbon, Office Button, Quick Access toolbar, contextual menus & the Mini toolbar.

Course Outline

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 2007 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. Working with objects such as clip art, SmartArt and graphic objects will be introduced.

Course Content

Getting Started with Excel 2007

• 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

 

   

Well presented, hands on course! The instructor was extremely knowledgable and helpful!! I have already reccommended this course to my managers.

Reviewed by Kelly D. 2011

   

EXCELLENT instructor!!! Very patient ... customized the class to the needs of the students!

Reviewed by Jackie G. 2011