Transcript Class 01 Excel CA202.ppt

CA202
Spreadsheet Application
Getting to know Excel
Lecture # 1
1
Objectives
•
•
•
•
•
•
Ways to start Excel
Opening workbooks Automatically
Setting Excel Options
Work with an existing data list
Create a Workbook
Check and correct data
2
Ways to start Excel
• Excel “path\filename”
– Open the named workbook
• Excel /r “path\filename”
– Open named workbook as a Read only
• Excel /e
– Start excel without showing the startup window and
blank workbook
• Excel /p “path\filename”
– Set the working folder, in which Excel will open and
save document
3
Opening workbooks Automatically
• To open workbook automatically, put the excel workbook
in C:\Documents and Settings\Courses\Application
Data\Microsoft\Excel\XLSTART folder
• If file is stored somewhere else use the following
command
– Choose Tools Options  General Tab
– Type the file name in Alternate startup file location”
• Each time excel starts it opens the file(s) in both folders,
alternate folder and the XLStart folder
• Excel attempt to open every file available in the startup
folders whether its word a sound or whatever. So only
keep the workbooks or their shortcuts in these folders
4
Opening workbooks Automatically
5
Setting Excel Options
• Choose Tools Options  General Tab
• Set recently use file list setting to 9
• Max number of worksheet in one
workbook is 255, but you may choose 1, to
save memory Disk space, 2ndly you can
always add when you need
• The User Name you specify, can be used
by other application as well
6
Main menu
Introducing Excel
Formatting
Toolbar
Column
Standard
Toolbar
Formula bar
Cell
Task Pane
Row
Formula bar
Worksheet
What is the wrong with this picture?
7
Excel file properties
8
Create a Workbook
• Start Excel and you are in the workbook
• Simplest way to enter the data is to click
and type the value
• Typing the sequence using AutoFill , grab
the fill handle at the lower right corner of
cell
• A similar tool, FillSeries lets you enter two
values in a series and use the fill handle to
expand the series
(12)
9
Create a Workbook
• AutoComplete feature detects when a
value is typed similar to previously entered
value
• Pick from List, lets you choose a value
from existing value in column (Alt+down arrow)
• Ctrl + Enter, lets you enter a value in
multiple cells simultaneously when you
type something in selected cell
10
AutoFill
Initial Selection
January
Jan
Monday
Mon
Week1
Quarter1
Qtr1
9:00
Filled Cell
February, March …
Feb, Mar, …
Tuesday, Wednesday …
Tue, Wed …
Week2, Week3 …
Quarter2, Quarter3 …
Qtr2,Qtr3 …
10:00, 11:00 …
11
AutoFill
Initial Selection Filled Cell
1997
1997, 1997, 1997 …
Potato
Potato, Potato …
12
Enable AutoComplete
13
Taking advantage of AutoComplete
• If First few character match the previous entry in column
excel complete the entry for you.
• To accept Hit Enter to reject keep typing
• You can press Alt + Down Arrow to display the small list
of existing entries in that column
• Click any one you want
• You can also Right click a cell in the column and choose
Pick from List… on the shortcut menu
• You can turn off the AutoComplete entry choosing
– Tools  Options  Edit Tab Clear “Enable AutoComplete for
Cell value”
14
Checking and Correcting data
• Find and Replace dialog box to locate the
old value and then change with new.
• Find Format in the Find and Replace
dialog box helps in locating formatted data
15
Chapter Key Points
•
•
•
•
•
Workbook and Worksheet
Windows search tool to search files
AutoFill, AutoComplete saves time
Spell checker to ensure spelling
Find and Replace
16