I did attempt to update a couple times, but then I got bored or petulant or some other emotion that made me not want to do it. So you missed out on me talking about: knitting; dreams; computer programs. Please ... do not weep.
So, anyway, who's good at Excel and is willing to give me pointers? Apparently I've never had cause to use spreadsheets before. I know, right? So now here we are.
Subscribe to:
Post Comments (Atom)
7 comments:
I made Excel my bitch a long time ago. What do you need to know?
I use excel at work all the time, so I can probably help if needed.
To be honest, I know even know enough to know what I need to know. Like, for instance, why are there millions of rows and columns?
I have no idea what I'm doing. I probably need a good tutorial.
Actually, there are 65,000 rows, I believe (why yes, I have tried to import files larger than that). Anyway, you don't have to use them all. Basically, ignore most of them. Use what you need, and ignore everything else. If you don't know what you need to know, could you give us an idea of what you are trying to use it for?
The rows and columns created a problem when I tried to print a document someone sent me. Is there anything I can do about that?
Anyway: what I primarily need is a list of contacts for different mailing lists. So there would be the names and various info of each contact, and then I would want them separated by groups, and then I also need to separate them between active and non-active. (Let me know if this doesn't make any sense.) And then some way of separating the active and temporarily non-active items from the permanently non-active items.
And also something for income/expense, but I'm not worried about that right now.
OK, these are things I can help with. For the printing, you want to highlight all the cells you want to print (highlight by clicking in one corner cell and dragging until everything you want is highlighted), then go into the file menu and select "set print area". Then it will just print the bits you want.
As for your grouping, there are two ways to do that, depending on whether your groups are mutually exclusive or not. If they are, set up a column for group, and give the group name to each, then set up a separate column where you can type either active, temp inactive, perm inactive. Then select the top row (by just clicking on the 1 next to it, it will select them all), and turn on auto filter. I believe that is in the tools menu, but it might be in one of the others, I'm doing this from memory, as I don't have excel on this computer. Then you can use that to select a group, by clicking on the arrow next to the group column, and active, by clicking the arrow in that column. Then, if you want to print it, you can use the print area I mentioned earlier to exclude those columns.
If contacts can be members of multiple groups, let me know, and I'll explain how to do that. This comment is long enough as it is.
Oh, and if you'd prefer to take this to email, you've got mine, right?
Actually, I don't know if I have a working email for you! But this is fine. The worst that can happen is several months hence someone is Googling Excel help and they anonymously scoff at my stupidity.
But this is very helpful! It gives me a place to start. And, I mean, I have used a computer before, so I would hope I'd be able to tweek anything that needs tweeking once I familiarize myself with the program.
But if I can't I'll totally bug you about it.
Post a Comment