Subscribe
Excel Training
January 8, 2007 4:23 pm
Juice Analytics’ Excel training worksheet is available for download. It covers their previously identified core Excel skills.
I thought I was pretty good with Excel, but a lot of this stuff is new to me. I’m a bad Excel guru. (Nobody tell Damion; he still sends me a lot of Excel questions.) Excel skills are very important for design. That, and data entry. (Tip for would-be designers: go work some shitty temp data entry jobs, and I’ll like you better. It not only improves your implementation skills — faster work, fewer errors — but it exposes you to a lot of bad UIs. Temp data entry jobs are a great way to learn usability.)
The Excel books on my shelf that I’ve read and love:
- Statistical Analysis with Excel for Dummies. No, really! This is a great book. You can read statistics books, which are full of hard math and don’t tell you how to actually implement anything, or you can read Excel books, which tell you how to implement everything but not why you’d want to. This book does both, and it skips the hard math parts.
The Excel books on my shelf that I haven’t read, but think I’ll love:
- Excel Best Practices for Business. It’s about building spreadsheets for usability and efficiency.
- Pivot Table Data Crunching. I just started using pivot tables recently. They’re stupidly powerful and stupidly hard to use. I’m hoping this book will tell me how to build pivot tables that the rest of my team can use.
Darius K. wrote:
Pivot tables are a person-with-three-columns-of-data’s best friend. My favorite pivot table at the moment is class vs. class average damage per second, which is even more powerful when you band it into level ranges.
Posted on 09-Jan-07 at 7:18 am | Permalink
Sara wrote:
Do you give the pivot tables to your end users, or do you just summarize your findings for them?
I’d like to mail my pivot tables out, but they’re just not intuitive.
Posted on 09-Jan-07 at 4:47 pm | Permalink
Darius K. wrote:
I give the pivot tables to the end users. In this case they’re designers. They love that stuff. If your end-users are not designers, well, maybe that won’t work so well.
Posted on 09-Jan-07 at 4:53 pm | Permalink
Adderall without prescription. wrote:
Buy cheap adderall online….
Average adult dose of adderall xr. Buy adderall without a prescription. Adderall xr. Adult adhd adderall. Adderall. Adderall and weight loss….
Posted on 08-Mar-08 at 11:35 am | Permalink
Buy phentermine. wrote:
Adipex phentermine vs….
Cheap phentermine. Phentermine. Order phentermine online. Phentermine side effects. Phentermine no prescription….
Posted on 22-Mar-08 at 7:37 am | Permalink
Cheap viagra. wrote:
Viagra….
Viagra. Cheapest viagra. Re viagra cello….
Posted on 22-Mar-08 at 9:06 am | Permalink
Lexapro. wrote:
What is lexapro….
Best time to take lexapro. Lexapro….
Posted on 22-Mar-08 at 9:19 am | Permalink