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. M

    How can I create a graph with multiple y-axes in Excel?

    I have some data and i want to plot them on excel. I am trying to plot them but i am drilling a hole in the water. I will appreciate if anyone can help me with this. I want 3y axes and 1x.Thank you.
  2. R

    Text data in excel pivot table

    Using Excel 2003, I'd like to display text data in the Data Items area of a pivot table. Currently, I see the number 1 in the field. I've changed the format to "Text", which has no effect on the data that's displayed. Is it possible to display text data in the Data Item area of a pivot table...
  3. E

    Thermodynamic properties in excel format

    Hey all, I'm looking for a version of steam/water thermodynamic properties for excel. I need it to be able to compute properties based on pressure and entropy. Something similar to the X Steam Tables (http://www.x-eng.com/XSteam_Excel.htm) would be awesome, but again, I need the ability to...
  4. I

    Can't Get Formula Result - Excel Radian Issue

    I can't get this formula to come out. I have done it on excel step by step over and over and it gets close, but always a little under. As in if the chord angle is 45 and I do all the calculations on the other side, it calculates to 43.85. They should both be 45 so I don't know what is going...
  5. A

    Please help, finding the acceleration of g from an excel graph

    Homework Statement I have to calculate g or find the acceleration of g using the slope of the trend line from the y vs. t^2 graph. I had to use excel and did this for lab with data and use the equation excel came up with after i finished the graph, and I have no idea how to find the...
  6. A

    Excel - increase value at mouse click

    I forgot long time ago the little I knew of VB applied to Excel. Can anyone give a snippet of VB code to get the value in cell C8 to increasing by n every time I click the mouse on cell C9? I recall that being possible but I am clueless now. Gracias for any help.
  7. M

    Fortran Can Fortran77 Write a File to Excel without Using Tab Separation?

    I have problem don't use tab to separate cell for writing file to excel. this algorithm write file to excel one cell only.i want write file separate cell on excel file. please suggest me about algorithm write file in excel file.
  8. M

    How to get Excel to generate any random number besides x?

    Here's my dillemma: I'm writing up a spreadsheet where we have 100 passengers on a plane. Excel randomly generates their assigned seat, and the seat they end up taking. But the problem is, I need to make it so that Excel does not generate the same number twice.
  9. M

    How can i use excel to solve some Statistics problems ?

    Well am not looking for someone to solve the problems ,,, am looking for somone telling me how to use excel to solve some problems. with excel functions. the problems " 1.From this population of 500 households, select a simple random sample of 50 households (Use the program...
  10. M

    How can i use excel to solve some Statistics problems

    how can i use excel to solve some Statistics problems ,,, hi all ,,, am looking here for help. to know how to solve some stat problem with excel could someone help me please ,,,, :uhh: well the things I want to know are. " A data set was gathered from 500 households (you can...
  11. Pengwuino

    Histograms in Excel: Analysis of Lab Report Grading

    I want to have an analysis of my lab report grading for my students and I figured I could make a histogram. I had been manually doing =COUNTIF()'s before but I learned you could install a histogram package just now! However, it seems to be giving me conflicting results that have to do with how...
  12. T

    Formulas for ellipse at an angle, in Excel.

    Hi. I know about the general formula for an ellipse: x^2/a^2 + y^2/b^2 = 1, that can be used to isolate y and calculate x,y points in excel. That's great, so far so good. That will create a ellipse, with horizontal A (x) axis and vertical B (y) axis. But what if one wants to rotate the...
  13. Pengwuino

    Maximizing Efficiency in Microsoft Office Programs: Advanced Tips and Tricks

    Does anyone know of any good guides on getting the most out of the programs that typically come with Microsoft Office? And not things like "How do I make a chart?", but something a little more advanced like a sort of "mail merge" between data on a spreadsheet and a word document "template". For...
  14. S

    Maxwell Ansoft to Excel: Tips & Tricks

    Hello guys Does anyone use Maxwell Ansoft? If so, have you tried to export it to Excell? if so do u use any MATLAB code to convert it? or use macros in excell? Thanks
  15. S

    Trying to create a simple pendulum angle output on excel

    Homework Statement Trying to create an excel spreadsheet that outputs the angles of a simple pendulum as it slowly comes to a stop. Homework Equations so I've used the formula: θ(t) = θ0cos(squareroot(g/R*t) where: θ0= inital angle g=gravity constant R= length of string t=time...
  16. 2

    Estimating an X Value with a Known Y Value in Excel

    I have a graph in excel and i need to estimate an x value with a known y value. Pretty much i need to draw a horizontal line at y= given value over to my data line. Then a verticle line down to find the x value. How can i do this?
  17. P

    MATLAB Matlab questions: Read from Excel file

    Hi, Looking for a bit of cheeky help with matlab, I am stumped! 1) I have written a program that i want to cycle through different sets of data, ideally this is what i would like: These are all xls files with columns of data ydata = ... xdata = ... zdata = ... for variable =...
  18. P

    Calculating Changing Velocity of a Rocket on Excel

    I am attempting to work out the changing velocity of a rocket on Excel. However, I cannot use the simple: \int{a} dt = v. at + C = v. If thrust is constant at 20 000 and the rocket is 2000kg with 600kg not made of fuel and 20kg lost every second, then would the equation be...
  19. S

    MATLAB How to export Matlab curve-fitted data to excel?

    Hi all, I have used MATLAB curve fit tool to curve-fit a set of x-y points. Now I want to export the curve-fitted y point to excel. Any idea how to do this? Thank you very much.
  20. U

    How Can I Extract Maximum and Minimum Voltages from EKG Graphs in Excel?

    I have various EKG graphs. I need all of the maximum and minimum voltages for each period. The periods are not all the same length. The maximums and minimums all vary. Is there any way I can do this? Note: it'll be hard selecting chunks of data and then finding it from that because...
  21. D

    Modeling piston/crank with position loop equation, excel plot

    Homework Statement Homework Equations I would like to know if my work is correct. I thought that the graph would be a sinusoidal, but there is a small irregularity in the middle. Am I correct in using θAC = 90 deg and θAB = 36.8699 deg in solving for the constant angular velocity...
  22. D

    Small Coding Problem for Excel Macro

    I want to code a macro that will take in an integer as a row number and insert two rows above that row. This will repeat in a for loop. The problem is that I'm not familiar with VB syntax. Here's what I have so far: Sub Insert_Rows_Loop() Dim CurrentSheet As Object Dim x As Integer '...
  23. L

    Calculating Error in Y-Intercept for Fixed Slope Linest in Excel

    Hello, Does anyone have an idea about how to use fit data with a line while fixing the slope in MS. Excel? Does linest by anyway capable of doing that? Thank you Lorna
  24. I

    MATLAB Exporting data from matlab to excel

    Hello, I ran a program in MATLAB and my output is coming in the command window. I want to export these output in excel. My output are in matrix form and I want to send it as a column data in excel. Please help me to do it. Thanks in advance.
  25. B

    D'Arcy-Weisbach pressure loss in Excel

    Hello, I am working on making an Excel work book to aid in figuring out pressure drops in a system. I am trying to use the Darcy Weisbach equation for pressure loss. http://www.engineeringtoolbox.com/darcy-weisbach-equation-d_646.html" In Excel I have =(C4*(C5/C6))*((C7+(SQRT(C8)))/2)...
  26. S

    How to draw a correlation function in excel

    Homework Statement For my homework i have to compute a correlation function in excel from available data. Data goes somewhat like this: 1 xxx yyy 2 xxx yyy 3 xxx yyy I now I have to calculate...
  27. L

    Interpolation of data on Excel for analysis of Load Displacement

    I don't need any help for the engineering maths I'll be doing after but if I anyone could advise me on how to write a program that would take a set of x and y values and then give me back the y values at certain intervals on the x-axis I would be very grateful. I've got colossal amounts of data...
  28. E

    Using Finite Difference Method In Excel

    ------Question------ a) Research the three finite difference approximations mentioned above (forward, backward and central). Use a spreadsheet to demonstrate each of these numerical methods for the function below. y=x3 −x2 +0.5x Investigate the derivative over the range x = [0,1], using...
  29. E

    Calculators Transfer Excel Files to TI-89 Calculator

    I have been looking around for some information about placing a microsoft excel file onto my TI-89 (The non titanium model). Has any done this before? Thanks
  30. Sirsh

    Excel help (V look up and a IF which are a logical and a reference.)

    Hi, Wondering if anyone can help me with figuring out of if it's possible to make a function on excel with V lookup and IF, if you can pls post an example. Or give an example of using both of these functions in a algorithm to reference to cells on another page in excel within the function...
  31. S

    Standard Deviation (bell graph) in excel

    Homework Statement Homework Statement Hello everyone! I have been having trouble with cumulative frequency graphs in excel for some time now. I wonder how you make the "bell graph" or cumulative frequency graphs or standard deviation graphs in microsoft excel. I have excel for mac. I...
  32. Saladsamurai

    Excel Histogram How does it calculate bin width

    Hey people, I am trying to write my own histogram making code since the Excel one sucks IMO. I am having some trouble thinking the whole bin 'width' thing through though. I plan on using the formula number of bins = k = 1.87(N - 1)0.40 + 1 Then I was going to figure out the bin...
  33. S

    Analyzing a Truss with Excel: Solving the Matrix Problem

    Homework Statement I have a simple truss to analyze using excel. I have done this and know how to do it on pen and paper using one equation to eliminate variables in another until down the line an answer pops out and I go back in and solve for all the other variables. However, this...
  34. T

    What is the Cost Function and How to Minimize it Using Excel Solver?

    Introduction to Operations Research, Hiller, 3.4-12 I believe 1 2 3 4 5 New Alloy tin 60 25 45 20 50 =40 zinc 10 15 45 50 45 =35 lead 30 60 10 30 10...
  35. S

    What divisor does Microsoft Excel use for standard deviation?

    By definition standard deviation has divisor 'N' . But in Microsoft Excel the "STDEV" function gives 'N-1' as divisor. This may not be major issue to many of the people. But the command "STDEV" makes many users feel that this is standard deviation, i.e. it has divisor 'N'. Misleading...is...
  36. W

    Synthesizing a Triangular Wave Using Microsoft© Excel

    Homework Statement A triangular wave is produced by the following combination of harmonics Using Microsoft© Excel, synthesise a triangular wave. Start with a plot of the first term and gradually add the next term. Print out the graph produced after adding each term...
  37. D

    Rounding numbers in microsoft excel

    i need to round numbers in a spreadsheet 2 decimal points, in a way that: for a number with a.byX for x>5 i need to round upwards for x<5 i need to round downwards for x=5 i need to round up if y is odd and round down if y is even for example 0.563~0.56 0.566~0.57 0.575~0.58...
  38. C

    How do you multiply/divide complex numbers in Excel?

    I have the equation: (.462-.32094i)*[(7.2+9.6i)/(4-8i)] the answer is: .107+.748i Now, I need to know how to enter this in Excel, because the 4 will be varying and I will need many rows and then my answer to be changing with the change in the equation. I have tried...
  39. Saladsamurai

    Anyone use VBA in Excel: eclaring Arrays as Public

    Anyone use VBA in Excel::Declaring Arrays as Public Egads man...I have seen plenty of modules with arrays declared as Public. Clearly I am making some boneheaded error here and cannot locate it: Any Thoughts?
  40. M

    Excel Projectile Motion: Predicting Trajectory with Wind Calculation

    I am attempting to create an excel worksheet that accurately predicts the trajectory of a projectile. Anyways, I am having some trouble with calculating wind along the Z axis, left or right of the target. Y axis is up in the air X axis is towards the target Z axis is left or right of target Fd...
  41. G

    Projectile Motion with Air Resistance Excel EVIL

    Homework Statement Ok I am working on a spreadsheet that calculates the velocity/position/drag of a point-mass projectile and I have been digging up the same equations for days and they aren't helping... lol... I just can't seem to get the numbers right, any help would be greatly appreciated...
  42. A

    Bus simulation in excel, exponential distribution departure

    Homework Statement The bus service operates between points A and B. The buses depart from the terminal station A with headways that follow the negative exponentioal distributiona with parameter 10 trips per hour. Assume that the characteristics of the system remain the same over time (not...
  43. C

    Using Excel Solver to find min cost?

    Homework Statement The cost production function as output, x, in 000's(where x>1.000) is given by the function f(x)= 8x^3 + (352/x^2)-6x +6350 Homework Equations USE THE EXCEL SOLVER function o determine the value of x which minimizes the cots. What is the cost at this point? What...
  44. R

    Drawing vectors on excel, how? due in 3 hours

    Drawing vectors on excel, how? Homework Statement Finding and graphing the resultant/equilibrant vector. Homework Equations A=90grams, angle=197 B=60grams, angle=81 C=80grams, angle=218 Find D and angle of D...which I've already found (D=140.67, angle=186.65) The Attempt at a...
  45. Saladsamurai

    VBA Excel UserForm Simple Question

    :smile: Hello there! I have created a Useform with a few rows of TextBoxes. I have Changed the names of them all to "Powerbox1" , "Powerbox2" ...etc. Now in my code, I would like to store all of those values taken from the UserForm and store them in an array called Power() I have...
  46. drizzle

    Copy Data from Notepad to Excel - Separate 2 Columns

    does anyone know how to copy data from Notepad file [Text Document] into Excel? the data I need to copy is two columns of numbers, but when I copy-paste them they appear as one column, I just couldn’t manage to separate them [they are about 40 pages long:cry:]. anyone have any suggestion, thanks...
  47. P

    Forecasting Monthly Expenditures Using Normal Distribution in Excel

    Hi, everyone, I have a quick question for normal distribution in Excel. There's a construction project with the following monthly expenditures: JUL 2008 $ 4,903 AUG 2008 $ 3,591 SEP 2008 $ 15,452 OCT 2008 $ 12,806 NOV 2008 $ 59,988 DEC...
  48. drizzle

    Solving Trigonometric Equations with Excel (Vista)

    :blushing: using excel (vista) how can I reverse the number to be in degrees rather than radians if I want to use trigonometric functions? I have to reverse the number of the angle in radian to use those functions and I want them to be in degrees, anyone know how, thanks in advance.
  49. Saladsamurai

    VBA Excel Does a Function Like this exist?

    GO TO POST #2 for new question please I hate to start a thread just for this, but my Googling skills SUCK today! Is there a function that returns what character is in a given position within a string? For example, Dim MyName As String MyName = "SaladSamurai" FunctionINeed(2)...
  50. Saladsamurai

    Excel VBA Run Time Error '13' Type MisMatch?

    Excel VBA:: Run Time Error '13' Type MisMatch?? I keep getting this error when I run this code. Nothing is highlighted..and VBA help is not working out for me. It just started when I added the for loop in bold below:Option Explicit Option Base 1Private Sub MathML_Converter() Dim i As Integer...
Back
Top