Transcript Excel Class Outline

Excel Class Outline
•
•
•
•
•
•
•
What is a spreadsheet? What can you do with them?
The Cell - basic unit of a spreadsheet
Making a Table - cells in Rows and Columns
Using your tables - sorting, re-arranging, editing
Viewing & Printing - formatting, titles & insert pictures
Using graphs - using the right kind & making it clear
Beyond the basic table - formulas, analysis, linking,
exporting
• Menu terms & Help - useful info to help you work
• Work on your project & ask questions
Excel
Class
What is a Spreadsheet?
What can you do with them?
• A spreadsheet is a way to collect and use information
–
–
–
–
–
Your information goes in a cell
Cells are arranged in rows and columns
As big or as small as you need
You decide what you want, and how it should be arranged
Spreadsheet = Workbook = Table = List = Database
• Some uses for spreadsheets
–
–
–
–
–
Inventories
Investment tracking
Mailing lists
Maintenance records
Collections
–
–
–
–
–
Budgets
Bookkeeping records
Mileage records
List of Anniversaries, Birthdays
Statistical data & analysis
Excel
Class
The Cell
• The cell is the basic unit of the spreadsheet
• A cell is a container for: headings, names, numbers,
dates, formulas, currency, addresses, notes, phone
numbers, part numbers ... any kind of information
• How we refer to cells
– Relative address
– By name
– Absolute address
height
width
Cell Properties
•Height
•Width
•Borders
•Patterns & colors
•Fonts
•Number formats
•Custom formats
Excel
Class
Making a Table
• Excel calls your table a “Workbook”. It can have several
sheets.
• A “Template” is a pre-designed workbook. (yours or
theirs)
• You can use a Template of create your own from a Blank
one.
• First, decide the purpose for your table.
• How do you want it arranged? Info in rows or columns?
• How should it look? Format the cells, add header/titles.
• Enter your information. Use filling & copying too.
• Save As vs. Save. Make a Template?
Excel
Class
Using Your Tables; Viewing & Printing
• Once a basic table has been created you can:
–
–
–
–
Add or insert information - by cell, or rows & columns
Delete or revise information - cell, or rows & columns
Find information (Edit/Find) & Replace
Re-arrange information
• Within columns/rows
• Re-arrange rows or columns
• Sort
–
–
–
–
–
Add Headers and Footers (dates, filenames, page #’s...)
Create graphs from your data [See Using Graphs]
Insert graphics
Copy cells to/from another table
Format and Print your table (Print Range)
Excel
Class
Using Graphs
• Makes numeric data easier to understand
• Use the Chart Wizard and experiment with chart types
–
–
–
–
–
Pie chart (also Bar graph) shows parts to whole
Column chart shows comparisons of values
Line or area chart shows changes over time
2-axis chart compares different, but related quantities
3D vs flat is your preference
• Customize the look with colors, labels, patterns
• Use a Legend?
• Add titles, gridlines and axes formats to improve
readability
• New data can be added to existing graphs
• Save with spreadsheet or on new page
Excel
Class
•
•
•
•
•
•
Beyond the Basics
Formulas - let the table do the work
Link Tables and/or graphs
Use analysis features
Automate steps for repetitive actions
Exporting/importing data with other applications
Spreadsheet data on the Web
Excel
Class
•
•
•
•
•
•
•
•
•
•
•
•
•
Menu Definitions - File Menu
New - opens new workbook
Open - open existing workbook
Close - close current screen (not same as Save)
Save - use this to update an existing file
Save As - Lets you name file AND locate place to save
Save as HTML - makes your data Browser-readable
Save Workspace - ?
Page Setup - For printer
Print Area - Allows you to select printed portion
Print Preview - Shows how page will print
Print - Calls up your printer dialog to print your doc.
Send to - Lets you e-mail the file
Properties - Descriptions you write
Excel
Class
•
•
•
•
•
•
•
•
•
•
•
•
•
Menu Definitions - Edit Menu
Undo - Reverses last step (if possible)
Repeat - repeats previous action with new selection
Cut - removes selection
Copy - duplicates selection
Paste - inserts selection
Paste Special - inserts part(s) of selection you want
Fill
Clear
Delete
Find
Replace
Go to
Publishing
Excel
Class
•
•
•
•
•
•
•
•
•
•
•
Menu Definitions - View Menu
Normal
Page Break Preview
Toolbars
Formula Bar
Status Bar
Header & Footer
Comments
Custom
Report Manager
Full Screen
Zoom
Excel
Class
•
•
•
•
•
•
•
•
•
•
•
Menu Definitions - Insert Menu
Cells, Rows, Columns
Worksheet
Chart
Page break
Function
Name
Comment
Picture
Movie
Object
Link
Excel
Class
•
•
•
•
•
Menu Definitions - Format Menu
Cells, Row, Column
Sheet
Autoformat
Conditional Format
Style - create and define styles
Excel
Class
•
•
•
•
•
•
•
•
•
•
Menu Definitions - Tools Menu
Spelling
Autocorrect
Share Workbook
Track changes
Merge Workbooks
Protection
(Specialized tools)
Customize
Preferences
Wizard
Excel
Class
•
•
•
•
•
•
•
•
•
•
•
•
Menu Definitions - Data Menu
Sort
Filter
Form
Subtotals
Validation
Table
Text to columns
Template Wizard
Consolidate; Group & Outline
Pivot Table Report
Get external data
Refresh
Excel
Class
•
•
•
•
•
•
Menu Definitions - Window Menu
New window
Arrange
Hide
Unhide
Split
Freeze Panes
Excel
Class
•
•
•
•
•
•
Menu Definitions - Help Menu
About Balloon help
Show Balloons
Microsoft Excel Help
Contents & Index
Help on the Web
Online Registration