oit_content_133107

# oit_content_133107 - Office of Information Technology Excel...

This preview shows pages 1–7. Sign up to view the full content.

Office of Information Technology Excel 2007/2010 Spreadsheet Basics

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
10 .24 .2011 OIT TE CHNOL OGY TRAIN ING S ERVICES Excel 2007/2010 Spreadsheet Basics The University of Minnesota is an equal opportunity educator and employer. This publication/material is available in alternative formats upon request. Send requests to oca@umn.edu . Printed on recycled and recyclable paper with at least 10 percent postconsumer material. ©2011 Regents of the University of Minnesota. All rights reserved.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
U N IV ER S ITY T EC HN OLO GY T R AIN IN G CE N TE R i Table of Contents LESSON 1 7 CREATE AND FORMAT A SIMPLE BUDGET 7 Open a new Excel workbook 8 Save a workbook 8 Enter text 9 Use the mouse to select a cell 10 Enter numbers 10 Use Auto Fit to adjust column width 10 Add up a range of numbers using Auto Sum 11 Label the total row 12 Label the amount column 12 Save changes to a workbook 12 Format a worksheet for on-screen legibility 13 Right align text 13 Select adjacent cells 13 Add a border to a range of cells 14 Deselect a range 14 Select non-adjacent cells 15 Emphasize data using the bold format 15 LESSON 2 17 MODIFY A WORKSHEET Add new data 18 Copy data using the fill handle 18 Create a multiplication formula 19 Use the fill handle to copy a formula 20 Insert a row 22 Insert multiple rows at once 23 Enter data in a selected range 23 Edit mode 24 Edit data within a cell using the formula bar 25 Edit data within a cell in the cell itself 25 Enter Edit mode using a keyboard shortcut 26 Replace the contents of a cell 26 Delete the contents of a cell 27 Live Preview 28 Change the font size 28 Merge and center data across cells 28 LESSON 3 31 CREATE AND MODIFY A PIE CHART Open an existing Excel workbook 32 Delete a row 32 Pie Charts 32 Insert a pie chart 32 Charts and Chart elements 34 Move a chart 34 Chart Tools 35 Modify chart elements 35 Edit a chart title 35 The Mini Toolbar 35 Format the chart title 36 Add data labels to a chart 36

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Uni versit y T e chn olo gy T ra in ing Center ii Modify data labels 37 Turn off the legend 38 Move a chart element: Move the title 39 Move a chart element: Move a data label 39 When data changes 40 Delete a chart 40 Change Chart Styles 41 Move a chart’s location 42 LESSON 4 43 WORKING WITH A DATABASE 43 Use Freeze Panes to keep a row in view 45 Find and Replace 45 Use Find and Replace again 48 Perform a simple ascending sort 49 Find data 50 Use Auto Complete 50 Perform a simple descending sort 51 Perform a custom sort 51 Filter data to view particular records 53 Remove a filter 54 Turn off filters 54 Unfreeze Panes 54 LESSON 5 55 FUNCTIONS AND FORMULAS 55 Function syntax 56 The AutoSum drop-down menu 56 Use a date function 58 Freeze Panes to keep a row and column in view 60 Hide rows 61 Write a formula using order of precedence rules 61 Edit a formula 62 Double-click to Fill down 63 Unhide rows 64 LESSON 6 65 FORMAT WITH STYLES Style types 66 Cell Styles 66 Format as Table 68 Change a table format 68 Conditional Formatting 69 Add data to a table 70 Delete a Row 70 Change font color 71 LESSON 7 73 PAGE LAYOUT AND PRINT SETUP EXCEL 2010
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 02/04/2012 for the course INFORMATIO Download C taught by Professor Office during the Spring '11 term at Minnesota.

### Page1 / 176

oit_content_133107 - Office of Information Technology Excel...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online