Category Archives: Marketing

Marketing: How to interact with external agencies efficiently

As a marketing professional, you need to work with multiple agencies – Direct Marketing, Lead generation, Event management, Advertising, Social Media, PR and so on. You are typically managing multiple brands, campaigns and complex set of KPIs.

Do you really handle all this using email? Is it not chaotic? Don’t you get lost in the confusing deluge of conversations, artworks, revisions, interactions, pending decisions?
If yes, here is a better way… read on to find out.

Even if you are not a marketing professional you will find this article useful if you need iterative interaction with external parties.

image

Continue reading Marketing: How to interact with external agencies efficiently

Marketing: Twitter Analytics using Excel

In an earlier article, we discussed how to analyze FaceBook posts using Excel. Now let us see how Twitter data can be analyzed. This article explains how to analyze your own twitter handle data. Usage Scenarios: Product specific handles, Corporate handles, brand launches, events, live seminars, customer feedback and so on.

twitter analytics using Excel

Continue reading Marketing: Twitter Analytics using Excel

Marketing: How to create “Our Customers” Slide in seconds

Any corporate sales presentation usually have a “our customer” slide. Usually creating such a slide is very cumbersome because the logos come in all shapes and sizes. Someone has to spend inordinate amount of time resizing and aligning all the logos – and often, the slide still looks shabby Sad smile Devil … Here is a method which will solve your problem instantly.

how to create our customers slide in seconds by Dr. Nitin Paranjape

Continue reading Marketing: How to create “Our Customers” Slide in seconds

Arrange multiple pictures in PowerPoint in Picture Tools

LifeLog

Yesterday, I conducted sessions for 650+ professionals at a leading automotive manufacturing company… Very smart audience, amazing grasping power.

image

Here is one of the demos I used in the session…

Problem

I have multiple pictures. I want to put them into a SmartArt diagram quickly. But if I use Insert – SmartArt – Picture SmartArt, I have to insert each picture one by one.

That is repetitive. Repetition = Inefficiency Sad smile

Is there a faster, smarter way?

Solution

Of course there is. Here are the steps.

  1. Choose Insert – Pictures
  2. Select all pictures and add them
  3. As soon as the pictures are inserted, they are already selected.
  4. DO NOT unselect them.image
  5. Notice that pictures are of different sizes and randomly arranged.
  6. While all pictures are selected, click the Picture Tools tab
  7. Open the Picture Layout dropdown
  8. Notice that all types of Picture SmartArt appear herePowerPoint Picture Tools
  9. Choose the one you want
  10. The size of the diagram will be determined by the size of the picture selection
  11. Adjust the diagram size as neededimage
  12. Open the text editor and add titles if required
  13. That’s it!