Transcript Excel 101 - Dakota State University

Excel 101
Pam Rowland and Kathy Engbrecht
Fall 2010
Introduction to Spreadsheets
• Spreadsheet – a computerized ledger
• Divided into rows and columns
– Columns identified with alphabetic headings
– Rows identified with numeric headings
• Cell – the intersection of a row and a column
– Cell reference uniquely identifies a cell
• Consists of column letter and row number
2
Quick Access
Toolbar
Backstage
view
Excel 2010 – the look
Tabs
Ribbon
Expansion
Button
rows
and
columns
Sheets
Microsoft switched to ribbon to have options more accessible and at your fingertips.
Types of Cell Entries
• Constant – an entry that does not change
– Can be a numeric value or descriptive text
• Function – a predefined computational task
• Formula – a combination of numeric
constants, cell references, arithmetic
operators, and functions
– Always begins with an equal sign
4
Formulas
•
•
•
•
+
*
/
Used for calculations
Start with = sign
Use cell locations where possible
Arithmetic Operators
= Add
= Subtract
= Multiply
= Divide
5
Let’s Create a Sheet
The Active Cell, Formula Bar, and
Worksheet Tabs
Active
Cell
Sheet
tabs and
names
Formula
Bar
Saving an Excel file
• Excel 2003 had the extension .xls
• Excel 2007 or 2010 has the extension .xlsx
• If sharing files with someone using Office
2003, you will need to Convert an Excel 2010
to 2003
– Go to the Backstage view by clicking on File
Making changes
• Add a row with 250 and 25 between rows 3
and 4
– Rt mouse click and insert row
• How are you going to get those formulas to
copy?
– Auto fill handle
Formatting
• Format the label ‘Add’ anyway you want – color,
bold, etc.
• Center label
• We want the same formatting on the rest of the
labels, so use FORMAT PAINTER
• Format Painter will copy the formatting from the
selected cell and paint the formatting on the
cell(s) you select next.
• To use the Format Painter more than once,
double click on Format Painter
Format numbers
•
•
•
•
Currency
Decrease decimals
Other number options
Home Ribbon
Shade and border
• Use the fill option for shading
• Use the launcher
button to get to
border options
Cut, Copy, Paste
• There are many ways to cut, copy, paste
• First select the data
– Right mouse click for the options
– Use the Ribbon
– Or use shortcut keys
• Cut = Ctrl + X
• Copy = Ctrl + C
• Paste = Ctrl + V
Questions?