Connect with us

Microsoft excel

Discussion in 'General Electronics Discussion' started by ElectronicsR, May 9, 2016.

Thread Status:
Not open for further replies.
Scroll to continue with content
  1. ElectronicsR

    ElectronicsR

    72
    1
    Mar 23, 2016
    Hello,
    What is purpose role use of excel in market?
    Is it open source??
     
  2. Alec_t

    Alec_t

    2,926
    796
    Jul 7, 2015
    Which market?
    I doubt that anything M$ produces is open source :D.
     
    davenn and Arouse1973 like this.
  3. ElectronicsR

    ElectronicsR

    72
    1
    Mar 23, 2016
    Hello,
    I mean people in organisation use it.
    How to download it for learning?
     
  4. Harald Kapp

    Harald Kapp Moderator Moderator

    10,995
    2,500
    Nov 17, 2011
    You don't download it. Not for learning, not for other purposes. Excel is a commercial tool you have to shell out money for.

    Use 'Libre Office' or 'openOffice' if you want free tools. These are comparable, but not identical, to the Microsoft office tools (incl. Excel).
     
  5. Herschel Peeler

    Herschel Peeler

    401
    65
    Feb 21, 2016
    I use it for inventory and other purposes. To record data in electronics exercises and create a graph of the results. As a design aid, I set up a spreadsheet with component design procedures. I don't think I can post Excel files here but I can post pdf views of the files if you were interested.

    There are other spreadsheet programs out there.
     
    Last edited: May 11, 2016
  6. ElectronicsR

    ElectronicsR

    72
    1
    Mar 23, 2016
    how to get spreadsheet?
     
  7. davenn

    davenn Moderator

    13,765
    1,920
    Sep 5, 2009
    you have been told several choices


    thread closed
     
  8. davenn

    davenn Moderator

    13,765
    1,920
    Sep 5, 2009
    A post from @Gryd3
    that will add ... has lots of info :)

    Looks like you may have a misunderstanding somewhere...
    I realize the thread is now closed, but I'll give you some last minute details here:

    Microsoft Excel = Spreadsheet application that supports in-line formulas and Microsoft's 'VBA' for programming within Excel.
    Excel *requires* payment to use properly, although you can use 'google documents' to make spreadsheets online in your browser here > https://docs.google.com/spreadsheets/u/0/
    Additionally, Microsoft offers a 'Viewer' for free... you can open Excel Documents with this, but you can *not* edit them. This can be found here > https://www.microsoft.com/en-ca/download/details.aspx?id=10

    Libre Office, Open Office, and Gnumeric are all open source spreadsheet applications and support in-line formulas, but do not offer Microsoft's 'VBA'. They can be found with a simple google search.

    For all intensive purposes, 'VBA' is very rarely used and most professionals working with Excel don't even know it exists. It's used to extend the feature set of Excel and can do things like automatically checking a web-site for a value, or auto-creating a folder structure for a job you may be working on. This is an entirely different topic though.

    The Spreadsheet available from all of the above products can be used for anything as basic as making properly spaced labels to some incredibly complex sheets. The complexity could be cosmetic to provide someone with a unique and presentable 'quote' sheet, or it could be complex in that the in-line formulas will do mathematical equations or comparisons to allow you or anyone else to enter various values and have the sheet provide an answer.

    I use both extensively in my current line of work. The simplest ones are a simple form that we print for staff to fill out, or perhaps the sheet that allows the machine operators to find out the optimal speeds for a cutting head when they enter certain details. The most complex is a template that our sales staff can fill out on the computer that auto calculates prices, estimated install dates and copies values to another page that can be presented in a cleaner format to our clients.

    In any case. I will not go into detail about how to use the in-line formulas or Microsoft's VBA. There are dedicated web-sites for each of the above products which will be better suited to assist you.

    Hopefully this gets you going in the right direction. I don't expect a reply, as everything should be covered here and any additional questions should be answered by you downloading one of the open source products or using 'google docs' to experiment. I've told you what I use the tool for... now you need to see what uses *you* have for it.
     
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Thread Status:
Not open for further replies.
Electronics Point Logo
Continue to site
Quote of the day

-