Xavier University Library: 26 Steps to Information Fluency: Step 14: Microsoft Excel

MY LIBRARY
My Library Privileges
My Library Record

HELP
Ask-a-Librarian
Citation Style Guides
Finding Articles FAQs
Finding Books FAQs
Off-Campus Access
Xtreme Subject Guides
xu.tutor
26 Steps

RESOURCES
Document Delivery/Annex Request Forms

RefWorks
TurnItIn

26 Steps to Infromation Fluency

Step 14: Microsoft Excel

Microsoft Excel is a spreadsheet software application for managing primarily numerical data and creating graphs based on that data. This software is on all computers at Xavier, including those computers in the library and academic computing labs. For help completing this step use the following resources:

Help available within Excel 2003: click Help on the menubar or press the F1 key
Help available within Excel 2007: click the ? icon in the top right menubar or press the F1 key
Learning Express Library (set up an account in the library to use off-campus; Excel 2003 and 2007)
Microsoft Office online training (Excel 2003 and 2007)
XU Discovery Services videos and handouts (Excel 2007)
Excel 2003 Personal Trainer, an online electronic book; have your ALL Card handy to access this resource
Excel 2007 for Starters: The Missing Manual, an online electronic book; have your ALL Card handy to access this resource

For this step you need to create a spreadsheet that demonstrates you know how to do the following tasks in Microsoft Excel:

Enter some data
Create a formula (e.g., SUM the numbers in a column or row)
Create a pie chart from your data
1. Include a legend
2. Include a percentage as your data label
3. Create a title for chart
Create a bar graph of your data
1. Include a value as your data label
2. Create a title for the graph
3. Create titles for the X & Y axes

BE SURE TO SAVE YOUR DOCUMENT FREQUENTLY!!

When you have completed your document upload it into your e-portfolio (Expo Directory). You cannot simply copy and paste it into your portfolio. You need to upload it as a file. If you have forgotten how to do this consult these e-portfolio instructions.