Advanced+Excel

media type="custom" key="765573"

 [[[|http://cinedelagente.com/html/muves.htm#|Stillwater], MN School]] that has Transformed Education with Technology [|Spreadsheet Jokes] - Relieve your Excel frustrations...lol Common Keyboard Shortcuts in Excel ===**Basic & Advanced Excel Concepts to Know **===

Order of Operations (Precedence):

 * = ** Level ** ||= ** Operation ** ||= ** Operator ** ||
 * = 1 ||= Parentheses  ||=   ||
 * = 2 ||= Exponentiation   ||= ^ ||
 * = 3 ||= Multiplication and Division ||= * /      ||
 * = 4 ||= Addition and Subtraction ||=   + - ||

Comparison Operators

 * ===Comparison Operator=== || ====**Meaning**==== ||
 * < || Less than ||
 * <= || Less than or equal to ||
 * > || Greater than ||
 * >= || Greater than or equal to ||
 * = || Equal to ||
 * < > || Not equal to ||

 **Common Formula Errors** You’ll See in EXCEL
**What Appears in the Cell and What happened?** **#DIV/0!** Appears when the formula calls for division by a cell that either contains the value 0 or, as is more often the case, is empty. Division by zero is a no-no. **#NAME?** Appears when the formula refers to a range name that doesn't exist in the worksheet. This error value appears when you type the wrong range name or fail to enclose in quotation marks some text used in the formula, causing Excel to think that the text refers to a range name. **#NULL!** Appears most often when you insert a space (where you should have used a comma) to separate cell references used as arguments for functions. **#NUM!** Appears when Excel encounters a problem with a number in the formula, such as the wrong type of argument in an Excel function or a calculation that produces a number too large or too small to be represented in the worksheet. **#REF!** Appears when Excel encounters an invalid cell reference, such as when you delete a cell referred to in a formula or paste cells over the cells referred to in a formula. **#VALUE!** Appears when you use the wrong type of argument or operator in a function, or when you call for a mathematical operation that refers to cells that contain text entries.

**USING THE NESTED IF FUNCTION TO ASSIGN LETTER GRADES BASED ON GRADE POINTS EARNED** ** //(All Versions)// **   You can use the following **Nested If Function** to read grade points (stored in column B in this example) and assign appropriate letter grades based on the grade points earned. Type **=IF(B2<60,”F”,IF(B2<70,”D”,IF(B2<80,”C”,IF(B2<90,”B”,”A”))))**. <span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif">This function says that if the grade point average is less than 60, assign the letter grade F. If between 60 and 69, assign D. If between 70 and 79, assign C. If between 80 and 89, assign B. Else, assign an A.

<span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif">[|Guidelines for Writing Spreadsheets] - good tips for readability and Excel spreadsheet etiquette

===<span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif; color: rgb(201, 54, 109); background-color: rgb(193, 227, 236); text-align: center; display: block">Advanced Excel Websites & Tutorials ===

<span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif">[|Create Charts using Excel] - great 20-30 minute tutorial by Microsoft <span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif">[|How to Create a Chart Quick Reference Card] [|Free Excel Lessons] [|Excel Basic Lessons] [|Excel 2003 Courses] - by Microsoft [|Excel 2003 Tips] - by category [|Excel VBA Tutorials] - use Visual Basic macros in your Excel files [|Excel User Tips] [|Excel Developer Tips] [|Excel Software Tips] - developed by Lisa Stevenson from Penn State University College of Engineering <span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif">**Excel Functions Spreadsheet Tutorial B - by Gary Moore of NC State University**
 * Excel 2003 Advanced Calculations - instruction sheet with screen shots developed by Towson University**
 * Excel Functions Spreadsheet Tutorial A** **<span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif">- by Gary Moore of NC State University **

<span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif">
<span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif"> media type="youtube" key="Ycab4OiPug0&hl=en&rel=0&color1=0x006699&color2=0x54abd6&border=1" height="373" width="425" ===<span style="font-family: 'Lucida Sans Unicode','Lucida Grande',sans-serif; color: rgb(201, 54, 109); background-color: rgb(193, 227, 236); text-align: center; display: block">Advanced Excel Resources & Presentations ===

This is the file that I used as a background for my Comment in N3 of the Key1 worksheet in the Advanced Excel Exercise workbook. Just right-click this image and choose Save Image As or Save Picture As, and Save it to your computer.



Interactive Timeline & Quiz Examples

 * Geography Example**


 * Math Example**


 * English Example**