Computer Science 12
Tutorials on
Microsoft Excel 2007
- Week 1: Excel tutorials
- Week 2: Excel tutorials
- Week 3: Excel tutorials
- Week 4: Excel tutorials
- Week 5: Excel tutorials
- Week 6: Excel tutorials
- Week 7: Excel tutorials
- Week 9: Excel tutorials
- Week 10: Excel tutorials
- More later.
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
To all information for Week 1 | To all tutorials about Excel
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
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.)
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
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 2.
To all information for Week 3 | To all tutorials about Excel
On IF and other logical functions (AND, OR) and nested IF functions:
- Excel’s AND, NOT, and OR Functions by Michele McDonough
- Excel 2007 AND Function and Excel 2007 OR Function on About.com
- Basic Logical Functions (AND OR) in Excel 2007 - video on Associated Content
- How to use nested IF statements in Excel with AND, OR, NOT on "Experiments in Finance"
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
On range names and labels:
- Named Ranges in Excel 2007 in Microsoft Excel Tutorials on Home and Learn's Free Computer Tutorials site.
- Naming a Cell or Range in Excel 2007 and Managing Range Names in Excel 2007 on the "for Dummies" site
- Using Labels in Excel Formulas and Functions in Articles about "how to use Excel" on About.com
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 3.
To all information for Week 4 | To all tutorials about Excel
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.)
On range names and labels:
- Named Ranges in Excel 2007 in Microsoft Excel Tutorials on Home and Learn's Free Computer Tutorials site.
- Naming a Cell or Range in Excel 2007 and Managing Range Names in Excel 2007 on the "for Dummies" site
- Using Labels in Excel Formulas and Functions in Articles about "how to use Excel" on About.com
See also the Excel tutorials listed for Week 4.
To all information for Week 5 | To all tutorials about Excel
On COUNTIF, SUMIF, AVERAGEIF:
- CountIF in Excel 2007 and SumIF on the Home and Learn site.
- COUNTIF and AVERAGEIF - Microsoft Office Excel 2007 Tutorial on a "Java examples" site
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 4.
To all information for Week 6 | To all tutorials about Excel
On the SMALL and LARGE functions:
- SMALL function: intro and details by Ted French, on About.com.
- LARGE function: intro and details by Ted French, on About.com.
On the PMT (payment), PV (present value), and FV (future value) functions:
- On the "For Dummies" site: Calculating Loan Payments with Excel 2007's PMT Function and Examining Investment Value with Excel 2007's PV and FV Functions
- Financial Functions (PMT) on Home and Learn
- Excel: Pmt Function on Tech on the Net
- Microsoft Office Online: Excel functions for personal financial decisions and PMT
- PCM Courseware: Using the PMT Function in Excel 2007 and Using the FV Function in Excel
It is recommended that you also use Excel's Help feature to get more information on all of the above.
To all information for Week 7 | To all tutorials about Excel
On Goal Seek:
- Using Goal Seek in Excel by Ted French on About.com
- Goal Seek in Excel 2007 - Home and Learn
- Using Excel's Goal Seek Feature - for Dummies
To all information for Week 9 | To all tutorials about Excel
On Excel's VLOOKUP function:
- About.com: Excel 2007 VLOOKUP Function and Step by Step version of Excel 2007 VLOOKUP tutorial including screen shots by Ted French
- Experiments in finance: "How to use VLookup in Excel," Part 1 and Part 2
- Excel at work: VLOOKUP Tutorial, Part 1 - Getting the Formula Right and Part 2 - Using Two Files With Error Handling
To all information for Week 10 | To all tutorials about Excel