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

    Excel VBAWriting a .txt file to an Array or Wrksht

    Go To Post #7 for new Question :smile: So let's that I have a .txt file called input.txt that simply contains the following: abc+123 I want to load input.txt using VBA into a 1-dim array called MyArray. I want each character to be an element of the array. That is a is MyArray(1), c...
  2. J

    Any VBA / Excel gurus present?

    I'm fairly new to Visual Basic, so the answer to this might be really simple... So here's the deal: I have something like 500 Excel worksheets, that each contain the following: 1. 2-N equally long rows of data 2. A Line graph of one of rows 2-N versus the top row What I need to do is change...
  3. G

    Eliminating noise from Excel Data

    I am observing the Sun with a small radio telescope for a research project. I am measuring the intensity of the flux and comparing it to X-ray flux data from the NOAA. I am plotting radio flux intensity against time and i get a big "hump" in the middle of the day due to less atmospheric...
  4. J

    Performing Regression Analysis on Excel: Two Methods

    Does anyone know how to do a regression analysis on excel? I need to find the correlation coefficient and the coefficient of determination and I only know how to do that with a graphing calculator TI 83+
  5. S

    Excel Formula Typing for Homework: Troubleshooting #VALUE Error

    Homework Statement I have the formula S=t^(-1/b)*g I want to type this into excel. Homework Equations The Attempt at a Solution For S are values typed into the second column (B) for t are values typed into column A. I 'named' the b and g using the name manager and set the...
  6. S

    Solving Maths Problems: Using Excel for Finding Values of s and r

    Homework Statement I have a formula: x=(y/s)^r I am given data: 6 values for x and the corresponding 6 values for y. I am to find the values of s and r. I could take logarithms and make this formula linear then use linear regression (as in statistics) and do the method of least...
  7. E

    Fortran Reading MS Excel Files in FORTRAN 77

    Dear Members, How can I read an MS Excel created csv or tab delimited file in FORTRAN 77? The two tab delimited and csv files are attached. Thank you, Ekin
  8. M

    Can I Use an IF Statement for Regression in Excel?

    Regression in Excel I want to make an regression of some data, but I only want to use some of the data. The data I want use is where Vacant = 1. Is this possible in excel? I have tried to use the if-function but the regression does not like "false" More info I want to make a...
  9. F

    Solving Excel 2003 Problem: Entries Not Showing in Formula Bar

    I have a wierdness with Excel 2003 and I can not figure out how to get rid of it: Problem: The entries in a cell do not show up in the formula bar. Particulars: 1) If I have an equation in a cell, the equation will show up only if I highlight the cell and then put my cursor in the...
  10. M

    Microsoft Excel 2007 - Sub/Superscript Buttons

    Does anyone a way (ANY WAY!) get get these buttons on either the Ribbon or Quicklink toolbars? p.s. for 2003 and pre users, yes I am aware that typically one would simply "Customize Toolbars", find the icons and drag them where you want them. However, though an option in Word, for some...
  11. W

    Polynomial Fit in EXCEL does not work as it should

    Hello all, I am trying to extract the 2nd degree polynomial coefficients from a curve of best fit applied in EXCEL. I know how to do it (http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas) 2nd Order Polynomial Trendline Equation: y = (c2 * x^2) + (c1 * x ^1) + b c2...
  12. P

    Can Excel be Used for Design Optimization? Tips and Resources for Success

    Quick question, I am taking this analog design class and the class includes a project which requires design optimisation using either excel,or mathcad Has anyone used excel to optimise the design? If yes, can you please guide me to the resource on how to setup excel to optimise or give...
  13. C

    Sliding on the surface of a rough sphere (ploting theta in excel)

    Homework Statement I have determined the solution to my problem however now the problem asks me to plot theta as the block flies off the sphere when Mu k ranges from 0.0 to 0.5 in increments of 0.05 I don't know a great deal about working with Microsoft Excel. Well I do just not enough to...
  14. S

    Creating a Distribution Curve in Excel: A Step-by-Step Guide

    Hi I'm trying to make a distribution curve in excel, but I can't seem to find it. I have excel 2003 I know how to make column graphs and stuff, but I can't seem to find where to find how to make a distribution curve can anyone help me? Here is a link of the type of graph I want to make...
  15. L

    Low pass filter or envelope detector in Excel

    I am playing with some accelerometer data and need to filter out the noisy output. How do I implement a Low pass filter in excel? I tried avg, rolling avg. They all smooth out the data but not what I want (averaged accn is finite when it is actually zero!) If I can create an envelope...
  16. J

    Need help designing a model and using excel

    Hello Everyone, I would like some help developing a model. I am using the Solver in Excel, but the results are giving me counter-intuitive results. I believe it is because my model is incorrect. Once I get some help perfecting the model, then I will worry about translating it for the Solver...
  17. W

    How can I fix round-off errors in Excel when using trendline equations?

    Hi, I am attempting to find an equation to fit a curve that I have plotted in Excel. I use the trendline function and get an equation but when i place that formula in excel and with the values they are different. I have attached the spreadsheet to show you. The yellow columns are my original...
  18. E

    Two data sets and want to do a regression excel y = C(x^n)

    I have two data sets and want to do a regression so that the equation that relates them is of the form y = C(x^n), where C and n are constants. How do I do this in Excel?
  19. A

    Creating a Y = kx + m plot in excel

    Homework Statement Values for t 1,2 3,4 7,15 9,32 12,28 15 18,39 21,45 Values for ln(V∞-Vt) 3,6 3,57 3,54 3,51 3,48 3,45 3,42 3,39 ln V∞ = 3,63 Homework Equations ln (V∞-Vt) = ln V∞ - k''t Teacher Quote: "If ln (V∞-Vt) is plotted against t in a diagram a straight...
  20. D

    MATLAB Matlab - importing data from excel & interpolating

    I have data that I'm using for a wind turbine project. The project requires that I retrieve data from an excel sheet that was supplied of experimentally tested values for lift and drag. These values for lift and drag are based on a value alpha (an angle, but irrelevant to the coding question)...
  21. Saladsamurai

    How to Label Proportional and Ultimate Stresses on Excel Stress-Strain Diagrams?

    EVEN EASIER EXCEL question! I am a little confused as to how I am supposed to "mark" the proportional and Ultimate stresses on my stress-strain diagrams. I created them with Excels 'insert x-y scatter' function. I cannot find any way to add a text-box though... Any ideas? I basically just...
  22. R

    Excel, proper equation format.

    Ok, so the teacher gave us an assignment to write a program that calculates the ratio below, tabulate it and plot it.. for given values of R and λ. T_b/T_a =([R^4-(R-λR)^4])/([4λR^2 (R-λR/2)^2]) I figured that I would use Excel to do this. I think the above equation converts to the...
  23. A

    Average Data from Multiple Excel Log Files

    I have a lot of Excel spreadsheets which are actually log files from a test (so they all have the same structure) and I need to get the data (a number) from a specific cell (same cell) in each file and do their average. Does anybody know an efficient method to do this?
  24. K

    What is the error of the trendline in Excel with error bars?

    I have a excel file with a graph that has error bars. i have added a trendline, but i want to know what the "error" of the trendline is? how do i make excel do that
  25. M

    Creating a Scatter Chart in Excel 2007

    Homework Statement Not sure if this is suppose to be posted here or not, but i need help with making a chart in excel 2007. I need to make a scatter chart. The x value is 0.25. The y values are 4.68E-19, 4.10E-19, 3.06E-19. The Attempt at a Solution I tried making the chart but it gets...
  26. S

    Project Staffing formula in Excel

    Greetings all - I am trying to determine the staffing requirement for an ongoing project. Here are the project specs, and I need to know if I need a part time or full time person. 461 clients 10 minutes to complete each client task (minimum of 10 minutes) Repeat each task quarterly...
  27. R

    Excel - help with eulers method on coupled equations

    im doing a simulation on a magnetic moment in a magnetic field B and I am quite stuck. its a set of coupled equations: m'-x=B*m-y & m'-y= - B*m-x where m-x is the x component, ' is rate of with respect to time etc. the vector should be precessing in a circle with frequency w= - B, B is set...
  28. E

    MATLAB Converting Excel Spreadsheet to Matrix and Storing in Mfile

    Hi I have just imported a fairly large matrix from a excel spread sheet (121x6) useing the xlsread function. Is there a way I can convert the matrix from my command window to look something like below. Matrix = [...; ...; ...; ...; ...; ...] I want to know if i can store the matrix in a...
  29. B

    Reading WAV as data/numbers into Excel

    Hi, I have read WAV files as data/numbers into MATLAB before for Fourier analysis etc and am now trying to do the same with Excel. I have found code online which has allowed me to make use of the winmm.dll from windows to be able to create a WAV sound file from excel and also to be able to...
  30. M

    Which formula do I use? (Megastats Excel Statistics homework problem)

    Homework Statement The Warren County Telephone Company claims in its annual report that “the typical customer spends $60 per month on local and long distance service.” A sample of 12 subscribers revealed the following amounts spent last month. $64 $66 $64 $66 $59 $62 $67 $61 $64 $58 $54...
  31. D

    Recording Voltage readings in Excel

    I am sure that many of you are using Excel to do data capture, what are some suggestions as to a USB interface module that will allow multiple voltage or current readings. Also, any suggestions on any built in timer functions in Excel? Thanks, pud
  32. K

    Exporting NDSolve Data to Excel

    Hello, I'm using mathematic (NDSolve) to solve a series of PDEs, which I have successfully done. Now I would like to export the data so that I can make a graph in Excel (I know I can plot the results in Mathematica (and I have) but I would like to be able to export it to Excel, as I am a...
  33. 5

    Anyone good at formulas in Excel 2007?

    Okay, the formula that I am working from is: (RL+S) – sqrt [ RL^2 – (S*sin CA)^2 ] – S*cos CA Rod Length = RL = 5.090 Half Stroke = S = 1.5 Crank Angle = CA = 107.5 With numbers plugged in (my version?): (5.090+1.5) - sqrt [5.090^2 - (1.5*sin (107.5))^2] - 1.5*cos (107.5) The...
  34. I

    FindRoot solving of Excel input columns

    Hi, I've posted another thread asking for general help on how to solve numerically with excel. Here is my specific situation if anybody is well versed with Mathematica programming. I'd appreciate any help. I've successfully created a FindRoot to solve eqn's for one set of data points...
  35. I

    Solving numerically with Excel?

    My quandary... it's related to not being able to evaluate numerically (non-algebraic solutions) with Excel. My Mathematica programming is limited, but I've managed to use Findroot to solve it, but it requires me to manually put in 3#'s, hit enter, then copy paste results back to excel...
  36. M

    Microsoft VBA Excel help (Please)

    Hi everyone, I'm new to the forum and just need some quick help on a VBA assignment if anyone has some spare time. I have three questions I need answered. They all take place in the latest version of Microsoft Excel, VBA. 1. I need a small 20-line chunk of code explained in detail...
  37. H

    Problem with excel finding computed velocity.

    i have done this over countless number of times and i can't get it to work, so i turn to the PF Gods and hopefully you guys/gals can figure it out. we were given data in a excel spreedsheet. we have to find the computed velocity. There is no write up how to do this, my teacher showed up on the...
  38. M

    Excel program with multiple tabs with shared information linked

    I need help on writing an excel program that will allow my company to have multiple tabs with some of the same information linked. I would like to have the people in my company each have a tab with there information on it, and when they change something in there tab the main tab with the master...
  39. B

    Cell formula promlem - Excel macro

    Hi I have been having a problem with a section of my code in the macro that I've created. The problem is that the formulae that I want to use aren't working and soe I get a "##Name" error in the cells where the formula is supposed to have worked. Patientrange = Range(PatAgeLet & "2" & ":"...
  40. Saladsamurai

    Does any one know how to make a stress strain diagram in MS excel?

    Or know of any good tutorials? This is a PAIN to do by hand.
  41. T

    MS Excel: Calculate Weekly Increase/Decrease

    Which do I find the excel function for additional amount up every week? For example: $100 + $50 = $150 last week then add new $50 this week total is $200 to keep the amount up every week. It should work either + /- amount Thank you.
  42. C

    Gray and 2's complement with Excel

    Does anyone know how I can get Excel to convert binary to Gray Code and two's complement?
  43. B

    Error Analysis On Excel Questions

    Homework Statement The error part of my physics labs have been takin up a lot of time lately. Anyways, say I have 10 numbers for time measurements like 3.53 s, 5.32 s, 3.57 s, 4.89 s, 3.24 s, etc... and my reaction time is say +/- 0.20 s. I want to average these 10 values out but I have to...
  44. C

    Calculating Years of Service & Summing Data in Excel

    Here is the part that I am confused on. I have to calculate the number of years the employees have been working for us, I believe the function I need to use is TODAY but it is not working, how can I get that function to work? I also need to figure out how to use the functions when looking at...
  45. P

    Remove Blank Cells in Excel | Excel Problem Solution

    Hi all, I have this excel problem: In a column, there are entries (can be characters or number), but there are also some blank cells. How could I remove all the blank cells so that the column is shorter. Here I attached an illustration Thanks for any comments
  46. A

    MATLAB Fitting a Curve to Data: MATLAB vs Excel

    I have a set of data and I need to fit a curve to it. The equation of the curve is: y=20-a*10*log(x) My problem is just getting a curve fit to this equation. What function in MATLAB should I be looking for? How do I get the value of 'a'? Is it easier to achieve this in Excel? How?
  47. K

    MS Excel Help - Saturation Points ?

    MS Excel Help -- Saturation Points ?! Does anyone know how to do this with if-then statements or something else? For example: I want to analyze inflow and outflow in a tank, when the volume reaches zero then it's empty of course--so I shouldn't have a negative volume after this, volume...
  48. H

    Find Maximum of Graph in Excel - Any Help Appreciated!

    Does anyone know how to find the maximum of a graph using excel? so i have this graph i plotted out, and i want to find the coordinates of the peak, is there a way to do it? or do i just have to estimate? any help would be appreciated! thanks!
  49. L

    How to Excel Analytical Chemistry

    I just got my Analytical Chemistry test grade. It's fine but not a great grade. Everybody thinks it was a problem of time constraint.I think it's because were given question types that are different from what is in our book. Around 70% is very acceptable. The rest is a complicated problem that...
  50. S

    Why Are Minor Gridlines in MS Excel Changing Values Automatically?

    Hey all, I have a quick question about the minor gridlines in MS Excel. I have points that differ by .00001 on the graph. However when I type this in, Excel automatically changes it to .000036 every time. I wasn't sure if anybody knew if Open Office could solve this problem or if its just...
Back
Top