|
Excel Basics
& Beyond: Vol. 2 Robert Mayben: rmayben@bama.ua.edu Introduction 1)
The
Technology in Motion Program (www.inservice.ua.edu/tim)
2)
Workshop
Web Site (www.bama.ua.edu/~rmayben/tim/excelvol2.htm) 3)
Excel
Basics & Beyond: Vol. 1: (www.bama.ua.edu/~rmayben/tim/excel.htm) 4)
Download
Excel Templates & Tutorials (www.inservice.ua.edu/tim/excel.zip) 5)
Microsoft
Class Tips Archive (www.microsoft.com/education/classtipsarchive.mspx) 6)
Workshop
Sample Data (Click
Here to Download Files) Workshop Outline This workshop explores basic Microsoft Excel skills through the
creation of products that educators often use in their classrooms.
Explanations and reviews of the skills can be found on the tutorial files
located in #4 of the introduction. Creating a Class Roster &
Grade Book 1)
Overview of the Excel Window & Entering Data
2)
Setting Up Rows & Columns/Merging Cells 3)
Sorting Data 4)
Creating Simple Calculations 5)
Using the Built-in Formulas 6)
Copying Data & Using the Different Cursors 7)
Formatting Cells-Numbers, Decimals, Alignment,
Fill Color, Borders 8)
AutoFormat 9)
Creating Charts & Graphs/Limiting Results 10)Printing & Page
Setup
Survey Results 1)
Percentage & Absolute Cell Reference Creating a Timeline (Time
Permitting) 1)
Use the instructions found at: www.microsoft.com/Education/CreateTimeline.mspx excel tips &
Tricks from MS Tips & Tricks Workshop 1)
Alphabetizing Columns Select a Cell in the Range è Pull down the Data
Menu è Select Sort è Select Sort By è Check Header Row or
No Header Row è Click OK 2)
Making Columns fit the text: At the top of the
column (letters), double click on the line between the two columns that you
would like to fit to the text.
3)
Orienting: www.microsoft.com/Education/CreateTimeline.mspx 4)
Easy Data Sets with Forms: www.microsoft.com/education/datasets.mspx
5)
Creating Charts Select a Cell in the
Range è Click on the Chart
Wizard Icon on the Standard Toolbar (Double check to make
sure that the wizard selects the proper range in step 2!)
6)
Pictographs with Charts: www.microsoft.com/Education/CreatePictograph.mspx
7)
Copying Charts into other Programs Select your chart è Copy it using your
preferred method è Open PowerPoint, etc.
è Paste in the desired
location (Edit the chart after pasting by double-clicking on it.)
Useful Excel resources 1)
Microsoft
Lesson Plans: www.microsoft.com/education/lessonplans.mspx
(Select Excel) 2)
UAB
Excel Bookmarks: www.ikeepbookmarks.com/office
(Click on Excel) 3)
4)
Ocean
Mapping with Excel: alex.state.al.us/lesson_view.php?id=6749
5)
6)
Excel
Resources for the Classroom Teacher: www.forsyth.k12.ga.us/kadkins/resources.htm 7)
Managing
Grades with Excel: www.microsoft.com/education/ManagingGrades.mspx
8)
MIStupid
Excel Tutorial Videos: www.mistupid.com/tutorials/excel
9)
Baycon
Group Excel Tutorial: www.baycongroup.com/el0.htm
10)Classrooms that Excel: www.sabine.k12.la.us/class/excel_resources.htm
11)Using MS Excel in the Classroom: www.willard.k12.mo.us/co/tech/Document/excel.pdf
12)Excel for Teachers: www.tiger.org/technology/tecshop/training/ExcelTeachers.doc 13)Excel 101 References: www.tiger.org/technology/tecshop/training/Excel101.doc
14)Excel 102 References: www.tiger.org/technology/tecshop/training/Excel102.doc
Need more help or ideas? 1)
Internet
4 Classrooms Online Practice Modules: 2)
The
Crabby Office Lady: office.microsoft.com/en-us/assistance/HA012226371033.aspx 3)
Microsoft
Back to School Resources: www.microsoft.com/education/BackToSchool.mspx 4)
100
Office Tips & Tricks-Parts 1 & 2: www.computeractive.co.uk/computeractive/features/2014067/office-100-tips-tricks-part www.computeractive.co.uk/computeractive/features/2014068/office-100-tips-tricks-part-2 5)
www.gpc.edu/~training/handout.htm 6)
Office
Tutorials: |
