Free Microsoft Excel 2013 Quick Reference

- Free Add-ins
- SUMPRODUCT Value Error Question
- Nested IF and LOOKUP - can anyone spot the problem with these formulas?
- Linking Question (long, sorry!)
- Help on excel
- Vlookup formula not working currectly
- Entering array in single cell
- IF and seven nested functions
- Help on excel project
- Make a Cell Output a Letter

Microsoft Excel Add-in Links & Search EngineΒ How to create an Excel Add-inBuild an Excel Add-inHow To Create Office COM Add-Ins by Using VBA and Office DeveloperFREE Excel Downloads Page with lots of freebies!Hey! That is Cool! Contributions from our Excel Help forum members.Calendar DownloadsDatabase Form, Navigating, Contact, Excel Web Toolbar and more!Excel Function DictionaryReferenceBrowserSpreadsheet ComposerEnhanced Data Form Access to source is not free.ExTools - Free Microsoft Excel add in download Stock market downloadsPop ToolsShared MacrosFUNCUSTOMIZE.DLL This free add-in allows to customize VBA user-defined functions in Excel's function wizard.MOREFUNC.XLL 65 add-in worksheet functions (translated from French into English). Examples.xlsAutoChart Manager This Excel add-in links the minimum and maximum values of a chart scales to worksheet cells.Β You may also view the help file onlineChart gap for N/A This Excel add-in ensures that all line and scatter charts on the active page have a discontinuity wherever the data point contains a #N/A.Chart Image to Data This add-in is designed for those instances when one has an image of a chart but not the underlying data. Once the image is in electronic form, this add-in can help estimate the values of the associated data.Countdown TimerDigital ClockBalance Wiz & Fill DownCustom Radar Chart The software in the custom-radar.xls file allows one to create a radar chart that is more customized than the one that Excel creates by default.Directory List This add-in creates a listing of a directory and all its sub-directories. Gantt (Project) chart This add-in creates and maintains Gantt (project) charts.Gantt functions This document provides a downloadable workbook with two immediately usable functions related to creating a Gantt (or Gantt-style) chart.Hover Chart Label This Excel add-in shows data labels in a chart only when the mouse hovers over the associated data point (or the label itself).Interactive Chart This Excel add-in shows the Y or X value associated with the corresponding X or Y value for any XY Scatter chart.PivotChart Drilldown Written in response to various requests for an utility of this nature, the PivotChart Drill-down add-in does just what the name implies.PLOT manager This program lets one graph any function that can be created in an Excel worksheet.Β In addition, the program improves the typical plot by concentrating its efforts on those portions of the graph with the greater curvature.SIMULATE SimRisk 2003, the successor to SIMULATE 2000, is a Monte Carlo simulation package written as an Excel add-in.Solve Polynomials This add-in solves for all solutions to polynomials of up to the 4th order (quadratic, cubic, and quartic or bi-quadratic).Β The results (2 numbers or 3 or 4) can be all real or in the complex plane.Table of Contents This program lets one create a Table of Contents for an Excel workbook.Β It uses information within the workbook and within specific worksheets to build the TOC.Text Write The Text Write Program is a Microsoft Excel workbook with a macro program that writes any sheet of any open workbook to a text file with lots of optionsTornado diagram This add-in creates Tornado diagrams that visually display the results of single-factor sensitivity analysis.Floating Browser This set of add-ins allow one to browse the 'Net without leaving the current application.Β There is one add-in for each of Excel, PowerPoint, and Word.Β Install the add-in at the appropriate location.Synchronized scrolling and Workbook windows navigatorΒ A Excel-based calculator An interactive graph analyzer An enhanced find toolVBA Timer Are you looking for an easy way to add VBA capability that relies on timed events?VBA Calendar This add-in allows a developer to add a calendar to a userform with almost zero programming.Array FunctionsPage of Excel Add-ins (all in Italian)Getting Stock Prices into Excel (Yahoo Finance)XL Grade BookXL Manager Functions used to solve problems in engineering, finance, accounting, and many other disciplines.ChangeUnits Understands virtually any combination of units and automatically checks to make sure each conversion is valid.ASAP Utilities Over 300 additional functions for Excel.Worksheet ToolsHidden Sheets Add-inPivotTable HelperXL Name ManagerFlexFindUltimate Excel Add-inXLXtrFunMatrix & Linear algebra functionsXL Precision>Inspector TextXL NumbersVB Numerical Numbers>Simstool & FormlistXL StatisticsClassification Tree In ExcelStats Add-insSmart IndenterLoadPictureGDI.zipBIG List of Free DownloadsVBA Code CleanerXY Chart LabelerExcel UtilitiesCode DocumentorDialog ConverterFaceIDMZ-Tools>Google Search Add-inVBA Code CompareDelete Links> Excel ViewerExcess Format CleanerRemove Hidden DataSave as PDFSave as PDF or XPSSave As XPSTemplate Wizard with TrackingComment ControlComplete Excel NamesDuplicate MasterDifferenceEngineXEasyFilterExcelCalcsExcel ExplosionPOP ToolsPivot PlayPivot PowerQuick Date EntrySend MailRandom GeneratorXL Functions DictionaryEATBusiness FunctionsWebCab XL

I am working on a gradebook. The final grade consists of a homework average, a project average, and three exam grades.

The homework average is calculated in column AV and the project average is calculated in column BF. The raw exam scores are entered in columns BR, BS and BT.

For the homework and project averages, it is important to differentiate between the case where no assignments have been graded, and the case where assignments have earned a grade of zero. When I calculate the homework average, I use the following array formula:

=IF(COUNT(AF10:AU10)=0,"",100*SUM(AF10:AU10/$AF$3:$AU$3)/COUNT(AF10:AU10))

If the count = 0, then no homework grades have been entered and I want nothing to display in the average column (AV). If count is greater than zero, the average is calculated and converted to a number between 0 and 100. The project average uses a similar formula.

I have a summary section in columns BY to CC, where BY is the homework average, BZ is the project average, and CA - CC are the exam scores

In the homework summary column, I would like the cell blank if no homework has been turned in, and use the formula: =IF(ISNUMBER(AV10), AV10, "")

I use similar formulas for the project average summary column and the grade summary columns. The above works fine for displaying the category averages.

My problem occurs when I try to calculate the weighted average for each student. The category weights are in row 3. Im trying to use the formula: =SUMPRODUCT( (BY10:CC10) * (BY3:CC3) )

This formula gives me a VALUE error. Using the Evaluate Formula tool (Excel 2003) I discovered that when the cells are blank (due to the entry in the IF formulas) Excel wants to treat those cells as text even though I have them formatted as numbers. I've tried a variety of array formulas using the ISNUMBER function, but can't get rid of the VALUE errors.

I would be very grateful for any advice the group can offer. Thank you in advance for any assistance.

--

I am trying to convert numbers on a 22 point scale (a test score) into a letter grade (A to H). For instance, If someone scored 20, this is an A3 grade; if they scored 16 they get a B2.

I have tried the following formulas, based on threads I searched, but I get the 'there's an error in your formula' message. I'm probably just being stupid but I can't see what I'm doing wrong.

=IF(I24=22,A1,IF(I24=21,A2,IF(I24=20,A3,IF(I24=19,A4,IF(I24=18,A5,IF(I24=17,B1,IF(I24=16 ,B2,IF(I24=15,B3,IF(I24=14,C1,IF(I24=13,C2, IF(I24=12,C3,IF(I24=11,D1,IF(I24=10,D2,IF(I24=9,D3,IF(I24=8,E1, IF(I24=7,E2,IF(I24=6,E3,IF(I24=5,F1,IF(I24=4,F2,IF(I24=3,F3, IF(I24=2,G1,IF(I24=1,G2,IF(I24=0,H,)))))))))))))))))))))))

=LOOKUP(I24,{22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0},{"A1,A2,A3,A4,A5", B1,B2,B3,C1,C2,C3,D1,D2,D3,E1,,E2,E3,F1,F2,F3,G1,G2,H"})

Thanks for taking the time to help out,

Excelnovice.

In my regular (paper) gradebook, students are listed in numbered rows, so as I get a new student, I have to add his/her name to the bottom of the list, no matter what letter the name starts with. The electronic gradebook, however, is strictly alphabetical. So as I continue to add students, my gradebook will look like (1. Adams 2. Davis 3. Smith 4. Moore (added later) 5. Franklin (added last). Meanwhile, the computer gradebook will look like (1. Adams 2. Davis 3. Franklin 4. Moore 5. Smith)

Obviously it's easier to enter using 10-key when I can just go straight down the list, so I can't go straight from paper gradebook (number order) to electronic gradebook (alphabetical order). Instead, what I'd like to do is have one Excel workbook that mirrors the number order of names in my paper gradebook, and one workbook that mirrors the alphabetical order of names in the computer gradebook. Each row would be a student's name, and each column would be an assignment/grade.

Since I'm inputting assignment/grades continuously, I'd like to be able to (in advance), link a bunch of cells (say, 25 columns worth) in the Franklin student row from the first worksheet (row 5) to the second worksheet (row 3). Note that the cells would be empty, since I haven't input any grades yet!

Then, as I input the first assignment, I can 10-key grades from the gradebook into the number-order workbook, and it will automatically link them to the correct row(s) in the alphabetical order workbook. Then the second workbook will already have the grades in alphabetical order for transfer to the computerized gradebook.

I'm sorry if I'm not explaining this well. It's just that entering the grades will be done several days a week over the course of six weeks - so it won't really be feasible to continue to link each grade for each student as I go. I'd rather link them in bulk at the beginning, and have them automatically transfer.

Can this be done? Any help will be MUCH appreciated!

I need help on my computer class project

im calulating student test score which are number and converting them into letter grade using this formula...=IF(D7>=90,"A",IF(D7>=80,"B",IF(D7>=70,"C",IF(D7>=60,"D",IF(D7>=50,"F")))))

but on some student test score its missed meaning the student missed the test or inactive meaning the student drop the class.. i need a formulas to calculate the missed and inactive students score so for example for missed test score the answer should be "inc" for incomplete and for inactive it should be"drop"

i tried using this formula... =if(d7=missed,"inc) so if d7 test score is missed that means the total grade should be "inc" and for inactive student the test grade should be"drop"..i tried using that formula but an error message shows up like this #name?

thought I'd found exactly what I need on Chip Pearson's site which describes

precisely what I'm trying to do but when I follow the instrucions my lookup

formula results in #REF!

If I try and enter the array with Ctrl-Shft-Enter I get the "the formula you

typed contains an error " message.

I'm confused! I must be missing something really obvious. The info from

Chip Pearson's site is below. I'd be grateful for an idiot's guide on

exactly how to get this to work.

Thanks a lot

----------------

........create a define name called "Grades" which refers to the array:

={0,"F";60,"D";70,"C";80,"B";90,"A"}

Then, use VLOOKUP to convert the number to the grade:

=VLOOKUP(A1,Grades,2)

where A1 is the cell contains the numeric value.

Grade book time again. I wish to convert number marks to letter grades, have tried to use the following;

IF(A3=0,"#",IF(A3<8,"U",IF(A3<12,"G",IF(A3<16,"F",IF(A3<20,"E",IF(A3<24,"D",IF(A3<28,"C",IF(A3<32,"B ",IF(A3<36,"A",IF(A3>35,"A*"))))))))))

But it won't work because it breaks the seven nested function rule.

Any suggestions how I can keep this to one cell?

Maybe a Vlookup or similar? Just a pointer would help,

Thanks for reading,

Dave

I need help on my computer class project

im calulating student test score which are number and converting them into letter grade using this formula...=IF(D7>=90,"A",IF(D7>=80,"B",IF(D7>=70,"C",IF(D7>=60,"D",IF(D7>=50,"F")))))

but on some student test score its missed meaning the student missed the test or inactive meaning the student drop the class.. i need a formulas to calculate the missed and inactive students score so for example for missed test score the answer should be "inc" for incomplete and for inactive it should be"drop"

i tried using this formula... =if(d7=missed,"inc) so if d7 test score is missed that means the total grade should be "inc" and for inactive student the test grade should be"drop"..i tried using that formula but an error message shows up like this #name?

No luck finding an answer? You could always try Google.