Excel 2010



Course Outline


1. Survey Results
2. Great starting resource for all levels - http://office.microsoft.com/en-us/excel-help/getting-started-with-excel-2010-HA010370218.aspx
3. Graph Tutorial
http://office.microsoft.com/en-us/excel-help/how-to-create-a-basic-chart-in-excel-2010-RZ102559017.aspx
http://office.microsoft.com/en-us/excel-help/CH010369059.aspx
4. Graph Challenge - Take a class poll and change the "dummy data" below to reflect the makeup of our Excel 2010 participants. Enter the data in an Excel spreadsheet. Create a pie graph.
Elementary
7
Middle
9
High School
1
Admin
0
Other
2
5. Sort and Filter Tables Tutorial -
http://office.microsoft.com/en-us/excel-help/use-excel-tables-to-manage-information-RZ102252956.aspx
http://office.microsoft.com/en-us/excel-help/video-filter-data-by-using-an-autofilter-VA101809989.aspx
http://office.microsoft.com/en-us/excel-help/video-sort-data-VA101809992.aspx
http://office.microsoft.com/en-us/excel-help/CH010369011.aspx
6. Sort and Filter Tables Challenge - Download and open the file. Sort the database based on the Name Field. Now, display the records that list "corn" as one of the items under the Agriculture field.
7. Formulas Tutorial
http://office.microsoft.com/en-us/excel-help/get-to-know-excel-2010-create-formulas-RZ101862712.aspx
http://office.microsoft.com/en-us/excel-help/CH010369013.aspx
8. Formulas Challenge - Create the following spreadsheet using formulas for the totals and grand total (in other words, do not type in the total amounts). If time, format the spreadsheet.
Item
Quantity
Price
Total
Laser Pointer
2
$25
$50
Projector Bulb
4
$200
$800
Flash Drive
10
$8
$80
Grand Total


$930
9. Drop-down List Tutorial
http://office.microsoft.com/en-us/excel-help/video-create-a-drop-down-list-VA101850355.aspx
http://office.microsoft.com/en-us/excel-help/create-or-remove-a-drop-down-list-HP010342357.aspx?CTT=3
10. Drop-down List Challenge - Create the following spreadsheet where the grade level column displays a drop-down list including 6th grade, 7th grade, and 8th grade
Student Name
Grade Level






11. Tips, Tricks, Video
Interactive Guides- 2003 to 2010 (Where are the commands???)
http://office.microsoft.com/en-us/outlook-help/learn-where-menu-and-toolbar-commands-are-in-office-2010-and-related-products-HA101794130.aspx
12. Practice, Create, Share

Resources
Make the Switch to Excel 2010
http://office.microsoft.com/en-us/excel-help/make-the-switch-to-excel-2010-RZ101809963.aspx?CTT=5&origin=HA010370218
Excel Help and How-Tos
http://office.microsoft.com/en-us/excel-help/
Protecting Your Files
http://office.microsoft.com/en-us/excel-help/office-2010-security-protecting-your-files-RZ101665538.aspx
Ribbon Hero
http://www.officelabs.com/projects/ribbonhero2/Pages/default.aspx