Home > Solved Really > Solved: REALLY Stupid Excel Question

Solved: REALLY Stupid Excel Question

It's there for Word. That's enough hijacking. There is no way they could have gotten it that wrong by accident. I understand that most people have some version of Windows on their computer and that usually implies that they have some version of the Microsoft "productivity" tools. this contact form

Changing the axes requires you to format each individual axis, change the maximum and minimum values (or at least tell it not to auto-scale the axes, in case anything else changes), We have to deal with the real, ugly, complex world, so I guarantee you that biologists are, on average, far more savvy about statistics than you are. Once you get a reasonable template, you can even just give them the two or three lines of code and have them substitute in their values for their own - easy It was originally for the Mac (it had an icon of a box that opened like a jack-in-the-box when you double clicked). https://forums.techguy.org/threads/solved-find-replace-possibly-my-dumbest-excel-question-to-date.545960/

All the defaults complained about above can in fact be changed. Yet Excel has plenty of statistical functions which implies Microsoft knows damn well it is being used for data analysis beyond the financial sector. Page 1 of 2 1 2 Next > Advertisement alcosaint Thread Starter Joined: Feb 2, 2006 Messages: 85 I've taken a copy of each of a set of 5 linked spreadsheets

Make this into a "teachable moment" - talk to your students about what makes for a good graph and why, explain "chartjunk," the uselessness of pie charts, and why not to The horizontal axis labels are just that: labels. alcosaint, Feb 21, 2007 #3 bomb #21 Joined: Jul 1, 2005 Messages: 8,310 alcosaint said: BTW - put your house on Liverpool to knock Barcelona out of CL over the two SEE THE WINNERS LVL 23 Overall: Level 23 Microsoft Excel 23 Microsoft Office 10 Message Active today Accepted Solution by:NBVC NBVC earned 400 total points ID: 400076482014-04-17 Sheet1!$1:$1048576 refers to

Join Now For immediate help use Live now! Similar Threads - Solved FIND REPLACE Find and Replace in Headings in Workbook with Multiple Sheet BratDawg, Feb 14, 2017, in forum: Business Applications Replies: 1 Views: 143 draceplace Feb 14, http://www.omnigroup.com/applications/omnigraphsketcher/ #72 Chris September 25, 2009 ARGHHHH!! http://ask.metafilter.com/35607/Very-likely-the-dumbest-Excel-question-ever-asked Yes, the capability is there, buried in some obscure submenu.

I much prefer MatLab over excel. Which sort of blows the whole idea of uncertainty analysis out of the water, unless you want to make them do least-squares regressions by hand. With the dataset that I have to work with, and for this particular example, the number of minutes is never going to exceed 60. Unfortunately, i don't think it exists anymore. #18 Stefan Krzywicki March 18, 2009 Orac: Excel's graphing is actually pretty good, better than much of what is available out there.

For example, I tried to convert 215 seconds with this formula, and my result was 7:58. I've checked the help index in Excel, looked online on Microsoft's help pages, and through AskMetafilter archives tagged 'Excel' and so far, nothing solves this problem.* I have a large amount So it is absolutely mindboggling to me to see physics students use a Microsoft product out of their own free will. (Also, I would recommend LaTeX for all documents that are Please explain.

I really enjoyed the references to other works. http://bornsunsoft.com/solved-really/solved-really-need-help-please-review-hjt-log.html Sucks like a grandmother on an egg. Sure, I'm sure it's easy in the sense that you can possibly find everything you need in a GUI menu somewhere, but I've found that the extra effort I invested in The plot area changes e.g.

Then give them these instructions so that they can open it and save all of the formatting you have done as their default chart type. #12 Martin Madsen March 18, 2009 Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,900 episodes of his daily video podcast, Learn Excel from MrExcel. And gnu-plot for additional graphing options. navigate here Please check back soon.

edit : omg ! This site is completely free -- paid for by advertisers and donations. two-one Liverpool ! ! !

By the way excel is the most used statistical software in the world and in many engineering companies it is still the most used software by engineers (mechanical, structural, aerospace, etc).

AFAIK I've never done anything to these files to specifically make them "shared" if you mean anything more than them being available on the network......mmmmmm.....on reflection, they started life on a These people have all the packages available but smart people hate black boxes. #81 George Lungu December 25, 2010 excelunusual dot com #82 Tom Buckley July 16, 2011 Give me a a kind of "find all cells with file links including the word 'original' and replace with 'new' " exercise. If you're being redirected from a site you’re trying to visit, seeing constant pop-up ads, unwanted toolbars or strange search results, your computer may be infected with malware.

I find it simply unconscionable to teach students Excel instead of something truly useful, like R or Octave or Mathematica. Helpful Links Meet the Staff Team Our Community Guidelines We Use Cookies Trophies And Levels Open the Quick Navigation Need Malware Removal Help? BTW - put your house on Liverpool to knock Barcelona out of CL over the two legs ! ! ! his comment is here It's free, it's powerful, it can replace SPSS, and it makes beautiful graphs.

Today I was trying to figure out how to do matrix multiplication in Excel and got the message ‘You cannot change part of a matrix'. alcosaint, Feb 21, 2007 #1 Sponsor bomb #21 Joined: Jul 1, 2005 Messages: 8,310 Hi 'saint, long time etc. Yes, this can be solved with a macro, but it's always bugged me that within the universal MSOffice Suite they could put the code in PowerPoint, Word, and Publisher, but not The amount of ignorance out there with respect to graphing and charting is appalling (I was somewhat guilty myself before I discovered Tufte).

Log in or Sign up Tech Support Guy Home Forums > Software & Hardware > Business Applications > Computer problem?

© Copyright 2017 bornsunsoft.com. All rights reserved.