What is Excel: Definition and 346 Discussions

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

View More On Wikipedia.org
Recent contents Top users
  1. K

    CST - Access CSTResultReader.dll from EXCEL VBA

    Hello, I am trying to control CST from Excel VBA. For instance, I would like to create a routine in Excel VBA similar to the postprocessing template “Evaluate Field in arbitrary coordinates” into Excel VBA, i.e. get the e-field values into an array and insert them on an excel sheet. I read...
  2. alane1994

    MHB Calculate Sigma Sums in Excel for Large n

    Is anyone familiar enough with excel to use it to find the sum in of sigma notation when "n" is large? \Sigma^{40}_{k=1} \sqrt\frac{3k-3}{4} Something like this?
  3. T

    Simulating rocket launches using excel

    Hello everyone, Over the past year, I have been trying to simulate the launch of a rocket to orbit using excel. I have been pretty successful, and I have what I think to be a mostly working product. However, it has some problems that may be affecting the results. First, I'l explain roughly...
  4. T

    Mathematica Fitting Data Imported into Mathematica from Excel

    Can you fit data that is imported into Mathematica 8? I am just using the Import command, and I cannot figure out how to work with this data. I would really like to fit my curve. This is the code I used to import the data: Import[datafile.xlsx"]
  5. M

    How to CREATE a green triangle in EXCEL

    On the internet there is only information on how to get rid of the trianglethat indicates an error in the formula in the cell. But in my workplace I need to upload data to a program and sometimes a successful upload requires that the data in my excel cells be marked by this error-triangle...
  6. D

    Autocorrelation function in Excel

    Autocorrelation function in Excel (SOLVED) Hi, I have tried reading through this forum looking for similar example but am unable to find one. Basically, I have a large set of data that I intend to do autocorrelation. =CORREL(A1:A10000,A2:A10001) =CORREL(A1:A10000,A3:A10002)...
  7. D

    Linear Least Squares Excel Template

    Homework Statement I had to make a Linear Least Squares Excel template for my first week's Physics lab to analyze linear data for the rest of the semester. All of my values come out correctly, except the standard deviation values. I was wondering if someone could take a look at my template and...
  8. L

    Fast Fourier Transform in excel

    I really need your help - i can't work out how to do a FFT in excel. The main problem is I don't have a constant sampling rate - I recorded the time and then the corresponding magnitude of the wave. I have followed everything oneline but I can't seem to get anything to work as I can't fill the...
  9. Darth Frodo

    Excel: Finding deviation from mean

    Hi guys, I have to find the deviation from the mean for each individual entry of a column of numbers. Any one have any idea how to do this? I'm clueless when it comes to excel
  10. J

    How can I get the LINEST function in Excel to return more than just slope?

    I figured there ought to be some Excel savvy people here. Anyway I can't seem to get the LINEST function in Excel to return anything other than slope. I provide it with y-values, x-values, and say true to constant and stats. All it gives me back is a slope. Maybe I'm being vague, just ask if you...
  11. H

    MATLAB Different correlation coefficient results between Matlab and Excel.

    Different correlation coefficient results between Matlab and Excel. Please Help! I have two sets of dat as below. A problem is that MATLAB and excel returns a different value of correlation coefficient (i.e., 0.801 from Excel and 0.786 from Matlab). For Matlab, I used the function...
  12. J

    How can I use the offset property in VBA to populate a variable in Excel?

    Hello all. I am trying to get my code to color cells if a referenced cell is populated. That part works but when I tried to populate another cell a different color I encountered a problem. You can see where the mistake comes in on the code. It is when I try to populate a variable 'strMyVar'...
  13. Y

    Plot Graphs & Tables from Excel Free with XY Graph Software

    Can Excel plot graph? If not, is there any free software to plot tables of numbers from Excel to XY graph.( just common graph)?
  14. S

    Excel help in making a document to calculate Cp of Air

    Homework Statement using the table of values supplied (a pdf document), construct an excel spreadsheet wherein a value can be input from 200-2250 and output will be air's specific heat capacity at that temperature. Homework Equations Cp= H2-H1/T2-T1 The Attempt at a Solution I...
  15. J

    How does excel calculate the best fit line?

    Background: I am working with pump curves in a hydraulic model. The model is written on excel. In the model pump curves are defined using tested flows vs. dynamic head (ft). The problem I am having is an iterative solution to fit an equation to the data points. Once the first equation is fit...
  16. Z

    Simple MS Excel Graph question

    I was watching this YT film about plotting on Excel. I copied the numbers from the film into an Excel sheet and plotted x against y1 and got a blue coloured plot. Then I plotted x against y2 and plotted a chart again. Though a second red coloured plot did not appear as in the film...
  17. N

    Mathematica How to Ignore Excel Headers in Mathematica for Statistical Analysis?

    Excel Headers --> Mathematica I have a large Excel .xls file. Miniature version shown below: Test1 Test2 75 64 58 85 81 55 64 63 70 94 88 90 78 96 96 98 54 97 75 61 I would like to do some statistical...
  18. J

    Convert excel graph to wav file

    Hello, I am attempting to take data from a PDV laser reflected off a vibrating surface and then convert that data into a sound file. The data from the laser is stored in an excel spread sheet but I do not know how to convert those data points into any form of sound file. I'm thinking a .wav...
  19. S

    Help with Data Justification Using Excel 2007

    Hi, My name is Stuart and I am an undergraduate student at the University of Strathclyde, UK. I'm just about to start my 3rd year but I was lucky enough to successfully set up a summer project for during the summer where I am working in the Centre for Biophotonics. I've been a member here...
  20. K

    Fortran Fortran code conversion into Excel VBA

    Hi, I'm currently working on a project that requires me to convert a Fortran code into excel vba. There are some problems that I've stumbled into, so itll be great if someone could help out. one of it would be on how to convert a COMMON statement in Fortran to Excel VBA ( as in how would...
  21. 6

    Simple Excel VBA problem; Applying a formula to a column if it contains a number

    Hello, I have a relatively simple problem, You have two columns filled with numbers. I want my macro to go through and check the columns or one of the colums to see if it has a number in it, then operate on those numbers and display an output in a third column . I tried this; Sub...
  22. manjuvenamma

    Draw Histogram in Excel: Is it Possible?

    Is it possible to draw histograms in Microsoft Excel? I see all charts of icons in the Excel tool bar but no histogram.
  23. evol1

    How do I calculate the heat transfer coefficient for pipe heat loss in Excel?

    Hi there, I am trying to make a spreadsheet which calculates the heat loss through a pipe and also heat loss when insulated, I am using the resistive analogy to calculate this and I have it working, the only problem I am having is the heat transfer coefficient, how do I calculate this? I...
  24. manjuvenamma

    Excel spread sheet : related to formula copying

    I have a table of numbers say 12 X 12 i.e A1 cell to L12 cell. All of them have numbers filled in. I have to create another table of identical size. first row and first column numbers are just duplicated in the new table i.e.A1 to A12 (first column) A1 to L1 (first row) cells are just...
  25. S

    MATLAB Simple MATLAB to Excel Question

    I've discovered that MATLAB is not my forte. I have a 51x3 matrix that I want to print to an Excel sheet, but with column headers. I can get the matrix into an Excel file and I can get the headers into an Excel file, but I cannot figure out how to get the two together. I've looked up how to do...
  26. K

    How to count the number of occurences of an integer in excel?

    Homework Statement I have a thousand random numbers generated between -100 and 100 and want to count the number of occurences of each integer. I know i can use the COUNTIF function, but for so many numbers it takes way too long. Is there a way to create a loop in excel that can do this or...
  27. B

    Excel graphing problems with a Physics lab

    Homework Statement I have two columns of data to graph from a lab we did on spherical lenses. The instructor showed a quick and dirty sketch of what our graph should look like - a decreasing curve. My data plots as an increasing linear graph. If I flip the x-axis data top to bottom I can...
  28. joe_cool2

    Toy Rocket Excel Sheet - Instantaneous Rest Frame

    So, I need to make an Excel spreadsheet that realistically models the motion of a toy rocket. I need to take drag, gravity, and thrust into account, keeping in mind that the latter two will be influenced by the change in mass. The equation for force I must use, then, is: F = ma + v(dm/dt)...
  29. T

    Frustrating excel problem with COS

    Dear all, I am currently using excel to work out some values for incident solar radiation but I am running into a rather frustrating problem when I try to do the following: =COS(9.863) my calculator tells me correctly this is 0.985. however, when I put this in excel it decides it...
  30. M

    How Do You Create a Line of Worst Fit in Excel?

    How would I go about creating a line of worst fit in excel? Would I create a different row for the uncertainties?
  31. S

    Conditional Formatting Issue in Excel

    Hi everyone. I have never worked in-depth with Excel and I am trying to make my life a bit simpler doing some data cleaning using the 'conditional formatting' option. My scenario is the following: I have two columns of data, column A and column B. I would like to take each entry (a string...
  32. K

    Fortran How To Run Fortran.exe using Excel

    Hello everybody, I have a fortran.exe (compiled using intel visual fortan comipler 10.1.24 and VS 2005) which takes an input.dat file and generates output.dat. Currently, I am trying to control fortran.exe execution with excel 2010 shell function. But it is not working properly. The...
  33. M

    Using Excel to figure out how much money I could make if I traded my dividends?

    I want to use Excel to figure out how much money, in dividends, I could make if I bought a stock in Microsoft, whose stock has recently stayed at $30-$31. They pay $0.80 in dividends/share. So far, I have a spreadsheet with columns "Years," "Shares," "Share Cost - Dividends," and...
  34. T

    Confused on creating a normalized histogram (on excel)

    I have all the information I need, but I just need a bit of help on getting my data on a normalized histogram in excel. First, if I'm not mistaking, a normalized histogram is just a normal histogram where it is roughly symmetrical about the curves centerline, is that correct? I have a list...
  35. M

    How does Excel anticipate a sampling distribution using just one sample?

    Hi, I know that Standard Error of a coefficient is the standard deviation of the sampling distribution associated with the coefficient. I understand the concept. What puzzles me is this: We have just one random sample to work with. The calculator or Excel doesn’t have any info on the...
  36. P

    Calculating a and b in excel (any excel masters)?

    Attached is a problem that I am supposed to use excel to find the best estimates of a and b. As I am horrible at excel could someone give me some pointers or an idea how to start? Please don't do it for me, I want to learn how to do it - I just need some help.
  37. D

    Excel VBA change (or edit ) links Macro

    Excel VBA change (or "edit") links Macro I have a Excel spreadsheet that has several links in it which I need to change to a different computer/user. The links are all the same and to change the source I have to go to "Edit Links" and manually change the location to the specific location on my...
  38. X

    VBA with Access and Excel Help

    This is a VBA problem inside access involving an excel sheet. I have an Access Table "sOrderTable" with [Unique ID], [Resource Group ID], [Priority] columns. I am trying to Identify "Unique IDs" in Column A of the EXCEL SHEET and where they match [Unique ID] in the ACCESS TABLE matching...
  39. J

    How Can I Manipulate Numbers in Excel's General Number Format?

    I have an csv file that has a column of numbers in the form ab:cd:ef:ghy The cell's number format is general, I want to be able (if other criteria are met) to change y into y+1. The final column must again have the form ab:cd:ef:ghy and the number format general, can anyone out there give me an...
  40. Z

    Solve Your Physics and Excel Problems with Expert Help | Contact Now

    I'm having a problem with a Physics / Excel sheet I've been working on. Does anyone here think they might have the Excel expertise to help? It's not very advanced Excel. Get in touch immediately please if you do. Thanks
  41. S

    Engineering Understanding RC Circuit Behavior in Excel: Exploring Energy and Current Changes

    Homework Statement Homework Equations v(t) = v0*e^(-t/RC) i(t) = C*(dv/dt) E = .5*C*V^2 P=v*i The Attempt at a Solution I'm having trouble with part e. As far as I can tell, all of my equations are correct, but the total energy delivered is notably less than the initial energy; I was hoping...
  42. R

    2-D temperature Distribution - Matlab or Excel

    Homework Statement I am trying to find the temperature distribution of a triangular cross section (right triangle). The left side is insulated, the other two sides are exposed to an ambient temperature and heat transfer coefficient when t>0. Both sides of the triangle are 20 cm long and we...
  43. A

    EXCEL - Binary to Decimal Worksheet

    Ok, this one exercise is really getting to me. Either I missed something, or our prof hasn't gone over any of this. I was hoping someone could decode this for me. Question: ____________________________________________________________________________...
  44. Y

    Now to program a sine divid by a sine function in Excel?

    This is part of the simulation program in Antenna field pattern. One part involve finding the position of the peak where: AF=\frac {\sin\;Nx}{sin \;x}\;\hbox { where N is an integer.} The peak is at x=0 and the AF=N. But excel do not accept this and call out as "DIV 0" error. Is there any way...
  45. M

    Calculating Autocorrelations for Large Data Sets in Excel: Tips and Alternatives

    I have a set of 9,999 equi-spaced data points, and I would like to calculate the autocorrelations for ALL lags up to 5,000. In Excel, I want to have this code: =CORREL(B1:B9998,B2:B9999) =CORREL(B1:B9997,B3:B9999) =CORREL(B1:B9996,B4:B9999) ... =CORREL(B1:B5000,B5000:B9999)...
  46. L

    Solving equations in excel or other solvers

    Need to find optimal solution by solving 2 equations X= VR*(R2+R1)/R2 - VN*R1/R2 Y= VR*(R2+R1)/R2 - VP*R1/R2 VP, VN are fixed. VP=5 & VN=0 VR can change. R1,R2 should be same. How do I find a combo of VR, R1, R2 so that - X = 0.46 & Y = 0.214 (this part is easy) The same...
  47. C

    Engineering Comparing Max. Voltage of Complex Waveforms in Excel and Simulation

    Hi...i have question on RLC circuit. Why my max.voltage of complex sinewave in Excel is different from the simulated complex waveform? which one is right? max.voltage of complex waveform in excel = 106.8V max.voltage of complex waveform in simulation = 126.8V Should it be the same?
  48. P

    Comparing Benefits of Excel for High Performance Computing and Analysis

    Hey Everyone! I'm looking for a good tool to do some high performance computing and analysis for my research. I've been going back and forth about using Excel as my primary tool as it is pretty straight forward so that I can share my data and results with others. Does anyone have any thought...
  49. I

    Calculus II Applied Project - Graphing Section - Help with Excel

    Homework Statement This is the third problem of a project for a Calculus II course. My issue is with graphing. Below is the problem, and below that my tutors explanation via e-mail to try and help me. I understand everything thus far, except for how I go about graphing. I am not strong in...
  50. B

    HelloDoes anyone know if it's possible to run an excel file in

    Hello Does anyone know if it's possible to run an excel file in Simulink? I have a column with a variable in excel, and don´t know if there is a block that I can get in simulink to run this variable. Regards
Back
Top