EPTHelp greatly appreciated! ^^
I don't want to work at the restaurant anymore, it's too tiring and pay isn't as satisfying for the amount of work done.
Learning Excel
| Blogs > Amnesia |
|
Amnesia
United States3818 Posts
Help greatly appreciated! ^^ I don't want to work at the restaurant anymore, it's too tiring and pay isn't as satisfying for the amount of work done. | ||
|
Sadistx
Zimbabwe5568 Posts
"Learning" excel is almost impossible, since there's so many things you can do with it, macros, statistical analysis. It all depends on what you currently need doing. | ||
|
Amnesia
United States3818 Posts
| ||
Carnivorous Sheep
Baa?21242 Posts
| ||
Empyrean
16935 Posts
On July 09 2010 12:18 Sadistx wrote: Honestly you can figure out 99% of what you need to do in Excel as you go by googling. "Learning" excel is almost impossible, since there's so many things you can do with it, macros, statistical analysis. It all depends on what you currently need doing. Please never do statistical analysis with excel T_T | ||
|
Cauld
United States350 Posts
| ||
Chill
Calgary25951 Posts
1. "I wonder how I can do this" 2. Google "excel how to ______" 3. If that doesn't work, try typing what I think the function will be called into Excel help. 4. If that doesn't work, I ask people on IRC and TL PM (seriously, I've done this about 5 times now) I haven't found any problem that wasn't solved that way. | ||
|
Servius_Fulvius
United States947 Posts
| ||
|
geometryb
United States1249 Posts
| ||
|
YejinYejin
United States1053 Posts
Click and drag. If you start getting lost, highlight your workers over and over again to boost APM? :D Oh, and if you understand the autofill function with click and drag, learn to use the pound sign in your formula. It really helps with keeping certain things constant as you autofill, and allowing others to change. But, as stated before, do not use Excel for statistical analylsis. >< | ||
|
Cauld
United States350 Posts
| ||
|
jgad
Canada899 Posts
Think of Excel like a huge garage filled with toolboxes. You don't really walk in and say : "What's the best way to learn how to use this garage?" It's a huge garage with hundreds of tools. The proper way to approach it is to start with a problem - an engine that needs fixing or a car that needs an oil filter changed. Start with simpler tasks, of course, and get to know the surroundings first, but always, always start with a real world problem first. Get a sheet full of data and have a plan of what you want done with it - then start learning how to do it. In this way you grow your skills as you tackle more and more complex problems, gaining experience with a wider and wider range of Excel's tools. Imagine walking into that garage without any particular piece of equipment to work on - no plan, no problem. How do you even start? Your only option is to start picking up tools at random and trying to figure out what they do...not exactly the best solution. So, yeah, in short, get your boss to give you some data to play with and a short list of the types of work he typically needs doing. Then you can go through it and see - ah, I need to start by doing "this". You'll also be able to get much more help from others this way as well - you can post a specific question that has a specific answer : "ok, so I'm trying to do X with this data and I'd like suggestions on the best way to go about doing it" WAY more likely to get a productive and helpful answer because it's a solvable problem. Anyway, best of luck - Excel's not that difficult. Count yourself blessed that you'll be learning from the clusterfuck Ribbon version and not having to slash your wrists every afternoon, cursing Microsoft daily for the trainwreck they made of your productivity. Office 2007 -> Microsoft sneaks into the garage at night, dumps out all the tools, and gets a team of deranged orangutans to "reorganize" them for you. You walk in the next day, take one look around, and FUUUUUUUUUUKKKKK!! Proceed to get nothing done for the next 18 months while you figure out wtf happened to your slick and streamlined workspace. 0_o | ||
|
GreEny K
Germany7312 Posts
| ||
|
Kletus
Canada580 Posts
| ||
|
ForSC2
United States580 Posts
| ||
|
xalo
Peru80 Posts
Think of Excel like a huge garage filled with toolboxes. So true Office 2007 -> Microsoft sneaks into the garage at night, dumps out all the tools, and gets a team of deranged orangutans to "reorganize" them for you. You walk in the next day, take one look around, and FUUUUUUUUUUKKKKK!! Proceed to get nothing done for the next 18 months while you figure out wtf happened to your slick and streamlined workspace. 0_o I find 2007 more comfortable than 2003, and the graphs are prettier :$ things you might be using in an office environment: Pivot tables VLOOKUP HLOOKUP CONCATENATE ISERROR IF NPV (finances) SUMIF COUNTIF etc. ohh and Macros, you can do pretty things with them | ||
|
jgad
Canada899 Posts
On July 09 2010 13:52 xalo wrote: So true I find 2007 more comfortable than 2003, and the graphs are prettier :$ It takes like ten times as much clicking get shit done in 2007 and there's almost no way to customize the interface like you could before. Mind you, I'm one of the dinosaurs who had like a decade of honed skills in office pre-'07. The change is far more of a kick in the balls when you've got that much invested in it. | ||
| ||
