Skip to Content

MS Excel

  • warning: array_fill() [function.array-fill]: Number of elements must be positive in /home/jimw3141/public_html/includes/database.inc on line 253.
  • warning: implode() [function.implode]: Invalid arguments passed in /home/jimw3141/public_html/includes/database.inc on line 253.
  • warning: array_keys() [function.array-keys]: The first argument should be an array in /home/jimw3141/public_html/modules/user/user.module on line 528.
  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/jimw3141/public_html/modules/user/user.module on line 528.
Sun, 09/26/2010 - 13:16 — jimw

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



Theme by Dr. Radut.