Excel – Pivot Table 2

Using pivot tables in Excel is relatively easy and can give you a much better look at your data. In this tutorial I demonstrate how to clean a spreadsheet, how to add a column of data using an if/then formula and then how to build the pivot table showing three different views of the same column of information, each providing a different perspective on the information.  This is all arranged in an easy to read format which can be printed and shared with colleagues.

Hope you enjoy.  Please leave a “like” or a comment.

Excellence in All Things

The pendulum swing for all our actions ranges from no effort to a perfectionistic ideal which is impossible to achieve.  The medium point of the pendulum swing is “good enough.” Jim Collins wrote in his book “Good to Great” that “good is the enemy of great.” His point is that when we achieve good, most think that is “good enough.” I want to suggest there is a place beyond good that I’ve called Excellent.

For more on this check out the short video below:

5 Ways Smart People Sabotage Their Success

First of all, if you are smart, you probably won’t even read this far, and if you do you almost certainly won’t click on the link to read the full article. THAT WOULD BE A MISTAKE!!! The smarter you are the more you should take the time to read this article . . . and PAY ATTENTION.

This comes from the Harvard Business Review, originally posted Nov. 15, 2018.

Mark was always one of the smartest kids in his class. He’s done well in his career, but when he checks Facebook, he sees people he outperformed at school who have now achieved more. Likewise, there are colleagues at his firm who have leapfrogged him. Sometimes he wonders, “What am I doing wrong?”

READ THE REST OF THE ARTICLE

Social Media

If you do not have and use a social media outlet, such as Twitter or LinkedIn, for personal and professional purposes you are missing a huge opportunity to share your experience and knowledge as well as draw upon the experience and knowledge of others. Having such an outlet and using it increases your credibility and benefits a larger audience. Benefiting the larger audience is a key part of social media.

For more on this check out the short video below:

Images for Presentations

Inserting images into your presentations for class can definitely take your presentation up a notch. In fact, there are many who say that using images instead of words has a better effect on retention and communication. I suppose part of that is because if you are showing words on the screen and also trying to talk the audience is trying to read the words and listen at the same time, which lessens the impact of both.

I do use some bullets in my presentations with a minimum number of words – always keeping the font at 28pts or larger, or even a quote from time to time. For the past few years, I have attempted to use images instead of text.  But, the big question then becomes where do you find copyright and royalty free images that are unique AND communicate the text they are replacing.

I have two sources for you. The first is described in the article at this LINK. It is a new site with access to over 300 million images.  The second is Pixabay.  I’ve not had a chance to try the Creative Commons site yet, but I do love the images from Pixabay. Check these sites out if you want to add some punch to your next presentation.

Excel Tip – Pivot Table 1

Pivot tables are among the most powerful features in Excel. For years I shied away from them because I thought they must be too difficult for me to grasp and too complicated to build – WRONG! Pivot Tables are relatively easy to build and the information provided can literally save you hours and hours of work.  It is definitely a win-win situation. I hope you will watch this short video (about 6 minutes) and then think about how you can experiment with Pivot Tables yourself.

Leaders Purposely Influence

John Maxwell defines Leadership with one word: Influence. What I know is that influence is the currency of achievement. The more influence you have, the greater your ability to achieve your goals, personal or professional. The reality is that unless you live on an uninhabited island, you are influencing others. Check out the short video below for more on this:

 

Excel Tip – Chart from Filter

I always love learning new tips in Excel that can help me communicate data in a way that contributes to better decision making. Just having a lot of data is relatively useless unless you can present in such a way that it makes sense.

In this tutorial, I have used the filter and sort procedures I shared in other tips as a foundation for charting my data.  Hope you enjoy.

Add Value to Everything You Do

The uppermost thought in your mind as you approach any task, position, or responsibility should be “How can I add value.”  This applies to every part of your life. You should always be asking yourself, “How can you take my skills, experience, education, resources and add value to the lines of others.”  Check out the short video below for more on this:

Personal Reflection

Benjamin Franklin said, “It takes many good deeds to build a good reputation, and only one bad one to lose it.” Proverbs 22:1 states, “Choose a good reputation over great riches; being held in high esteem is better than silver or gold.” Be aware of your personal reputation with the various areas of your life. Check out this short video for more on this: