A focus on improvement- in self, in business, in life
February 2, 2011 Leave a comment
Okay, now that we have come up with a slick way to quickly create some sample data to work with, we can finally get to the heart of the matter. Pivot Tables! Once you learn this and begin to play with it a little, you’ll be amazed at how much it can help you with analyzing data very, very quickly. You’ll also finally feel good about putting “Proficient in Excel” or “knowledge of Pivot Tables” on your resume. LOL.
February 1, 2011 4 Comments
I’ve been asked by many of you to put together something on Pivot Tables. In doing so, I found the hardest part was compiling sample data that allowed me to highlight some of the cool features that Pivot Tables have to offer. After searching the web for sample data to use and coming up empty, I decided to go the long route and just start typing. But as luck would have it, I stumbled upon a slick way or two to generate some useful data. Attached is that discovery in two parts. This is my first attempt at a video blog, so please provide any feedback, good or bad.
Part I
January 30, 2011 2 Comments
We have three or four months before spring is here. 90 to 120 days to shed those extra pounds before we’re forced to wear shorts and tee shirts or be uncomfortably hot. It’s also one of the last chances I’ll have to train outdoors with my shirt off without embarrassing my children— or myself— but I’ll leave that for another day’s post.
The good news is that it was about this time last year that I read two books that helped me look as good as I had probably since my college football playing days: The All Pro Diet by Tony Gonzalez, future Hall of Fame Tight End currently of the Atlanta Falcons; and The Abs Diet by Men’s Health Editor-in-Chief David ZincZenko. Read more of this post
January 28, 2011 1 Comment
Excel’s SUMIF() Formula is a great tool. It allows you to sum a column based on specific criteria (from another column). But what if you want information filtered based on two (or more) criteria?
Enter SUMPRODUCT(). Read more of this post
BobbyBluford.com 