Excel Introduction

Short Description
formula. Microsoft Excel includes four different types of calculation … AutoSum to have Excel automatically create a summation formula to add a group or …

Website: www.techdocs.ku.edu | Filesize: 424kb

Content
. 2005 The University of Kansas. All rights reserved
Excel Introduction
Instructional Services at KU Libraries
A Division of Information Services
www.lib.ku.edu/instruction
Abstract: This document introduces users to basic Excel tasks, such as
creating, saving, and opening new Excel workbooks and
worksheets; selecting, copying, and moving data; constructing
formulas; formatting worksheets; and setting up worksheets for
printing. It is used in conjunction with the Excel Introduction
workshop.
Contents
Introduction ………………………………………………………………………………………………………2
Objectives ………………………………………………………………………………………………………..2
Prerequisites …………………………………………………………………………………………………….2
Related Training Available from ACS ……………………………………………………………………2
Definitions ………………………………………………………………………………………………………..2
Creating and Opening Excel Workbooks ……………………………………………………………….3
Inside an Excel Worksheet ………………………………………………………………………………….4
Creating Formulas……………………………………………………………………………………………10
Editing & Deleting Formulas ………………………………………………………………………………12
Copying Formulas and Values …………………………………………………………………………..13
Changing the Workbook or Worksheet Appearance………………………………………………16
Getting Additional Help……………………………………………………………………………………..22Instructional Services
Excel Introduction
Instructional Services at KU Libraries - 2 - . 2005 The University of Kansas
A Division of Information Services
Introduction
Excel is a spreadsheet program that allows users to create worksheets that store
information in workbook files. The built-in functions allow users to create and edit
formulas; copy and move data; format worksheets; and set up worksheets for printing.
Objectives
The goal of this workshop is to introduce participants to the introductory commands and
features of the Excel program. After today’s workshop, participants will be able to:
?Create, open, and save Excel workbooks
?Select, copy, and move data
?Create formulas using relative and absolute references
?Format worksheets
?Use Page Setup to set up worksheets for printing
Prerequisites
It is assumed that the participants in this workshop have basic computing skills and know
how to use the Windows or Mac OS X operating system to maintain files and
directories/subdirectories, open, close, and save files.
Related Training Available from Instructional Services
All workshops offered by Instructional Services, are free to KU students, staff, faculty,
and approved affiliates.
To learn more about or register for workshops, receive automatic announcements of
upcoming workshops,…