This is the Excel formula to convert a number in cell D10 to a letter grade:
=IF(D2<60,"F",IF(D2<70,"D",IF(D2<80,"C",IF(D2<90,"B","A"))))
There are many references to online tutorials on the Internet. Use your favorite search engine and type in "excel tutorial", for example, in the search dialog. Then click go and you will be taken to many, many sites that have online tutorials about Microsoft Excel. My favorite search engine is Google. I found the following links and references using Google.
An excellent link to use is my brother Ed's web site. Like me, he has also been teaching for a while and is currently teaching Microsoft Office at Burlington County Community College. Although this is a college level course, the reference links and quizzes are useful for anyone at any level of understanding of the MS Office applications.
General Reference (and Excel) Links:
I've listed these links again here because they include MS Excel tutorials on the sites.
- Microsoft Office Excel
- BayCon Group tutorials
- Computertim Technologies
- OneOnOne Computer Training - you can subscribe to a weekly newsletter for free
- Education Online for Computers
- Digital Education Network - has tutorials on PowerPoint98, IE, Office2000, FrontPage2000, Outlook Express
- Electric Teacher - Technology help for Teachers - has tutorials on PowerPoint, Word, Basic Internet and others
- Maharishi University of Management - Computer Help Desk - has tutorials on Word, Excel, PowerPoint, Outlook Express, and others
- Indiana University - Purdue University Online Tutorials - has tutorials on Internet and PowerPoint2000
- Shelly Cashman Book Series - has tutorials on all Office applications
Sample Exercises:
The following table contains the files that are used in my classes. Not all will be used during class, but are provided here for you to download and review at your leisure. I will be developing descriptions of exercises that will go along with each file.
- Excel samples
- 01
- 02
- 03
- 04
- 05
- 07
- 08
- 08
- 15
- 29
- 31
- 33
- Downloads