Project status, tracking template in Excel for content management

Messy and garbled Excel sheets are a nightmare for content writers and managers. To make project tracking simple, I created this flexible and responsive project tracking template Excel sheet. Content writers and project managers sometimes handle loads of documents. A lengthy and multi-point content review process adds to the complexity of knowing the exact situation of each article or content piece. There are many project templates available on the internet. Some are simply timelines templates. But few come close to tackling the details and complexities that exist on the ground for writers and content creators. The Excel project tracker is divided into three neat areas: Writing, Review and Final Status. This makes it easy to switch and check the status of each stage, and prevents the tracker from getting cluttered. The project status template is meant to be maintained by writers, though reviewers too can add their status updates. The tool uses automatic field update features of Excel to reduce manual entry in multiple columns. So when a writer enters a status...
Read More

Jargon Density Checker: Optimize your language to drive conversions

I know, its a lowly Word macro, but it also comes adorned with your ultra favorite, old styled windows message box. Presenting the Jargon Density Checker macro for Word 2007 and later versions, with all my pride. No one knows how or when it began. I suspect technology had a hand in it. Or may be business owners wanting to say something as well as not say it. After all, everyone had to have a ‘core’ competency. Not less or more. Core, as in core. Jargon isn’t always ‘blue sky thinking’, but it was ‘scaled’ high enough to shake some grounds of sanity when words like ‘predictors of beaconicity’, ‘coterminosity’ and ‘double devolution’ were heard. Your friendly jargon density checker is ‘driven’ by a custom list of 200 words to avoid in formal business and corporate writing. Maybe not avoid, but at least know that you are using terms that can switch off minds as fast as one could possibly do to those designer bulbs of innovation...
Read More

THE ABC OF NEWSLETTERS

I recently wrote a post on newsletters that covered some important aspects of newsletters. An HR forum recently had members asking some very basic questions on how to go about publishing a newsletter: What is a newsletter? How is it different from an in-house magazine?How do I name my newsletter?Are e-mailers and newsletters the same? What about e-newsletters?Are there free templates available?How much will it cost? Below I share some ideas based on my own personal experience. What is a newsletter? Simply put, a newsletter is a small publication (print, html, pdf, email) that contains news, updates and relevant information for a select group or audience. So it’s not meant for everyone, and it does not contain lengthy articles, essays, or detailed content. But who puts out a newsletter? The first time I came across one was as a member of a small scholarly association – it was a folded one page print issue delivered in mail, with news and updates from that particular field. This was the...
Read More

OVERCOMING THE NEWSLETTER CHALLENGE

Ms Spitfire is pacing up and down her sea facing office. She wants a company newsletter sent out every week to all employees at NAIL, informing them of the latest activities and wins of various teams. But first, she must figure out some newsletter basics. Ms Spitfire: Dang! What’s a newsletter really for? What brief should I give to my team so that they can get started on this asap, and do not face a mishap down the line? Do you have any damn #@#@! knowledge on this? Well, Ms Spitfire, here are some tidbits related to newsletters of various types and purposes that you may find helpful. At one company, the internal employee newsletter was eagerly awaited and browsed every morning. The sections that garnered most attention – humor, news, puzzles, brain tickling challenges, and trivia. Not quite the old serious stuff you would expect a corporate newsletter to spread to employees. But this is precisely how readership taste defies mission based activities. Your...
Read More