Context Specific Shortcut Reminder for MS Office (or any other program)

Much of my work day is spent in Excel and Powerpoint. I’m employed by a marketing consulting firm and part of my job is turning CPG data into clear, persuasive insights to guide clients and help them persuade their customers. To speed up the tedious parts of this task I have turned to AutoHotKey scripting and learning more keyboard shortcuts.

Remembering simple shortcuts is easy, but there are many out there that I’ve never used, or have forgotten. So I created a script that can remind me of the shortcuts available in any active program. If I’m in Excel, it will remind me of  Excel shortcuts. If I’m in Powerpoint, it will remind me of Powerpoint shortcuts. You get the idea.

Here’s video of it in action:

Let me know if you like the idea or have other ideas or improvements. If you want a copy, I’d be happy to send you one. This concept can be adapted for just about any program.

Leave a Comment

Filed under Uncategorized

What is Social Media?

A followup to my “What is Marketing?” video, this has been up on YouTube for a bit but I’ve neglected to post it here. This is a very quick (<2minute) introduction to what social media is, at its most core/basic.

Leave a Comment

Filed under Uncategorized

What is Marketing? – a succinct and insightful orientation to marketing and branding

I’ve been meaning to create videos on Marketing basics for a while now. My marketing workshop experiences have proved the importance of communicating the basics again, and I noticed a LOT of people are out there searching for “What is Marketing” and “What is SEO” etc. The video is 2 minutes long, covering marketing, customer lifetime value, and branding. Even if you are an expert, you’ll probably still learn something (or at least, enjoy the refresh).

Stay tuned for my next video, which will be on Social Media, I promise you that you won’t want to miss it.

2 Comments

Filed under B2B Marketing, Business, Marketing

How to measure anything – book review and summary

I recently finished How to Measure Anything: finding the value of intanglible in business. It’s a great book, I highly recommend it. Especially if you have a engineering/science background and find yourself in management.

Hubbard claims that there are no intangibles that you can’t measure. Central to this claim is his definition of measurement as “uncertainty reduction.” This means that the point of measuring is not to find THE answer, but to reduce our uncertainty about what the answer is. He suggests starting with the estimate of” calibrated” experts who can consistently estimate within a 90% confidence interval. From this initial range you calculate the value of more information. I.e. how much is it worth to further reduce your uncertainty. If the benefit of more measurement is worth the cost you should perform that measurement. He then provides some helpful measurement techniques.

The most helpful part of the book, at least for me, was his definition of measurement and his value of information calculations. Defining measurement as uncertainty reduction helped to break me out of an engineering mode of measurement. In engineering you can usually measure very accurately. In either case you then use “the answer” in the rest of your calculations. The problem with this is assuming that a measurement can or needs to give you “the answer” to be helpful. It doesn’t keep in mind what the measurement is for in most cases.

His calculations of information is a great way to examine current or potential measurements and ask if it’s worthwhile. I’m certain that many businesses are wasting lots  of money measuring things that are easy to measure with high certainty, but are mostly worthless in terms of information value. It would be much more valuable to gather a few important metrics, even if there is a big range at a 90% confidence interval.

The basic approach is:

  1. Build a model of the problem. If you don’t understand how a variable affects the outcome, you won’t know what’s important and what you need to measure to what precision.
  2. Gather what you already know about the problem. Use current estimates and “calibrated experts”
  3. Calculate the value of gathering more information. You may already have enough information to come to your conclusion or make your decision. If not, you need to figure out if more information is worth the cost.
  4. Take measurements of the high value variables.
  5. Make your decision

My notes from the book:

Section 1 – No “intangible” is unmeasurable.

Chapter 1 - Hubbard suggests going through the book with some tough measurement problem in mind, you’ll find a way to measure it.

Also, he states there are three important propositions that define an approach to measurement in business:

  1. Measurements inform uncertain decisions
  2. There are many things to measure and many ways. Perfect certainty is rarely a realistic option.
  3. Therefore management needs ways to reduce uncertainly about decisions.

Chapter 2 – Hubbard provides examples and strategies for  measurement: Fermi decompositions (like what MBAs use for case questions). He states, “The concept of measurement as ‘uncertainty reduction’ and not necessarily the elimination of uncertainty is a central theme of this book.”

Chapter 3 – People don’t think some things are measurable because they have misconceptions about three aspects of measurement:

  • Concept of measurement (they      have an incorrect definition of measurement)
  • Object of measurement (they      are not clear on what they need to measure)
  • Methods of measurement (they      don’t have enough ways to measure)

Def of measurement: a quantitatively expressed reduction if uncertainty based on one or more observations.

Even a small reduction in uncertainty can be worth millions.

Clarification Chain:

  1. If it matters at all, it is detectable/observable
  2. If it is detectible, it can be detected as an amount (or range of possible amounts)
  3. If it can be detected as a range of possible amounts, it can be measured.

Helpful way to think of what you need to measure: thought experiments. Ask “What if?” what you wanted to measure was happening in one group and not in another, what would be different?

It’s very important to know why you want to measure something and what decision will it effect.

“If you don’t know what to measure, measure anyway. You’ll learn what to measure.” – David Moore

Four useful measurement assumptions:

  1. Your problem is not as unique as you think
  1. You have more data than you think
  1. You need less data than you think
  1. An adequate amount of new data is more accessible than you think.

Rule of five: there is a 93.75% chance that the median of a population is between the smallest and largest  values in a random sample of five from that population.

His five step process for measuring

  1. Define a decision problem and the relevant uncertainties
  2. Determine what you know now
  3. Compute the value of additional information
  4. Apply the relevant measurement instrument(s) to high-value measurements
  5. Make a decision and act on it

Section 2 – Before you measure

Chapter 4 – Clarify the measurement problem. What decision are you supporting? What will more information do for you? how will it change your decisions?

You need to understand the difference between uncertainty and risk. Uncertainty is simply the lack of certainty. You do not know the “true” outcome/state. The measurement of uncertainty is a set of probabilities assigned to a set of possibilities, e.g. there is a %50 chance of X, %30 chance of Y, and 20% chance of Z occurring. Risk is just a state of uncertainty where one or more of the possible outcome is negative.

Chapter 5 – Calibrating experts

You need to have a good grasp of probabilities and calibrate your intuitive understanding if a 90% confidence interval (add Wikipedia link).

It is possible to “calibrate” people so they are capable of repeatedly making guesses in a 90% CI (confidence interval). Calibration requires several exercises the most important if which is the equivalent bet exercise where you pretend to your 90% CI estimate is a bet versus an actual true 90% probability. If you are indifferent, then you are at a 90% confidence interval.

Chapter 6 – measuring risk through modeling

Monte Carlo simulations.

Chapter 7 – Measuring the value of information

Expected Value of information (EVI) = Reduction in expected opportunity loss (EOL)
EVI = EOLbefore info – EOLafter info

EOL = Change of making a sub-optimal decision x Cost of making a sub-optimal decision.

Expected Value of Perfect Information (EVPI) = EOLbefore info

(EOL after is zero if information is perfect, you’d make the perfectly optimal decision)

A common measurement myth: When you have a lot of uncertainty, you need a lot of data to tell you something useful. Actually, if you have a lot of uncertainty now, you don’t need much data to reduce uncertainty significantly. When you have a lot of certainty already, then you need a lot of data to reduce uncertainty significantly.

Section 3 – Measurement methods

Decompose the problem into its parts.

Perform secondary research

Use basic methods of observation:

  1. Does it leave a trail of any      kind?
  1. If the trail doesn’t already      exist, can you observe it directly or at least a sample of it?
  2. If it doesn’t appear to leave      behind a detectible trail can you devise a way to begin tracking it?
  3. If tracking the existing      conditions doesn’t suffice, can the phenomenon be “forced” to      occur under conditions that allow for easier observation? (i.e. an      experiment)

Measure Just enough

Consider the Error

He then goes into more detailed statistical techniques

1 Comment

Filed under Business

Taking the future of education for a spin


USC’s Bovard Administration Building by greatdegree on Flickr

The form of education will change significantly in the next ten years. Fundamentally, the formula creating this change is 1. Record the best teachers explaining very important content and concepts, 2. Use the internet to distribute this content (video, slides, and lecture notes) usually giving it away. There are several organizations that are working on different forms of this formula:

  • Coursera is currently offering some very interesting classes by professors at Stanford, University of Michigan, and Berkley. They are all for free, and some sort of certification will be offered.
  • MITx is offering a number of MIT classes for free. They are working on a certificate program as well (it will not be issued using MIT’s name)
  • Khan Academy offers free straightforward lessons on a wide variety of topics/concepts. They recently received funding from Bill Gates. No certification is currently offered, it’s focus is on tutoring.

I have been watching some of these new ideas about education as they have been developing, always thinking about how they could be applied to training, enrichment, and motivation in the workplace. These ideas and initiatives (and ones we haven’t even heard about yet) will be transforming education inside and outside of the workplace. Anyone with a computer and the internet (which is just about everyone) will have access to the very best educational content.

What this will mean for businesses, I’m not entirely sure. It does mean there’s no excuse for a poor training programs. With simple training tracking software (common in HR departments these days) and a facilitator to manage curriculum, any business could have its own internal “university”. If someone wants to change job function or move up, they could show their commitment and ability by working towards a “degree” which would be issued by the company.  They would take free courses from USC, Stanford, MIT, Harvard, and others according to the specified curriculum. Internal, company specific, courses and any applicable third-party certifications for specific skills could be included as well. The cost for such a program would be extremely low and the cost will continue to drop.

When Courersa recently launched their first set of classes I decided to jump on board and try it out for myself. I’ve signed up for a class called “Model Thinking” which is taught by Scott Page from the University or Michigan. I’m looking forward to seeing how this all works and if it is valuable. There are a couple others (Design and Analysis of Algorithms and Probabilistic Graphical Models) that I may try out as well.

Once I dig into the content I’ll write about the experience. We’ll see if this really is the future of education and what the implications are for businesses.

Leave a Comment

Filed under Business, Knowledge Work Productivity, Technology

Management tools – Gallup’s Q12 Engagement Survey

Managing and leading can be difficult. It’s well documented that as you move up a hierarchy the harder it is to get honest feedback on your ideas and on the organization’s health. In these positions quantitative measures of engagement can be a helpful tool for understanding the health of your organization and for asking the right questions of your employees.

“Engagement” sounds like squishy business jargon. But there are many tested measurement tools and there is a well documented relationship between high engagement levels among employees and superior organizational performance. Some instruments, like the Utrecht Work Engagement Scale, are used in academia and others are developed by management consultants (Gallup, Towers Perrin, Blessing White, Hewitt, and Kenexa all have their own flavors). Gallup’s Q12 instrument is one of the best known examples.

Generally these instruments consist of a simple survey. The results are tallied and each employee is graded as (generally) “Engaged” “Neutral” or “Actively disengaged.” A survey is helpful if you want to perform a check-up of the whole organization or a large department. But there’s a lot of value in simply using the questions as a framework while communicating and thinking about employees. They can be a teacher, helping you understand what is important to your employees and to keeping them engaged.

See for yourself, read through the list of questions that make up the Gallup Q12 . As you read, think about the people you manage and how they would answer each statement.

The Q12 statements follow.  For each statement there are six response options (from 5=strongly agree to 1=strongly disagree; the sixth response option — don’t know/does not apply — is unscored).

  1. I know what is expected of me at work.
  2. I have the materials and equipment I need to do my work right.
  3. At work, I have the opportunity to do what I do best every day.
  4. In the last seven days, I have received recognition or praise for doing good work.
  5. My supervisor, or someone at work, seems to care about me as a person.
  6. There is someone at work who encourages my development.
  7. At work, my opinions seem to count.
  8. The mission or purpose of my company makes me feel my job is important.
  9. My associates or fellow employees are committed to doing quality work.
  10. I have a best friend at work.
  11. In the last six months, someone at work has talked to me about my progress.
  12. This last year, I have had opportunities at work to learn and grow.

These are straight forward. If you know your people at all, you probably know how they would answer them. And if they wouldn’t rate themselves as highly engaged, it’s pretty clear how you could fix this. If, on average, your people rate “Agree” to “Strongly Agree” then you have engaged people, you’re doing a great job.

Generally I wouldn’t advocate “teaching to the test” because of the temptation to game the measurement. But in this case Gallup seems to have done a good job covering most of the basic needs of employees in these simple questions. The only exception I see is pay equity. The measurement assumes that employees feel they are being paid fairly.

As you manage and lead in your organization the Q12 is a useful tool to help to keep the feedback flowing. Use it to check your assumptions about employee engagement and make sure you haven’t been blinded by your position.

Leave a Comment

Filed under Business, Collaboration, Knowledge Work Productivity, Leadership, Simple but Hard

Fixity, Fluidity, and Presence–Paper vs. Electronic

Kevin Kelly compared the fixity of paper books with the fluidity of ebooks in a recent blog post titled “Fixity vs. Fluidity” (which was inspired by Nick Carr). He highlights four aspects of “fixity” that paper books have:

Fixity of the page– The page stays the same. Whenever you pick it up, its’ the same. You can count on it, and refer and cite it with certainty.

Fixity of the edition– No matter which copy of the book you pick up, anywhere, it will be the same, so the fixed content is shared, and within an edition, the same always.

Fixity of the object– Paper books last a very long time, and their text doesn’t change as they age.

Sense of completeness — A sense of finality and closure that became part of the attraction of literature.

And four positive aspects of “fluidity” that ebooks have:

Fluidity of the page — Can flow to fit any space, any where, any time.

Fluidity of the edition— Can be corrected or improved incrementally.

Fludity of the item— Can be kept in the cloud at such low cost that it is “free” to keep and constantly slipped to new “movage” platforms.

Sense of growth — The never-done-ness of an ebook (at least in the ideal) resembles a life more than a stone, animating us as creators and readers.

I resonate with both lists of positive attributes. Paper books have an authority and weight (No, not the lb/kg type) to them that electronic media do not have. But, an ebook can be be changed easily, re-uploaded to an ereader, always current.

But there’s something in this “fixity” that wasn’t included in his post. Something I’ve been thinking about recently that is lacking in most computing experiences. I’m calling it persistence and presence.

A paper book is both persistent and present in a way that an ebook is not. Similarly, paper notebooks, sketches, lists, and notes are also persistent and present in a way that their electronic equivalents are not.

It struck me recently that MS OneNote (my life organizer of choice) has never completely replaced sticky notes, reminders on bulletin boards, whiteboard brainstorming, and similar physical “tools”. The purchasing manager probably thinks I’m single handedly keeping 3M in business with my post-it note purchases. These physical tools are persistent and present, I don’t have to choose to view them, they are just there. OneNote, in it’s current form (with one exception I’ll get to later), is only one of many programs I can choose to open while I’m on my computer. If I don’t open it, I’m not confronted by my Todo’s, Projects, and other notes. They are not persistently present (even more so If I don’t turn my computer on at all). A sticky note on my desk, however, confronts me. It can’t be ignored. Physical books are the same way. They sit on the shelf saying “read me!” every time you walk by. Especially if you have a spot on your shelf for the books you want to read next like I do. Walking into the living room I see those books, right at eye level just waiting for some time  with me in my reading chair.

So, for me, these physical tools remain because their persistence and presence are useful. Until there are ways to make electronic information as persistent and present as a post-it note or paper book, I’ll probably keep using them.

I’m sure the lack of presence and persistence in electronic media and tools will be addressed. My windows phone (the exception I mentioned above) allows me to make a couple of my key OneNote pages (“Todo and idea capture” and “Week’s Goals and Today’s todos”) persistent by putting them on the start screen of my phone. And they are present because I always have my phone with me.

WindowsPhoneOneNote

New technologies like windows with built in monitors/TV, imbedded micro projectors shining information onto walls, and the “Internet of Things” will all increase the persistence and presence of digital content if designed properly.

2 Comments

Filed under Technology