BST USE OF EXCEL

i need to up my excel game
i thought i knew how to use it but it turns out i was fooling myself
need inspiration

paste special is your friend

and it is more special

special friends

is there a shortcut to insert empty row?

i've been doing right click->insert->empty row->CTRL-YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY

just left click and insert

err i guess right click
i get l/r confused

select the row you want to insert the cell above and then click.

hahahaha

srsly there is a little shortcuts menu that pops up if you select and right click. you should not have to have to do any of this other nonsense.

how would that work? right click brings up contextual menu. i'm talking bout keyboard shorcuttys.

a contextual menu is not a shortcut!

a shortcut is something you use to avoid the contextual menu, usually a ctrl something keystroke.

but you can just insert an empty row by selecting "insert" in that menu, it's much quicker than going into the insert menu!

what if i want to insert 20 rows?

Context menus have received some criticism from usability analysts when improperly used, as some applications make certain features only available in context menus, which may confuse even experienced users (especially when the context menus can only be activated in a limited area of the application's client window).

bell labs is an imbecile cutty you are wasting your time

select 20 rows and then hit insert?

highlight 20 rows and then insert

fuck u deez

xpost tom

computers are so dumb at people

there is still the extra step of choosing what to insert

i think this is going to make me lose my mind for a bit ugh
it's that i've got years of ms word tables indoctrination. also i am v tired.

not if you select an entire row. go over to the numbers for the rows and click on the first one, select down to the first one's value + x and then select insert from the right-click menu, voila, you now have x+whatever number of new rows

http://www.danielleaubert.com/print/exceldrawings_book.html

or I mean just x number of new rows. argh whatever

does ANYONE get access though?? i mean seriously whats up with that

rrrobyn what exactly do you need help with?

THANK YOU TOM!

that is what i was saying all along. arhgggggggggggg

I have a gift for being able to solve problems from the users' perspective without getting into semantic arguments vis a vis "shortcuts" and "contextual menus" and other slashdot-hole dev jargon that damages our relationship with our own machines

my favorite was when jaymc couldn't get the killfile to work and I was just like "make sure the monkey in the corner is brown and not gray"

that is what i was saying all along. arhgggggggggggg

no you were confusing left from right

anyway the best use I have made of excel was a 2-axis chart demonstrating the lack of any relationship between overall ping volume fluctuations and tcp/udp scan traffic seen on several chunks of dark IP space over a period of 30 days

also, putting gradients in the plot area of your graphs is as they say "urgent and key"

i have written some killar macros

i have written some millar macros

anybody here ever had to use Goal Seek? I did, for school once

at one point i totally got access but haven't used it in many years

i'm just making a simple table. it is embarrassing. am figuring it out though b/c i think i'm just frustrated b/c brain is still in writing mode not spreadsheet mode.

I haven't used EXCEL since college.

Access is kinda o_O.

Access is basically terrible. I have a coworker that uses it I think but really seriously I can't figure out what it's supposed to do that Excel can't, for our purposes. AutoFilter, bitches!

well I just meant finding for NPV = 0

-are you familiar with microsoft word, excel, & access?
-yes, ive used word & excel quite a bit. not too much access though im afraid.
-yeah, thats fine.

i'm doing i bit better now
(the thing is that i deal with excel files but don't really make my own. times are changing)
i added some colours

let me know if you need help.
despite everyone calling me a moran on this thread, i work with excel way much more than any person should ever have to.

i use excel to make calendars

and graph paper

is filemaker useful for anything other than cataloging my CDs?

you don't use it for any school stuff?

no we have dedicated programs for all of that

ROCKY'S BOOTS SON

most of which are no doubt front-ends for program in question

re: rocky's boots

LOL @ 5th grade

let's talk turtle logo

oh fuck yes start a thredd

is filemaker useful for anything other than cataloging my CDs?

-- moonship journey to baja, Wednesday, November 7, 2007 5:31 PM (55 minutes ago) Bookmark Link

for having people duplicate course databases that should just be on the web in each fucking department

Tom Ogilvy, Chip Pearson OTM

ms outlook, eat my ass.
i really resent that i have to use this.

like what you'd prefer LOTUS GNOTES

all enterprise mail + calendar clients are awful garbage. worst applications ever in the history of computing by millions of miles

can't we just all use gmail?

when do email direct to brane

so many people say that now! if google wasn't being run by a load of overpaid fuckwits they'd make a new hardware appliance that just runs their office apps and sell it to everyone, instead of their lopsided ad-driven "google services for your domain" bunkum aimed at small biz + college

max, when email direct to brane, gun direct to mouth

search on outlook is so slow and stupid.

it just blows my mind how long it takes to open a goddamned e-mail on notes or outlook. I mean fuck it you have to use one, I get to use BOTH. shit planet. that's where we live.

ok here is a question - so how do i start row numbering at 1 a few rows down from the top, where say, the first couple of rows have info in them but want to start numbering at a dif line b/c i want to keep a count of things in a particular 'row section' - i mean can you make row sections?

SHIT PLANET, population all of us

also, do i have to make a macro to sort by column? e.g., if i have a column of last names and want to sort alphabetically? (obv i am used to access and word)

this is all sort of being done in anticipation of me setting up some kind of database perhaps if that might work better - it's like a client and product ordering thing (but not 'product management')

btw i just like saying macro but i don't really know what it means
teach me the ways of the excel nerd for i wish to be one of you

rrrrob - to sort by column, select the data you want to sort - go to "sort" in the data toolbar and select your criteria. you can also mess around with trying autofilter on your column headings.

macros are more for automating on tasks/charts that you will be making over and over again.

oh cool! thanks!
i am going to look into 'macros' but first maybe 'filters'

http://www.powertec.net/cadu/pascoa/excel7.gif

http://bp2.blogger.com/_zD-zh2jtvZU/RzN_WO05eNI/AAAAAAAAAQc/pJkO1a45aI4/s400/evah.gif

ok here is a question - so how do i start row numbering at 1 a few rows down from the top, where say, the first couple of rows have info in them but want to start numbering at a dif line b/c i want to keep a count of things in a particular 'row section' - i mean can you make row sections?

if I am understanding you correctly, what you can do is type the number "1" in a blank cell next to the top cell of the row section you want to number. Hover your mouse over the bottom left corner of the cell, and when your cursor turns into a +, click and drag the mouse downwards, and it will automatically fill in numbers.

when you have to use outlook remotely through a browser, is it even possible to use the search emails function? i can never find it, this sucks.

wtf is up with the formatting on MS word? i copy and paste something and it goes all wacky, half in bold, have in size 16 RED letters, fonts all over the place, when neither the destination or source formats had any of that shit???!

(sorry this is like the 1 project i have to use word on a year and it drives me insane....)

andd dont get me started on the tabs/margins

seriously. is this intuitive for ANYONE?

bell, my weak solution is to have a notepad file open at all times to paste into, recopy and drop into whatever doc so fonts/sizes match what i'm working on. shit always goes haywire if you copy/paste HTML. other progs too.

all enterprise mail + calendar clients are awful garbage. worst applications ever in the history of computing by millions of miles

-- El Tomboto, Thursday, November 8, 2007 6:37 PM (1 week ago)

groupwise is not THAT bad

for an organization of <200 people, that is

wtf is up with the formatting on MS word? i copy and paste something and it goes all wacky, half in bold, have in size 16 RED letters, fonts all over the place, when neither the destination or source formats had any of that shit???!

so use the format painter. no big whoop.

the format what now? i ended up emailing this to myself so i can format it over the weekend while watching endless law & order episodes

don't you guys use the "paste plaintext" option?

format painter.

OK I WILL TRY THIS THanks to u

i'm sure i could use a plaintext option but i mostly just ctrl-c and v when there is tons of stuff so that sounds like an extra step?

My HS tech teacher (AWESOME MAN) made an xls w/eqns et al to make sure none of the theater techies working on the plays wld have overlapping RF frequencies on the walkie-talkie thinglike thing system. Was für ein Badass!

I ran into him in downtown Boise (he lived in my hometown 400 miles away) when shrooming,,,,,whoa boy that was awesome & confusing. He was always photocopying me puzzles from old issues of Omni. Eventually I started dating his son and I hung out w/his dad (tech teacher) and his brothers probably more than said BF who was always jamming Led Zep on his guitar downstairs. (*barfs*) His dad and I would have timed Jumble contests, play Myst together helping each other solve the puzzles, work on maths word problems, He taught me how to use SoundEdit 16 and we'd geek out on paper & printing presses together, read PC Week (IIRC that is its name) together, and just geex out. God that was a brilliant and upstanding man. We played frisbee golf together....

BUT DID YOU BANG?

http://www.spoon-tamago.com/2013/05/28/tatsuo-horiuchi-excel-spreadsheet-artist/

We have a winner ^ how does he do it?

I don't know. I actually tried downloading one of the files to see how he did it and still couldn't tell.

Aw, he's using AutoShapes. That's cheating! I was hoping it was built from a grid of really tiny cells.

(In 2003, Insert -> Picture -> Autoshapes. In 2007, I think it's Insert -> Shapes. They're a massive pain in the ass to work with so it's still something of a feat but you can position them wherever you like and if you double-click on them you get gradient shading and transparency and stuff so they're pretty full-featured for something probably nobody ever uses.

Or you can rightclick on his picture in Excel and choose "Ungroup" and see some of the shapes he's used but he's got groups of groups of groups of... down to like 8 levels deep and holy hell if you ungroup them all with a macro there are nearly 12,000 shapes in total. That must have taken a long time. My laptop is crying just redrawing them all.)