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

    Graphic in excel for practicum

    Homework Statement So I have to make three charts for the measurments that we made in class (physics experiments but it's not important). The first one had to be with a linear trendline, the second one with a exponential and the third one with a logarithmic trendline. For some reason the last...
  2. Hercuflea

    Insert data into excel, calculate+retrieve data using Python

    Hello, I currently have a Google Sheets document that I want to run some analysis on. The document is very formula- heavy (not just raw data). It takes a set of input numbers and does some computations and gives me an important output number at the bottom of the spreadsheet. These computations...
  3. M

    MATLAB Solving MATLAB to Excel Copy Issues

    Hi PF! I am trying to copy info from MATLAB to Excel via the following code filename = 'testdata.xlsx'; A = [12.7 5.02 -98 63.9 0 -.2 56]; xlswrite(filename,A) but I receive the following warning: Warning: Could not start Excel server for export. XLSWRITE will attempt to write file in CSV...
  4. W

    How to get Output from this Program into Excel?

    Hi All, I have been trying to teach myself programming recently (Python, mostly). I obviously still have a good way to go. User MarneMath was nice-enough to help me in this post a while back: : https://www.physicsforums.com/threads/classification-valuation-problem-baseball.893418/#post-5630986...
  5. L

    Solving for Minimum point Excel

    Homework Statement [/B] Hello, I trying to solve for the minimum value that the x and y components reach in plot (A). I know that you can perform this using IgorPro but I would like to know how to solve for it using Excel. The plot was constructed using the following data points: 110...
  6. M

    I Area under curve using Excel question

    Hi there, I was wondering if someone could help clarify something for me. I am using excel to find the area under a curve. I am using the : (B1+B2)/2*(A2-A1) equation to do it. However, due to the nature of the graph, all the value I am getting are negative. The values on the X axis decrease...
  7. kyphysics

    Help with Annoying Stuff on Excel

    I currently use the free online (web-based) version of MS Excel through Google Docs. I recently made a spreadsheet to input medical billing stuff and have come across some annoying problems that I'm wondering if anyone has experience with and could help me resolve: 1.) I have one column...
  8. M

    Plotting two matrices in Excel

    Hi PF! I have two matrices of equal dimensions. I would like to plot them such that row ##i## of matrix 1 corresponds the x-axis and row ##i## of matrix 2 corresponds to the y axis, so that row ##i## of matrix 1 and matrix 2 together give a coordinate. Does anyone know how to do this quickly...
  9. M

    Enhance Your Excel Plots with Custom Labels for Optimal Data Visualization

    Hi PF! I'm plotting a log-log plot in excel, and each axis currently lists numbers like 1, 10, 100, 1000. What I would like is ##10^2,10^3##... etc. Any help would be awesome!
  10. A

    Calculators How to delete column(s) with particular values in Excel?

    In Excel, I wish to automatically delete multiple columns that have (0) in particular row location. How to do this? After the deletion, the data array should shrink to only columns that do not have (0) at that row.
  11. A

    How to fill cells in Excel in particular sequence?

    Suppose I need to fill a row composed of 32 cells with a sequence of 4 cells with value 1 in a row followed by 4 cells with value 0 in a row and then again 4 cells of 1 and so on. How can I do this without copying those cells and repeating pasting them in their location?
  12. M

    How to concatenate columns in Excel

    Say I have two columns containing data in Excel. Column A contains 10 non empty cell and column B contains 12 non empty cells. How can I create a column C with 10 + 12 cells without specifically telling Excel to put cell B1 in cell C11. In other words I would like to concatenate column A and B...
  13. A

    Calculators How to perform singular value decomposition using MS Excel?

    I have a matrix of data and I want to do SVD using excel, is it possible?
  14. A

    How to copy the value of a cell in Excel to a new location?

    Suppose I apply a particular function and I get a value of the cell-A1. How can I copy this value to another cell-C1 and the entire column under C1 to use it in a new operation provided that C1 and the entire column are always updated when A1 changes?
  15. L

    Excel secondary axis without layout tab

    Hello, I am trying to make a graph on excel 2013 with two y axes, and the internet says I should click on the "Layout" tab under the Chart Tools tab, but I do not have that tab. How do I do this?
  16. B

    B Why is the %change of the %change of a sequence so chaotic?

    Take the sequence 1,2,3,4,5,6,7,8,9,10... If you found the percent change for each interval and kept on finding the percent change of the percent change of the sequence, why does the change become more and more chaotic? Here is a quick table I made...
  17. jmex

    A little help in programming docx to Excel

    Hello all, i don't have much knowledge about programming so i googled about fetching datas from docx to excel and it showed can be done by VB. I see under developer tab in excel and opened Macros where i can write programmes. Now i have many docx files in my folder and daily it is increased by...
  18. GerryZ

    MHB Importing Excel Table into MHB Forum

    Hello MHB Gurus I'm writing this section but I'm not sure if is the right one I wonder if is possible to import an Excel Table (with copy and paste) from excel into the forum with line and boarders Thank you for your help 7 mag 2014 10:20 1,3928 7 mag 2014 10:25 1,3926 7 mag 2014 10:30 1,3925...
  19. B

    Learn How to Calculate Unknown Variables in Excel: Step-by-Step Guide

    How do I make excel to calculate 2 unknown from 2 equations like these a . x = 5 a. x^2 = 10 for example How do I do the setup?
  20. kelvin490

    MATLAB How can I append new columns to an existing Excel file with MATLAB?

    I would like to ask how to use MATLAB to append new columns into existing excel file without altering the original data in the file? In my case I don't know the original number of columns and rows in the file and it is inefficient to open the files one by one and check in practice. Another...
  21. L

    Help for excel, calculate division of colums by sums

    I have column from E5 -->E35 which contains values for each box. another column from F5-->F35 contains values for each box I have a sums column, H5-->H35,, which contains values for the sums between the E and F boxes (E5+F5=H5 ;;; E6+F6=H6 etc...) I want a division column inside J5-->J35 which...
  22. Square1

    SUMPRODUCT in Excel: Multiply & Add Values Easily

    Hi. I am having issues using the sumproduct function in excel. I two values in cells A1 and B1 that I want to multiply. I have two values in cells C1 and D1 that I want to multiply, and so on and so forth. I want to add these products afterwards. I think I have a problem with the syntax I use...
  23. S

    Solve question using Excel or Matlab

    water moves over a stationary horizontal flat plate of one-meter length. if velocity of water is 1 m/s, draw boundary layer and friction coefficient versus x for this plate. hint: start your curves from x=1cm.Professor asked us to do it in Matlab or Excel and I'm not sure I understand how to...
  24. I

    Zoom and pan in MS Excel graph

    I have a lot pressure data (in CSV) taken over a long time and would like to dynamically zoom and pan to analyse the data. Any suggestions?
  25. B

    How to Combine Gradient Uncertainty with other Uncertainty?

    Homework Statement I did an experiment to measure the speed of sound(using two microphones and a hammer). I changed the distance between the two mics and calculated(using a fast timer) the time taken for the sound to reach from the start mic to the end mic. I made a graph(distance on x axis...
  26. W

    Importing flat files (e.g.) Excel directly into SQL Database

    Hi all, I have a bunch of legacy files I am trying to import directly into an .sql database. Is there a way of doing this other than by using Microsoft's import/export Wizard?
  27. S

    Excel spreadsheet that prevents using data

    Hey all, pretty easy question. Received a request that we are obligated to uphold regarding our purchasing information. We must provide the information in a concise format (pff). Here's the issue. They are going to use it to sell marketing information and we don't like the idea of them making...
  28. phy9

    Excel formula for rounding a value & error

    I'm having a physics lab in which a report needs to be submitted after an experiment. The experiment includes many measurements: values with their errors. I need to round the error up to 2 significant digits, and then to round the value up to to the amount of digits that the error is presented...
  29. E

    Uncertainties and LINEST in Excel....

    I don't think this qualifies as a homework question, as I can work around it; please move if necessary. I am currently doing a lab report on the Magnetic Susceptibility of different samples. In one part of this report I have to plot Force vs B^2, which is a linear fit. I have errors which have...
  30. F

    How to write imaginary coefficient in excel 2013

    i have equation: ur=2.c(1-v2)/(w.d.i)(1+v2) i don't know how to write imaginary coefficient in excel.please help:(
  31. Steven Ellet

    Lookup Row 3 Column "amz" - Result Side by Side

    If I want to lookup row 3 column "amz" and the end result will be side by side, how do i do that Example: a=.4 m=.91 z=.22 input; amz output: .4.91.22
  32. J

    Graphing stress-strain plots on excel

    1. I'm given time (s), extension (mm), tensile stress (mPa), and tensile strain (%) in a table. I'm supposed to graph it on excel, but my graphs don't look at all like a stress-strain graph. 2. I think it's probably because I'm using tensile stress or strain? Or is it an excel error I'm doing...
  33. 24forChromium

    Excel: Entering empty cells with function

    How can I set up a function with an if command such that it only copies values greater than zero from another column while leave the rest of the cells empty (not zero)?
  34. E

    Engineering Basic calcs in excel for dc lap wound motor

    Homework Statement My group and I have to design a lap wound dc motor. Maximum of 12 volts and 5 amps. Must have no more than two poles. The aim is to achieve maximum efficiency. I've created this excel spread sheet to calculate the gauge of wire we need and the type of magnets. Also how...
  35. RJLiberator

    In search of a Graphing Program for Excel data

    Here is essentially what I need to do for a school essay: I have an excel sheet with 200 points (x corresponding to A1 column values, y corresponding to B1 column values). I need to find a way to transfer this to a graphing program in quadrant 1 (all x,y coordinates are >= 1 and less than or...
  36. 24forChromium

    Use Excel to find the similarity between functions.

    I am writing a paper and I came up with a function that uses a hypothetical relationship to predict the value of one variable at different points in time, I graphed it, and then graphed the actual readings from an experiment. How can quantitatively describe how close the two trends are? In other...
  37. 24forChromium

    Converting R-Value to Percent Uncertainty in Linear Regression Predictions

    I just need a quick answer, say I have a bunch of data points on a graph, I made a trendline with a function of y = 5x + 6, and a r value of R^2 = 3, is there a way of converting the r value into a percent uncertainty in the prediction of the functions? Say I used the function to predict when x...
  38. 24forChromium

    Combining Force and Velocity Data in Excel with Irregular Sample Rate

    Not really a programming question, but if you will: I have two data series, one is force over time, the other is velocity over time. The first series has a sample rate of 1 measurement per 0.1 second and is consistent. The second series has an irregular sample rate (due to the intermittent...
  39. 24forChromium

    Can Excel Help Me Find When a Particle is on the Right of the Centre?

    I should probably be asking Excel's programmers, but I have been lucky in this forum lately; here is what I got going on: I have a data table composed of two variables: time and angular velocity of a particle around a centre point. Time is just 0.0, 0.1, 0.2 (in seconds) and so on. Angular...
  40. saurabh anand

    ANSYS: Calculate SIF w/ Excel for Fracture Mechanics Analysis

    Hello all, I am a new user to Ansys. I am currently using it for fracture mechanics analysis to calculate the stress intensity factor(SIF). I am supposed to calculate the SIF for different force applied to my model. The forces are on an excel sheet. Is there some way I could link this excel...
  41. L

    Excel spreadsheet calculating costs

    Can anyone tell me how to work out the Kw usage of a plate heat exchanger using Primary and return flow rates when no demand for hot water or heating is needed; assuming 0.04p per Kwh is charged. Basically a valve is passing when the heat/hot water is off and want to work out the heat loss and...
  42. QuantumCurt

    Fitting data to a Gaussian Distribution in Excel

    Hey everyone, I'm hoping I can get some input on this. As some of you may recall, I'm currently in an internship at Fermilab, and I've hit a snag in plotting my data. I'm measuring the intensity of the NuMI neutrino beam at multiple different points to look for discrepancies in the measured...
  43. G

    MATLAB Exporting data points to Excel with Matlab?

    I have an optimization algorithm running 50 full trials with up to 10,000 iterations each (it breaks off if the error goal is reached before that). I want to export the iteration number and the best function value at each iteration to an excel file, then after each trial completes move to the...
  44. QuantumCurt

    Converting string of dates in Excel

    Hey everyone, This may not be the right place to post this, so if an admin thinks a different section would be better suited, please move this thread. So I'm in the midst of my summer internship at Fermilab right now. I'm currently trying to plot some data for the beam intensity of the NuMI...
  45. C

    Generating Colour in Excel Cells

    Im trying to colour excel cells using (r,g,b) values. I understand its possible to do this through macros or through custom functions. Any suggestions / solutions?
  46. W

    MATLAB Converting Excel formulae into Matlab code

    Hi everyone, I will start off by saying that I am a complete novice in Matlab and prefer to use Excel however the data that I have requires more computing power than Excel can provide. I have 16 sets of data with over 70,000 rows and 9 columns. The first column is a time series separated into...
  47. M

    Question about finding electric field using slope on excel

    Homework Statement I have a list of data, positions and measured voltages at each position. As part of my lab analysis I have to find the electric field at each position. I know that the slope of a potential versus distance plot is the electric field, but I have no clue how to find not the...
  48. I

    Excel 2011 for Mac Mixed Reference Macros Issues

    Homework Statement Hello! I would be grateful for your help. I've tried many many times to record a mixed reference macro on my mac, and it doesn't record a thing. No problems with recording separate macros with relative or absolute reference. Problems description: I have few sheets with...
  49. E

    Free Alternatives to Excel for Accounting

    hi are there any good free alternatives to Microsoft excel to do accounts in Thanks
  50. parazit

    Superscript Formula in Excel Function CONCATENATE

    Hello Master. I would like to ask a question about MS Excel and one of it's functions; CONCATENATE. I'm trying to write a huge number of reactions in the Excel as the following form : 12C (α,p) 15N So, since I have tons of reactions to organize according to the alphabetic order and isotopes...
Back
Top