All posts by Jake Moede

99-Spreadsheet modeling, Excel power users, Excel resources

Introducing…. Power Pivot (with Excel)

2 Comments

I think everyone can agree that pivot tables are great excel tools which make analyzing and sorting massive amounts of data a life saver. However, over the course of the past couple years I have been introduced to Power Pivot. Yes, Power Pivot. Pivot tables on steroids. At first, I was pretty intimidated because of the sheer size and complexity on the surface. But after spending some time learning and taking “lunch n’ learn” course at work, Power Pivots and I are becoming friends. My favorite part is being able to run pivot tables essentially off other pivot tables. At work, we’ve also created many tools that allow our leaders to simply and easily run their own reports for specific requests, which saves everyone time. (The analyst teams refresh the data regularly as needed).

I’ve included a couple links below about Power Pivot, and would encourage all to consider using the valuable tool the next time you are looking to crush some colossal data. It’s available as a free add-on for Excel 2010 and now comes standard on Excel 2013.

Happy Pivot Tabling!

 

WJEM

 

https://www.youtube.com/watch?v=URy_uQYS49s

http://info.110consulting.com/blog/bid/374825/Top-10-Benefits-of-Using-Excel-PowerPivot

http://blogs.office.com/2010/10/01/top-5-ways-powerpivot-helps-excel-pros/

04-Managing a project team, feedback, team dynamics

“Always demand what is right, never accept second best.”

1 Comment

A little over three years ago I was watching the evening news. Towards the end the broadcast there was a segment to remember the life of a lifelong television producer, Mr. Jeff Gralnick, who had recently passed away. At the conclusion of Mr. Gralnick’s successful life story, the Anchor mentioned quote from him, “Always demand what is right, never accept second best.”

These words have stuck with me since and have been used as one of my own personal motto’s and guiding principles. They don’t mean that one needs to always have the “best of something,” but to strive for what is the most appropriate in a given situation.

As we continue to progress throughout our careers and develop into leaders, these are great words to operate with each day. I’ve used this philosophy when working with teams to ensure that tasks are not only completed successfully, but carried out in the correct manner, and have seen great results.

http://www.nbcnews.com/video/nightly-news/42981261

What do you think of this quote?

WJEM