# Any one good with excel? **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [March 14, 2008, 8:28am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014 "2008-03-14T08:28:50Z")\ **Posts on this page:** 18\ **Page:** 2
**Author:** ![ultradriver10000](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ultradriver10000/32/7397_2.png) [@ultradriver10000](https://forums.speedlife.net/u/ultradriver10000)\ **Post date:** [March 14, 2008, 10:23am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/21 "2008-03-14T10:23:41Z")
Its pretty easy if you stack your data vertically. They you can call out that row of data in any formula you want. You can also then drag that formula down to get a set of answers with different inputs… That being said look for help online and try playing with it for a while. Its a pretty useful tool. ---
**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\ **Post date:** [March 14, 2008, 10:23am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/22 "2008-03-14T10:23:41Z")
if sucks… you can only nest it like 8 times ---
**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\ **Post date:** [March 14, 2008, 10:24am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/23 "2008-03-14T10:24:07Z")
> [@ultradriver10000](#): > > Its pretty easy if you stack your data vertically. They you can call out that row of data in any formula you want. You can also then drag that formula down to get a set of answers with different inputs… > > That being said look for help online and try playing with it for a while. Its a pretty useful tool. it doesnt matter what way you stack it… as long as its consistent ---
**Author:** ![Treads4Heads](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/treads4heads/32/7416_2.png) [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)\ **Post date:** [March 14, 2008, 10:25am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/24 "2008-03-14T10:25:58Z")
lol if I had the time to play I would, but its due in 4hours. I thought it was going to be simple “add data, make graph, ???, profit” but this shit is nuts ---
**Author:** ![BuickGN](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/buickgn/32/7200_2.png) [@BuickGN](https://forums.speedlife.net/u/BuickGN)\ **Post date:** [March 14, 2008, 10:26am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/25 "2008-03-14T10:26:06Z")
little button on the top right called help, use it, it works well and is there for a reason. ---
**Author:** ![The\_Russian](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/the_russian/32/7414_2.png) [@The\_Russian](https://forums.speedlife.net/u/The_Russian)\ **Post date:** [March 14, 2008, 10:49am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/26 "2008-03-14T10:49:27Z")
I hate exel with a huge passion. ---
**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\ **Post date:** [March 14, 2008, 11:17am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/27 "2008-03-14T11:17:23Z")
why excell is so fucking easy ---
**Author:** ![ineedacar](https://avatars.discourse-cdn.com/v4/letter/i/48db29/32.png) [@ineedacar](https://forums.speedlife.net/u/ineedacar)\ **Post date:** [March 14, 2008, 11:22am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/28 "2008-03-14T11:22:17Z")
> [@ILCisDEAD](#): > > why excell is so fucking easy :word: i taught myself how to use it when i was like 14 lol i can see how its confusing tho if you’ve never opened the program. ---
**Author:** ![Mrs\_Karus](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/mrs_karus/32/7426_2.png) [@Mrs\_Karus](https://forums.speedlife.net/u/Mrs_Karus)\ **Post date:** [March 14, 2008, 11:43am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/29 "2008-03-14T11:43:29Z")
> [@ineedacar](#): > > :word: i taught myself how to use it when i was like 14 lol > > i can see how its confusing tho if you’ve never opened the program. I luckily have never had to use it during school, work whatever. I do have “excel for dummies” on hand though. 😃 ---
**Author:** ![Treads4Heads](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/treads4heads/32/7416_2.png) [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)\ **Post date:** [March 14, 2008, 12:14pm UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/30 "2008-03-14T12:14:42Z")
How can I do averages? ---
**Author:** ![Nikuk](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/nikuk/32/7254_2.png) [@Nikuk](https://forums.speedlife.net/u/Nikuk)\ **Post date:** [March 14, 2008, 12:15pm UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/31 "2008-03-14T12:15:29Z")
=average(a1:a296;c3:c8) etc ---
**Author:** ![Treads4Heads](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/treads4heads/32/7416_2.png) [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)\ **Post date:** [March 14, 2008, 12:16pm UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/32 "2008-03-14T12:16:12Z")
nvm, forgot I needed to add the = ---
**Author:** ![TgDn32](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/tgdn32/32/7360_2.png) [@TgDn32](https://forums.speedlife.net/u/TgDn32)\ **Post date:** [March 14, 2008, 4:12pm UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/33 "2008-03-14T16:12:31Z")
> [@Treads4Heads](#): > > nvm, forgot I needed to add the = No wonder you haven’t been on TF2… I could’ve had this done for you by now, then more time for BOOSH pyro pwnage. ---
**Author:** ![RedGoober4Life](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/redgoober4life/32/7610_2.png) [@RedGoober4Life](https://forums.speedlife.net/u/RedGoober4Life)\ **Post date:** [March 14, 2008, 8:09pm UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/34 "2008-03-14T20:09:25Z")
> [@BigRon](#): > > chicks dig guys with sweet excel skillz. > > -Wait for the fun with v or h lookups, if statements and all the other fun stuff eff that shit. if i’m going to use those I might as well open Matlab. ---
**Author:** ![redrum](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/redrum/32/7398_2.png) [@redrum](https://forums.speedlife.net/u/redrum)\ **Post date:** [March 15, 2008, 6:42am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/35 "2008-03-15T06:42:12Z")
I do excel programming as part of my job, I think its a lot of fun. Turn on the ipod and just go, the day will fly by. IMO anyone doing anything remotely related to business for a career should at minimum have a decent working knowledge of excel. ---
**Author:** ![tpgsr](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/tpgsr/32/7374_2.png) [@tpgsr](https://forums.speedlife.net/u/tpgsr)\ **Post date:** [March 15, 2008, 7:39am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/36 "2008-03-15T07:39:37Z")
Seriously excel is a must in business. The funny thing we have an executive assistant that does all of the formulas and such for all of our projects, I am really bad with that part… but if you tell me that you need a VBA application to make excel do an irish jig i can make it happen! I really don’t get how i have to look up simple tasks, but when it comes to the most complicated workbooks, I can have them done in about an hour (well I have had a project take a week, but that one is a fully customizable file based on the user that logs in and is somewhere around 4 mb. [mrexcel.com](http://mrexcel.com) is a good help, as is Pearson consulting’s free articles when you are stuck. ---
**Author:** ![Treads4Heads](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/treads4heads/32/7416_2.png) [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)\ **Post date:** [April 11, 2008, 9:33am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/37 "2008-04-11T09:33:52Z")
BUMPPPPPP I need help again I have a series of equations that I need build off each other and the answer of that set goes into the same set of equations, but in a different row. I know if you drag the box down, it will compute the same function but is there a way I can tell excel to take answer from box A, put it in box B, and use box B for the rest of the equations? ---
**Author:** ![Treads4Heads](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/treads4heads/32/7416_2.png) [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)\ **Post date:** [April 11, 2008, 9:40am UTC](https://forums.speedlife.net/t/any-one-good-with-excel/45014/38 "2008-04-11T09:40:02Z")
this will probably be easier if I just show what I need, we are given the first variable (0.1) sqrt(0.1 x 1.8x10^-5) -log(sqrt(0.1 x 1.8x10^-5)) = 14–log(sqrt(0.1 x 1.8x10^-5)) now, for the next number, I need to use sqrt(0.1 x 1.8x10^-5) and so on. How do I do this? [Previous page](https://forums.speedlife.net/t/any-one-good-with-excel/45014.md?page=1)