|
Technology Training Centre ~ Excel Word Training in Edmonton Cancellation Policy
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 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
Pre-Requisites: Basic computer concepts/skills and knowledge of Windows
Certificates offered: Certificate of completion
Duration Details: 1 day
9:00am - 4:00pm
Facility Location: Edmonton Training Center
B-11 Cameron Library
University of Alberta
Edmonton
Alberta
Canada
T6G 2J8
| 
