Review for my Latest Publication – “9 Essential Skills for Excel 2010”

Main Menu Essential Skills for Excel

Main Menu for “9 Essential Excel Skills”

I just received a fabulous review, from one of my viewers, for my video tutorial, “9 Essential Skills for Excel 2010.”

Read this Review

Product Reviews

It’s really a master piece!!

Posted by Tamoghna on 8th Sep 2012

“I was a beta tester of “9 Essential Excel Skills- Excel 2010” by Danny Rocks. In one word this is an excellent resource for anyone who wants to master those essential skills which are required to use excel professionally. There are total 9 chapters which consist of a series of dense but brief video lessons.

The lessons have been planned in a careful way so that the viewers are introduced from simple to more complex topics.

Surely you are going to be amazed by the incredible picture and sound quality of the videos. I had a feeling as if I was watching an excel movie while putting my head phone. Danny has several qualities as an instructor. His pace of delivery and voice modulation is just fantastic and if you are not an absolute excel-newbie watching a video just one time is enough. Before starting each lesson he gives a brief introduction so that you can connect what you learned in the previous lesson. He also repeats and stresses some part which you will find really helpful.

Another great take away from this video tutorial is a bunch of great keyboard shortcuts and best excel practices which you can expect only from an excel veteran. Among so many other things I was left with surprise why I didn’t use “page layout view” and “vertical alignment formatting” before! Even if you are an advanced excel user surely you are going to learn a lot of useful tricks including some commonly encountered gotchas and how to avoid them.

I won’t be taken aback If this product goes every corner of the excel user community and becomes best seller in this field.”

Learn More About My Video Tutorial

I have produced the “9 Essential Skills for Excel 2010” in two formats:

Both versions include 4 hours of video instruction. 25 individual video tutorials. The Excel Practice files that I used while filming the video tutorials. A PDF of the Step-by-step Instructional Guide that I created for these video lessons.

Version for Excel 2007 Now Available!

DVD-ROM, "9 Essential Excel 2007 Skills"

DVD-ROM, “9 Essential Excel 2007 Skills”

I have just published “9 Essential Excel 2007 Skills” for DVD-ROM. Click to to get more information about my latest publication.

Secure Shopping at The Company Rocks

You can use a secure shopping cart to purchase my products at my online shopping website – http://shop.thecompanyrocks.com

 

 

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Book Review: Marketing Your Retail Store – In the Internet Age

I love this book!

If you operate a retail business, regardless of size or industry, you need to buy this book – now! In my opinion, it is the most practical and tactical business book for retailers who want to learn how to attract and retain customers. For every concept covered, Bob & Susan Negen provide both “Low-Tech Tactics” and “High-Tech Tactics” for the retailer to implement. Continue reading “Book Review: Marketing Your Retail Store – In the Internet Age” »

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Book Review – Treasure Hunt

I think that this is a very important business book and I recommend that my clients read it – and to take its findings to heart.  The new consumer enjoys mixing upscale with downscale products- to create their own customized lifestyle, satisfy their ever changing “value calculus,” and meet their emotional needs.

Michael Silverstein is the co-author of 2005's best-seller “Trading Up,” which showed us why consumers want new luxury goods – and find them with Callaway Golf Clubs; shopping at Victoria's Secret,;eating at Panera Bread and drinking Belvedere Vodka.  That certainly is an appealing prospect for any manufacturer or retail who has visions of higher margins and increased spending dancing in the head.

In Treasure Hunt, we learn that (most of) these same consumers “trade down” because:

“I'm a smart shopper – and highly skilled at it.”

“There's no material difference in the products”

“My Mom taught me how to be a smart shopper.”

“I can go without it.”

We have all seen these consumers (and I am becoming one of them) at Target, Costco, Lowe's and Dollar General.  The majority are female.  And it is no longer a paradox to see new BMWs or Lexus automobiles parked in from of a Wal-Mart or Target store.  People enjoy “treasure hunting” for bargains not so much because they “have to” but rather because the can and “want to.”

This is a valuable lesson to learn – the “Bifurcating Market” – where you can reach high and search low at the same time.  Just be sure to avoid the path that leads to the boring and deadly middle ground (remember Sears, Montgomery-Ward and most department stores.)

I have worked for over 30 years in the Music Products industry.  Many of my clients are in this industry.  Most bemoan the fact that retail prices are dropping and margins are shrinking.  They are quick to place blame (cheap imported products, big-box retailers, Internet retailers who don't have to charge sales tax, etc.)  But I think that they miss the point – many consumers will happily “treasure hunt” for bargains – as long as it is combined with a satisfying shopping experience – and use some of these savings to purchase the “upscale” products that they desire.

Increasingly, it is the “shopping experience” that is driving the marketplace.  “Cheap” no longer connotes “bad.”  Now, “boring and bland” are “bad.”  To succeed in today's market, it is wise to consider the words of legendary retailer Leslie Wexner:

“People are looking for emotional highs.  Winning companies invent new products that capture the consumer's imagination.”

Ignore the reality of the bifurcated market at your peril – and many companies continue to ignore it.  Instead, learn how to deliver trading-down goods at unbelievable prices or create trading-up goods with genuine differences that can – and do – command a premium price.

I like the format of this book.  It follows actual consumers to their homes and along on shopping trips to discover the reasons and motivations for their behavior.  It is fascinating.  Real people, real stories.  And, it goes a long way towards demolishing our stereotypical assumptions of the “middle-class” consumer.  Regardless of demographics or level of income, each consumer has their own story to tell.  It is unfortunate that too many retailers fail to tell their own story – and attract this new consumer.

One of the best features of this book is the website that supports it – www.bcg.com/treasurehunt.  Click on the link and you will see the real people interviewed in the book and learn more about the research that went into compiling the statistics in the book.  Increasingly, publishers and authors are creating exciting websites to support the traditional printed product.  I like this trend – it is exciting!  I hope that you can learn how to make your own store or products exciting – there is a rich pay-off when your learn how to tap into the “bifurcating” market.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Collecting Intellectual Income

“Never feel guilty about reading, it's what you do to do your job.”

– William Safire

This quote appears on the very last page of Peggy's Noonan classic book, “On Speaking Well.”  Mr. Safire was giving this advice to a young writer.  Ms. Noonan goes on to say that “reading is the collecting of intellectual income; writing is the spending of it.  You need to read to write, you need to take in other people's words and thoughts and images.”

Regardless of your political views (both Safire and Noonan were speechwriters for Republican Presidents) is is hard to top the expert advice that Safire and Noonan offer.  They are professional writers and speakers and they continue to be students of writing and speaking.  Both have written for others (politicians, business leaders and celebrities) as well as for themselves.  They are keen observers of the political scene but they excel at studying and explaining how choosing the right word for the right occasion helps to communicate a powerful message.

After listening to the eulogies at President Ford's memorials I picked “On Speaking Well” out of my bookcase.  I wanted to re-read Peggy Noonan's thoughts about writing for others.  I had my own opinions about which politician relied too heavily on a speechwriter and which may have written their own eulogy for President Ford.  (My opinion is that Vice President Cheney wrote his own  – it was the the most sincere speech that I ever heard him deliver!)

I ended up re-reading the book from cover-to-cover – what a great investment!  I certainly collected so “intellectual income” from this book which I will be spending soon.  I am not writing a full book review of “On Speaking Well,” but I give it my full recommendation as a book that must be in your bookcase if you are serious about improving your communications skills.  (I was so charged up with my re-reading that I am now re-reading Jack Valenti's book , “Speak Up With Confidence.”)

President Reagan was labeled as “The Great Communicator” and Peggy Noonan was one of his speechwriters.  Many critics panned Reagan as a simple-minded politician who never-the-less was able to win over audiences and leave behind many memorable phrases.  The critics said that it was a case of style over substance.  Ms. Noonan – as you might suspect – argues aggressively that this is not the case.  And she is very persuasive in making it!  She argues that Reagan used simple language to communicate big ideas:

“The language of love is simple because love is big.  And big things are best said, are almost always said, in small words.”

You will gain a new appreciation for using simple words to express big things by reading “On Speaking Well.”  For me, the highlight of the book is Peggy Noonan's insightful commentary of some of the best-known speeches of the past 100 years.  Of course there is the usual John F. Kennedy, Winston Churchill, Ronald Reagan.  But also the Earl Spencer's eulogy for his sister Princess Diana.  And… Hyman Roth's speech to Michael Corleone in The Godfather II – What a bonus!

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Review – Winning at Retail

Lately, I have been re-reading some of my favorite business books.  “Winning at Retail” is one of them.  The authors have a solid history as retail consultants and they are passionate about creating and studying successful (and unsuccessful) retail operations.  In the authors words, great retailers understand the importance of two things:

1) Targeting a particular group of customers.

2) Carefully choosing what you'll be great at offering them.

A successful retailer understands that you can not be all things to all people – you must choose a specific target customer and then follow them closely to understand what most influences their buying habits.  And then you must and then you must build your business to become the best in that one area – as your targeted customer perceives it.  You must build your business around your customer.  Learn how to give them more of what they want and less of what they do not want.

“Winning at Retail” builds on the principles of the 1981 marketing classic, “Positioning: The Battle for Your Mind,” By Al Ries and Jack Trout.  You must learn how to be seen and heard in the overcrowded (and ultra-competitive) marketplace.  In this book, you will learn EST principles (NO, not those kooky Werner Earhardt seminars from the 70's!)  In this case EST is becoming the B(EST ) in one of these five dimensions:

1) Cheap – EST: Winning with Price – (e.g. Wal-Mart, Costco and Dollar General)

2) Big-EST: Winning with Dominant Assortments – (e.g. the “category killers” Best Buy, Home Depot, Home Depot and Barnes & Noble)

3) Hot-EST: Winning with Fashion – (e.g. Chico's, Starbucks and Target)

4) Easy-EST: Winning with Solution-Oriented Service – (e.g. Container Store, Publix and Kohl's)

5) Quick-EST: Winning with Fast Service – (e.g. McDonald's, Walgreens and Kinko's)

As in “Positioning,” it is vital to understand that the target customer's perception of which retailer is the B(EST) at offering something that's important (prices, selection, service, etc.) wins the game – for now!  Because, it is difficult to remain dominant in one of these 5 dimensions.  The marketplace is ultra-competitive and customer preferences are always in flux.

Smaller, independent retailers should not be put off because the author's mainly discuss large retail operations.  Anyone can learn the basic principles and adapt it to their situation.  Actually, because we are so familiar with the successful and unsuccessful retailers used as case studies, it is easy to understand why these EST principles are so vital to success.

I really like this book because it is based in reality – not some theoretical proposition.  The writing is conversational – personal – and the authors' passion for retail shines throughout the book.  They know each of the case studied retailers inside and out.  And – they never stray from their basic principle:  In today's market the customer is in control and successful retailers learn how to give their targeted customers more control in the buying process.  If you want to win at retail today – and in the future – follow your customers.  Learn what is most important to them and then become the best source to provide it!

 

 

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Book Review – Creating Competitive Advantage

How many business owners or top managers can quickly articulate the competitive advantages that set their company apart from the competition?  In Jaynie L. Smith's experience as a consultant, not many!  In fact, in her research, only 2 out of 1,000 C.E.O.'s could do so.  Is it any wonder that so many manufacturers and retailers believe that consumers will only make purchases based on low prices?  Perhaps, this is why we have a fast “race to the bottom” on pricing and rapidly dwindling profit margins.  But this does not have to be the case.

“Creating Competitive Advantage” offers many powerful and practical strategies and exercises to help you to identify and articulate clear, compelling reasons why existing customers should continue to do business with you and why potential customers should choose you instead of your competitors.  In her workshops, the author asks owners and employees to come up with a list of competitive advantages that are:

Objective – not subjective

Quantifiable – not arbitrary

Are not already claimed by your competition

Are not cliches – always be specific!

So, for example – instead of saying, “We provide quality products,” say, “Last year, less than half of 1 percent of our customers returned one of our products.” (If your product is as good as you say, you won't have a lot of returns.  Quantify your results and the results that your customers report and then – let all your current and potential customers know about it – this becomes your competitive advantage.

The best possible summary of the book – and the reasons why you should run out to get and read this book – is listed on the cover jacket.  “The Five Fatal Flaws of Most Companies:”

1) They don't have a competitive advantage, but they think they do.

2) They have a competitive advantage but don't know what it is – so they lower prices instead.

3) They know what their competitive advantage is but neglect to tell clients about it.

4) They mistake “strengths” for competitive advantages.

5) They don't concentrate on competitive advantages when making strategic and operational decisions.

I really like this book.  The author goes to great length to detail specific results from some of the many companies she has worked with – the results are nothing less than spectacular and in many cases, it was the company's employees (front line staff) who identified the clear advantages.  Throughout the book, Jaynie Smith constantly stresses the need to use quantifiable research and specific benefits – that will matter to your customers.

Of course, if your company has a clear competitive advantage internal or external) your competitors will try to copy it.  So, you must be constantly searching for new clear-cut advantages to stay ahead of your competition – and be sure to tell your customers what you are offering and why it matters to them.  Don't make the 5 fatal flaws!

Once your company has defined their competitive advantage(s) be sure to tell everyone in your company what they are.  Train your staff around your competitive advantage – turn each employee into a first-rate salesperson.  When they believe in your advantage they will enthusiastically tell everyone “why they should do business with your firm rather than with somebody else.”

Any business who wants to learn how to compete rather than constantly lower prices needs to buy this book and put these strategies into practice – today!  Before your competitors do so.

The author maintains a very useful website with a Discover your competitive advantage” interactive worksheet.  Fill it out – the results are quite revealing.  Learn how much money you may be losing by not identifying and articulating your competitive advantage.

 

 

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Book Review – Steal These Ideas!

I would jump at the opportunity to have an afternoon conversation with the managing director and head of advertising / brand management at Citigroup Global Wealth Management.  Especially if I knew that his father wrote the original direct subscriber letters for Playboy Magazine – from the “bunny's perspective!”  How much would I pay for that opportunity?  A lot! 

However, all we have to pay is $18.95 (or less) to have that conversation with Steve Cone when we buy his book, “Steal These Ideas! Marketing Secrets That Will Make You a Star.”

Steve Cone is opinionated.  He knows what works and what doesn't – and he tells you why.  He writes in a very engaging, conversational style.  He speaks from personal experience – the campaigns that he has worked on; and from an historical perspective.  Some of his comments about “Tag lines” or slogans are very amusing: e.g. from JP Morgan Chase – “The Right Relationship is everything.” (Am I using a dating service?)

We live in an over-communicated society.  The first challenge for any business or service is to get noticed – and to create some excitement.  However, once you get noticed too many art directors sabotage your efforts – they use fonts that make it difficult to read (sans serif; white reverse type.)  Too many ads fail because they do not give the consumer a compelling call to action – the reason to STOP everything now and order the product or service.

Steve Cone writes extensively on how to develop an effective “Tag Line” for your business.  He neatly integrates this with “building your brand” and creating your “unique selling proposition.”  For Cone, marketing successfully is all about simple ideas brilliantly executed that reinforce your brand message.

Of special note is the chapter on creating effective brochures.  Six great suggestions:

1) Put a picture of a person on the brochure along with one-or-two-line highlights of the contents within.

2) Summarize the key takeaways of the brochure in bold and easy-to-read copy.

3) Tell readers what you want them to do – on every page.

4) Regularly use a question & answer format withing your brochures. (Great suggestion!)

5) Have a real contact name and return address prominently displayed.

6) Potential readers will make split-second decisions about whether to read or toss it.

And Chapter 12 – “The Three Most Important Customer Lessons You Will Ever Learn,” is priceless.  This chapter provides more wisdom, insight and practical tactics that most MBA programs!  The lessons are:

1) People renew the way they are acquired.  (Think about PBS renewal campaigns.)

2) The most critical time in a new customer's relationship with your business is the first week after her initial purchase. (Amen!)

3) Forget complicated clusters and demographics. (There are only 5 basic customer groups.)

This book is a quick read – and one that you will often return to for ideas and inspiration.  The premise is – there are no new ideas.  Learn how to adapt proven tactics to improve your company's marketing.  The secret is how well you execute these ideas! 

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Book Review – Winning the Toughest Customer

If you are in sales or marketing you need to get this book – and take its message to heart.  That is, if you really want to grow your sales or market share.

This is not a “preachy” book.  It doesn't shout, “Understand women or else…”  Yes, the statistics are compelling: Women make or influence over 80% of all purchases made in America today; 48% of all privately-held businesses in the USA are majority woman-owned, etc.  But the book is really about understanding how to sell to anyone the way they want to be sold to, in the way that will make them want to buy from you and keep them coming back for more.  A winning approach!

There is no “psycho-babble” here.  Just a very well-written logical approach to understanding how women think, why the react as they do and how to reach them – and keep them as customers – and as a valuable source of referrals.

Here are two key concepts from the book:

“Many women will buy from you not because they understand what you are selling but because you understand !”

“A woman will buy when she feels confident about her decision.  What women want is information enabling them to gain the confidence they need to move the sale forward,  What they want is the knowledge necessary to make a good decision for themselves.”

I read this book just before my wife hosted a bridal shower for 30 women at our house.  As I silently listened and observed their conversations and actions the concepts that Delia Passi presented in this book really “rang true.” 

If you have ever grown frustrated trying to sell to a woman; gotten angry when they said, ” I have to think about this some more.” or just generally wondered why it takes woman so long to make up their mind – if they ever do… the payoff for you is:

“The time spent acquiring and retaining women customers will ultimately lead to more business generated per customer, twice as many referrals, and a tendency to create greater word-of-mouth marketing for you and your brand.”

I'm sold!  And I now have a better understanding of how to sell to and understand women.  I recommend this book

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Book Cover – Alpha Dogs

This is the cover for a book that I highly recommend.  The author is Donna Fenn and the ISBN # is: 978-0-06-075867-7.  The author has a special website for this book – www.alphadogs.com

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

I Recommend – Books

This is one of the best books on business strategy on the market today – particularly if you are a small business owner or an entrepreneur.  The author, Donna Fenn is a columnist for Inc. Magazine

As part of her research she visited and reports on 8 different small business creators – ranging from a bicycle shop owner and a top Harley-Davidson dealer to a unique group of independent Public Relations / Consultants federation.

Each entrepreneur has achieved success but faced many difficult challenges as they grew.  How they dealt with each challenge – and the lessons learned – form the crux of this book.

A common thread – each company is successful in an area that most people would assume has become commodotized – and ruled by giant ope raters whose primary attraction is a low price – NOT SO!

If you are a small business owner who worries about competing against predatory marketers, big-box retailers or category-killers, run – as fast as you can to get a copy of this book and read it immediately!

Any entrepreneur will recognize that they can easily suffer from this symptom:

“… because it so often the case that they pursue the business for the love of food, but are wiped out by the business reality of producing and selling it.”

The best way to give you the essence of this book is to quote the final words:

“The business itself – not the product, the service, or even the entrepreneur – is the Alpha Dog.  It's responsive, dynamic, and takes nothing for granted;  it's resilient and sustainable.  And it refuses to accept the conventional wisdom that size is limiting.  It knows that even a very small dog, when it stands in the proper light, can cast an awesome shadow.”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn