Computer Science 12
Tutorials on
Microsoft Excel 2007/2010
- Week 1: Excel tutorials (general topics, formulas, cell references)
- Week 2: Excel tutorials (simple functions, line breaks)
- Week 3: Excel tutorials (charts, tables, date functions)
- Week 4: Excel tutorials (the IF function)
- More later.
Week 1: Excel tutorials (general topics, formulas, cell references)
General tutorials on Excel 2007:
- Spreadsheets on About.com, including Basic Excel 2007 Spreadsheet Tutorial
- Microsoft Excel 2007 Tutorial by Denise Etheridge
- Excel tutorial - Vertex42
- Excel 2007 Tutorial - Florida Gulf Coast University
- Excel 2007 (Windows) Tutorial - Brown University
- Microsoft Excel 2007 Tips
On the use of formulas:
- Basic Excel 2007 Formula Tutorial on About.com
- Building Basic Formulas in Excel 2007 by Paul McFedries
- Combining arithmetic operators in the Microsoft Excel 2007 Course on the Home and Learn site.
- Calculation operators and precedence on Microsoft's site
On cell references, absolute vs. relative:
- Home & Learn: Absolute Cell References
- About.com: Absolute Cell Reference
- Karyn Stille: Relative and Absolute Cell References
- ozgrid: Excel cell references
- Pearson: Relative And Absolute References In Formulas
To all information for Week 1 | To all tutorials about Excel
Week 2: Excel tutorials (simple functions, line breaks)
On Excel functions in general, and specifically the SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, and MEDIAN functions:
- Very basic intro: AutoSum and Excel Functions in Microsoft Excel 2007 Tutorial by Denise Etheridge
- Another very basic intro: Performing Calculations in Florida Gulf Coast University's Excel 2007 Tutorial
- Excel Formulas and Functions in Excel 2007 on Quamut.
- Crunching Numbers with Excel 2007's AVERAGE, MAX, MIN, and MEDIAN Functions in Functions on the "for Dummies" site
- Count Functions and Statistical functions in Using Excel Functions in Spreadsheets on About.com
- How to use A functions in Excel (e.g. COUNTA as distinct from COUNT) on the Microsoft site
Line breaks in cells:
- Add A Line Break To A Cell In Excel 2007 on Windows Fanatics
- Line Breaks in Formulas on Daily Dose of Excel
It is recommended that you also use Excel's Help feature to get more information on all of the above.
See also the Excel tutorials listed for Week 1.
To all information for Week 2 | To all tutorials about Excel
Week 3: Excel tutorials (charts, tables, date functions)
On Excel charts:
- Excel Charts in Microsoft Excel 2007 Tutorial by Denise Etheridge
- Charts in Excel 2007 in Florida Gulf Coast University's Excel 2007 Tutorial
- "Section Three - Excel 2007 Charts" in Microsoft Excel 2007 Course on Home and Learn's Free computer Tutorials site.
- Create charts - tutorial for beginners on "MS Tips and Tricks"
- Charts and Graphics in MS Excel 2007 Tutorials on brainbell.com
- "Charting with Excel" in Excel 2007: LTS Online Help Documentation at the University of Wisconsin at Eau Claire
- Charts, plus including Excel 2007 Pie Chart Tutorial and Excel 2007 Column Chart Tutorial on About.com.
- How to copy a chart from Excel into a Word document in Making the Most of Word by Shauna Kelly
On Excel tables:
- Change Excel 2007 spreadsheets to tables for easier data analysis by Mary Ann Richardson, on Tech Republic
- The Essentials of Creating and Working with Tables in Excel 2007 on the "for Dummies" site
- Table section in Microsoft Office Excel 2007 Tutorial on a "Java examples" site
- Working with Tables in Excel 2007 on the website of JKP Application Development Services
- Introducing Excel 2007: Tables - Not just a pretty format by Simon Hurst
- Tables on the Microsoft Excel Team Blog. Begin with the bottom post and work your way up. (Click on each post's title to see the entire post.)
Date functions:
- Excel's Date Functions on About.com
- The Date Function in Excel 2007 on Home and Learn
- Inserting Dates and Times in the Microsoft Excel 2007/2008 tutorial in the online help documentation at the University of Wisconsin
It is recommended that you also use Excel's Help feature to get more information on all of the above.
See also the Excel tutorials listed for Week 1.
To all information for Week 3 | To all tutorials about Excel
Week 4: Excel tutorials (the IF function)
On the Excel IF function:
- The IF Function in Excel 2007 on Home and Learn
- Excel Basics and the IF Function on Productivity Portfolio
- The Excel 2007 IF Function on MSOffice-tutorial-training.com
- Using the IF Function in Excel 2007 by Michele McDonough
- Pages on Excel IF Functions, including Excel IF Function Step by Step Tutorial and Excel 2007 IF Function on About.com
See also the Excel tutorials listed for Week 3.
To all information for Week 4 | To all tutorials about Excel