Microsoft Office 2007 - Excel Topic 9
|
Preliminary
|
-
Sheet
-
Worksheet or spreadsheet - allows a grid layout of numbers
-
Workbook - an Excel file can have multiple sheets
-
Cells can be linked between sheets or among files
-
If an cell is changed, then Excel automatically updates the sheet
-
Commands
-
Go to - allows users to jump to a particular page
-
Create a name for a cell
-
Then use "go to" to go directly to that cell
-
Find - allows users to find a specific text in a cell
-
Replace - allows users to search for particular text and replace them with other text
-
Undo - allows users to undo something
-
Redo - allows users to redo something
-
Cursor keys - allows movement within spreadsheet
-
Up, down, left, or right - moves the cursor
-
Page down, page up, home, or end
-
Home is the first left cell on sheet
-
End is the last cell on sheet
-
For my computer, press CTRL for home or end
-
Excel does have a spell check
-
It is not turned on
-
Go to Review
|
Proficient in Excel
|
-
Basic Editing
-
Style - Bold, Italics, and Underline
-
Alignment - Left, Center, or Right
-
Change font face, font color, and size
-
Background color for cells
-
Borders - can add lines, etc.
-
Numbers - can specify currency, decimal points, commas, etc.
-
Functions - grow font or shrink font
-
Formatting cells
-
Automatically fill in cells - show method to automatically fill in months or days of the week
-
Can restrict which values are put into a cell
-
Data validation - under Data menu
-
Restrict cells to dates, positive numbers, etc.
-
Can delete cells, columns, or rows
-
Can insert cells, columns, or rows
-
Can adjust the size of columns and/or rows
-
Can hide columns or rows
-
Can name or re-name sheets
-
Save documents in a variety of formats
-
Save as Excel 97 - 2003 format (or .xls)
-
Export Excel as a HTML file
-
Microsoft creates overly complicated HTML code
-
You would not do this for webpages
-
Copy and past spreadsheet to an HTML
|
Functions
|
-
Excel has a variety of functions
-
Organized into several categories
-
Financial
-
Logical
-
Text
-
Date and time
-
Lookup and references
-
Math and trig
-
Statistics
-
Altering looks of a table
-
Use Table Styles to choose a pleasant looking table
-
Manually change the lines, colors, and background color
-
Inserting fonts; alignment, color, face, size, etc.
-
Insert or delete cells, rows, or columns
-
Sort function
-
Can sort a list alphabetically or numerically
-
A way to organize a list
-
Copy and Paste
-
Microsoft has a severe deficiency when copying and pasting
-
It remembers and copies the original style, like font face, size, etc.
-
Then your document looks terrible, because the formatting does not match
-
Paste text as text only, so it does not change the style of your document
-
Can create a simple database
-
Excel has functions that can do simple database functions
-
A record is a row of information
|
Charts and Graphs
|
-
Excel 2007 - much improvement in graphs and charts
-
Types of graphs
-
Column
-
Line
-
Pie
-
Bar
-
Area Scatter
-
Title
-
Legend
-
Backgrounds for graph, legend can be changed to different colors; Excel allows complicated changes in color including gradients and translucence.
-
Add series names
-
Add x labels, such as years
-
Note - graphs can be copy and paste to Word, PowerPoint
|