Hello! On Tuesday, April 12th the Technology Ambassadors Program held an instructional workshop on Microsoft Excel from 3:30-4:30pm at the Peck School. Excel is an extremely useful spreadsheet application that can be used to organize data, such as student grades and test scores, and then display the information in charts and graphs.
There were 27 people in attendance at Tuesday's workshop and the TAP Team was thrilled!
For those of you who missed the workshop or those of you who would like to reinforce concepts taught at the workshop, below are helpful online resources and videos related to Microsoft Excel.
MICROSOFT EXCEL ONLINE RESOURCES
http://www.baycongroup.com/el0.htm: An in-depth online tutorial on Microsoft Excel 2007. It also offers a tutorial on Microsoft Excel 2002/2003.
http://people.usd.edu/~bwjames/tut/excel/index.html: A step-by-step tutorial on the basics of Microsoft Excel.
http://www.internet4classrooms.com/on-line_excel.htm: A site that offers basic and advanced tutorials on Microsoft Excel. It also offers training on keyboard shortcuts and Excel spreadsheet downloads that can be incorporated into classroom lessons for students.
http://www.wallstreetprep.com/extrafiles/finmodeling/downloads/xlshortcuts07.pdf: A very useful reference sheet that lists keyboard shortcuts for Microsoft Excel 2007.
MICROSOFT EXCEL VIDEO TUTORIALS
The video above explains:
- What is Excel?
- Rows, Columns, Cells, Worksheets, Sheet Tab Names, Workbook
- File Extensions
- Excel 2007 Ribbons
- Excel 2007 Quick Access Tool Bar
- How to find features in Excel 2007
- How to add buttons to the QAT Quick Access Toolbar
The video above explains:
- Cut, Copy, Paste
- Keyboard Shortcuts
- Forumulas
- Cell References
The video above explains:
- Mathematics in Excel
The video above explains:
- Basic Functions for Data Analysis (e.g., AVERAGE, SUM, MIN, MAX, and COUNT)
The video above explains:
- Charts and Graphs
No comments:
Post a Comment